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 | Overview | LOG FULL %
Used LgPgs
Max LgPgs |
| Identifying Log Mode | | Archive Mode |
| Detecting Logging Errors | Overview | LOG ERRORS |
| Identifying Size of Log Buffer Pool | IO | TOTAL LOG BUFFER PAGES |
| Monitoring Log Buffer I/O | IO
IO Log Session
IO Log Program | LOG BUFF WR
LOG DISK RD
LOG DISK WR |
| Monitoring Checkpoints | IO | CHECKPOINTS |
