DB2CONN Resource Table
A CICS® Resource that describes a DB2® connection in an active CICS system being managed by CICSPlex® SM.
The Primary key field for this resource class is NAME.
The following actions are supported:
- REBUILD
- Rebuild the security environment.
- CONNECT
- Connect to the DB2 environment.
The CONNECT action does have a parameter, BUSY, but this is ignored and deprecated. Applications should not specify the BUSY parameter. Note that the BUSY parameter still applies to DISCONNECT and is a required parameter.
- DISCONNECT
- Disconnect from the DB2 environment.
The parameter data for the DISCONNECT action is:
where cvda is required and is one of the following valid CVDA values for the DB2 connection busy condition:PARM('BUSY(cvda).')- WAIT
- NOWAIT
- FORCE
- FORCE
- Force disconnection from the DB2 environment.
- DISCARD
- Discard the DB2 connection.
- External resource name
- CICSDb2Connection
- Length
- 408
- Usage
- API or WUI or CICS Management Client Interface or EVALDEF
- API view
- Yes
- CMAS context
- No
- SCOPE applies
- Yes
- Only query CMASs in workload
- No
- Object type
- CICS Resource
- Copybook identifier
- EYUt0086
| Operations | Actions | Parameters | Required |
|---|---|---|---|
| GET | None | N/A | |
| SET | None | N/A | |
| PERFORM SET | REBUILD | None | N/A |
| CONNECT | BUSY(value) | No | |
| DISCONNECT | BUSY(WAIT, NOWAIT, FORCE) | Yes | |
| FORCE | None | N/A | |
| DISCARD | None | N/A |
| Name | Datatype | Source | Len | Sum | Set | Description | Default | Get Invalid | Attr ID |
|---|---|---|---|---|---|---|---|---|---|
| EYU_CICSNAME | CHAR | CPSM | 8 | DIFF | No | CICS System Name | |||
| EYU_CICSREL | CHAR | CPSM | 4 | DIFF | No | CICS Release | |||
| EYU_RESERVED | CHAR | CPSM | 4 | N/A | No | Reserved | |||
| ACCOUNTREC | CVDAS | INQ | 4 | LIKE | Yes | Accounting record option | 2 | ||
| ACCOUNTREC Input/output valid values | UOW, TXID, NONE, TASK | ||||||||
| AUTHID | CHAR | INQ | 8 | DIFF | Yes | Pool thread authorization ID | 3 | ||
| AUTHTYPE | CVDAS | INQ | 4 | LIKE | Yes | Pool thread authorization type | 4 | ||
| AUTHTYPE Input/output valid values | GROUP, SIGN, TERM, TX, OPID, USERID | ||||||||
| AUTHTYPE Output valid values | NOTAPPLIC | ||||||||
| BASDEFINEVER | BINARY | CPSM | 1 | AVG | No | BAS resource definition version | 0 | E640 E650 | 77 |
| CCALLS | CNUMERIC | STAT | 4 | AVG | No | Number of calls using command threads | 55 | ||
| CHANGEAGENT | CVDAS | INQ | 4 | LIKE | No | Last modification agent | E640 E650 | 69 | |
| CHANGEAGENT Input/output valid values | CSDAPI, CSDBATCH, DREPAPI, DREPBATCH, CREATESPI, NOTAPPLIC | ||||||||
| CHANGEAGREL | CHAR | INQ | 4 | DIFF | No | Last modification agent release | E640 E650 | 70 | |
| CHANGETIME | DATETIME | INQ | 8 | MAX | No | Last modification time | E640 E650 | 72 | |
| CHANGEUSRID | CHAR | INQ | 8 | DIFF | No | Last modification user ID | E640 E650 | 68 | |
| COMAUTHID | CHAR | INQ | 8 | DIFF | Yes | Command thread authorization ID | 7 | ||
| COMAUTHTYPE | CVDAS | INQ | 4 | LIKE | Yes | Command thread authorization type | 8 | ||
| COMAUTHTYPE Input/output valid values | CGROUP, CSIGN, CTERM, CTX, COPID, CUSERID | ||||||||
| COMAUTHTYPE Output valid values | NOTAPPLIC | ||||||||
| COMTHREADLIM | CNUMERIC | INQ | 4 | AVG | Yes | Maximum number of command threads | 6 | ||
| COMTHREADS | CNUMERIC | INQ | 4 | AVG | No | Number of active command threads | 5 | ||
| CONNECTERROR | CVDAS | INQ | 4 | LIKE | Yes | Connection error processing option | 9 | ||
| CONNECTERROR Input/output valid values | ABEND, SQLCODE | ||||||||
| CONNECTST | CVDAS | INQ | 4 | LIKE | Yes | Connection status | 10 | ||
| CONNECTST Input/output valid values | CONNECTED, NOTCONNECTED | ||||||||
| CONNECTST Output valid values | CONNECTING, DISCONNING | ||||||||
| CSIGNONS | CNUMERIC | STAT | 4 | AVG | No | Number of command thread signons | 56 | ||
| CTCURR | CNUMERIC | STAT | 4 | AVG | No | Current number of command threads | 60 | ||
| CTHWM | CNUMERIC | STAT | 4 | AVG | No | Peak number of command threads | 61 | ||
| CTIMEGMT | TIMESTP | STAT | 8 | MAX | No | GMT connect time | 32 | ||
| CTIMELOC | TIMESTP | STAT | 8 | MAX | No | Local connect time | 33 | ||
| CTLIMIT | CNUMERIC | STAT | 4 | AVG | No | Maximum number of command threads | 59 | ||
| CTOVERF | CNUMERIC | STAT | 4 | AVG | No | Number of command thread overflows to pool | 58 | ||
| CTTERM | CNUMERIC | STAT | 4 | AVG | No | Number of command thread terminations | 57 | ||
| DB2GROUPID | CHAR | INQ | 4 | DIFF | Yes | DB2 data sharing group ID | 65 | ||
| DB2ID | CHAR | INQ | 4 | DIFF | Yes | DB2 subsystem ID | 11 | ||
| DB2RELEASE | CHAR | INQ | 4 | DIFF | No | DB2 version and release | 12 | ||
| DEFINESOURCE | CHAR | INQ | 8 | DIFF | No | Source of the resource definition | E640 E650 | 73 | |
| DEFINETIME | DATETIME | INQ | 8 | MAX | No | Creation time | E640 E650 | 74 | |
| DROLLBACK | CVDAS | INQ | 4 | LIKE | No | Deadlock resolution rollback option | 13 | ||
| DROLLBACK Output valid values | ROLLBACK, NOROLLBACK | ||||||||
| DTIMEGMT | TIMESTP | STAT | 8 | MAX | No | GMT disconnect time | 34 | ||
| DTIMELOC | TIMESTP | STAT | 8 | MAX | No | Local disconnect time | 35 | ||
| INSTALLAGENT | CVDAS | INQ | 4 | LIKE | No | Installation agent | E640 E650 | 71 | |
| INSTALLAGENT Input/output valid values | CSDAPI, CREATESPI, GRPLIST | ||||||||
| INSTALLTIME | DATETIME | INQ | 8 | MAX | No | Installation time | E640 E650 | 76 | |
| INSTALLUSRID | CHAR | INQ | 8 | DIFF | No | Installation user ID | E640 E650 | 75 | |
| MSGQUEUE1 | CHAR | INQ | 4 | DIFF | Yes | Unsolicited error message TDQ name 1 | 14 | ||
| MSGQUEUE2 | CHAR | INQ | 4 | DIFF | Yes | Unsolicited error message TDQ name 2 | 15 | ||
| MSGQUEUE3 | CHAR | INQ | 4 | DIFF | Yes | Unsolicited error message TDQ name 3 | 16 | ||
| NAME-1 | CHAR | INQ | 8 | DIFF | No | DB2 connection name | 1 | ||
| NONTERMREL | CVDAS | INQ | 4 | LIKE | Yes | Non-terminal transaction thread-release option | 17 | ||
| NONTERMREL Input/output valid values | RELEASE, NORELEASE | ||||||||
| PABORTS | CNUMERIC | STAT | 4 | AVG | No | Number of pool thread aborts | 42 | ||
| PCALLS | CNUMERIC | STAT | 4 | AVG | No | Number of calls using pool threads | 39 | ||
| PCOMMITS | CNUMERIC | STAT | 4 | AVG | No | Number of pool thread commits | 41 | ||
| PLAN | CHAR | INQ | 8 | DIFF | Yes | Name of plan used for pool | 18 | ||
| PLANEXITNAME | CHAR | INQ | 8 | DIFF | Yes | Name of dynamic plan exit used for pool threads | 19 | ||
| PPSIGNONS | BINARY | STAT | 4 | AVG | No | Number of pool thread partial signons | E640 E650 E660 E670 E680 E690 E700 | 81 | |
| PREUSELIMCT | BINARY | STAT | 4 | AVG | No | Number of times a pool thread reached REUSELIMIT | E640 E650 E660 | 80 | |
| PRIORITY | CVDAS | INQ | 4 | LIKE | Yes | TCB priority | 20 | ||
| PRIORITY Input/output valid values | HIGH, EQUAL, LOW | ||||||||
| PRQCUR | CNUMERIC | STAT | 4 | AVG | No | Current number of tasks waiting for pool thread | 53 | ||
| PRQHWM | CNUMERIC | STAT | 4 | AVG | No | Peak number of tasks waiting for pool thread | 54 | ||
| PSIGNONS | CNUMERIC | STAT | 4 | AVG | No | Number of pool thread signons | 40 | ||
| PSPHASE | CNUMERIC | STAT | 4 | AVG | No | Number of units of work with single phase commit | 43 | ||
| PTCREATE | BINARY | STAT | 4 | AVG | No | Number of times threads created | E640 E650 E660 E670 E680 E690 E700 | 82 | |
| PTCURR | CNUMERIC | STAT | 4 | AVG | No | Current number of active pool threads | 48 | ||
| PTHWM | CNUMERIC | STAT | 4 | AVG | No | Peak number of active pool threads | 49 | ||
| PTLIMIT | CNUMERIC | STAT | 4 | AVG | No | Maximum number of pool threads | 47 | ||
| PTREUSE | CNUMERIC | STAT | 4 | AVG | No | Number of times transactions reused pool threads | 44 | ||
| PTTERM | CNUMERIC | STAT | 4 | AVG | No | Number of times threads terminated | 45 | ||
| PTWAIT | CNUMERIC | STAT | 4 | AVG | No | Number of pool thread waits | 46 | ||
| PURGECYCLEM | CNUMERIC | INQ | 4 | AVG | Yes | Protected thread purge cycle (minutes) | 21 | ||
| PURGECYCLES | CNUMERIC | INQ | 4 | AVG | Yes | Protected thread purge cycle (seconds) | 22 | ||
| PXCURR | CNUMERIC | STAT | 4 | AVG | No | Current number of tasks using a pool thread | 50 | ||
| PXHWM | CNUMERIC | STAT | 4 | AVG | No | Peak number of tasks using a pool thread | 51 | ||
| PXTOTAL | CNUMERIC | STAT | 4 | AVG | No | Total number of tasks that used a pool thread | 52 | ||
| RESYNCMEMBER | CVDAS | INQ | 4 | LIKE | Yes | Resynchronization member | 66 | ||
| RESYNCMEMBER Input/output valid values | RESYNC, NORESYNC, NOTAPPLIC | ||||||||
| REUSELIMIT | BINARY | INQ | 4 | AVG | Yes | Thread reuse limit | E640 E650 E660 | 79 | |
| SIGNID | CHAR | INQ | 8 | DIFF | Yes | Authorization ID used by CICS-DB2 attach | 23 | ||
| STANDBYMODE | CVDAS | INQ | 4 | LIKE | Yes | Standby mode action | 31 | ||
| STANDBYMODE Input/output valid values | NOCONNECT, CONNECT, RECONNECT | ||||||||
| STATSQUEUE | CHAR | INQ | 4 | DIFF | Yes | Attachment statistics TDQ name | 24 | ||
| TCBFREE | CNUMERIC | STAT | 4 | AVG | No | Current number of connections without a TCB | 62 | ||
| TCBLIMIT | CNUMERIC | INQ | 4 | AVG | Yes | Maximum number of connections (TCBLIMIT) | 26 | ||
| TCBRDYQCURR | CNUMERIC | STAT | 4 | AVG | No | Current number of tasks waiting for a connection | 63 | ||
| TCBRDYQHWM | CNUMERIC | STAT | 4 | AVG | No | Peak number of tasks waiting for a connection | 64 | ||
| TCBS | CNUMERIC | INQ | 4 | AVG | No | Current number of connections with a TCB | 25 | ||
| TCURR | CNUMERIC | STAT | 4 | AVG | No | Current number of connections with a TCB | 37 | ||
| THREADERROR | CVDAS | INQ | 4 | LIKE | No | Action following thread error | 27 | ||
| THREADERROR Output valid values | ABEND, N906D, N906 | ||||||||
| THREADLIMIT | CNUMERIC | INQ | 4 | AVG | Yes | Maximum number of pool threads | 29 | ||
| THREADS | CNUMERIC | INQ | 4 | AVG | No | Number of active pool threads | 30 | ||
| THREADWAIT | CVDAS | INQ | 4 | LIKE | Yes | Thread wait option | 28 | ||
| THREADWAIT Input/output valid values | TWAIT, NOTWAIT | ||||||||
| THWM | CNUMERIC | STAT | 4 | AVG | No | Peak number of subtask TCBs | 38 | ||
| TLIMIT | CNUMERIC | STAT | 4 | AVG | No | Current maximum number of subtask TCBs | 36 | ||