SAP ABAP Table DB2QSTC (Structure for Statement Trace)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DB-DB2 (Application Component) DB2 for z/OS
     ⤷ STU2 (Package) CCMS for DB2 for OS/390

Basic Data

Table Category	INTTAB	Structure
Structure	DB2QSTC	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	QSTCSTNM	☐	DB2QSTSTNM	DB2RAW16	RAW	16	0	DB2 statement name
2	QSTCTOKN	☐	DB2QSTTOKN	DB2INT4	INT4	10	0	Statement ID
3	QSTCUSE	☐	DB2QSTUSE	DB2DEC19V	DEC	19	0	Current Copies
4	QSTCCOPY	☐	DB2QSTCOPY	DB2INT4	INT4	10	0	Number of copies of the statement
5	QSTCSTAT	☐	DB2QSTSTAT	DB2CHAR30	CHAR	30	0	Status of the statement
6	QSTCLR	☐	DB2QSTLR		CHAR	10	0	Cache literal replacement indicator
7	QSTCIDDL	☐	DB2QSTIDDL	DB2CHAR05	CHAR	5	0	Statement invalidated by DROP or ALTER
8	QSTCIRVK	☐	DB2QSTIRVK	DB2CHAR05	CHAR	5	0	Statement invalidated by REVOKE
9	QSTCIRST	☐	DB2QSTIRST	DB2CHAR05	CHAR	5	0	Statement invalidated by RUNSTATS
10	QSTCCLRU	☐	DB2QSTCLRU	DB2CHAR05	CHAR	5	0	Statement removed from cache by LRU (last recently used)
11	QSTCISTM	☐	DB2QSTISTC	DB2CHAR14	CHAR	14	0	Time when statement was inserted into cache
12	QSTCEXEC	☐	DB2QSTEXEC	DB2DEC19V	DEC	19	0	Number of executions of the statement
13	QSTCRBUF	☐	DB2QSTRBUF	DB2DEC19V	DEC	19	0	Synchronous Reads
14	QSTCGPAG	☐	DB2QSTGPAG	DB2DEC19V	DEC	19	0	Getpages
15	QSTCEROW	☐	DB2QSTEROW	DB2DEC19V	DEC	19	0	Rows examined (Only data rows are taken into account)
16	QSTCPROW	☐	DB2QSTPROW	DB2DEC19V	DEC	19	0	Rows Processed
17	QSTCSORT	☐	DB2QSTSORT	DB2DEC19V	DEC	19	0	Number of sorts performed for statement
18	QSTCINDX	☐	DB2QSTINDX	DB2DEC19V	DEC	19	0	Number of index scans performed for statement
19	QSTCTSCN	☐	DB2QSTTSCN	DB2DEC19V	DEC	19	0	Number of tablespace scans performed for statement
20	QSTCPLGP	☐	DB2QSTPLGP	DB2DEC19V	DEC	19	0	Number of parallel groups created for statement
21	QSTCWRIT	☐	DB2QSTWRIT	DB2DEC19V	DEC	19	0	Synchronous Writes
22	QSTCAET	☐	DB2QSTCAET		CHAR	19	0	Time elapsed
23	QSTCSTLN	☐	DB2QSTSTLN	INT2	INT2	5	0	The length of the SQL Statement
24	QSTCSTMT	☐	DB2QSTSTMT		CHAR	255	0	Statement text
25	QW0316TM2	☐	DB2QW316TM2		CHAR	14	0	Time when stmt was inserted into cache - stored clock format
26	QW0316UT1	☐	DB2QW316UT1		CHAR	14	0	Date/Time when stmt stat was updated -in stored clock format
27	QW0316UT2	☐	DB2QW316UT2		CHAR	14	0	Date/Time when the stmt stat was updated -in external format
28	QW0316L1	☐	DB2QW316L1	INT2	INT2	5	0	Length of program name
29	QW0316T1	☐	DB2QW316T1	CHAR128	CHAR	128	0	Program name
30	QW0316LX	☐	DB2QW316LX	DB2INT4	INT4	10	0	Statement Line Number
31	QW0316T2	☐	DB2QW316T2	DB2CHAR32	CHAR	32	0	Transaction name
32	QW0316L3	☐	DB2QW316L3	INT2	INT2	5	0	Length of user ID
33	QW0316T3	☐	DB2QW316T3	CHAR128	CHAR	128	0	User ID
34	QW0316X4	☐	DB2QW316X4	CHAR128	CHAR	128	0	User group
35	QW0316X5	☐	DB2QW316X5	CHAR128	CHAR	128	0	The value of QUALIFIER bind option
36	QW0316X6	☐	DB2QW316X6	DB2CHAR03	CHAR	3	0	ISOLATION
37	QW0316X7T	☐	DB2QW316X7	DB2CHAR03	CHAR	3	0	CURRENTDATA
38	QW0316X8T	☐	DB2QW316X8	DB2CHAR04	CHAR	4	0	DYNAMICRULES
39	QW0316X9T	☐	DB2QW316X9	DB2CHAR03	CHAR	3	0	CURRENT DEGREE
40	QW0316XAT	☐	DB2QW316XA	DB2CHAR03	CHAR	3	0	CURRENT RULES
41	QW0316XBT	☐	DB2QW316XB	DB2CHAR05	CHAR	5	0	CURRENT PRECISION
42	QW0316XCT	☐	DB2QW316XC	DB2CHAR03	CHAR	3	0	WITH HOLD
43	QW0316TS	☐	DB2QM316TS	DB2CHAR16	CHAR	16	0	Timestamp: Begin of Statistics Collection
44	QW0316CT	☐	DB2QM316CT	DB2CHAR16	CHAR	16	0	Accumulated CPU Time
45	QW0316W1	☐	DB2QM316W1	DB2CHAR16	CHAR	16	0	Accumulated Wait Time for Synchronous I/O
46	QW0316W2	☐	DB2QM316W2	DB2CHAR16	CHAR	16	0	Accumulated Wait Time for Lock and Latch Req.
47	QW0316W3	☐	DB2QM316W3	DB2CHAR16	CHAR	16	0	Accumulated Wait Time for Sync. Execution Unit Switch
48	QW0316W4	☐	DB2QM316W4	DB2CHAR16	CHAR	16	0	Accumulated Wait Time for Global Locks
49	QW0316W5	☐	DB2QM316W5	DB2CHAR16	CHAR	16	0	Accumulated Wait Time for Read Activity by Another Thread
50	QW0316W6	☐	DB2QM316W6	DB2CHAR16	CHAR	16	0	Accumulated Wait Time for Write Activity by Another Thread
51	QW0316W7	☐	DB2QW316W7C		CHAR	16	0	Accumulated wait time for latch req
52	QW0316W8	☐	DB2QW316W8C		CHAR	16	0	Accumulated wait time for page latch
53	QW0316W9	☐	DB2QW316W9C		CHAR	16	0	Accumulated wait time for drain lock
54	QW0316WA	☐	DB2QW316WAC		CHAR	16	0	Acc. wait for drain when waiting for claims to be released
55	QW0316WB	☐	DB2QW316WBC		CHAR	16	0	Accumulated wait time for logwriter
56	QW0316XE	☐	DB2QW316XE		CHAR	16	0	ENDuser ID - Value provided on RRS (re)signon
57	QW0316XF	☐	DB2QW316XF		CHAR	18	0	Workstation name - Value provided on RRS (re)signon
58	QW0316RT	☐	DB2QW316RT	DB2DEC19V	DEC	19	0	RID List Not Used due to DB2 Limits Exceeded
59	QW0316RS	☐	DB2QW316RS	DB2DEC19V	DEC	19	0	RID List Not Used due to Insufficient Storage
60	RRSAFPGM	☐	DB2QW316T1	CHAR128	CHAR	128	0	Program name
61	RRSAFLEN	☐	DB2Q316CLX	DB2CHAR10	CHAR	10	0	Statement Line Number
62	RETOEXECS	☐	DB2RETOEXECS	DB2DEC25V6	DEC	25	6	Average rows examined(Only data rows are taken into account)
63	RPTOEXECS	☐	DB2RPTOEXECS	DB2DEC25V6	DEC	25	6	Average rows processed
64	RPTOROWEXE	☐	DB2RPTOREX		CHAR	26	0	Ratio: Rows processed to rows examined of statement
65	RAETOEXECS	☐	DB2RAETOEXECS	DB2DEC19V6	DEC	19	6	Average elapsed time
66	RAETOROWS	☐	DB2RAETOROWS	DB2DEC19V6	DEC	19	6	Average elapsed time / row
67	AVGCPU	☐	DB2AVGCT	DB2DEC19V6	DEC	19	6	Average CPU time
68	AVGWAIT	☐	DB2AVGW	DB2DEC19V6	DEC	19	6	Average wait time
69	AVGSIOW	☐	DB2AVGW1	DB2DEC19V6	DEC	19	6	Average synchronous I/O time
70	AVGSYIO	☐	DB2XVGSYIO	DB2DEC25V6	DEC	25	6	Average synchronous I/Os
71	RIDFAIL	☐	DB2RIDFAIL		CHAR	19	0	RID list failures
72	GPRPROC	☐	DB2GPPRPROC	DB2DEC21V2	DEC	21	2	Getpages per rows processed
73	RETOPROW	☐	DB2RETOPROW	DB2DEC21V2	DEC	21	2	Examined/processed Rows (Only data rows are taken into acc.)
74	STATTXT	☐	DB2STATTXT	DB2CHAR18	CHAR	18	0	Status
75	AVGLOLA	☐	DB2AVGW2	DB2DEC19V6	DEC	19	6	Average wait for lock/latch
76	AVGEUSW	☐	DB2AVGW3	DB2DEC19V6	DEC	19	6	Average wait for EU switch
77	AVGGLLO	☐	DB2AVGW4	DB2DEC19V6	DEC	19	6	Average wait for global lock
78	AVGREAD	☐	DB2AVGW5	DB2DEC19V6	DEC	19	6	Average wait for other read
79	AVGWRIT	☐	DB2AVGW6	DB2DEC19V6	DEC	19	6	Average wait for other write
80	AVGLARQ	☐	DB2AVGW7	DB2DEC19V6	DEC	19	6	Average wait time for latch req
81	AVGPGLA	☐	DB2AVGW8	DB2DEC19V6	DEC	19	6	Average wait time for page latch
82	AVGDRLO	☐	DB2AVGW9	DB2DEC19V6	DEC	19	6	Average wait time for drain lock
83	AVGCLRL	☐	DB2AVGWA	DB2DEC19V6	DEC	19	6	Average wait for drain when waiting for claims to be rel.
84	AVGLOGW	☐	DB2AVGWB	DB2DEC19V6	DEC	19	6	Average wait time for logwriter
85	AVGOTHE	☐	DB2AVGOTHED		DEC	19	6	Average other wait time (dec)
86	TIMCPU	☐	DB2TIMCPU		CHAR	26	0	CPU time
87	TIMWAIT	☐	DB2TIMWAIT		CHAR	26	0	Wait time
88	TIMSYIO	☐	DB2TIMSYIO		CHAR	26	0	Wait time for synchronous I/O
89	TIMLOLA	☐	DB2TIMLOLA		CHAR	26	0	Wait time for lock/latch
90	TIMEUSW	☐	DB2TIMEUSW		CHAR	26	0	Wait time for EU switch
91	TIMGLLO	☐	DB2TIMGLLO		CHAR	26	0	Wait time for global lock
92	TIMREAD	☐	DB2TIMREAD		CHAR	26	0	Wait time for other read
93	TIMWRIT	☐	DB2TIMWRIT		CHAR	26	0	Wait time for other write
94	TIMLARQ	☐			CHAR	26	0
95	TIMPGLA	☐			CHAR	26	0
96	TIMDRLO	☐			CHAR	26	0
97	TIMCLRL	☐			CHAR	26	0
98	TIMLOGW	☐			CHAR	26	0
99	TIMOTHE	☐	DB2TIMOTHE		CHAR	26	0	Other wait time
100	RANBTONE	☐	DB2AVGRBUF	DB2DEC25V6	DEC	25	6	Average synchronous reads
101	RANWTONE	☐	DB2AVGWRITE	DB2DEC25V6	DEC	25	6	Average synchronous writes
102	RANGTONE	☐	DB2AVGGPAG	DB2DEC25V6	DEC	25	6	Average getpages
103	RANSTONE	☐	DB2AVGSORT	DB2DEC25V6	DEC	25	6	Average sorts
104	RANITONE	☐	DB2AVGINDX	DB2DEC25V6	DEC	25	6	Average index scans
105	RANTTONE	☐	DB2AVGTSCN	DB2DEC25V6	DEC	25	6	Average tablespace scans
106	RARSTONE	☐	DB2AVG316RS	DB2DEC25V6	DEC	25	6	Average RID failures - no storage
107	RARTTONE	☐	DB2AVG316RT	DB2DEC25V6	DEC	25	6	Average RID failures - limit
108	RANLTONE	☐	DB2AVGPLGP	DB2DEC25V6	DEC	25	6	Average parallel groups
109	RANGTONP	☐	DB2NGTONP	DB2DEC25V6	DEC	25	6	Getpages per rows processed
110	RANRTONP	☐	DB2NRTONP	DB2DEC25V6	DEC	25	6	Examined/rows processed (Only data rows are taken into acc.)
111	RAW1TOBW	☐	DB2W1TOBW		CHAR	26	0	Average duration of a synchronous I/O
112	EXECPSEC	☐	DB2EXESEC	DB2DEC25V6	DEC	25	6	Average executions per second
113	QW0316W1N	☐	DB2QW316W1	DB2DEC16	DEC	16	0	Accumulated Wait Time for Synchronous I/O
114	QW0316W2N	☐	DB2QW316W2	DB2DEC16	DEC	16	0	Accumulated Wait Time for Lock and Latch Req.
115	QW0316W3N	☐	DB2QW316W3	DB2DEC16	DEC	16	0	Accumulated Wait Time for Sync. Execution Unit Switch
116	QW0316W4N	☐	DB2QW316W4	DB2DEC16	DEC	16	0	Accumulated Wait Time for Global Locks
117	QW0316W5N	☐	DB2QW316W5	DB2DEC16	DEC	16	0	Accumulated Wait Time for Read Activity by Another Thread
118	QW0316W6N	☐	DB2QW316W6	DB2DEC16	DEC	16	0	Accumulated Wait Time for Write Activity by Another Thread
119	QW0316W7N	☐	DB2QW316W7		DEC	16	0	Accumulated wait time for latch req
120	QW0316W8N	☐	DB2QW316W8		DEC	16	0	Accumulated wait time for page latch
121	QW0316W9N	☐	DB2QW316W9		DEC	16	0	Accumulated wait time for drain lock
122	QW0316WAN	☐	DB2QW316WA		DEC	16	0	Acc. wait for drain when waiting for claims to be released
123	QW0316WBN	☐	DB2QW316WB		DEC	16	0	Accumulated wait time for logwriter
124	QW0316CTN	☐	DB2QW316CT	DB2DEC16	DEC	16	0	Accumulated CPU Time
125	QSTCAETN	☐	DB2QSTAET	DB2DEC16	DEC	16	0	Time elapsed
126	QW0316TD	☐	DB2QW316TD	CHAR128	CHAR	128	0	Name of the table referenced in the statement
127	MEMBNM	☐	DB2MEMN	DB2CHAR08	CHAR	8	0	DB2 member name in data sharing environment
128	STATUID	☐			CHAR	29	0

History

Last changed by/on	SAP	20130604
SAP Release Created in