SAP ABAP Table DB2QTHDLST (ST04: DB2 thread overview)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DB-DB2 (Application Component) DB2 for z/OS
     ⤷ STU3 (Package) Development Class for Database Monitor

Basic Data

Table Category	INTTAB	Structure
Structure	DB2QTHDLST	Table Relationship Diagram
Short Description	ST04: DB2 thread overview

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MEMBNM	☑	DB2MEMN	DB2CHAR08	CHAR	8	0	DB2 member name in data sharing environment
2	ACE	☑	DB2RAW04	DB2INT4	INT4	10	0	Field type raw, length 8, 4 bytes
3	CONNID	☐	DB2WHCCN	DB2CHAR08	CHAR	8	0	The connection ID of the thread
4	HDSUBSYSID	☐	DB2SWPSSID	DB2CHAR04	CHAR	4	0	DB2 subsystem ID
5	HDATDAT	☐	DB2SWPATDT	DB2DATE	DATS	8	0	Date when sampling is taken
6	HDATTIM	☐	DB2SWPATTM	DB2TIME	TIMS	6	0	Time when sampling is taken
7	HDLRESTIME	☐	DB2SWPLRTM	DB2TIME	TIMS	6	0	Time of last reset
8	JOBNAME	☐	DB2THDJOB	DB2CHAR8	CHAR	8	0	The job name of the thread.
9	DBPLAN	☐	DB2WHCPLAN	CHAR128	CHAR	128	0	DB2 plan name
10	AUTHID	☐	DB2WHCAID	CHAR128	CHAR	128	0	The authorization ID under which the transaction is running
11	CORRID	☐	DB2WHCCV	DB2CHAR16	CHAR	16	0	The correlation ID of the thread (IP address)
12	THDTSTAT	☐	DB2THDTSTT	DB2SINT	INT2	5	0
13	THDSTAT	☐	DB2W0148AI	DB2CHAR16	CHAR	16	0	The status of the thread
14	FILLER	☐	DB2CHAR08	DB2CHAR08	CHAR	8	0	Field type char, length 8
15	SQLCNT	☐	DB2THDSQL	DB2INT4	INT4	10	0	The total number of executed SQL statements
16	DBCOMMIT	☐	DB2WACCOMM	DB2INT4	INT4	10	0	The number of successful phase 2 or single-phase commits
17	ABORT	☐	DB2WACABRT	DB2INT4	INT4	10	0	Total number of rollback requests
18	GETPAGE	☐	DB2BACGET	DB2INT4U	INT4	10	0	Number of Getpage Requests
19	UPDPAGE	☐	DB2BACSWS	DB2INT4U	INT4	10	0	The number of times a buffer update occurs for the agent
20	LOCKS	☐	DB2THDLOCK	DB2INT4	INT4	10	0	The total number of currently hold locks.
21	QTXANPL	☐	DB2TXANLP	DB2INT4	INT4	10	0	Maximum page or row locks held
22	CPUTIME	☐	DB2WACAJST	DB2INT4	INT4	10	0	The accumulated home CPU time a thread spent in DB2
23	ELTIME	☐	DB2THDELT	DB2INT4	INT4	10	0	Time elapsed since DB2 thread was started
24	LOCKMOD	☐	DB2LOCKMOD	DB2CHAR06	CHAR	6	0	The mode of the lock held on the resource
25	ACTTIME	☐	DB2THDTACT	DB2CHAR16	CHAR	16	0	Activity time (Class 1 elapsed time)
26	TIMEINDB2	☐	DB2INDB2	DB2TIMEP	CHAR	8	0	Percentage of time spent in DB2
27	PROCINDB2	☐	DB2PROCDB2	DB2TIMEP	CHAR	8	0	Percentage of time spent processing in DB2
28	WPTYPE	☐	DB2WPTYE	DB2CHAR05	CHAR	5	0	Corresponding R/3 work process type
29	WPNUMBER	☐	DB2WPNUM	DB2NUMC10	NUMC	10	0	Work process number
30	WPID	☐	DB2WPID	DB2NUMC10	NUMC	10	0	Work process ID
31	ASHOST	☐	DB2ASHOST	DB2CHAR32	CHAR	32	0	Application server host name
32	THDREQ	☐	DB2W0148RQ	DB2INT4	INT4	10	0	Number of Requests Sent to DB2
33	THDEUWN	☐	DB2EUWN	DB2CHAR18	CHAR	18	0
34	THDEUTX	☐	DB2EUTX	CHAR32	CHAR	32	0
35	THDACT1	☐	DB2THDACT1	DB2INT4	INT4	10	0
36	THDACT2	☐	DB2THDACT2	DB2INT4	INT4	10	0
37	QMDASUFX	☐			CHAR	200	0
38	QMDAPLAT	☐			CHAR	18	0
39	QWHDRQNM	☐			CHAR	128	0
40	QWHCEUID	☐			CHAR	128	0
41	QWHCTOKN	☐			CHAR	22	0
42	QWACPARR	☐			CHAR	10	0
43	QW0148CI	☐			CHAR	128	0

History

Last changed by/on	SAP	20110908
SAP Release Created in	620