DSNC STOP

Use the CICS® DB2® attachment facility command DSNC STOP to stop the attachment facility. Alternatively, you can issue a CEMT or EXEC CICS SET DB2CONN NOTCONNECTED command to stop the attachment facility.

Environment

This command can be issued only from a CICS terminal.

Syntax

STOP syntax

Abbreviation

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

Authorization

Access to this command can be controlled using the CICS transaction attach security check for transaction DSNC, and the CICS command security check for resource DB2CONN. This command requires UPDATE access.

This command requires UPDATE access. For more information about CICS security, see Security in a CICS DB2 environment.

Parameter description

QUIESCE: Specifies that the CICS DB2 attachment facility is to be stopped after CICS transactions currently running complete. QUIESCE waits for all active transactions to complete, so new UOWs can start and acquire threads.
FORCE: Specifies that the CICS DB2 attachment facility is to be stopped immediately by forcing disconnection with DB2, regardless of any transactions that are running. Currently running transactions that have accessed DB2 are forcepurged. This includes transactions that may have committed updates to DB2 in a previous UOW, but have not yet accessed DB2 in their current UOW.

Usage notes

For a DSNC STOP QUIESCE, message DFHDB2012 is output to the terminal. The terminal then remains locked until shutdown is complete, when message DFHDB2025 is output.

For a DSNC STOP FORCE, message DFHDB2022 is output to the terminal. The terminal then remains locked until shutdown is complete, when message DFHDB2025 is output.

Examples

Example 1

To quiesce stop the CICS DB2 attachment facility:

 
    DSNC STOP

Figure 1. Sample output from DSNC STOP command

 
DFHDB2012 07/09/98 14:54:28 IYK4Z2G1 Stop quiesce of the CICS-DB2 attachment
facility from DB2 subsystem DB3A is proceeding.

The message resulting from the DSNC STOP command shown in Figure 1 is replaced by the message shown in Figure 2 when shutdown is complete.

Figure 2. Sample output from DSNC STOP when shutdown is complete

 
DFHDB2025I 07/09/98 14:58:53 IYK4Z2G1 The CICS-DB2 attachment has disconnected
from DB2 subsystem DB3A

Example 2

To force stop the CICS DB2 attachment facility:

 
    DSNC STOP FORCE

Figure 3. Sample output from DSNC STOP FORCE command

 
DFHDB2022 07/09/98 15:01:51 IYK4Z2G1 Stop force of the CICS-DB2 attachment
facility from DF2D is proceeding.

The message resulting from the DSNC STOP FORCE command shown in Figure 3 is replaced by the message shown in Figure 4 when shutdown is complete.

Figure 4. Sample output from DSNC STOP FORCE when shutdown is complete

 
DFHDB2025I 07/09/98 15:10:55 IYK4Z2G1 The CICS-DB2 attachment has disconnected
from DB2 subsystem DF2D group DFP2

In this example, group attach was used, so the name of the DB2 subsystem and the name of its group are shown.