SAP ABAP Table DB2TIMES (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	DB2TIMES	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	☐	DB2OUTDB2	DB2CHAR16	CHAR	16	0	Time spent out of DB2
2	THDTCPUTOT	☐	DB2TCPUTOT	DB2CHAR16	CHAR	16	0	Total CPU time on System z including DB2
3	THDTINB2	☐	DB2TINDB2	DB2CHAR16	CHAR	16	0	Accumulated elapsed time in DB2
4	THDTCPUIN	☐	DB2TCPUIN	DB2CHAR16	CHAR	16	0	CPU time spent in DB2
5	THDTSUSPIN	☐	DB2TSUSPIN	DB2CHAR16	CHAR	16	0	Time spent suspended in DB2
6	THDTNAINDB	☐	DB2TNAINDB	DB2CHAR16	CHAR	16	0	Not attributed time in DB2
7	THDTIO	☐	DB2TIO	DB2CHAR16	CHAR	16	0	I/O suspension time
8	THDTLKLA	☐	DB2TLKLA	DB2CHAR16	CHAR	16	0	Lock/latch supension time
9	THDTOTHR	☐	DB2TOTHR	DB2CHAR16	CHAR	16	0	Other read suspensions time
10	THDTOTHW	☐	DB2TOTHW	DB2CHAR16	CHAR	16	0	Other write suspensions time
11	THDTSRVT	☐	DB2TSRVT	DB2CHAR16	CHAR	16	0	Wait time for DB2 commit phase II processing
12	THDTARCHQ	☐	DB2TARCHQ	DB2CHAR16	CHAR	16	0	Archive log quiesce suspension time
13	THDTDRLK	☐	DB2TDRLK	DB2CHAR16	CHAR	16	0	Drain lock suspension time
14	THDTCLREL	☐	DB2TCLREL	DB2CHAR16	CHAR	16	0	Claim release suspension time
15	THDTARCHR	☐	DB2TARCHR	DB2CHAR16	CHAR	16	0	Archive read suspension time
16	THDTPGLA	☐	DB2TPGLA	DB2CHAR16	CHAR	16	0	Page latch suspension time
17	THDTNOTM	☐	DB2TNOTM	DB2CHAR16	CHAR	16	0	Notify messages suspension time
18	THDTGLOBTM	☐	DB2TGLOBTM	DB2CHAR16	CHAR	16	0	Global locking suspension time
19	THDTIOE	☐	DB2TIOE	NUMC10	NUMC	10	0	Number of I/O suspensions
20	THDTLKLAE	☐	DB2TLKLAE	NUMC10	NUMC	10	0	Number of Lock / Latch Suspensions
21	THDTOTHRE	☐	DB2TOTHRE	NUMC10	NUMC	10	0	Number of other read suspensions
22	THDTOTHWE	☐	DB2TOTHWE	DB2NUMC10	NUMC	10	0	Number of other write suspensions
23	THDTSRVTE	☐	DB2TSRVTE	DB2NUMC10	NUMC	10	0	Number of waits for commit phase II or abort
24	THDTARCHQE	☐	DB2TARCHQE	DB2NUMC10	NUMC	10	0	Number of ARCHIVE LOG QUIESCE suspensions
25	THDTDRLKE	☐	DB2TDRLKE	DB2NUMC10	NUMC	10	0	Number of drain lock suspensions
26	THDTCLRELE	☐	DB2TCLRELE	DB2NUMC10	NUMC	10	0	Number of claim release suspensions
27	THDTARCHRE	☐	DB2TARCHRE	DB2NUMC10	NUMC	10	0	Number of archive read suspensions
28	THDTPGLAE	☐	DB2TPGLAE	DB2NUMC10	NUMC	10	0	Number of page latch suspensions
29	THDTNOTME	☐	DB2TNOTME	DB2NUMC10	NUMC	10	0	Number of notify messages suspensions
30	THDTGLOBTE	☐	DB2TGLOBTE	DB2NUMC10	NUMC	10	0	Number of global locking suspensions
31	THDTIOA	☐	DB2TIOA	DB2CHAR10	CHAR	10	0	Average duration of I/O suspension
32	THDTLKLAA	☐	DB2TLKLAA	DB2CHAR10	CHAR	10	0	Average duration of lock/latch supensions
33	THDTOTHRA	☐	DB2TOTHRA	DB2CHAR10	CHAR	10	0	Average duration of other read suspensions
34	THDTOTHWA	☐	DB2TOTHWA	DB2CHAR10	CHAR	10	0	Average duration of other write suspensions
35	THDTSRVTA	☐	DB2TSRVTA	DB2CHAR10	CHAR	10	0	Average waiting time for commit phase II or abort
36	THDTARCHQA	☐	DB2TARCHQA	DB2CHAR10	CHAR	10	0	Average duration of ARCHIVE LOG QUIESCE suspensions
37	THDTDRLKEA	☐	DB2TDRLKA	DB2CHAR10	CHAR	10	0	Average duration of drain lock suspensions
38	THDTCLRELA	☐	DB2TCLRELA	DB2CHAR10	CHAR	10	0	Average duration of claim release suspensions
39	THDTARCHRA	☐	DB2TARCHRA	DB2CHAR10	CHAR	10	0	Average duration of archive read suspensions
40	THDTPGLAA	☐	DB2TPGLAA	DB2CHAR10	CHAR	10	0	Average duration of page latch suspensions
41	THDTNOTMA	☐	DB2TNOTMA	DB2CHAR10	CHAR	10	0	Average duration of notify messages suspensions
42	THDTGLOBTA	☐	DB2TGLOBTA	DB2CHAR10	CHAR	10	0	Average duration of global locking suspensions
43	THDTINDB2	☐	DB2INDB2	DB2TIMEP	CHAR	8	0	Percentage of time spent in DB2
44	THDTPRODB2	☐	DB2PROCDB2	DB2TIMEP	CHAR	8	0	Percentage of time spent processing in DB2
45	THDTSUSDB2	☐	DB2SUSPDB2	DB2TIMEP	CHAR	8	0	Time spent suspended in DB2 / Time spent in DB2 (%)
46	THDTNAIDB2	☐	DB2NAIDB2	DB2TIMEP	CHAR	8	0	Time not attributed in DB2 / Time spent in DB2 (%)
47	THDTOUTDB2	☐	DB2POUTDB2	DB2TIMEP	CHAR	8	0	Time spent out of DB2 / Activity time (%)
48	THDTTCPU	☐	DB2PTCPU	DB2TIMEP	CHAR	8	0	Total CPU time / Activity time
49	THDTACTT	☐	DB2THDTACT	DB2CHAR16	CHAR	16	0	Activity time (Class 1 elapsed time)
50	THDTOCST	☐	DB2TOCST	DB2CHAR16	CHAR	16	0	Wait time for open/close service task (incl. HSM recall)
51	THDTSLST	☐	DB2TSLST	DB2CHAR16	CHAR	16	0	Wait time for SYSLGRNG recording service task
52	THDTDSST	☐	DB2TDSST	DB2CHAR16	CHAR	16	0	Wait time for data set extend/delete/define service task
53	THDTOTHRST	☐	DB2TOTHRST	DB2CHAR16	CHAR	16	0	Wait time for other service tasks
54	THDTOCSTE	☐	DB2TOCSTE	DB2NUMC10	NUMC	10	0	Number of waits for open/close service task
55	THDTSLSTE	☐	DB2TSLSTE	DB2NUMC10	NUMC	10	0	Number of waits for SYSLGRNG recording service task
56	THDTDSSTE	☐	DB2TDSSTE	DB2NUMC10	NUMC	10	0	Number of waits for data set ext./del./def. service task
57	THDTOTHRSE	☐	DB2TOTHRSE	DB2NUMC10	NUMC	10	0	Number of waits for other service tasks
58	THDTOCSTA	☐	DB2TOCSTA	DB2CHAR10	CHAR	10	0	Average waiting time for open/close service task
59	THDTSLSTA	☐	DB2TSLSTA	DB2CHAR10	CHAR	10	0	Average waiting time for SYSLGRNG recording service task
60	THDTDSSTA	☐	DB2TDSSTA	DB2CHAR10	CHAR	10	0	Average waiting time for dataset ext./del./def. service task
61	THDTOTHRSA	☐	DB2TOTHRSA	DB2CHAR10	CHAR	10	0	Average waiting time for other service tasks
62	THDTCOMM	☐	DB2TCOMM	DB2INT4	INT4	10	0	Number of successful phase 2 or single-phase commit requests
63	THDTABRT	☐	DB2TABRT	DB2INT4	INT4	10	0	Number of rollback requests
64	THDTSPEP	☐	DB2TSPE	DB2TIMEP	CHAR	8	0	Total elapsed time spent executing SQL in stored procedures
65	THDTSPPP	☐	DB2TSPP	DB2TIMEP	CHAR	8	0	Accumulated TCB time spend in DB2 by stored procedures
66	THDTSPET	☐	DB2TSPET	DB2CHAR16	CHAR	16	0	Total elapsed time spent executing SQL in stored procedures
67	THDTSPPT	☐	DB2TSPPT	DB2CHAR16	CHAR	16	0	Accumulated TCB time spend in DB2 by stored procedures
68	THDTSPEAT	☐	DB2TSPEAT	DB2CHAR16	CHAR	16	0	Total elapsed time spent in stored procedures
69	THDTSPCPT	☐	DB2TSPCPT	DB2CHAR16	CHAR	16	0	Accumulated TCB time spent
70	THDTEEDASC	☐	DB2TEEDASC	DB2CHAR10	CHAR	10	0	DB2 entry/exit duration elapsed time
71	THDTEEDJST	☐	DB2TEEDJST	DB2CHAR10	CHAR	10	0	DB2 entry/exit duration processing (CPU)
72	THDTEEDPEB	☐	DB2TEEDPEB	DB2CHAR10	CHAR	10	0	Stored procedure entry/exit duration elapsed time
73	THDTEEDPTT	☐	DB2TEEDPTT	DB2CHAR10	CHAR	10	0	Stored procedure entry/exit duration processing (CPU)
74	THDTUDEBT	☐	DB2TUDEBT	DB2CHAR16	CHAR	16	0	Total elapsed time spent for user-defined function
75	THDTUDTTT	☐	DB2TUDTTT	DB2CHAR16	CHAR	16	0	Accumulated TCB time in DB2 issued by user-defined functions
76	THDTUDEAT	☐	DB2TUDEAT	DB2CHAR16	CHAR	16	0	Total elapsed time spent in user-defined functions
77	THDTUDCPT	☐	DB2TUDCPT	DB2CHAR16	CHAR	16	0	Accumulated TCB time for user-defined function
78	THDTUDEP	☐	DB2TUDEP	DB2TIMEP	CHAR	8	0	Elapsed time in percent for user-defined function
79	THDTUDPP	☐	DB2TUDPP	DB2TIMEP	CHAR	8	0	Processing (CPU) for user-defined function
80	THDTUDFDEB	☐	DB2UDFDEB	DB2CHAR10	CHAR	10	0	UDF entry/exit duration elapsed time
81	THDTUDFDTT	☐	DB2UDFDTT	DB2CHAR10	CHAR	10	0	UDF entry/exit duration processing (CPU)
82	THDTTRETT	☐	DB2TRETT	DB2CHAR16	CHAR	16	0	Accumulated elapsed time used while executing
83	THDTTRTTT	☐	DB2TRTTT	DB2CHAR16	CHAR	16	0	Accumulated TCB time used while executing
84	THDTTRTET	☐	DB2TRTET	DB2CHAR16	CHAR	16	0	Accumulated TCB time used for executing triggers
85	THDTTREET	☐	DB2TREET	DB2CHAR16	CHAR	16	0	Accumulated elapsed time used for executing triggers
86	THDTPECDT	☐	DB2PECDT	DB2CHAR16	CHAR	16	0	Accumulated CPU time user for DB2
87	THDTPECTT	☐	DB2PECTT	DB2CHAR16	CHAR	16	0	Accumulated TCB time used before enclave is created
88	THDTIFAETT	☐	DB2IFAETT	DB2CHAR16	CHAR	16	0	Accumulated elapsed time spent processing IFI calls
89	THDTIFATTT	☐	DB2IFATTT	DB2CHAR16	CHAR	16	0	Accumulated CPU time spent processing IFI calls
90	THDTIFAETP	☐	DB2IFAETP	DB2TIMEP	CHAR	8	0	Elapsed IFI time to total DB2 time in percent
91	THDTIFATTP	☐	DB2IFATTP	DB2TIMEP	CHAR	8	0	Processing (CPU) times to total DB2 activity time in percent
92	THDTIFIELT	☐	DB2TIFIELT	DB2CHAR10	CHAR	10	0	IFI entry/exit duration elapsed time
93	THDTIFIPRT	☐	DB2TIFIPRT	DB2CHAR10	CHAR	10	0	IFI entry/exit duration processing (CPU)
94	THDTLOGW	☐	DB2LOGW	DB2CHAR16	CHAR	16	0	Log writes suspension time
95	THDTCAST	☐	THDTCAST	DB2CHAR16	CHAR	16	0	Stored procedures suspension time
96	THDTUDST	☐	THDTUDST	DB2CHAR16	CHAR	16	0	User defined functions suspension time
97	THDTLOGWE	☐	DB2LOGWE	DB2NUMC10	NUMC	10	0	Number of log writes
98	THDTCASTE	☐	DB2CASTE	DB2NUMC10	NUMC	10	0	Number of stored procedures
99	THDTUDSTE	☐	DB2UDSTE	DB2NUMC10	NUMC	10	0	Number of user defined function
100	THDTIOP	☐	DB2TIOP	DB2CHAR10	CHAR	10	0	Percent of time in DB2 for synchronous reads and writes
101	THDTSRVTP	☐	DB2SRVTP	DB2CHAR10	CHAR	10	0	Percent of time in DB2 for commit, abort, deallocate
102	THDTOTHRP	☐	DB2OTHRP	DB2CHAR10	CHAR	10	0	Percent of time spent in DB2 for other agents' read
103	THDTOTHWP	☐	DB2OTHWP	DB2CHAR10	CHAR	10	0	Percent of time spend in DB2 for other agents' writes
104	THDTLKLAP	☐	DB2LKLAP	DB2CHAR10	CHAR	10	0	Percent of time spent in DB2 for locks and latches
105	THDTPGLAP	☐	DB2PGLAP	DB2CHAR10	CHAR	10	0	Percent of time spent in DB2 for page latches
106	THDTOCSTP	☐	DB2OCSTP	DB2CHAR10	CHAR	10	0	Percent of time spent in DB2 for open ,close, HSM recall
107	THDTDSSTP	☐	DB2DSSTP	DB2CHAR10	CHAR	10	0	Percent of time spent in DB2 for dataspace manager service
108	THDTSLSTP	☐	DB2SLSTP	DB2CHAR10	CHAR	10	0	Percent of time spent in DB2 for SYSLGRNX recording
109	THDTOTHRSP	☐	DB2OTHRSP	DB2CHAR10	CHAR	10	0	Percent time in DB2 for other synchronous EU switch services
110	THDTGLOBTP	☐	DB2GLOBTP	DB2CHAR10	CHAR	10	0	Percent of time spent in DB2 for global locks
111	THDTNOTMP	☐	DB2NOTMP	DB2CHAR10	CHAR	10	0	Percent of time spent in DB2 for notify messages
112	THDTDRLKP	☐	DB2DRLKP	DB2CHAR10	CHAR	10	0	Percent of time spent in DB2 for drain locks
113	THDTCLRELP	☐	DB2CLRELP	DB2CHAR10	CHAR	10	0	Percent of time spent in DB2 for claim locks
114	THDTLOGWP	☐	DB2LOGWP	DB2CHAR10	CHAR	10	0	Percent of time spent in DB2 for log writes
115	THDTARCHQP	☐	DB2ARCHQP	DB2CHAR10	CHAR	10	0	Percent of time spent in DB2 for ARCHIVE LOG QUIESCE command
116	THDTARCHRP	☐	DB2ARCHRP	DB2CHAR10	CHAR	10	0	Percent of time spent in DB2 for archive log read
117	THDTCASTP	☐	DB2CASTP	DB2CHAR10	CHAR	10	0	Percent of time spent in DB2 for stored procedures
118	THDTUDSTP	☐	DB2UDSTP	DB2CHAR10	CHAR	10	0	Percent of time spent in DB2 for user defined functions
119	THDTLOGWA	☐	DB2LOGWA	DB2CHAR10	CHAR	10	0	Average log writes
120	THDTCASTA	☐	DB2CASTA	DB2CHAR10	CHAR	10	0	Average of stored procedures
121	THDTAWLG	☐	DB2LOGW	DB2CHAR16	CHAR	16	0	Log writes suspension time
122	THDTARLG	☐	DB2LOGWE	DB2NUMC10	NUMC	10	0	Number of log writes
123	THDTAWTK	☐			CHAR	16	0
124	THDTAWTM	☐			CHAR	16	0
125	THDTAWTN	☐			CHAR	16	0
126	THDTAWTO	☐			CHAR	16	0
127	THDTAWTQ	☐			CHAR	16	0
128	THDTARTK	☐			NUMC	10	0
129	THDTARTM	☐			NUMC	10	0
130	THDTARTN	☐			NUMC	10	0
131	THDTARTO	☐			NUMC	10	0
132	THDTARTQ	☐			NUMC	10	0
133	THDTAWTKA	☐			CHAR	10	0
134	THDTAWTMA	☐			CHAR	10	0
135	THDTAWTNA	☐			CHAR	10	0
136	THDTAWTOA	☐			CHAR	10	0
137	THDTAWTQA	☐			CHAR	10	0
138	THDTAWTKP	☐			CHAR	10	0
139	THDTAWTMP	☐			CHAR	10	0
140	THDTAWTNP	☐			CHAR	10	0
141	THDTAWTOP	☐			CHAR	10	0
142	THDTAWTQP	☐			CHAR	10	0
143	QWACCLS1_ZIIP	☐			CHAR	16	0
144	QWACCLS2_ZIIP	☐			CHAR	16	0
145	QWACTRTT_ZIIP	☐			CHAR	16	0
146	QWACZIIP_ELIGIBLE	☐			CHAR	16	0
147	QWACSPNF_ZIIP	☐			CHAR	16	0
148	QWACUDFNF_ZIIP	☐			CHAR	16	0
149	ZIIP12ACT	☐			CHAR	8	0
150	ZIIP2ACT	☐			CHAR	8	0
151	ZIIPEL2ACT	☐			CHAR	8	0
152	ZIIP2DB2T	☐			CHAR	8	0
153	ZIIPEL2DB2T	☐			CHAR	8	0

History

Last changed by/on	SAP	20110908
SAP Release Created in