SAP ABAP Table DB2GLOTIME (DB2 global times with V8)

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	DB2GLOTIME	Table Relationship Diagram
Short Description	DB2 global times with V8

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

History

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