SAP ABAP Table DB2TIMESC1 (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	DB2TIMESC1	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	☐	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	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	☐	DB2TOCSTEC	DB2INT4	INT4	10	0	Number of waits for open/close service task
55	THDTSLSTE	☐	DB2TSLSTEC	DB2INT4	INT4	10	0	Number of waits for SYSLGRNG recording service task
56	THDTDSSTE	☐	DB2TDSSTEC	DB2INT4	INT4	10	0	Number of waits for data set ext./del./def. service task
57	THDTOTHRSE	☐	DB2TOTHRSC	DB2INT4	INT4	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	☐	DB2TCOMMC	DB2INT4	INT4	10	0	Number of successful phase 2 or single-phase commit requests
63	THDTABRT	☐	DB2TABRTC	DB2INT4	INT4	10	0	Number of rollback requests

History

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