CICS-supplied transactions for CICS DB2

CICS provides a number of transactions that you can use to manage the interface with DB2.

CEMT

The following CEMT options are available:

The equivalent EXEC CICS INQUIRE and EXEC CICS SET commands are described in System commands.

PLAN and PLANEXITNAME options are available on the INQUIRE DB2TRAN command, so you can find out in a single step which plan is used by a specified transaction or set of transactions, or which transactions use a specified plan.

DSNC

The DSNC transaction can be used to perform the following:
  • Enter DB2® commands from a CICS terminal.
  • Cause threads to be terminated when they are released (DSNC DISCONNECT).
  • Display information about transactions using the CICS DB2 interface, and display statistics (DSNC DISPLAY).
  • Modify the unsolicited message destinations, and modify the number of active threads used by a DB2ENTRY, the pool, or for commands (DSNC MODIFY).
  • Shut down the CICS DB2 interface (DSNC STOP).
  • Start the CICS DB2 interface (DSNC STRT).

The DSNC transaction executes program DFHD2CM1, which handles both CICS DB2 attachment facility and DB2 commands. You can distinguish DB2 commands from CICS DB2 attachment facility commands by the hyphen (-) character, which is entered with DB2 commands. This character is not a DB2 subsystem recognition character, but a command recognition character. It is always a -, independent of the character defining the DB2 subsystem, since CICS can only connect to one DB2 subsystem at a time. There is no need to use different DB2 subsystem recognition characters from CICS, and thus we use only the default - character.

DFHD2CM1 can also be activated by transactions other than DSNC. Thus you can give a different transaction code to each CICS DB2 attachment facility command, and to each DB2 command. This enables you to apply different levels of security to each command.

Alternative transaction definitions for CICS DB2, supplied in sample group DFH$DB2

Alternative transaction definitions for CICS DB2 attachment facility commands are supplied with the following names:
  • DISC
  • DISP
  • STRT
  • STOP
  • MODI

Alternative transaction definitions for DB2 commands are also supplied with the following names: