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.