DB2ENTRY Resource Table
A CICS® Resource that describes a DB2® entry 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:
- DISCARD
- Discard the DB2 entry.
- DISABLE
- Disable the DB2 entry.
The parameter data for the DISABLE action is:
where cvda is required and is one of the following valid CVDA values for the DB2 entry busy condition:PARM('BUSY(cvda).')- WAIT
- NOWAIT
- FORCE
- External resource name
- CICSDb2Entry
- Length
- 248
- 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
- EYUt0087
| Operations | Actions | Parameters | Required |
|---|---|---|---|
| GET | None | N/A | |
| SET | None | N/A | |
| PERFORM SET | DISABLE | BUSY(WAIT, NOWAIT, FORCE) | Yes |
| DISCARD | None | N/A | |
| ENABLE | 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 | |||
| ABORTS | CNUMERIC | STAT | 4 | AVG | No | Number of aborts | 19 | ||
| ACCOUNTREC | CVDAS | INQ | 4 | LIKE | Yes | Accounting record option | 2 | ||
| ACCOUNTREC Input/output valid values | NONE, TASK, TXID, UOW | ||||||||
| AUTHID | CHAR | INQ | 8 | DIFF | Yes | Thread authorization ID | 6 | ||
| AUTHTYPE | CVDAS | INQ | 4 | LIKE | Yes | Authorization type | 7 | ||
| AUTHTYPE Input/output valid values | GROUP, SIGN, TERM, TX, OPID, USERID | ||||||||
| BASDEFINEVER | BINARY | CPSM | 1 | AVG | No | BAS resource definition version | 0 | E640 E650 | 44 |
| CALLS | CNUMERIC | STAT | 4 | AVG | No | Number of calls | 16 | ||
| CHANGEAGENT | CVDAS | INQ | 4 | LIKE | No | Last modification agent | E640 E650 | 35 | |
| CHANGEAGENT Input/output valid values | CSDAPI, CSDBATCH, DREPAPI, DREPBATCH, CREATESPI, NOTAPPLIC | ||||||||
| CHANGEAGREL | CHAR | INQ | 4 | DIFF | No | Last modification agent release | E640 E650 | 37 | |
| CHANGETIME | DATETIME | INQ | 8 | MAX | No | Last modification time | E640 E650 | 38 | |
| CHANGEUSRID | CHAR | INQ | 8 | DIFF | No | Last modification user ID | E640 E650 | 36 | |
| COMMITS | CNUMERIC | STAT | 4 | AVG | No | Number of commits | 18 | ||
| DEFINESOURCE | CHAR | INQ | 8 | DIFF | No | Source of the resource definition | E640 E650 | 39 | |
| DEFINETIME | DATETIME | INQ | 8 | MAX | No | Creation time | E640 E650 | 40 | |
| DISABLEDACT | CVDAS | INQ | 4 | LIKE | Yes | Disabled action | 3 | ||
| DISABLEDACT Input/output valid values | ABEND, SQLCODE, POOL | ||||||||
| DROLLBACK | CVDAS | INQ | 4 | LIKE | No | Deadlock rollback option | 8 | ||
| DROLLBACK Output valid values | ROLLBACK, NOROLLBACK | ||||||||
| ENABLESTATUS | CVDAS | INQ | 4 | LIKE | Yes | Enabled status | 9 | ||
| ENABLESTATUS Input/output valid values | ENABLED, DISABLED | ||||||||
| ENABLESTATUS Output valid values | DISABLING | ||||||||
| INSTALLAGENT | CVDAS | INQ | 4 | LIKE | No | Installation agent | E640 E650 | 43 | |
| INSTALLAGENT Input/output valid values | CSDAPI, CREATESPI, GRPLIST | ||||||||
| INSTALLTIME | DATETIME | INQ | 8 | MAX | No | Installation time | E640 E650 | 42 | |
| INSTALLUSRID | CHAR | INQ | 8 | DIFF | No | Installation user ID | E640 E650 | 41 | |
| NAME-1 | CHAR | INQ | 8 | DIFF | No | DB2 entry name | 1 | ||
| PLAN | CHAR | INQ | 8 | DIFF | Yes | Plan name | 10 | ||
| PLANEXITNAME | CHAR | INQ | 8 | DIFF | Yes | Dynamic plan exit name | 11 | ||
| PRIORITY | CVDAS | INQ | 4 | LIKE | Yes | TCB priority | 12 | ||
| PRIORITY Input/output valid values | HIGH, EQUAL, LOW | ||||||||
| PROTECTNUM | CNUMERIC | INQ | 4 | AVG | Yes | Maximum number of protected threads | 15 | ||
| PSIGNONS | BINARY | STAT | 4 | AVG | No | Number of partial signons | E640 E650 E660 E670 E680 E690 E700 | 47 | |
| PTCURR | CNUMERIC | STAT | 4 | AVG | No | Current number of protected threads | 28 | ||
| PTHREADS | CNUMERIC | INQ | 4 | AVG | No | Number of protected threads | 4 | ||
| PTHWM | CNUMERIC | STAT | 4 | AVG | No | Peak number of protected threads | 29 | ||
| PTLIM | CNUMERIC | STAT | 4 | AVG | No | Maximum number of protected threads | 27 | ||
| REUSELIMCT | BINARY | STAT | 4 | AVG | No | Number of times a DB2ENTRY thread reached REUSELIMIT | E640 E650 E660 | 46 | |
| RQCUR | CNUMERIC | STAT | 4 | AVG | No | Current number of tasks waiting for thread | 33 | ||
| RQHWM | CNUMERIC | STAT | 4 | AVG | No | Peak number of tasks waiting for thread | 34 | ||
| SIGNONS | CNUMERIC | STAT | 4 | AVG | No | Number of signons | 17 | ||
| SPHASE | CNUMERIC | STAT | 4 | AVG | No | Number of UOWs with single phase commit | 20 | ||
| TCREATE | BINARY | STAT | 4 | AVG | No | Number of times threads created | E640 E650 E660 E670 E680 E690 E700 | 48 | |
| TCURR | CNUMERIC | STAT | 4 | AVG | No | Current number of threads | 25 | ||
| THREADLIMIT | CNUMERIC | INQ | 4 | AVG | Yes | Maximum number of active threads | 14 | ||
| THREADS | CNUMERIC | INQ | 4 | AVG | No | Number of active threads | 5 | ||
| THREADWAIT | CVDAS | INQ | 4 | LIKE | Yes | Thread wait option | 13 | ||
| THREADWAIT Input/output valid values | TWAIT, NOTWAIT, TPOOL | ||||||||
| THWM | CNUMERIC | STAT | 4 | AVG | No | Peak number of active threads | 26 | ||
| TLIMIT | CNUMERIC | STAT | 4 | AVG | No | Maximum number of threads | 24 | ||
| TREUSE | CNUMERIC | STAT | 4 | AVG | No | Number of times threads reused | 21 | ||
| TTERM | CNUMERIC | STAT | 4 | AVG | No | Number of times threads terminated | 22 | ||
| TWORO | CNUMERIC | STAT | 4 | AVG | No | Number of thread waits or overflows | 23 | ||
| XCURR | CNUMERIC | STAT | 4 | AVG | No | Current number of tasks | 30 | ||
| XHWM | CNUMERIC | STAT | 4 | AVG | No | Peak number of tasks | 31 | ||
| XTOTAL | CNUMERIC | STAT | 4 | AVG | No | Total number of tasks | 32 | ||