HP 3000 Manuals

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


ALLBASE/SQL Performance and Monitoring Guidelines

Starting SQLMON 

To run SQLMON, log on from the account where the database resides as a
user with system manager capability or as DBECreator.  Then, issue the
following command:

     : SQLMON 

After displaying a banner and several menus, SQLMON displays a prompt
that shows that you are in the Overview subsystem:

     SQLMONITOR  OVERVIEW =>

SQLMON has six subsystems, named Overview, IO, Load, Lock, SampleIO, and
Static.  The SQLMON prompts identify the current subsystem.  All of the
prompts listed below are subsystem prompts:

     SQLMONITOR  OVERVIEW =>

     SQLMONITOR  IO =>

     SQLMONITOR  LOAD =>

     SQLMONITOR  LOCK =>

     SQLMONITOR  SAMPLEIO =>

     SQLMONITOR  STATIC =>

From a subsystem prompt, you can access SQLMON screens, issue SQLMON
commands, or exit the program.



MPE/iX 5.0 Documentation