Skip to Content

Default language.

Issuing Db2 commands

If you have the proper authorization in  (different from Db2 authorization), you can also issue Db2 commands from the full-screen COMMAND line (usually from the Log Display so that you can see the response).

Related topic

Reviewing-critical-problems

To issue Db2 commands

Issue the DISPLAY THREAD command by entering -DIS THD(*) on the COMMAND line.The command is routed automatically to the Db2 system that is shown in the target field. You do not need to know the subsystem recognition character (SSRC) for each Db2.

The command response is displayed.

BMC Software -------------------- Log Display -------------- General services
COMMAND ===>                                                 TGT ===> DB2G
LINE=      30,270  LOG= #1   STATUS= INPUT    TIME= 16:01:28 INTV===> 3
16:00:20  -DIS THD(*)
16:00:20  DSNV401I - DISPLAY THREAD REPORT FOLLOWS -
16:00:20  DSNV402I - ACTIVE THREADS -
16:00:20  NAME     ST A   REQ ID           AUTHID   PLAN     ASID
16:00:20  DB2CALL  T  *   143 DB231        D31X              0068
16:00:20  DB2CALL  T       30 OLTF         OLTF              00CF
16:00:20  X18H     N      300 0001DSN8IC0  PDRIVER           010D
16:00:20  X18H     N        2              BABUSER           00FC
16:00:20  CICSCN3  N        3              BABUSER           0117
16:00:20  CICSCN3  N        0                                0117
16:00:20  CICSCN3  N        0                                0117
16:00:20  CICSCN3  N        0                                0117
16:00:20  CICSCN3  N        0                                0117
16:00:20  CICSCN3  N        0                                0117
16:00:20  CICSCN3  N        0                                0117
16:00:20  CICSCN3  N        0                                0117
16:00:20  CICSCN3  N        0                                0117
16:00:20  CICSCN3  N        0                                0117
16:00:20  CICSCN3  N        0                                0117
16:00:20  CICSCN3  N        0                                0117
16:00:20  CICSCN3  N        0                                0117
16:00:20  DISPLAY ACTIVE REPORT COMPLETE
16:00:20  DSN9022I - DSNVDT '-DIS THD' NORMAL COMPLETION

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

BMC AMI Ops Monitor for Db2 13.1