CREATE DB2CONN

Define a DB2CONN in the local system.

Read syntax diagramSkip visual syntax diagramCREATE DB2CONN
 
>>-CREATE DB2CONN(data-value)--ATTRIBUTES(data-value)----------->
 
>--ATTRLEN(data-value)--LOGMESSAGE(cvda)-----------------------><
 
CREATE DB2CONN attribute values:
 
                            .-CONNECTERROR(sqlcode)-.
|--+---------------------+--+-----------------------+----------->
   '-DESCRIPTION(char58)-'  '-CONNECTERROR(abend)---'
 
                          .-MSGQUEUE1(CDB2)--.
>--+-------------------+--+------------------+------------------>
   +-DB2GROUPID(char4)-+  '-MSGQUEUE1(char4)-'
   '-DB2ID(char4)------'
 
>--+------------------+--+------------------+------------------->
   '-MSGQUEUE2(char4)-'  '-MSGQUEUE3(char4)-'
 
   .-NONTERMREL(yes)-.  .-PURGECYCLE(0,30)------.
>--+-----------------+--+-----------------------+--------------->
   '-NONTERMREL(no)--'  '-PURGECYCLE(0-59,0-59)-'
 
   .-RESYNCMEMBER(yes)-.
>--+-------------------+--+---------------+--------------------->
   '-RESYNCMEMBER(no)--'  '-SIGNID(char8)-'
 
   .-STANDBYMODE(reconnect)-.  .-STATSQUEUE(CDB2)--.
>--+------------------------+--+-------------------+------------>
   +-STANDBYMODE(noconnect)-+  '-STATSQUEUE(char4)-'
   '-STANDBYMODE(connect)---'
 
   .-TCBLIMIT(12)-----.  .-THREADERROR(n906d)-.
>--+------------------+--+--------------------+----------------->
   '-TCBLIMIT(4-2000)-'  +-THREADERROR(abend)-+
                         '-THREADERROR(n906)--'
 
   .-ACCOUNTREC(none)-.
>--+------------------+--+---------------+---------------------->
   +-ACCOUNTREC(uow)--+  '-AUTHID(char8)-'
   +-ACCOUNTREC(task)-+
   '-ACCOUNTREC(txid)-'
 
   .-AUTHTYPE(userid)-.  .-DROLLBACK(yes)-.
>--+------------------+--+----------------+--+-------------+---->
   +-AUTHTYPE(group)--+  '-DROLLBACK(no)--'  '-PLAN(char8)-'
   +-AUTHTYPE(signid)-+
   +-AUTHTYPE(term)---+
   +-AUTHTYPE(txid)---+
   '-AUTHTYPE(opid)---'
 
   .-PLANEXITNAME(DSNCUEXT)-.  .-PRIORITY(high)--.
>--+------------------------+--+-----------------+-------------->
   '-PLANEXITNAME(char8)----'  +-PRIORITY(equal)-+
                               '-PRIORITY(low)---'
 
   .-THREADLIMIT(3)------.  .-THREADWAIT(yes)-.
>--+---------------------+--+-----------------+----------------->
   '-THREADLIMIT(3-2000)-'  '-THREADWAIT(no)--'
 
                         .-COMAUTHTYPE(userid)-.
>--+------------------+--+---------------------+---------------->
   '-COMAUTHID(char8)-'  +-COMAUTHTYPE(group)--+
                         +-COMAUTHTYPE(signid)-+
                         +-COMAUTHTYPE(term)---+
                         +-COMAUTHTYPE(txid)---+
                         '-COMAUTHTYPE(user)---'
 
   .-COMTHREADLIM(1)------.
>--+----------------------+-------------------------------------|
   '-COMTHREADLIM(0-2000)-'
 

Conditions: ILLOGIC, INVREQ, LENGERR, NOTAUTH

Note to COBOL programmers:

In the syntax above, you must use
     --- ATTRIBUTES ( data-area )---  instead of
     --- ATTRIBUTES ( data-value)---

Description

The CREATE DB2CONN command installs a DB2CONN definition with the attribute specified on the command. It does not use a resource definition stored in the CSD. If there is already a DB2CONN in the local CICS region, the new definition replaces the old one; if not, the new definition is added.

A syncpoint is implicit in CREATE DB2CONN processing, except when an exception condition is detected early in processing the command. Uncommitted changes to recoverable resources made up to that point in the task are committed if the CREATE executes successfully, and rolled back if not.

Options

ATTRIBUTES(data-value)
specifies the attributes of the DB2CONN being added. The list of attributes must be coded as a single character string using the syntax shown in DB2CONN attributes. See ATTRIBUTES option for general rules for specifying attributes, and the DB2CONN section in the CICS® Resource Definition Guide for details about specific attributes.
Note:
You can assign default values for all attributes of a DB2CONN definition by specifying an ATTRLEN value of 0. You still need to specify the ATTRIBUTES option, however, even though its value is not used.
ATTRLEN(data-value)
specifies the length in bytes of the character string supplied in the ATTRIBUTES option, as a halfword binary value. The length can be from 0 to 32767.
DB2CONN(data-value)
specifies the 8-character name of the DB2CONN definition to be added to the CICS region.
LOGMESSAGE
specifies whether CICS logs the attributes used for the resource being created to the CSDL transient data queue. CVDA values are:
LOG
The resources attributes are logged to the CSDL transient data queue.
NOLOG
The resources attributes are not logged to the CSDL transient data queue.

Conditions

ILLOGIC
RESP2 values:
2
The command cannot be executed because an earlier CONNECTION or TERMINAL pool definition has not yet been completed.
INVREQ
RESP2 values:
n
There is a syntax error in the ATTRIBUTES string, or an error occurred during either the discard or resource definition phase of the processing. See Appendix C. EXEC CICS CREATE RESP2 values for information on RESP2 values.
7
The LOGMESSAGE cvda value is not valid.
200
The command was executed in a program defined with an EXECUTIONSET value of DPLSUBSET or a program invoked from a remote system by a distributed program link without the SYNCONRETURN option.
LENGERR
RESP2 values:
1
The length you have specified in ATTRLEN is negative.
NOTAUTH
RESP2 values:
100
The user associated with the issuing task is not authorized to use this command.
102
The user associated with the issuing task is not an authorized surrogate of the user specified in the AUTHID, COMAUTHID, or SIGNID parameter.
103
The user associated with the issuing task is not authorized to create a DB2CONN with an AUTHTYPE or COMAUTHTYPE parameter.
[[ Contents Previous Page | Next Page Index ]]