Monitoring the CICS DB2 attachment facility using DB2 commands

Once a connection between CICS and DB2 is established, terminal users authorized by CICS security can use the DSNC transaction to route commands to the DB2 system.

About this task

The commands take the following form: 
     DSNC-DB2command

For example, the DSNC -DIS THREAD command can show CICS DB2 threads.

The command is routed to DB2 for processing. DB2 checks that the authorization ID passed from CICS is authorized to issue the command entered.

Responses are routed back to the originating CICS user. The command recognition character (CRC) of a hyphen, (-), must be used to distinguish DB2 commands from CICS DB2 attachment facility commands. For DB2 commands issued from CICS, the CRC is always -, regardless of the subsystem recognition character.

Both CICS and DB2 authorization are required to issue DB2 commands from a CICS terminal:
  • CICS authorization is required to use the DSNC transaction, and
  • DB2 authorization is required to issue DB2 commands.

For more information see CICS-supplied transactions for CICS DB2.