SQLMON has six subsystems, which are listed below:
Overview, which shows general performance information
IO, which provides information on data and log buffer activity
Load, which displays transaction throughput data
Lock, which shows locking activity
SampleIO, which provides information on DBEFile, table, and index I/O
Static, which describes indexes, tables, DBEFiles, and constraints
The name of a screen identifies the subsystem to which it belongs. Each subsystem has a primary screen, with the same name as the subsystem, and secondary screens, whose names begin with the subsystem name.
When you access a screen, you automatically move to the subsystem that screen belongs to.
Figure 6-1 “SQLMON Road Map” shows how the SQLMON screens and subsystems are
organized.
Figure 6-1 SQLMON Road Map