Adding Log Volumes 
The log entries of a database are permanently stored in the log volumes (log area). You can increase the size of the log area by adding log volumes. However, you cannot delete log volumes.
If the log area is full, the database stops working. Note that when the log area is full, you first need to carry out a log backup.
Caution
Adding a new log volume will not immediately reduce the filling level of the log area. The system will only use the new log volume after you have carried out a log backup.
Note
To speed up the writing of log entries from the log queues in the working memory to the log area, you can divide the log area into several log partitions.
For more information, see Configuring Log Partitions.
Note
To prevent the log area from filling up, you have the following options:
You can activate the automatic log backup (the system can overwrite the log entries already saved).
For more information, see Activating or Deactivating Automatic Log Backup.
You can activate the overwrite mode for the log area (recommended for test systems only).
For more information, see Activating or Deactivating the Overwrite Mode for the Log Area.
Prerequisites
You are logged on to the database as the database system administrator or as a DBM operator with server authorization for accessing database parameters or utility sessions (see Glossary, Server Permission).
To create a new log volume, the MaxLogVolumes value must be at least as high as the sum of the number of existing log volumes and the number of log volumes that are to be defined (see Changing Database Parameters).
NoteEvery time the database is started, the system checks whether there is enough space available for at least one volume of each type. If not, it automatically increases the setting of the appropriate database parameter by 1.
End of the note.
Procedure
Select the database in the explorer tree.
In the context menu of the database, choose Administration.
Open the Log Area tab page.
Choose New... .
Enter the required data.
Volumes: Properties Property
Description
Size
Minimum size: 1000 pages or 8000 KB
Device/File
Device/path and file name
Type
Type of physical memory
FILE (F)
A volume can be a part of a physical hard disk, a complete physical hard disk, or a storage system consisting of several storage units.
Can be used on all operating systems
LINK (L)
Can only be used on Unix and Linux
RAW (R)
Raw device
Can only be used on Unix and Linux
Log Volume: Example Property
Sample Data
Name
DISKL0001
Size
50 MB
Device/File
C:\ProgramData\sdb\globaldata\DEMODB\volumes\log\DISKL0001
Type
FILE