The database system logs all transactions that change application data or the database catalog in log entries. The database system uses these log entries to roll back or repeat SQL statements, if necessary.
Use one of the following database tools:
Database Studio, Database Manager CLI, or CCMS (in SAP systems only)
To specify the most important logging properties, use the log settings.
Name |
Description |
---|---|
Log mode |
Specifies whether the database system supports software-based mirroring.
|
Overwrite mode for the log area |
Specifies whether the database system can overwrite redo log entries in the log area even if they have not been backed up.
If overwrite mode is on and you switch it off, you then have to execute a complete data backup. |
Redo log management |
Specifies whether the database system writes redo log entries.
If redo log management is off and you switch it on, you then must perform a complete data backup. |
More information:
Database Studio, Changing Log Settings
Database Manager CLI, param_addvolume
To specify further logging properties, for example log segment size and number of log volumes, use database parameters.
More information: Database Parameters
If you need to increase the log area, add log volumes.
More information:
Database Studio, Adding Log Volumes
Database Manager CLI, param_addvolume
Database Administration in CCMS, Monitoring the Log Area
Concepts of the Database System, How Databases Log Data Changes