Issuing commands from CICS terminals

You can enter all Db2 commands except START DB2 from a CICS® terminal that is authorized to enter the DSNC transaction code.

Procedure

Begin general-use programming interface information.To issue commands from CICS terminals:

Use the DSNC transaction.
CICS can attach to only one Db2 subsystem at a time, so it does not use the Db2 command prefix. Instead, each command that is entered through the CICS attachment facility must be preceded by a hyphen (-).
The CICS attachment facility routes the commands to the connected Db2 subsystem and obtains the command responses.

Example

For example, you enter the following command:

DSNC -DISPLAY THREAD

Db2 returns the following messages:

DSNV401I - DISPLAY THREAD REPORT FOLLOWS -
DSNV402I - ACTIVE THREADS -
⋮ 
End general-use programming interface information.