SQLMON is an online diagnostic tool that monitors the activity of an
ALLBASE/SQL DBEnvironment.
In addition to providing information about locking, I/O, and file capacity,
SQLMON displays information about logging activity.
SQLMON is documented fully in
the ALLBASE/SQL Performance and Monitoring Guidelines. Table 6-1 “SQLMON Log Monitoring Tasks” summarizes the log monitoring tasks
you can perform with SQLMON.
Table 6-1 SQLMON Log Monitoring Tasks
Task | SQLMON Screens | Fields |
---|
Determining Log File Capacity | | LOG FULL %
Used LgPgs
Max LgPgs |
| | |
| | |
Identifying Size of
Log Buffer Pool | | |
Monitoring Log Buffer I/O | IO
IO Log Session
IO Log Program | LOG BUFF WR
LOG DISK RD
LOG DISK WR |
| | |