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