Structural summaries

You can use structural summaries to view summaries of SQL activity from the perspective of the Db2 objects on which SQL statements act.

For example, on the Select Summary Level panel, select 5 (Db2) to view information from the Db2 subsystem perspective:

Figure 1. Structural Summaries panel
YYYY/MM/DD HH:MM:SS  ------- Structural Summaries -------   Row 1 of 1     
Option  ===>                                                  Scroll ===> PAGE 
QM Subsystem : QM01         Interval Start Date: MM/DD/YYYY  Time: HH:MM:SS 
Filters Enabled : N            Interval End   Date: MM/DD/YYYY  Time: HH:MM:SS 
CMD - Enter "/" to select action                                                                     >
CMD  DB2            GetPages            Elapsed SyncRead SyncWrit SeqPftch     
 --  ----     -------------- ------------------ -------- -------- --------     
 __  DB01               7683           0.752588        2        0       33     
***************************** Bottom of Data **********************************

You can drill down to refine your view of specific query activity of interest and can access reports that show details about selected activity. When you select a row of data for display, the criteria is added to the filter for obtaining the next set of data. The navigation area (NAVI) of the display is populated as you drill down to the appropriate level. As you back out (drill up), the navigational area is refreshed to remove the levels you have navigated out of.

  • Any column display functions (for example, CSIZE and CFIX) used on any level of the drill down affect all top-level reports.
  • The INTV command can only be used at the top-most level of the operational summaries display.
  • The elapsed time in operational summaries is the elapsed time of the duration of entire SQL calls and the elapsed time in structural summaries is the elapsed time of GETPAGE operations.
  • When a dynamic SQL statement runs on more than one Db2 subsystem and you attempt to view information about that SQL statement in operational summaries, Db2 Query Monitor prompts you to specify the Db2 subsystem ID of interest prior to invoking IBM® Db2 SQL Performance Analyzer for z/OS®.
  • Blank fields indicate you are viewing activity for multiple Db2s/Plans/Pgms/AuthIDs etc. Fields are automatically populated when you drill down to display activity associated with a particular Db2s/Plans/Pgms/AuthIDs etc.