IMAGE/SQL: Issues and answers concerning SQL tables

Software

Papers & Training

Java

HP Partners

News & Events

Register for more info

4.2 How are the SQLMON screens and subsystems organized?

Key points

• SQLMON screens are organized into subsystems. Each subsystem is a set of screens that are logically related to each other.
  • OVERVIEW shows general performance information.
  • IO provides information on data and log buffer activity.
  • LOAD displays transaction throughput data.
  • LOCK shows locking activity.
  • SAMPLEIO provides information on DBEFile, table and index I/O.
  • STATIC provides relatively non-dynamic information about DBEFiles, tables, and indexes (such as current size, length of hash overflow chains, etc.)

  Each subsystem consists of a main screen, which has the same name as the subsystem, and additional "detail" screens. For example the screens in the OVERVIEW subsystem are:

  • OVERVIEW (main screen),
  • OVERVIEW SESSION (detail screen)
  • OVERVIEW PROGRAM (detail screen)

• The main screen of a subsystem contains a high-level or summary information for the subsystem, and the other screens give more detailed information. Most of the time, the user will first visit the main screen of a subsystem to obtain the "big picture", and afterwards will visit detail screens to obtain more specific information of interest.

• When you access a screen, you automatically move to the subsystem that the screen belongs to. The name of the current subsystem is displayed in the prompt. For example:

     SQLMONITOR  OVERVIEW  =>  /* you are in the OVERVIEW subsystem. */
  
     SQLMONITOR  LOCK  =>      /* you are in the LOCK subsystem.     */
  

• You access a screen by typing the name of the screen (or an abbreviation) at the prompt. A menu is printed to help you remember the names of screens (and abbreviations) that you should type.

  SQLMONITOR SUBSYSTEMS (and abbreviations):
  
             OVERVIEW     IO     LOAD     LOCK     SAMPLEIO     STATIC
                /o        /i     /loa     /loc        /sa         /st
  
  CURRENT SUBSYSTEM SCREENS:
  
                         OVERVIEW     SESSION     PROGRAM
                             o           s           p
  

  To obtain a screen in the current subsystem, type one of the abbreviations listed in the CURRENT SUBSYSTEM part of the menu:

  NOTE: the prompt shows that you are now in the OVERVIEW subsystem.

  
  SQLMONITOR  OVERVIEW  => o  /* To obtain the OVERVIEW screen         */
  
  SQLMONITOR  OVERVIEW  => s  /* To obtain the OVERVIEW SESSION screen */
  
  SQLMONITOR  OVERVIEW  => p  /* To obtain the OVERVIEW PROGRAM screen */
  

  To obtain a screen in another subsystem, you must type an abbreviation for the subsystem:

  NOTE: the prompt shows that you are now in the LOCK subsystem

  SQLMONITOR  LOCK  => /o     /* To obtain the OVERVIEW screen         */
  
  SQLMONITOR  LOCK  => /o s   /* To obtain the OVERVIEW SESSION screen */
  
  SQLMONITOR  LOCK  => /o p   /* To obtain the OVERVIEW PROGRAM screen */
  

• The OVERVIEW, LOCK, and STATIC subsystems are perhaps the most useful to the typical IMAGE/SQL DBA, so I'll briefly cover these on the next few pages.

Page last updated on November 29, 1995