The CICS® DB2® attachment facility DSNC command allows you to enter DB2 commands from CICS .
This command can be issued only from a CICS terminal
DSNC syntax >>-DSNC --+-------------+--db2-command------------------------>< '-destination-'
You can omit DSNC from the DB2 command if the relevant transaction definition is installed from the CICS DB2 sample group, DFH$DB2. For example, if you are installing the -DIS transaction definition.
DSNC -DIS THD(*)
can be abbreviated to:
-DIS THD(*)
The sample CICS DB2 group, DFH$DB2, contains the following transaction definitions for issuing DB2 commands:
-ALT | -ARC | -CAN |
-DIS | -MOD | -REC |
-RES | -SET | -STA |
-STO | -TER |
Issuing DB2 commands using DSNC does not require any authorization from CICS over and above transaction attach security required to run the DSNC transaction. It does, however, require DB2 privileges. For more information about CICS security, see Security in a CICS DB2 environment.
Issue the DB2 command -DISPLAY THREAD from a CICS terminal to display threads for a CICS with applid IYK4Z2G1.
DSNC -DISPLAY THREAD(IYK4Z2G1)
DSNV401I : DISPLAY THREAD REPORT FOLLOWS - DSNV402I : ACTIVE THREADS - NAME ST A REQ ID AUTHID PLAN ASID TOKEN IYK4Z2G1 N 3 JTILLI1 00BA 0 IYK4Z2G1 T 3 ENTRXC060001 CICSUSER TESTC06 00BA 16 IYK4Z2G1 T 3 POOLXP050002 CICSUSER TESTP05 00BA 17 IYK4Z2G1 T * 6 COMDDSNC0003 JTILLI1 00BA 18 DISPLAY ACTIVE REPORT COMPLETE DSN9022I : DSNVDT '-DIS THREAD' NORMAL COMPLETION DFHDB2301 07/09/98 13:36:36 IYK4Z2G1 DSNC DB2 command complete.