SAP ABAP Table DB2TIMESC (DB2 Times)

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	DB2TIMESC	Table Relationship Diagram
Short Description	DB2 Times

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

History

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