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:

WAIT
NOWAIT
FORCE

FORCE

Force disconnection from the DB2 environment.

DISCARD

Discard the DB2 connection.

External resource name: CICSDb2Connection
Length: 400
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

Table 1. Valid CPSM operations
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

Table 2. DB2CONN resource table attributes
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
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
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