Accessing current activity from summary displays

You can access current activity from some drill down paths in operational summaries.

Procedure

  1. On the Db2 Query Monitor main menu, type 1 in the Option field and press Enter.
  2. Select the appropriate operational summary level.
  3. Navigate to the drill down path of interest that supports the A line command.
  4. Type A in the CMD field next to the SQL activity of interest and press Enter.
    The Summary SQL Activity panel is displayed with implicit filtering. For example, if you drill down through operational summaries by Db2 (R71C), Plan (DSNESPCS) and Program, then type A in the CMD field next to the line item DSNESM68, the Summary SQL Activity panel shows the current activity for Db2 SSID R71C, Plan DSNESPCS, and Program DSNESM68.
    Figure 1. Summary SQL Activity panel
    YYYY/MM/DD HH:MM:SS  ------- Summary SQL Activity -------   No rows to display  
    Option  ===>                                                  Scroll ===> PAGE 
    QM Subsystem : QM01          Interval Start Date: MM/DD/YYYY  Time: HH:MM:SS 
    Filters Enabled : N             Interval End   Date: CURRENT     Time: CURRENT 
    CMD - Enter "/" to select action 
    ------------------------------------------------------------------------       
    CMD SSID Plan     Program    DB2 CPU Time    DB2 Elapsed       GETPAGES 
    --- ---- -------- -------- -------------- -------------- --------------- 
        DBB6 CQMEOPLN CQMEO          2.031096       2.454969         16,190