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