SAP ABAP Table DB2QTHDTM (DB2QTHDTM)

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	DB2QTHDTM	Table Relationship Diagram
Short Description	DB2QTHDTM

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	.INCLUDE	☐				0	0	DB2 Times
4	THDTOUDB2	☐	DB2OUTDB2C	DB2DEC16	DEC	16	0	Time spent out of DB2
5	THDTCPUTOT	☐	DB2TCPUTOC	DB2DEC16	DEC	16	0	Total System z CPU time including DB2
6	THDTINB2	☐	DB2TINDB2C	DB2DEC16	DEC	16	0	Accumulated Elapsed Time in DB2
7	THDTCPUIN	☐	DB2TCPUINC	DB2DEC16	DEC	16	0	CPU time spent in DB2
8	THDTSUSPIN	☐	DB2TSUSPIC	DB2DEC16	DEC	16	0	Time spent suspended in DB2
9	THDTNAINDB	☐	DB2TNAINDC	DB2DEC16	DEC	16	0	Not attributed time in DB2
10	THDTIO	☐	DB2TIOC	DB2DEC16	DEC	16	0	I/O suspension time
11	THDTLKLA	☐	DB2TLKLAC	DB2DEC16	DEC	16	0	Lock / Latch Supension Time
12	THDTOTHR	☐	DB2TOTHRC	DB2DEC16	DEC	16	0	Other read suspensions time
13	THDTOTHW	☐	DB2TOTHWC	DB2DEC16	DEC	16	0	Other write suspensions time
14	THDTSRVT	☐	DB2TSRVTC	DB2DEC16	DEC	16	0	Number of waits for commit phase II or abort
15	THDTARCHQ	☐	DB2TARCHCC	DB2DEC16	DEC	16	0	Archive log quiesce suspension time
16	THDTDRLK	☐	DB2TDRLKC	DB2DEC16	DEC	16	0	Drain lock suspension time
17	THDTCLREL	☐	DB2TCLRECC	DB2DEC16	DEC	16	0	Claim release suspension time
18	THDTARCHR	☐	DB2TARCCC	DB2DEC16	DEC	16	0	Archive read suspension time
19	THDTPGLA	☐	DB2TPGLAC	DB2DEC16	DEC	16	0	Page latch suspension time
20	THDTNOTM	☐	DB2TNOTMC	DB2DEC16	DEC	16	0	Notify messages suspension time
21	THDTGLOBTM	☐	DB2TGLOBCC	DB2DEC16	DEC	16	0	Global locking suspension time
22	THDTIOE	☐	DB2TIOEC	DB2INT4	INT4	10	0	Number of I/O suspensions
23	THDTLKLAE	☐	DB2TLKLAEC	DB2INT4	INT4	10	0	Number of Lock / Latch Suspensions
24	THDTOTHRE	☐	DB2TOTHREC	DB2INT4	INT4	10	0	Number of other read suspensions
25	THDTOTHWE	☐	DB2TOTHWEC	DB2INT4	INT4	10	0	Number of other write suspensions
26	THDTSRVTE	☐	DB2TSRVTEC	DB2INT4	INT4	10	0	Number of waits for commit phase II or abort
27	THDTARCHQE	☐	DB2TARCHQC	DB2INT4	INT4	10	0	Number of archive log quiesce suspensions
28	THDTDRLKE	☐	DB2TDRLKEC	DB2INT4	INT4	10	0	Number of Drain Lock Suspensions
29	THDTCLRELE	☐	DB2TCLRELC	DB2INT4	INT4	10	0	Number of Claim Release Suspensions
30	THDTARCHRE	☐	DB2TARCHRC	DB2INT4	INT4	10	0	Number of Archive Read Suspensions
31	THDTPGLAE	☐	DB2TPGLAEC	DB2INT4	INT4	10	0	Number of Page Latch Suspensions
32	THDTNOTME	☐	DB2TNOTMEC	DB2INT4	INT4	10	0	Number of Notify Messages Suspensions
33	THDTGLOBTE	☐	DB2TGLOBTC	DB2INT4	INT4	10	0	Number of Global Locking Suspensions
34	THDTACTT	☐	DB2THDTACC	DB2DEC16	DEC	16	0	Activity time (Class 1 elapsed time) [hh:mm:ss.ms]
35	THDTOCST	☐	DB2TOCSTC	DB2DEC16	DEC	16	0	Wait time for open/close service task (incl. HSM recall)
36	THDTSLST	☐	DB2TSLSTC	DB2DEC16	DEC	16	0	Wait time for SYSLGRNG recording service task
37	THDTDSST	☐	DB2TDSSTC	DB2DEC16	DEC	16	0	Wait time for data set extend/delete/define service task
38	THDTOTHRST	☐	DB2TOTHRCC	DB2DEC16	DEC	16	0	Wait time for other service tasks
39	THDTLOGW	☐	DB2LOGWC	DB2DEC16	DEC	16	0
40	THDTOCSTE	☐	DB2TOCSTEC	DB2INT4	INT4	10	0	Number of waits for open/close service task
41	THDTSLSTE	☐	DB2TSLSTEC	DB2INT4	INT4	10	0	Number of waits for SYSLGRNG recording service task
42	THDTDSSTE	☐	DB2TDSSTEC	DB2INT4	INT4	10	0	Number of waits for data set ext./del./def. service task
43	THDTOTHRSE	☐	DB2TOTHRSC	DB2INT4	INT4	10	0	Number of waits for other service tasks
44	THDTLOGWE	☐	DB2LOGWEC	DB2INT4	INT4	10	0
45	THDTCOMM	☐	DB2TCOMMC	DB2INT4	INT4	10	0	Number of successful phase 2 or single-phase commit requests
46	THDTABRT	☐	DB2TABRTC	DB2INT4	INT4	10	0	Number of rollback requests
47	QWACCAST	☐			DEC	16	0
48	QWACUDST	☐			DEC	16	0
49	AWACCAST	☐			CHAR	10	0
50	QWACCANM	☐			INT4	10	0
51	THDTSTP	☐			DEC	16	0
52	THDTSTPSQL	☐			DEC	16	0
53	THDTSTPSQLE	☐			INT4	10	0
54	THDTUDCP	☐			DEC	16	0
55	THDTUDTT	☐			DEC	16	0
56	THDTUDNE	☐			INT4	10	0
57	THDTUDEA	☐			DEC	16	0
58	THDTUDEB	☐			DEC	10	0
59	THDTTRTT	☐			DEC	16	0
60	THDTTRET	☐			DEC	16	0
61	THDTPECT	☐			DEC	16	0
62	THDTTRTE	☐			DEC	16	0
63	THDTTREE	☐			DEC	16	0
64	THDTAWTK	☐			DEC	16	0
65	THDTAWTM	☐			DEC	16	0
66	THDTAWTN	☐			DEC	16	0
67	THDTAWTO	☐			DEC	16	0
68	THDTAWTQ	☐			DEC	16	0
69	THDTARTK	☐			INT4	10	0
70	THDTARTM	☐			INT4	10	0
71	THDTARTN	☐			INT4	10	0
72	THDTARTO	☐			INT4	10	0
73	THDTARTQ	☐			INT4	10	0
74	THDTAWLG	☐			DEC	16	0
75	THDTARLG	☐			INT4	10	0
76	QWACCLS1_ZIIP	☐			DEC	16	0
77	QWACCLS2_ZIIP	☐			DEC	16	0
78	QWACTRTT_ZIIP	☐			DEC	16	0
79	QWACZIIP_ELIGIBLE	☐			DEC	16	0
80	QWACSPNF_ZIIP	☐			DEC	16	0
81	QWACUDFNF_ZIIP	☐			DEC	16	0
82	ZIIP12ACT	☐			DEC	16	0
83	ZIIP2ACT	☐			DEC	16	0
84	ZIIPEL2ACT	☐			DEC	16	0
85	ZIIP2DB2T	☐			DEC	16	0
86	ZIIPEL2DB2T	☐			DEC	16	0

History

Last changed by/on	SAP	20070813
SAP Release Created in	700