Using the Realtime Monitor › SQL Overview (PF17)

SQL Overview (PF17)

 PM-Rnn.n SYSTEM71         CA, Inc.                  V71      08.348 15:12:27.33
 CMD-->                                                             Window : 02
                                                                    Refresh: 10
   02 SQL Overview
       _ Row Level Activity
 Fetch     Insert    Update    Delete
 60        5         26        3

           Sort Activity
 Total #   Hi-Row    Low-Row   # Rows
 4         20        3         41

 Access Module       Number of SQL
 Recompiles          Statements
 2                   5

Screen Description

The SQL Overview screen provides summary SQL information for the entire system since startup.

To view detailed information about each active SQL transaction, you can request the SQL Detail screen by returning to the menu screen and pressing PF18, or by typing a nonblank character next to SQL Detail on the menu screen then pressing [Enter].

What To Look For

• Look for large values in the Hi-Row field under Sort Activity.
• Look for large values under Access Module Recompiles. Three reasons for recompiles:
  • Changes in the physical database definition

    Note: Use discretion in planning changes to components of the physical database definition.

  • Program recompiling; the recompile changes the date/time stamp, necessitating an AM recompile

    Note: Try to limit program compiles on a production system.

  • An SQL statement referencing a temporary table before the table is defined

    Note: Define temporary tables before referencing them.

• Monitor the Total # field for total number of sorts performed since startup. Keep track of this field to insure that the database contains the indexes needed to support the application requests for sorted data.