MDB2THRD Resource Table

A CICS® Monitored resource that describes a subset of the DB2® thread attributes sampled by the CICSPlex® SM MAS Monitor agents.

The Primary key field for this resource class is INITTRAN.

The following actions are supported:
DISCARD
Remove the Monitored resource instance.
RESET
Reset all Monitoring instance attributes.

These actions require no unique parameter data.

External resource name
Length
112
Usage
API or WUI or EVALDEF
API view
Yes
CMAS context
No
SCOPE applies
Yes
Only query CMASs in workload
No
Object type
CICS Monitored
Copybook identifier
EYUt1389
Table 1. Valid CPSM operations
Operations Actions Parameters Required
GET   None N/A
PERFORM SET DISCARD None N/A
  RESET None N/A
Table 2. MDB2THRD FEEDBACK error codes
Value Code Description
9 MDB2THRD_NO_MON_DATA No data for monitored resource
10 MDB2THRD_MON_SYSDEF_REQ Monitored resource required by Real Time Analysis (RTA)
Table 3. MDB2THRD resource table attributes
Name Datatype Source Len Sum Set Description Attr ID
EYU_CICSNAME CHAR CPSM 8 DIF No CICS System Name  
EYU_CICSREL CHAR CPSM 4 DIF No CICS Release
EYU_RESERVED CHAR CPSM 4 N/A No Reserved
ABORTCNT BINARY CPSM 4 AVG No Number of aborts 17
AUTHCNT BINARY CPSM 4 SUM No Number of authorizations done 12
AUTHTYPE EYUDA CPSM 4 LIKE No Authorization type 3
AUTHTYPE Output valid values USER, TERMID, TRANID, SIGNID, CHARSTR, USERID, RACFGID, NULL
CURTHREADS BINARY CPSM 2 AVG No Current number of threads 7
CURUSERATE RATE CPSM 4 AVG No Usage rate for current sample 14
DPMODE EYUDA CPSM 4 LIKE No Dispatching mode 4
DPMODE Output valid values HIGH, LOW, EQ
 INITTRAN-1  CHAR CPSM 4 DIFF Yes Initial transaction 2
INTERVALID TIMESTP CPSM 8 LIKE No Interval identifier 1
INTUSERATE RATE CPSM 4 AVG No Usage rate for interval 15
MAXTHREADS BINARY CPSM 2 AVG No Maximum number of threads 6
NAME CHAR CPSM 4 DIFF No DB2 subsystem 21
OTHERIDS BINARY CPSM 4 AVG No Number of transactions in group 19
PLANNAME CHAR CPSM 8 DIFF No Plan name if not dynamic allocation 11
PLANPRGM CHAR CPSM 8 DIFF No Dynamic plan allocation exit program 10
READCOMMIT BINARY CPSM 4 AVG No Number of read only commits 18
ROLLBACKOPT EYUDA CPSM 4 LIKE No Rollback option 5
ROLLBACKOPT Output valid values YES, NO
RSVTHREADS BINARY CPSM 4 AVG No Reserved threads 8
THREADHWM BINARY CPSM 2 MAX No Peak number of threads in use 20
THREADWAIT BINARY CPSM 4 SUM No Number of thread waits 16
THREADWOPT EYUDA CPSM 4 LIKE No Thread wait option 9
THREADWOPT Output valid values TWAIT, NOTWAIT, POOL, YES, NO, NA
USECOUNT BINARY CPSM 4 SUM No Number of times plan used 13