DSNC MODIFY

Use the CICS® DB2® attachment facility command DSNC MODIFY to modify: the message queue destinations of the DB2CONN, the THREADLIMIT value for the pool, DSNC commands, or DB2ENTRYs. These modifications can also be made using CEMT, or EXEC CICS, SET DB2CONN or DB2ENTRY commands.

Environment

This command can be issued only from a CICS terminal.

Syntax

MODIFY syntax

Read syntax diagramSkip visual syntax diagram DSNC MODIFY DESTinationoldnewTRANsactiontransaction-idinteger

Abbreviation

DSNC MODI or MODI (using the MODI transaction from the CICS DB2 sample group DFH$DB2).

Authorization

You can control access to this command using CICS authorization checks:

  • Transaction attach security for transaction DSNC.
  • Command security for resource DB2CONN. This command requires UPDATE access.
  • For DSNC MODIFY TRANSACTION commands modifying the attributes of a DB2ENTRY. There are also command security checks for resources DB2ENTRY and DB2TRAN and resource security for the DB2ENTRY. The command requires READ access to resource DB2TRAN, and UPDATE access to resource DB2ENTRY for command security. In addition, the resource security command requires UPDATE access to the particular DB2ENTRY involved. For more information about CICS security, see Security in a CICS DB2 environment.

Parameter description

DESTination
Specifies that the MSGQUEUE parameter of the DB2CONN table is to be changed, replacing the "old" destination ID with the "new" destination ID.
old
Any destination ID currently set in the MSGQUEUE of the DB2CONN.
new
A new destination identifier.
TRANsaction transaction-ID integer
Specifies that the THREADLIMIT value associated with the given transaction or group is to be modified. The command uses a transaction ID to identify either the pool, command, or the DB2ENTRY THREADLIMIT value to be modified.
  • To change the THREADLIMIT value of the pool, a transaction ID of CEPL must be used.
  • To change the THREADLIMIT for command threads, a transaction ID of DSNC must be used.
  • To change the THREADLIMIT for a DB2ENTRY, use the transaction ID of any transaction that is defined to use the DB2ENTRY.

integer is a new maximum value.

Usage notes

The integer specified in the command DSNC MODIFY TRANSACTION cannot be larger than the value specified for the TCBLIMIT parameter of the DB2CONN. The lowest possible value is zero.

Examples

Example 1
To change the specification of the MSGQUEUE parameter in the DB2CONN from MTO1 to MTO2: 
 
            DSNC MODI DEST MTO1 MTO2
Figure 1. Sample output from DSNC MODIFY DESTINATION command
 
 DFHDB2039 07/09/98 14:47:17 IYK4Z2G1 The error destinations are: MT02 ****
 ****.
Example 2
To change the pool thread limit to 12: 
 
    DSNC MODI TRAN CEPL 12
Figure 2. Sample output from DSNC MODIFY TRANSACTION command (pool thread)
 
 DFHDB2019 07/09/98 14:49:28 IYK4Z2G1 The modify command is complete.
Example 3
To change the command thread limit to 3: 
 
    DSNC MODI TRAN DSNC 3
Figure 3. Sample output from DSNC MODIFY TRANSACTION command (for a command thread)
 
 DFHDB2019 07/09/98 14:49:28 IYK4Z2G1 The modify command is complete.
Example 4
To change the thread limit of the DB2ENTRY used by transaction XP05 to 8:
 
    DSNC MODI TRAN XP05 8
Figure 4. Sample output from DSNC MODIFY TRANSACTION command (changing DB2ENTRY thread limit)
 
 DFHDB2019 07/09/98 14:49:28 IYK4Z2G1 The modify command is complete.