DB2THRD Resource Table

A CICS® Resource that describes an attachment thread from an active CICS system to a DB2® subsystem.

The Primary key field for this resource class is INITTRAN.

Table 1. Valid CPSM operations
Operations	Actions	Parameters	Required
GET		None	N/A

Table 2. DB2THRD resource table attributes
Name	Datatype	Source	Len	Sum	Description	Attr ID
EYU_CICSNAME	CHAR	CPSM	8	DIFF	CICS System Name
EYU_CICSREL	CHAR	CPSM	4	DIFF	CICS Release
EYU_RESERVED	CHAR	CPSM	4	N/A	Reserved
ABORTCNT	BINARY	CPSM	4	AVG	Number of aborts	14
AUTHCNT	BINARY	CPSM	4	AVG	Number of authorizations performed	11
AUTHTYPE	EYUDA	CPSM	4	LIKE	Authorization type	2
AUTHTYPE Output valid values	USER, TERMID, TRANID, SIGNID, CHARSTR, USERID, RACFGID, NULL, NA
CURTHREADS	BINARY	CPSM	2	AVG	Number of current threads	6
DPMODE	EYUDA	CPSM	4	LIKE	Dispatching mode	3
DPMODE Output valid values	HIGH, LOW, EQ
INITTRAN-1	CHAR	CPSM	4	DIFF	Initial transaction	1
MAXTHREADS	BINARY	CPSM	2	AVG	Maximum number of threads	5
NAME	CHAR	CPSM	4	DIFF	DB2 subsystem	18
OTHERIDS	BINARY	CPSM	4	AVG	Number of transactions in group	16
PLANNAME	CHAR	CPSM	8	DIFF	Plan	10
PLANPRGM	CHAR	CPSM	8	DIFF	Dynamic plan exit for pool threads	9
READCOMMIT	BINARY	CPSM	4	AVG	Number of read-only commits	15
ROLLBACKOPT	EYUDA	CPSM	4	LIKE	Rollback option	4
ROLLBACKOPT Output valid values	YES, NO
RSVTHREADS	BINARY	CPSM	4	AVG	Number of reserved threads	7
THREADHWM	BINARY	CPSM	2	AVG	Peak number of concurrent threads in use	17
THREADWAIT	BINARY	CPSM	4	AVG	Number of thread waits	13
THREADWOPT	EYUDA	CPSM	4	LIKE	Thread wait option	8
THREADWOPT Output valid values	TWAIT, NOTWAIT, POOL, YES, NO, NA
USECOUNT	BINARY	CPSM	4	AVG	Number of times plan used	12