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 .

Length
96
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
EYUt0033 or DB2THRD
Valid API operations
GET
Table 108. DB2THRD resource table attributes
Name Datatype Source Len Sum Description 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
 INITTRAN-1  CHAR CPSM 4 DIF Initial transaction 1
AUTHTYPE EYUDA CPSM 4 LIKE Authorization type 2
AUTHTYPE Output Valid Values USER TERMID TRANID SIGNID CHARSTR USERID RACFGID NULL NA
DPMODE EYUDA CPSM 4 LIKE Dispatching mode 3
DPMODE Output Valid Values HIGH LOW EQ
ROLLBACKOPT EYUDA CPSM 4 LIKE Rollback option 4
ROLLBACKOPT Output Valid Values YES NO
MAXTHREADS BINARY CPSM 2 AVG Maximum number of threads 5
CURTHREADS BINARY CPSM 2 AVG Number of current threads 6
RSVTHREADS BINARY CPSM 4 AVG Number of reserved threads 7
THREADWOPT EYUDA CPSM 4 LIKE Thread wait option 8
THREADWOPT Output Valid Values TWAIT NOTWAIT POOL YES NO NA
PLANPRGM CHAR CPSM 8 DIF Dynamic plan exit for pool threads 9
PLANNAME CHAR CPSM 8 DIF Plan name 10
AUTHCNT BINARY CPSM 4 AVG Number of authorizations performed 11
USECOUNT BINARY CPSM 4 AVG Number of times plan used 12
THREADWAIT BINARY CPSM 4 AVG Number of thread waits 13
ABORTCNT BINARY CPSM 4 AVG Number of aborts 14
READCOMMIT BINARY CPSM 4 AVG Number of read-only commits 15
OTHERIDS BINARY CPSM 4 AVG Number of transactions in group 16
THREADHWM BINARY CPSM 2 AVG Peak number of concurrent threads in use 17
NAME CHAR CPSM 4 DIF DB2 subsystem name 18
[[ Contents Previous Page | Next Page Index ]]