Displaying Information About the Log Area 
Prerequisites
You are logged on to the database as the database system administrator or as a DBM operator.
The database is 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
To change any of these settings, choose the corresponding link.
Usage
Free and used space in the log area
Activities
Information on logging:
Log pages written with redo log entries
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
Group Commits
Indicates how often the system wrote pages that waited for more than one task
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 (see Database Administration, Database Parameters)
Log Volumes
Note that you cannot delete log volumes.