Using the Realtime Monitor › SQL Detail (PF18)

SQL Detail (PF18)

 PM-Rnn.n SYSTEM71         CA, Inc.                  V71      08.348 03:26:10.25
 CMD-->                                                             Window : 02
                                                                    Refresh: 20
   02 SQL Detail                                                              >
   Trans      User     Access         ACM       SQL    Rows     Rows    Rows
   Number     ID       Module   Recompile Processed Fetched Inserted Updated
   557        DDK      SQLAM1         0         1        0        1       0
   962        GRD                     0         8       32        0       0

 PM-Rnn.n SYSTEM71         CA, Inc.                  V71      08.348 03:26:10.25
 CMD-->                                                             Window : 02
                                                                    Refresh: 20
   02 SQL Detail                                                           <  >
 Trans         Rows    Rows Number Hi-Row Lo-Row   Rows  Pages Pages     Pages
 Number     Updated Deleted  Sorts  Sorts  Sorts Sorted Written  Read Requested
 557             0       0       0      0      0      0      2     0       5
 962             0       0       0      0      0      0      0     0      86

 PM-Rnn.n SYSTEM71         CA, Inc.                  V71      08.348 03:26:10.25
 CMD-->                                                             Window : 02
                                                                    Refresh: 20
   02 SQL Detail                                                           <
  Trans      Hi-Row Lo-Row   Rows  Pages Pages     Pages    Rows Update Select
  Number      Sorts  Sorts Sorted Written  Read Requested Current  Locks  Locks
  557             0      0      0      2     0       5        1       7      3
  962             0      0      0      0     0      86       50       1      5

Screen Description

The SQL Detail screen displays a line of information for each SQL transaction.

What To Look For

• Look for a high number in the Rows Requested field compared to the number in the Rows Current field. This ratio should be as close to 1:1 as possible.
• Look at the ratio of pages requested to pages read. The ratio can be an indication of the effectiveness of the buffer size and database design. Low ratios could indicate that either the buffer is too small or the database should be tuned.
• 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.

Active System Summary (PF19)

PM-Rnn.n SYSTEM71         CA, Inc.                  V71      08.348 03:31:10.25
 CMD-->                                                             Window : 02
                                                                    Refresh: 20
   02 Active System Summary                                                   >
   Job      Job      Job           Program
   Name     Number   Status   ASID Name        DCV     CV    SVC Version
   SYSTEM71 JOB19126   NS     007C RHDCOMVS    710    148    172 18.5.00
   SYSTEM72 JOB05353   NS     0079 RHDCOMVS    720    222    172 18.5.00 

PM-Rnn.n SYSTEM71         CA, Inc.                  V71      08.348 03:31:10.25
 CMD-->                                                             Window : 02
                                                                    Refresh: 20
   02 Active System Summary                                                   >
   Job      Job           Program                                Tape  
   Name     Status   ASID Name        DCV     CV    SVC Version  Number
   SYSTEM71   NS     007C RHDCOMVS    710    148    172 18.5.00  GJI50B
   SYSTEM72   NS     0079 RHDCOMVS    720    222    172 18.5.00  GJI50B

Screen Description

The Active System Summary screen provides a list of all active IDMS central versions (z/OS only). To select a system for monitoring, type any non-blank character in the select field to the left of a system name and press ENTER.

Note: You can also select a system for monitoring using the SYStem top-line command. For more information on the SYStem command, see Control Keys and Commands.