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:
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.
The parameter data for the DISCONNECT action is:
PARM('BUSY(cvda).')
where cvda is required and is one of the following valid CVDA values for the DB2 connection busy condition:
API Actions
Parameters: None
PARM(' [BUSY(value)] .')
PARM(' BUSY(value) .')
Parameters: None
Parameters: None
Name | Datatype | Source | Len | Sum | Set | Description | Get Invalid | Set Invalid | Attr ID |
---|---|---|---|---|---|---|---|---|---|
EYU_CICSNAME | CHAR | CPSM | 8 | N/A | CICS System Name | ||||
EYU_CICSREL | CHAR | CPSM | 4 | N/A | CICS Release | ||||
EYU_RESERVED | CHAR | CPSM | 4 | N/A | Reserved | ||||
NAME-1 | CHAR | INQ | 8 | DIF | DB2 connection name | 1 | |||
ACCOUNTREC | CVDAS | INQ | 4 | LIKE | yes | Accounting record option | 2 | ||
ACCOUNTREC Input/Output Valid Values | UOW TXID NONE TASK | ||||||||
AUTHID | CHAR | INQ | 8 | DIF | 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 | ||||||||
COMTHREADS | CODEDBIN | INQ | 4 | AVG | Number of active command threads | 5 | |||
COMTHREADLIM | CODEDBIN | INQ | 4 | AVG | yes | Maximum number of command threads | 6 | ||
COMAUTHID | CHAR | INQ | 8 | DIF | 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 | ||||||||
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 | ||||||||
DB2ID | CHAR | INQ | 4 | DIF | yes | DB2 subsystem ID | 11 | ||
DB2RELEASE | CHAR | INQ | 4 | DIF | DB2 version and release | 12 | |||
DROLLBACK | CVDAS | INQ | 4 | LIKE | Deadlock resolution rollback option | 13 | |||
DROLLBACK Output Valid Values | ROLLBACK NOROLLBACK | ||||||||
MSGQUEUE1 | CHAR | INQ | 4 | DIF | yes | Unsolicited error message TDQ name 1 | 14 | ||
MSGQUEUE2 | CHAR | INQ | 4 | DIF | yes | Unsolicited error message TDQ name 2 | 15 | ||
MSGQUEUE3 | CHAR | INQ | 4 | DIF | yes | Unsolicited error message TDQ name 3 | 16 | ||
NONTERMREL | CVDAS | INQ | 4 | LIKE | yes | Non-terminal transaction thread-release option | 17 | ||
NONTERMREL Input/Output Valid Values | RELEASE NORELEASE | ||||||||
PLAN | CHAR | INQ | 8 | DIF | yes | Name of plan used for pool | 18 | ||
PLANEXITNAME | CHAR | INQ | 8 | DIF | yes | Name of dynamic plan exit used for pool threads | 19 | ||
PRIORITY | CVDAS | INQ | 4 | LIKE | yes | Subtask priority | 20 | ||
PRIORITY Input/Output Valid Values | HIGH EQUAL LOW | ||||||||
PURGECYCLEM | CODEDBIN | INQ | 4 | AVG | yes | Protected thread purge cycle (minutes) | 21 | ||
PURGECYCLES | CODEDBIN | INQ | 4 | AVG | yes | Protected thread purge cycle (seconds) | 22 | ||
SIGNID | CHAR | INQ | 8 | DIF | yes | Authorization ID used by CICS-DB2 attach | 23 | ||
STATSQUEUE | CHAR | INQ | 4 | DIF | yes | Attachment statistics TDQ name | 24 | ||
TCBS | CODEDBIN | INQ | 4 | AVG | Current number of subtask TCBs | 25 | |||
TCBLIMIT | CODEDBIN | INQ | 4 | AVG | yes | Maximum number of subtask TCBs | 26 | ||
THREADERROR | CVDAS | INQ | 4 | LIKE | Action following thread error | 27 | |||
THREADERROR Output Valid Values | ABEND N906D N906 | ||||||||
THREADWAIT | CVDAS | INQ | 4 | LIKE | yes | Thread wait option | 28 | ||
THREADWAIT Input/Output Valid Values | TWAIT NOTWAIT | ||||||||
THREADLIMIT | CODEDBIN | INQ | 4 | AVG | yes | Maximum number of pool threads | 29 | ||
THREADS | CODEDBIN | INQ | 4 | AVG | Number of active pool threads | 30 | |||
STANDBYMODE | CVDAS | INQ | 4 | LIKE | yes | Standby mode action | 31 | ||
STANDBYMODE Input/Output Valid Values | NOCONNECT CONNECT RECONNECT | ||||||||
CTIMEGMT | TIMESTP | STAT | 8 | MAX | GMT connect time | 32 | |||
CTIMELOC | TIMESTP | STAT | 8 | MAX | Local connect time | 33 | |||
DTIMEGMT | TIMESTP | STAT | 8 | MAX | GMT disconnect time | 34 | |||
DTIMELOC | TIMESTP | STAT | 8 | MAX | Local disconnect time | 35 | |||
TLIMIT | CODEDBIN | STAT | 4 | AVG | Current maximum number of subtask TCBs | 36 | |||
TCURR | CODEDBIN | STAT | 4 | AVG | Current number of subtask TCBs | 37 | |||
THWM | CODEDBIN | STAT | 4 | AVG | Peak number of subtask TCBs | 38 | |||
PCALLS | CODEDBIN | STAT | 4 | AVG | Number of calls using pool threads | 39 | |||
PSIGNONS | CODEDBIN | STAT | 4 | AVG | Number of pool thread signons | 40 | |||
PCOMMITS | CODEDBIN | STAT | 4 | AVG | Number of pool thread commits | 41 | |||
PABORTS | CODEDBIN | STAT | 4 | AVG | Number of pool thread aborts | 42 | |||
PSPHASE | CODEDBIN | STAT | 4 | AVG | Number of units of work with single phase commit | 43 | |||
PTREUSE | CODEDBIN | STAT | 4 | AVG | Number of times transactions reused pool threads | 44 | |||
PTTERM | CODEDBIN | STAT | 4 | AVG | Number of times threads terminated | 45 | |||
PTWAIT | CODEDBIN | STAT | 4 | AVG | Number of pool thread waits | 46 | |||
PTLIMIT | CODEDBIN | STAT | 4 | AVG | Maximum number of pool threads | 47 | |||
PTCURR | CODEDBIN | STAT | 4 | AVG | Current number of active pool threads | 48 | |||
PTHWM | CODEDBIN | STAT | 4 | AVG | Peak number of active pool threads | 49 | |||
PXCURR | CODEDBIN | STAT | 4 | AVG | Current number of tasks using a pool thread | 50 | |||
PXHWM | CODEDBIN | STAT | 4 | AVG | Peak number of tasks using a pool thread | 51 | |||
PXTOTAL | CODEDBIN | STAT | 4 | AVG | Total number of tasks that used a pool thread | 52 | |||
PRQCUR | CODEDBIN | STAT | 4 | AVG | Current number of tasks waiting for pool thread | 53 | |||
PRQHWM | CODEDBIN | STAT | 4 | AVG | Peak number of tasks waiting for pool thread | 54 | |||
CCALLS | CODEDBIN | STAT | 4 | AVG | Number of calls using command threads | 55 | |||
CSIGNONS | CODEDBIN | STAT | 4 | AVG | Number of command thread signons | 56 | |||
CTTERM | CODEDBIN | STAT | 4 | AVG | Number of command thread terminations | 57 | |||
CTOVERF | CODEDBIN | STAT | 4 | AVG | Number of command thread overflows to pool | 58 | |||
CTLIMIT | CODEDBIN | STAT | 4 | AVG | Maximum number of command threads | 59 | |||
CTCURR | CODEDBIN | STAT | 4 | AVG | Current number of command threads | 60 | |||
CTHWM | CODEDBIN | STAT | 4 | AVG | Peak number of command threads | 61 | |||
TCBFREE | CODEDBIN | STAT | 4 | AVG | Current number of free subtask TCBs | 62 | |||
TCBRDYQCURR | CODEDBIN | STAT | 4 | AVG | Current number of tasks waiting for a subtask TCB | 63 | |||
TCBRDYQHWM | CODEDBIN | STAT | 4 | AVG | Peak number of tasks waiting for a subtask TCB | 64 | |||
DB2GROUPID | CHAR | INQ | 4 | DIF | yes | DB2 data sharing group ID | E530 | E530 | 65 |
RESYNCMEMBER | CVDAS | INQ | 4 | LIKE | yes | Resynchronization member | E530 | E530 | 66 |
RESYNCMEMBER Input/Output Valid Values | RESYNC NORESYNC |