SAP ABAP Table DB2QSTCC (Structure for Statement Trace)

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	DB2QSTCC	Table Relationship Diagram
Short Description	Structure for Statement Trace

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	RETOEXECS	☐	DB2RETOEXE		CHAR	21	0	Average rows examined(Only data rows are taken into account)
2	RPTOEXECS	☐	DB2RPTOEXE		CHAR	21	0	Average rows processed
3	RPTOROWEXE	☐	DB2RPTOREX		CHAR	26	0	Ratio: Rows processed to rows examined of statement
4	RAETOEXECS	☐	DB2AETOEXE		CHAR	19	0	Average elapsed time
5	AVGCPU	☐	DB2AVGCPU		CHAR	19	0	Average CPU time
6	AVGWAIT	☐	DB2AVGWAIT		CHAR	19	0	Average wait time
7	AVGSIOW	☐	DB2AVGSIOW		CHAR	19	0	Average synchronous I/O time
8	AVGSYIO	☐	DB2AVGSYIO		CHAR	21	0	Average synchronous I/Os
9	RIDFAIL	☐	DB2RIDFAIL		CHAR	19	0	RID list failures
10	GPRPROC	☐	DB2GPRPROC		CHAR	21	0	Getpages per rows processed
11	RETOPROW	☐	DB2RETOPRW		CHAR	21	0	Examined/Processed Rows (Only data rows are taken into acc.)
12	STATTXT	☐	DB2STATTXT	DB2CHAR18	CHAR	18	0	Status
13	AVGLOLA	☐	DB2AVGLOLA		CHAR	19	0	Average wait for lock/latch
14	AVGEUSW	☐	DB2AVGEUSW		CHAR	19	0	Average wait for EU switch
15	AVGGLLO	☐	DB2AVGGLLO		CHAR	19	0	Average wait for global lock
16	AVGREAD	☐	DB2AVGREAD		CHAR	19	0	Average wait for other read
17	AVGWRIT	☐	DB2AVGWRIT		CHAR	19	0	Average wait for other write
18	AVGLARQ	☐			CHAR	19	0
19	AVGPGLA	☐			CHAR	19	0
20	AVGDRLO	☐			CHAR	19	0
21	AVGCLRL	☐			CHAR	19	0
22	AVGLOGW	☐			CHAR	19	0
23	AVGOTHE	☐	DB2AVGOTHE		CHAR	19	0	Average other wait time
24	TIMCPU	☐	DB2TIMCPU		CHAR	26	0	CPU time
25	TIMWAIT	☐	DB2TIMWAIT		CHAR	26	0	Wait time
26	TIMSYIO	☐	DB2TIMSYIO		CHAR	26	0	Wait time for synchronous I/O
27	TIMLOLA	☐	DB2TIMLOLA		CHAR	26	0	Wait time for lock/latch
28	TIMEUSW	☐	DB2TIMEUSW		CHAR	26	0	Wait time for EU switch
29	TIMGLLO	☐	DB2TIMGLLO		CHAR	26	0	Wait time for global lock
30	TIMREAD	☐	DB2TIMREAD		CHAR	26	0	Wait time for other read
31	TIMWRIT	☐	DB2TIMWRIT		CHAR	26	0	Wait time for other write
32	TIMLARQ	☐			CHAR	26	0
33	TIMPGLA	☐			CHAR	26	0
34	TIMDRLO	☐			CHAR	26	0
35	TIMCLRL	☐			CHAR	26	0
36	TIMLOGW	☐			CHAR	26	0
37	TIMOTHE	☐	DB2TIMOTHE		CHAR	26	0	Other wait time
38	RANBTONE	☐	DB2RNBTONE		CHAR	21	0	Average synchronous reads
39	RANWTONE	☐	DB2RNWTONE		CHAR	21	0	Average synchronous writes
40	RANGTONE	☐	DB2RNGTONE		CHAR	21	0	Average getpages
41	RANSTONE	☐	DB2RNSTONE		CHAR	21	0	Average sorts
42	RANITONE	☐	DB2RNITONE		CHAR	21	0	Average index scans
43	RANTTONE	☐	DB2RNTTONE		CHAR	21	0	Average tablespace scans
44	RARSTONE	☐	DB2RRSTONE		CHAR	21	0	Average RID failures - no storage
45	RARTTONE	☐	DB2RRTTONE		CHAR	21	0	Average RID failures - limit
46	RANLTONE	☐	DB2RNLTONE		CHAR	21	0	Average parallel groups
47	RANGTONP	☐	DB2NGTONP	DB2DEC25V6	DEC	25	6	Getpages per rows processed
48	RANRTONP	☐	DB2NRTONP	DB2DEC25V6	DEC	25	6	Examined/rows processed (Only data rows are taken into acc.)
49	RAW1TOBW	☐	DB2W1TOBW		CHAR	26	0	Average duration of a synchronous I/O
50	EXECPSEC	☐	DB2EXESEC	DB2DEC25V6	DEC	25	6	Average executions per second
51	QSTCSTNM	☐	DB2QSTCSTN	DB2RAW16	RAW	16	0	DB2 statement name
52	QSTCTOKN	☐	DB2QSTCTOK	DB2NUMC10	NUMC	10	0	Statement ID
53	QSTCUSE	☐	DB2QSTCUSE		NUMC	19	0	Current Copies
54	QSTCCOPY	☐	DB2QSTCCOP	DB2NUMC10	NUMC	10	0	Number of copies of the statement
55	QSTCSTAT	☐	DB2QSTSTAT	DB2CHAR30	CHAR	30	0	Status of the statement
56	QSTCIDDL	☐	DB2QSTIDDL	DB2CHAR05	CHAR	5	0	Statement invalidated by DROP or ALTER
57	QSTCIRVK	☐	DB2QSTIRVK	DB2CHAR05	CHAR	5	0	Statement invalidated by REVOKE
58	QSTCIRST	☐	DB2QSTIRST	DB2CHAR05	CHAR	5	0	Statement invalidated by RUNSTATS
59	QSTCCLRU	☐	DB2QSTCLRU	DB2CHAR05	CHAR	5	0	Statement removed from cache by LRU (last recently used)
60	QSTCISTM	☐	DB2QSTISTC	DB2CHAR14	CHAR	14	0	Time when statement was inserted into cache
61	QSTCEXEC	☐	DB2QSTCEXE		NUMC	19	0	Number of executions of the statement
62	QSTCRBUF	☐	DB2QSTCRBU		NUMC	19	0	Synchronous Reads
63	QSTCGPAG	☐	DB2QSTCGPA		NUMC	19	0	Getpages
64	QSTCEROW	☐	DB2QSTCERO		NUMC	19	0	Rows Examined
65	QSTCPROW	☐	DB2QSTCPRO		NUMC	19	0	Rows Processed
66	QSTCSORT	☐	DB2QSTCSOR		NUMC	19	0	Number of sorts performed for statement
67	QSTCINDX	☐	DB2QSTCIND		NUMC	19	0	Number of index scans performed for statement
68	QSTCTSCN	☐	DB2QSTCTSC		NUMC	19	0	Number of tablespace scans performed for statement
69	QSTCPLGP	☐	DB2QSTCPLG		NUMC	19	0	Number of parallel groups created for statement
70	QSTCWRIT	☐	DB2QSTCWRI		NUMC	19	0	Synchronous Writes
71	QSTCAET1	☐	DB2THCTIM		NUMC	19	0	DB2 Thread times
72	QSTCAET2	☐	DB2THCTIM		NUMC	19	0	DB2 Thread times
73	QSTCAET	☐	DB2QSTAETC		CHAR	26	0	Time elapsed
74	QSTCSTLN	☐	DB2QSTSTLN	INT2	INT2	5	0	The length of the SQL Statement
75	QSTCSTMT	☐	DB2QSTSTMT		CHAR	255	0	Statement text
76	QW0316L1	☐	DB2QW316L1	INT2	INT2	5	0	Length of program name
77	QW0316T1	☐	DB2QW316T1	CHAR128	CHAR	128	0	Program name
78	QW0316LX	☐	DB2Q316CLX	DB2CHAR10	CHAR	10	0	Statement Line Number
79	QW0316L2	☐	DB2QW316L2	INT2	INT2	5	0	Length of transaction name
80	QW0316T2	☐	DB2QW316T2	DB2CHAR32	CHAR	32	0	Transaction name
81	QW0316L3	☐	DB2QW316L3	INT2	INT2	5	0	Length of user ID
82	QW0316T3	☐	DB2QW316T3	CHAR128	CHAR	128	0	User ID
83	QW0316X4	☐	DB2QW316X4	CHAR128	CHAR	128	0	User group
84	QW0316X5	☐	DB2QW316X5	CHAR128	CHAR	128	0	The value of QUALIFIER bind option
85	QW0316X6	☐	DB2QW316X6	DB2CHAR03	CHAR	3	0	ISOLATION
86	QW0316X7T	☐	DB2QW316X7	DB2CHAR03	CHAR	3	0	CURRENTDATA
87	QW0316X8T	☐	DB2QW316X8	DB2CHAR04	CHAR	4	0	DYNAMICRULES
88	QW0316X9T	☐	DB2QW316X9	DB2CHAR03	CHAR	3	0	CURRENT DEGREE
89	QW0316XAT	☐	DB2QW316XA	DB2CHAR03	CHAR	3	0	CURRENT RULES
90	QW0316XBT	☐	DB2QW316XB	DB2CHAR05	CHAR	5	0	CURRENT PRECISION
91	QW0316XCT	☐	DB2QW316XC	DB2CHAR03	CHAR	3	0	WITH HOLD
92	QW0316TS	☐	DB2QW316TS	DB2DEC16	DEC	16	0	Timestamp: Begin of Statistics Collection
93	QW0316TD	☐	DB2QW316TD	CHAR128	CHAR	128	0	Name of the table referenced in the statement
94	QW0316CT	☐	DB2Q316CCT		CHAR	16	0	Accumulated CPU Time
95	QW0316W1	☐	DB2QW31W1C		CHAR	16	0	Accumulated Wait Time for Synchronous I/O
96	QW0316W2	☐	DB2QW31W2C		CHAR	16	0	Accumulated Wait Time for Lock and Latch Req.
97	QW0316W3	☐	DB2QW31W3C		CHAR	16	0	Accumulated Wait Time for Sync. Execution Unit Switch
98	QW0316W4	☐	DB2QW31W4C		CHAR	16	0	Accumulated Wait Time for Global Locks
99	QW0316W5	☐	DB2QW31W5C		CHAR	16	0	Accumulated Wait Time for Read Activity by Another Thread
100	QW0316W6	☐	DB2QW31W6C		CHAR	16	0	Accumulated Wait Time for Write Activity by Another Thread
101	QW0316W7	☐	DB2QW316W7C		CHAR	16	0	Accumulated wait time for latch req
102	QW0316W8	☐	DB2QW316W8C		CHAR	16	0	Accumulated wait time for page latch
103	QW0316W9	☐	DB2QW316W9C		CHAR	16	0	Accumulated wait time for drain lock
104	QW0316WA	☐	DB2QW316WAC		CHAR	16	0	Acc. wait for drain when waiting for claims to be released
105	QW0316WB	☐	DB2QW316WBC		CHAR	16	0	Accumulated wait time for logwriter
106	QW0316RT	☐	DB2Q316CRT		CHAR	19	0	RID List Not Used due to DB2 Limits Exceeded
107	QW0316RS	☐	DB2Q316CRS		CHAR	19	0	RID List Not Used due to Insufficient Storage
108	RRSAFPGM	☐	DB2QW316T1	CHAR128	CHAR	128	0	Program name
109	RRSAFLEN	☐	DB2Q316CLX	DB2CHAR10	CHAR	10	0	Statement Line Number

History

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