SAP ABAP Table DB2QW0316 (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	DB2QW0316	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	QW0316TM2	☐			CHAR	8	0
2	QW0316UT1	☐			CHAR	8	0
3	QW0316UT2	☐			CHAR	10	0
4	QW0316L1	☐	DB2QW316L1	INT2	INT2	5	0	Length of program name
5	QW0316T1	☐	DB2QW316T1	CHAR128	CHAR	128	0	Program name
6	QW0316LX	☐	DB2QW316LX	DB2INT4	INT4	10	0	Statement Line Number
7	QW0316L2	☐	DB2QW316L2	INT2	INT2	5	0	Length of transaction name
8	QW0316T2	☐	DB2QW316T2	DB2CHAR32	CHAR	32	0	Transaction name
9	QW0316L3	☐	DB2QW316L3	INT2	INT2	5	0	Length of user ID
10	QW0316T3	☐	DB2QW316T3	CHAR128	CHAR	128	0	User ID
11	QW0316X4	☐	DB2QW316X4	CHAR128	CHAR	128	0	User group
12	QW0316X5	☐	DB2QW316X5	CHAR128	CHAR	128	0	The value of QUALIFIER bind option
13	QW0316X6	☐	DB2QW316X6	DB2CHAR03	CHAR	3	0	ISOLATION
14	QW0316X7T	☐	DB2QW316X7	DB2CHAR03	CHAR	3	0	CURRENTDATA
15	QW0316X8T	☐	DB2QW316X8	DB2CHAR04	CHAR	4	0	DYNAMICRULES
16	QW0316X9T	☐	DB2QW316X9	DB2CHAR03	CHAR	3	0	CURRENT DEGREE
17	QW0316XAT	☐	DB2QW316XA	DB2CHAR03	CHAR	3	0	CURRENT RULES
18	QW0316XBT	☐	DB2QW316XB	DB2CHAR05	CHAR	5	0	CURRENT PRECISION
19	QW0316XCT	☐	DB2QW316XC	DB2CHAR03	CHAR	3	0	WITH HOLD
20	QW0316TS	☐	DB2QW316TS	DB2DEC16	DEC	16	0	Timestamp: Begin of Statistics Collection
21	QW0316CT	☐	DB2QW316CT	DB2DEC16	DEC	16	0	Accumulated CPU Time
22	QW0316W1	☐	DB2QW316W1	DB2DEC16	DEC	16	0	Accumulated Wait Time for Synchronous I/O
23	QW0316W2	☐	DB2QW316W2	DB2DEC16	DEC	16	0	Accumulated Wait Time for Lock and Latch Req.
24	QW0316W3	☐	DB2QW316W3	DB2DEC16	DEC	16	0	Accumulated Wait Time for Sync. Execution Unit Switch
25	QW0316W4	☐	DB2QW316W4	DB2DEC16	DEC	16	0	Accumulated Wait Time for Global Locks
26	QW0316W5	☐	DB2QW316W5	DB2DEC16	DEC	16	0	Accumulated Wait Time for Read Activity by Another Thread
27	QW0316W6	☐	DB2QW316W6	DB2DEC16	DEC	16	0	Accumulated Wait Time for Write Activity by Another Thread
28	QW0316W7	☐	DB2QW316W7		DEC	16	0	Accumulated wait time for latch req
29	QW0316W8	☐	DB2QW316W8		DEC	16	0	Accumulated wait time for page latch
30	QW0316W9	☐	DB2QW316W9		DEC	16	0	Accumulated wait time for drain lock
31	QW0316WA	☐	DB2QW316WA		DEC	16	0	Acc. wait for drain when waiting for claims to be released
32	QW0316WB	☐	DB2QW316WB		DEC	16	0	Accumulated wait time for logwriter
33	QW0316RT	☐	DB2QW316RT	DB2DEC19V	DEC	19	0	RID List Not Used due to DB2 Limits Exceeded
34	QW0316RS	☐	DB2QW316RS	DB2DEC19V	DEC	19	0	RID List Not Used due to Insufficient Storage
35	QW0316TD	☐	DB2QW316TD	CHAR128	CHAR	128	0	Name of the table referenced in the statement

History

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