DB2CDEF Resource Table

A CICS® Definition that describes the connection properties of a DB2® connection.

The Primary key field for this resource class is NAME.

The Secondary key field for this resource class is DEFVER.

The Tertairy key field for this resource class is CSDGROUP.

The following actions are supported:
INSTALL
Install a DB2 connection definition.

The parameter data for the INSTALL action is described in Parameters for installing CICS definitions using BAS.

External resource name
CICSDefinitionDb2Connection
Length
280
Usage
API or Batch Utility or WUI or CICS Management Client Interface
API view
No
CMAS context
No
SCOPE applies
No
Only query CMASs in workload
No
Object type
CICS Definition
Copybook identifier
EYUt3817
Table 1. Valid CPSM operations
Operations Actions Parameters Required
GET   CICSSYS(value) No
    CSDGROUP(value) No
    RESGROUP(value) No
CREATE   CSD No
    RESGROUP(value) No
UPDATE   CSD No
REMOVE   CSD No
PERFORM SET INSTALL FORCEINS(YES, NO) No
    MODE(value) No
    NOTIFY(NO, INACTIVE, RELEASE, FULL) No
    OVERRIDE No
    OVERTYPE(TARGET, RELATED, BOTH, NONE) No
    RELATED(value) No
    STATECHK(YES, NO) No
    TARGET(value) Yes
    USAGE(LOCAL) Yes
  ADDTOGRP RESGROUP(value) Yes
  CSDINSTALL None N/A
  CSDCOPY AS_RESOURCE(value) No
    DUPACTION(DUPERROR, DUPNOREPLACE, DUPREPLACE) No
    TO_CSDGROUP(value) No
Table 2. DB2CDEF FEEDBACK error codes
Value Code Description
1 DB2CDEF_INV_DATA Attribute data invalid
2 DB2CDEF_REC_NOT_FOUND Requested resource not found
4 DB2CDEF_REC_EXISTS Resource already exists
5 DB2CDEF_REC_CHANGED Resource definition already changed
6 DB2CDEF_INV_RESTYPE Invalid resource type
7 DB2CDEF_INV_VER Invalid resource version
11 DB2CDEF_NON_MP Maintenance point CMAS not available
12 DB2CDEF_INV_CONTEXT Context not found
13 DB2CDEF_INCONSISTENT_SET Inconsistent set condition
14 DB2CDEF_INV_RESGROUP Resource group not found
21 DB2CDEF_INV_ACTION Invalid action
22 DB2CDEF_INV_RECADDR Invalid record address
23 DB2CDEF_INV_RECLEN Invalid record length
24 DB2CDEF_DIFF_VERSION Different version
25 DB2CDEF_EARLY_NAMELIST_END Early name list end
26 DB2CDEF_INV_NAMELIST Invalid name list
27 DB2CDEF_INV_NAME Invalid name
28 DB2CDEF_INV_MINNAME Invalid minor name
29 DB2CDEF_NOTIFY Notify
30 DB2CDEF_PARTIAL_INSTALL Partial install
31 DB2CDEF_NOTHING_INSTALLED Nothing installed
32 DB2CDEF_NO_TARGETS No targets
33 DB2CDEF_NO_RELATED No related systems
34 DB2CDEF_INV_TSCOPE Invalid target scope
35 DB2CDEF_INV_RSCOPE Invalid related scope
36 DB2CDEF_INV_USAGE Invalid usage
37 DB2CDEF_INV_MODE Invalid mode
38 DB2CDEF_INV_STATECHK Invalid state check
39 DB2CDEF_INV_FORCEINS Invalid force install
40 DB2CDEF_INV_NOTIFY Invalid notify
41 DB2CDEF_INV_OVERTYPE Invalid over type
42 DB2CDEF_INV_OVRBLOCK Invalid override block
43 DB2CDEF_INV_ORSTRING Invalid override string
44 DB2CDEF_INV_STRNGTERM Invalid string terminator
45 DB2CDEF_INV_EMBEDTERM Invalid embedded terminator
46 DB2CDEF_INV_ATTRIBUTE Invalid attribute
47 DB2CDEF_INV_LITERAL Invalid literal
48 DB2CDEF_INV_ORSTGNA Invalid override string
49 DB2CDEF_SCOPE_REQUIRED Scope required
50 DB2CDEF_USAGE_CONFLICT Usage conflict
51 DB2CDEF_NODEFS_SELECTED No definitions selected
52 DB2CDEF_MORE_THAN_1_RELSYS More than one related system
53 DB2CDEF_MISSING_RELSYSID Missing related system identifier
54 DB2CDEF_SCOPE_CONFLICT Scope conflict
55 DB2CDEF_INV_CSDGROUP Invalid CSD group
56 DB2CDEF_REC_NOT_REMOVED Record not removed
57 DB2CDEF_INV_RESOURCE Invalid resource
58 DB2CDEF_INV_CICS_RESTYPE Invalid CICS restype
59 DB2CDEF_PARTIAL_ACTION Partial action
60 DB2CDEF_NOTHING_ACTIONED Nothing actioned
61 DB2CDEF_INV_BOTHTOAS TO_CSDGROUP and AS_RESOURCE are mutually exclusive
62 DB2CDEF_INV_NOTTOAS Either TO_CSDGROUP or AS_RESOURCE is required
63 DB2CDEF_CSD_ERROR CSD access error
Table 3. DB2CDEF resource table attributes
Name Datatype Source Len Req Sum Description Default Value Range Get Invalid Attr ID
ACCOUNTREC CVDAS CPSM 4 Yes LIKE Accounting record option NONE     22
ACCOUNTREC Input/output valid values NONE, UOW, TASK, TXID
AUTHID CHAR CPSM 8 No DIFF Pool thread authorization ID       23
AUTHTYPE CVDAS CPSM 4 Yes LIKE Pool thread authorization type NOTAPPLIC     24
AUTHTYPE Input/output valid values USERID, GROUP, TERM, TX, OPID, SIGN, NOTAPPLIC
CHANGEAGENT CVDAS CPSM 4 No LIKE Last modification agent     E640 E650 43
CHANGEAGENT Input/output valid values DREPAPI
CHANGEAGREL CHAR CPSM 4 No DIFF Last modification agent release     E640 E650 45
CHANGETIME DATETIME CPSM 8 Yes MAX Last modification time       1
CHANGEUSRID CHAR CPSM 8 No DIFF Last modification user ID     E640 E650 44
COMAUTHID CHAR CPSM 8 No DIFF Command thread authorization ID       32
COMAUTHTYPE CVDAS CPSM 4 Yes LIKE Command thread authorization type NOTAPPLIC     33
COMAUTHTYPE Input/output valid values USERID, GROUP, TERM, TX, OPID, SIGN, NOTAPPLIC
COMTHREADLIM CHAR CPSM 4 Yes DIFF Maximum number of command threads 3 0-2000   31
CONNECTERROR CVDAS CPSM 4 Yes LIKE Connection error processing option SQLCODE     9
CONNECTERROR Input/output valid values ABEND, SQLCODE
CREATETIME DATETIME CPSM 8 Yes MAX Time created       34
 CSDGROUP-3  CHAR CPSM 8 Yes DIFF CSD group     E640 E650 47
DB2GROUPID CHAR CPSM 4 No DIFF DB2 data sharing group ID       40
DB2ID CHAR CPSM 4 No DIFF DB2 subsystem ID       10
 DEFVER-2  BINARY CPSM 1 Yes AVG Version 0 0-15   5
DESCCODEPAGE BINARY CPSM 4 No DIFF Description code page 37 0-99999999   42
DESCRIPTION CHAR CPSM 58 No DIFF Description       38
DROLLBACK EYUDA CPSM 4 Yes LIKE Deadlock resoultion rollback option YES     25
DROLLBACK Input/output valid values YES, NO
MSGQUEUE1 CHAR CPSM 4 Yes DIFF Unsolicited error message TDQ name 1 CDB2     11
MSGQUEUE2 CHAR CPSM 4 No DIFF Unsolicited error message TDQ name 2       12
MSGQUEUE3 CHAR CPSM 4 No DIFF Unsolicited error message TDQ name 3       13
 NAME-1  CHAR CPSM 8 Yes DIFF Name       7
NONTERMREL EYUDA CPSM 4 Yes LIKE Non-terminal transaction thread-release option YES     14
NONTERMREL Input/output valid values YES, NO
PLAN CHAR CPSM 8 No DIFF Name of plan used for pool       26
PLANEXITNAME CHAR CPSM 8 No DIFF Name of dynamic plan exit used for pool threads       27
PRIORITY CVDAS CPSM 4 Yes LIKE TCB priority HIGH     28
PRIORITY Input/output valid values HIGH, LOW, EQUAL
PURGECYCLEM CHAR CPSM 2 Yes DIFF Protected thread purge cycle (minutes) 0 0-59   15
PURGECYCLES CHAR CPSM 2 Yes DIFF Protected thread purge cycle (seconds) 30 0-59   16
RESYNCMEMBER EYUDA CPSM 4 Yes LIKE Resynchronization member YES     41
RESYNCMEMBER Input/output valid values YES, NO
REUSELIMIT CHAR CPSM 5 Yes LIKE Thread reuse limit 1000 0-10000 E640 E650 E660 48
SIGNID CHAR CPSM 8 No DIFF Authorization ID used by CICS-DB2 attach       17
STANDBYMODE CVDAS CPSM 4 Yes LIKE Standby mode RECONNECT     18
STANDBYMODE Input/output valid values RECONNECT, NOCONNECT, CONNECT
STATSQUEUE CHAR CPSM 4 Yes DIFF Attachment statistics TDQ name CDB2     19
TCBLIMIT CHAR CPSM 4 Yes DIFF Maximum number of connections into DB2 12 4-2000   20
THREADERROR CVDAS CPSM 4 Yes LIKE Action following thread error N906D     21
THREADERROR Input/output valid values ABEND, N906D, N906
THREADLIMIT CHAR CPSM 4 Yes DIFF Maximum number of pool threads 3 3-2000   30
THREADWAIT EYUDA CPSM 4 Yes LIKE Thread wait option YES     29
THREADWAIT Input/output valid values YES, NO
USERDATA1 CHAR CPSM 8 No DIFF User data area 1       35
USERDATA2 CHAR CPSM 8 No DIFF User data area 2       36
USERDATA3 CHAR CPSM 8 No DIFF User data area 3       37