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.

Length
112
Usage
API or EVALDEF
API view
Yes
CMAS context
No
SCOPE applies
Yes
Only query CMASs in workload
No
Object type
CICS Monitored
Copybook identifier
EYUt1389 or MDB2THRD
Valid API operations
GET and PERFORM

API Actions

DISCARD
Discard

Parameters: None

RESET
Reset

Parameters: None

Table 292. MDB2THRD FEEDBACK error codes
Code Description Code Description
MON_SYSDEF_REQ Monitored resource required by Real Time Analysis (RTA) NO_MON_DATA No data for monitored resource
Table 293. MDB2THRD 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
INTERVALID TIMESTP CPSM 8 N/A Interval identifier 1
 INITTRAN-1  CHAR CPSM 4 DIF Initial transaction 2
AUTHTYPE EYUDA CPSM 4 LIKE Authorization type 3
AUTHTYPE Output Valid Values USER TERMID TRANID SIGNID CHARSTR USERID RACFGID NULL
DPMODE EYUDA CPSM 4 LIKE Dispatching mode 4
DPMODE Output Valid Values HIGH LOW EQ
ROLLBACKOPT EYUDA CPSM 4 LIKE Rollback option 5
ROLLBACKOPT Output Valid Values YES NO
MAXTHREADS BINARY CPSM 2 AVG Maximum number of threads 6
CURTHREADS BINARY CPSM 2 AVG Current number of threads 7
RSVTHREADS BINARY CPSM 4 AVG Reserved threads 8
THREADWOPT EYUDA CPSM 4 LIKE Thread wait option 9
THREADWOPT Output Valid Values TWAIT NOTWAIT POOL YES NO NA
PLANPRGM CHAR CPSM 8 DIF Dynamic plan allocation exit program 10
PLANNAME CHAR CPSM 8 DIF Plan name if not dynamic allocation 11
AUTHCNT BINARY CPSM 4 N/A Number of authorizations done 12
USECOUNT BINARY CPSM 4 N/A Number of times plan used 13
CURUSERATE RATE CPSM 4 AVG Usage rate for current sample 14
INTUSERATE RATE CPSM 4 AVG Usage rate for interval 15
THREADWAIT BINARY CPSM 4 N/A Number of thread waits 16
ABORTCNT BINARY CPSM 4 AVG Number of aborts 17
READCOMMIT BINARY CPSM 4 AVG Number of read only commits 18
OTHERIDS BINARY CPSM 4 AVG Number of transactions in group 19
THREADHWM BINARY CPSM 2 MAX Peak number of threads in use 20
NAME CHAR CPSM 4 DIF Name of DB2 subsystem 21
[[ Contents Previous Page | Next Page Index ]]