SAP MaxDB :: Displaying Information About the Log Area

 

Prerequisites

Log on to the database as the database system administrator or as a DBM operator.

The database should be in the ONLINE operational state.

Procedure

Select the database in the explorer tree.

In the context menu of the database, choose Administration.

Open the Log Area tab page.

 

Log Area: Information

Property	Description
General	Log settings: o Log Mode o Overwrite Mode for the Log Area o Redo Log Management Automatic log backup: Activating or Deactivating Automatic Log Backup To change any of these settings, choose the corresponding link.
Usage	Free and used space in the log area
Activities	Information on logging: o Log pages written with redo log entries o Wait for Log Writer Indicates how often the system had to wait for a commit or rollback for the Log Writer for finish an I/O operation o Group Commits Indicates how often the system wrote pages that waited for more than one task o If the value of Log I/O Queue Overflow is greater than 0, increase the space available for log queues. You can configure the number of log queues with the special database parameter LogQueues and the size of the log queues with LogQueueSize.
Parameters	Database parameters relevant for log volumes
Log Volumes	Configured log volumes