Follow these steps to view Db2
command activity.
About this task
Db2 Query
Monitor does not track Db2 commands that have not been executed (for example,
syntax errors, bad return codes).
Procedure
-
On the DB2 Query Monitor main menu, type 4 in the
Option field and press Enter.
The DB2 Command Activity panel is displayed:
The following options are available:
- SSID
- The Db2 subsystem on which the activity occurred.
-
- Offload table name
- CQM_DB2_COMMDANDS
- Column name
- DB2_SUBSYSTEM
- Jobname
- The name of the job.
-
- Offload table name
- CQM_DB2_COMMDANDS
- Column name
- JOBNAME
- Authid
- The primary authorization ID.
-
- Offload table name
- CQM_DB2_COMMDANDS
- Column name
- AUTHID
- Command
Timestamp
- The date and time that Query Monitor recorded the execution of a
given Db2 command.
-
- Offload table name
- CQM_DB2_COMMDANDS
- Column name
- COMMAND_TIMESTAMP
- Command
Text
- The text of the Db2
command.
-
- Offload table name
- CQM_DB2_COMMDANDS
- Column name
- COMMAND_TEXT
-
When finished viewing DB2 command activity, press PF3 to
return to the Db2 Query
Monitor Main Menu.