Viewing activity summaries

Browse summary level information from an operational or structural perspective for the Db2® subsystems monitored by your Query Monitor subsystem.

Activity summary perspectives
SQL activity in a Db2® subsystem can be summarized from an operational perspective or a structural perspective.
Activity summaries - fields (ISPF)
The fields at the top of the activity summary panels show information about the selected interval and the navigational sequence you took to view the data.
Activity summaries - line commands (ISPF)
The line commands that are available on the activity summary panels allow you to refine your view of query information. The line commands that are available vary based on your drill-down path.
Activity summaries - columns (ISPF)
The columns that display on the various activity summary panels depend on your view (operational or structural summaries) and on the line commands that you have selected.
Unstacking to prior level in summaries
When you view data in activity summaries, you can re-select a particular option. How Db2® Query Monitor behaves when you do this is controlled by the Unstack To Prior Level In Summaries setting on the Query Monitor Dialog Options panel [IBM DB2 Query Monitor for z/OS panel (the main menu) option 0. Settings].
Viewing your drill down path
You can view your drill down path from any activity summary panel using the KEYMAP command.
Selecting a summary level
You can select either an operational or structural summary perspective when viewing your SQL activity.
Viewing SQL activity for a selected summary
When you view activity summaries in Db2® Query Monitor, you can view the SQL activity for the activity level of interest, such as a specific plan, Db2® subsystem, or program.
Operational summaries
You can use operational summaries to view and drill down through summaries of SQL activity from the perspective of the Db2 application program that produced the SQL requests.
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.

Parent topic: Using the ISPF interface