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:

   PARM('BUSY(cvda).')

where cvda is required and is one of the following valid CVDA values for the DB2 connection busy condition:

FORCE
Force disconnection from the DB2 environment.
DISCARD
Discard the DB2 connection.
Length
320
Usage
API or EVALDEF
API view
Yes
CMAS context
No
SCOPE applies
Yes
Only query CMASs in workload
No
Object type
CICS Resource
Copybook identifier
EYUt0086 or DB2CONN
Valid API operations
GET SET and PERFORM

API Actions

REBUILD
Rebuild

Parameters: None

CONNECT
Connect

PARM(' [BUSY(value)] .')

DISCONNECT
Disconnect

PARM(' BUSY(value) .')

FORCE
Force

Parameters: None

DISCARD
Discard

Parameters: None

Table 101. DB2CONN resource table attributes
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
[[ Contents Previous Page | Next Page Index ]]