DSNC STRT

Use the DSNC STRT command to start the CICS® DB2® attachment facility. The CICS DB2 attachment facility allows CICS application programs to access DB2 databases. Alternatively, issue a CEMT or EXEC CICS SET DB2CONN CONNECTED command to allows your CICS application programs to access DB2 databases.

Environment

This command can be issued only from a CICS terminal.

Syntax

STRT syntax

Read syntax diagramSkip visual syntax diagram DSNC STRT   ssid

Abbreviation

DSNC STRT or STRT (using the STRT 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.

For more information about CICS security, see Security in a CICS DB2 environment.

Parameter description

ssid
Specifies a DB2 subsystem ID to override the DB2 subsystem ID (DB2ID) or DB2 data-sharing group ID (DB2GROUPID) specified in the DB2CONN. You cannot specify a DB2 data-sharing group ID in a DSNC STRT command.

Usage notes

If a DB2CONN is not installed when the DSNC STRT command is issued, error message DFHDB2031 is produced, indicating that no DB2CONN is installed. Resource definitions must be installed from the CSD before attempting to start the CICS DB2 attachment facility.

If you issue a DSNC STRT command and specify a DB2 subsystem ID, any DB2GROUPID in the installed DB2CONN definition is blanked out, and needs to be set again (using CEDA INSTALL or a SET DB2CONN command) to use group attach on subsequent occasions.

The hierarchy for determining the DB2 subsystem to use is as follows:
  1. Use the subsystem ID if specified in a DSNC STRT command.
  2. Use the DB2ID in the installed DB2CONN if not blank.
  3. Use the DB2GROUPID in the installed DB2CONN for group attach.
  4. Use the subsystem ID if specified on the INITPARM when the DB2ID and DB2GROUPID in the last installed DB2CONN are blank (or have subsequently been set to blanks). On any startup, INITPARM is always used if the last installed DB2CONN contained a blank DB2ID and a blank DB2GROUPID, even if the DB2ID or DB2GROUPID were subsequently changed using a SET command.
  5. Use a default subsystem ID of DSN.

Examples

Example 1
To start the CICS DB2 attachment facility using the DB2 subsystem ID (DB2ID) or DB2 data-sharing group ID (DB2GROUPID) from an installed DB2CONN: 
 
                  DSNC STRT
In this example, group attach is used, so the name of the DB2 subsystem and the name of its group are shown.
Figure 1. Sample output from DSNC STRT command
 
DFHDB2023I 07/09/98 15:06:07 IYK4Z2G1 The CICS DB2 attachment has connected to
DB2 subsystem DF2D group DFP2
Example 2
To start the CICS DB2 attachment facility, using an installed DB2CONN, but overriding the DB2 subsystem ID (DB2ID) or DB2 data-sharing group ID (DB2GROUPID) in the DB2CONN with the DB2 subsystem ID DB3A: 
 
                  DSNC STRT DB3A
Figure 2. Sample output from DSNC STRT using DB3A
 
DFHDB2023I 07/09/97 15:06:07 IYK4Z2G1 The CICS DB2 attachment has connected to
DB2 subsystem DB3A
If you are not using group attach, and the DB2 subsystem is not active when an attempt is made to start the CICS DB2 attachment facility, the following output is received if STANDBYMODE=NOCONNECT is specified in the DB2CONN:
Figure 3. Sample output from DSNC STRT when DB2 is not active and STANDBYMODE=NOCONNECT
DFHDB2018 07/09/98 15:14:10 IYK4Z2G1 DB3A DB2 subsystem is not active.
If STANDBYMODE=CONNECT or RECONNECT, the following output is received:
Figure 4. Sample output from DSNC STRT when DB2 is not active and STANDBYMODE=CONNECT or RECONNECT
 DFHDB2037 07/09/98 15:15:42 IYK4Z2G1 DB2 subsystem DB3A is not active.
 The CICS DB2 attachment facility is waiting.
If you are using group attach, and no DB2 subsystems in the data-sharing group are active when an attempt is made to start the CICS DB2 attachment facility, the following output is received if STANDBYMODE=NOCONNECT is specified in the DB2CONN:
Figure 5. Sample output from DSNC STRT with group attach when no DB2 subsystems in the data-sharing group are active and STANDBYMODE=NOCONNECT
 DFHDB2037 07/09/01 12:30:10 IYK2ZFV1 DB2 group DFP2 has no active members.
If STANDBYMODE=CONNECT or RECONNECT, the following output is received:
Figure 6. Sample output from DSNC STRT with group attach when no DB2 subsystems in the data-sharing group are active and STANDBYMODE=CONNECT or RECONNECT
 DFHDB2037 07/09/01 12:55:00 IYK2ZFV1 DB2 group DFP2 has no active members.
 The CICS DB2 attachment facility is waiting.