The database system permanently saves the database log entries 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 database log area is full, the database stops working.
Caution
If the log area is full, you have to execute a log backup. Only then can the database system use new log volumes.
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).
More information: Activating or Deactivating Automatic Log Backup
You can activate the overwrite mode for the log area (recommended for test systems only).
More information: Changing Log Settings
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.
More information: 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.
More information: Changing Database Parameters
Note
Every 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.
In the context menu of the database, choose Administration.
Open the Log Area tab page.
Choose New.... .
Enter the required data.
Property |
Description |
---|---|
Size |
Minimum size: 1000 pages or 8000 KB |
Device/File |
Device/path and file name |
Type |
Type of physical memory
|
Property |
Sample Data |
---|---|
Name |
LOG002 |
Size |
50 MB |
Device/File |
C:\Documents and Settings\All Users\Application Data\sdb\data\demodb\log\DISKL0002 |
Type |
FILE |