Viewing Db2 command activity

You can view Db2® command activity for the Db2 subsystems that are monitored by your Query Monitor subsystem.

About this task

Db2 Query Monitor does not track Db2 commands that have not been executed. For example, if the commands had syntax errors or bad return codes, they are not tracked by Db2 Query Monitor.

Procedure

To view Db2 command activity:
  1. On the IBM DB2 Query Monitor for z/OS panel (the main menu), specify your subsystem in the Query Monitor Target field.
  2. Specify 4 in the Option field, and press Enter.
    The DB2 Command Activity panel is displayed:
    Figure 1. DB2 Command Activity panel
    YYYY/MM/DD HH:MM:SS  ------- DB2 Command Activity -------  Row 1 of 5          
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 
------------------------------------------------------------------------     > 
SSID  JOBNAME  AUTHID   Command Timestamp     Command Text                     
----  -------- -------- --------------------- ---------------------------------
SS01  JOBNM1   USERID   MM/DD/YYYY -  2:13:49 -DISPLAY DATABASE(*)             
SS01  JOBNM1   USERID   MM/DD/YYYY -  2:33:34 -DISPLAY DATABASE(*)             
SS01  JOBNM1   USERID   MM/DD/YYYY -  3:01:22 -DISPLAY DATABASE(*)             
SS01  JOBNM1   USERID   MM/DD/YYYY -  3:12:27 -DISPLAY DATABASE(*)             
SS01  JOBNM1   USERID   MM/DD/YYYY -  3:21:11 -DISPLAY DATABASE(*)             
***************************** Bottom of Data **********************************
    The columns on this panel display information from the CQM_DB2_COMMANDS table as follows:
    Column on the DB2 Command Activity panel Column in CQM_DB2_COMMANDS
    SSID DB2_SUBSYSTEM
    JOBNAME JOBNAME
    AUTHID AUTHID
    Command Timestamp COMMAND_TIMESTAMP
    Command Text COMMAND_TEXT

    For more information about any of these columns, see CQM_DB2_COMMANDS.

What to do next

When finished viewing DB2 command activity, press PF3 to return to the IBM DB2 Query Monitor for z/OS panel (the main menu).