HP 3000 Manuals

Navigating SQLMON Subsystems [ ALLBASE/SQL Performance and Monitoring Guidelines ] MPE/iX 5.0 Documentation


ALLBASE/SQL Performance and Monitoring Guidelines

Navigating SQLMON Subsystems 

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  shows how the SQLMON screens and subsystems are organized.

[]
Figure 6-1. SQLMON Road Map


MPE/iX 5.0 Documentation