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
|
|
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 |