Issuing Db2 commands
If you have the proper authorization in
BMC AMI Ops Monitor for Db2
(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).
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
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
Related topic
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*