This menu function displays the state and activity of the logging process.
The following information is output:
- Maximum storage space available on the log devspace in KB
(Max. size in KB)
- Size of a segment in KB
(Segment size in KB)
Segmentation of the log devspace is especially advantageous for the log mode Autosave. Completed log segments are automatically saved while the database is operational. Afterwards, the saved segment is available again for the logging mechanism.
- Size of space reserved on the log devspace
(Reserved size in KB)
- Mode in which the log is operated
(Mode)
- Size of used space
(Used size in KB)
- Percentage of the devspace used
(Used in %)
The utilization level of the log devspace should be monitored carefully. If the utilization level reaches 100%, the database is shut down automatically. Work can only be continued after the log devspace has been saved and cleared. If the utilization level exceeds 60%, messages are output to the diagnostic file of the database.
- Space available
(Free size)
- Percentage of the devspace unused
(Free size in %)
Example:
The next section displays the write and read activities (physical writes, physical reads), as well as the number of completed segments (Segment completed) in the log devspace since the last restart of the database system.
The next section displays statistical information about save and checkpoint activities:
- Number of SAVEPOINTS written
(Savepoints)
- Number of CHECKPOINTS written
(Checkpoints)
- Average SAVEPOINT distance, measured in KB
(KB per savepoint)
- Average CHECKPOINT distance, measured in KB
(KB per checkpoint)
The next section displays information about the log queue before the logging process:
- Current size of the log queue
(Queue size)
- Number of group commits
(Group commits)
- Devspace currently allocated
(Queue allocated)
- Number of wait states for log write operations
(Waits for logwriter)
- Maximum size of log queue
(Queue entries)
- Maximum number of wait states per log page
(Max. waits)
- Number of log queue overflows
(Overflows)
- Average number of wait states per log page
(Avg. waits)