Accessing current activity from summary displays
You can access current activity from some drill down paths in operational summaries.
Procedure
- On the Db2 Query Monitor main menu, type 1 in the Option field and press Enter.
- Select the appropriate operational summary level.
- Navigate to the drill down path of interest that supports the A line command.
-
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