IMAGE/SQL: Issues and answers concerning SQL tables

Software

Papers & Training

Java

HP Partners

News & Events

Register for more info

4.1 How do I start SQLMON?

Key points

SQLMON is an online diagnostic tool that monitors the activity of a DBEnvironment. SQLMON screens provide information on file capacity, locking, I/O, logging, tables, and indexes. They summarize activity for the entire DBEnvironment, or focus on individual sessions, programs, or database components. SQLMON is a read-only utility, and cannot modify any aspect of the DBEnvironment.

• To run SQLMON, simply type sqlmon at the system prompt.
  • On MPE/iX, SQLMON consists of two files:
    • SQLMONP.PUB.SYS is the executable program.
    • SQLMON.PUB.SYS is a command file which issues file equations and a command to "run sqlmonp.pub.sys".
    When you type sqlmon to invoke the program, you are actually executing the command file.
  • On HP-UX, the executable is stored under /usr/bin/sqlmon. When you type sqlmon to invoke the program, you are actually executing the program file.

• If you are a new user, type help main to learn more about SQLMON basics (such as the SET DBENVIRONMENT command, and how to navigate the SQLMON screens).

• Issue the SET DBENVIRONMENT command to 'connect' to the DBEnvironment. To successfully issue this command, one of the following must be true:
  • you are the DBECreator
  • (on MPE/iX) you have system manager (SM) capability.
  • (on HP-UX) you are logged in as root/superuser.
  • you know the DBEnvironment maintenance word
  
  SQLMONITOR OVERVIEW => set dbenv musicdbe [ MAINT=maint ]

  DBEnvironment is not active (no other session in progress). (DBWARN 34505)

  At least one TurboIMAGE database is attached to this DBEnvironment (DBWARN 34526). TurboIMAGE locks are not visible in SQLMON. Use DBUTIL to determine locks granted on TurboIMAGE objects.
  
  The MAINT word is not required if you are the DBECreator or you have system manager (or root/superuser) capability.

  If nobody is connected to the DBE, then a warning is issued. Many SQLMON screens cannot be accessed if the DBE is not active.

  A warning is issued when an IMAGE/SQL DBE is accessed, to remind you that SQLMON only shows locks on ALLBASE/SQL tables (including the system catalog). You must use DBUTIL to see locks on TurboIMAGE objects.

• For more information about SQLMON, see Chapters 6 - 9 of the ALLBASE/SQL Performance and Monitoring Guidelines document (HP Part No. 36216-90102 on MPE/iX and 36217-90185 on HP-UX).

Page last updated on November 29, 1995