Viewing your drill down path

You can view your drill down path from any activity summary panel using the KEYMAP command.

Procedure

  1. On the Db2 Query Monitor main menu, type 1 in the Option field and press Enter.
  2. Select the summary level that you want to view.
  3. Navigate to the SQL activity of interest.
  4. In the option line, type KEYMAP and press Enter.
    The Display Summary Keys panel is displayed:
    Figure 1. Display Summary Keys panel
    YYYY/MM/DD HH:MM:SS  --------- Display Summary Keys --------  Row 1 of 10         
Option  ===>                                                  Scroll ===> PAGE 
 QM Subsystem : QM01                Interval Start Date: MM/DD/YYYY  Time: HH:MM:SS 
MVS SMFID       : DB01                Interval End   Date: CURRENT     Time: CURRENT  
    ------------------------------------------------------------------------     > 
    2.3/2.2 SUMMARIZE BY DESCRIPTION                                           
    LINECMD KEY TYPE     KEY VALUE                                             
    ------- ------------ ------------------------------------------------------
      4/U   Authid       DB2 Authid Operational Display                        
            PLAN         DB2V8PLN                                              
            Program      DB2V8PLN                                              
            DB2 SSID     DB01                                                  
      3/R   Program      Program Operational Display                           
            PLAN         DB2V8PLN                                              
            DB2 SSID     DB01                                                  
      2/2   DB2          DB2 Operational Display                               
            PLAN         DB2V8PLN                                              
      1/P   Plan         Plan Operational Display                              
***************************** Bottom of Data **********************************