SAP ABAP Table DB2QDSCHIST_V10 (Content of dynamic statement cache history)

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	DB2QDSCHIST_V10	Table Relationship Diagram
Short Description	Content of dynamic statement cache history

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	DSCDATE	☐	DATS	DATS	DATS	8	0	Field of type DATS
3	DSCTIME	☐	TIMS	TIME	TIMS	6	0	Field of type TIMS
4	USERID	☐	DB2USERID	DB2SINT	INT2	5	0
5	QSTCTOKN	☐	DB2QSTTOKN	DB2INT4	INT4	10	0	Statement ID
6	DSCMSEC	☐	DB2EVTTMS	DB2CHAR06	CHAR	6	0	Event time stamp (milliseconds)
7	.INCLUDE	☐				0	0	Structure describing content of dynamic statement cache
8	QSTCSTNM	☐	DB2QSTSTNM	DB2RAW16	RAW	16	0	DB2 statement name
9	QSTCUSE	☐	DB2QSTUSE	DB2DEC19V	DEC	19	0	Current Copies
10	QSTCCOPY	☐	DB2QSTCOPY	DB2INT4	INT4	10	0	Number of copies of the statement
11	QSTCSTAT	☐	DB2QSTSTAT	DB2CHAR30	CHAR	30	0	Status of the statement
12	QSTCISTM	☐	DB2QSTISTM	DB2RAW10	RAW	10	0	Time when statement was inserted into cache
13	QSTCLR	☐	DB2QSTLR		CHAR	10	0	Cache literal replacement indicator
14	QSTCEXEC	☐	DB2QSTEXEC	DB2DEC19V	DEC	19	0	Number of executions of the statement
15	QSTCRBUF	☐	DB2QSTRBUF	DB2DEC19V	DEC	19	0	Synchronous Reads
16	QSTCGPAG	☐	DB2QSTGPAG	DB2DEC19V	DEC	19	0	Getpages
17	QSTCEROW	☐	DB2QSTEROW	DB2DEC19V	DEC	19	0	Rows examined (Only data rows are taken into account)
18	QSTCPROW	☐	DB2QSTPROW	DB2DEC19V	DEC	19	0	Rows Processed
19	QSTCSORT	☐	DB2QSTSORT	DB2DEC19V	DEC	19	0	Number of sorts performed for statement
20	QSTCINDX	☐	DB2QSTINDX	DB2DEC19V	DEC	19	0	Number of index scans performed for statement
21	QSTCTSCN	☐	DB2QSTTSCN	DB2DEC19V	DEC	19	0	Number of tablespace scans performed for statement
22	QSTCPLGP	☐	DB2QSTPLGP	DB2DEC19V	DEC	19	0	Number of parallel groups created for statement
23	QSTCWRIT	☐	DB2QSTWRIT	DB2DEC19V	DEC	19	0	Synchronous Writes
24	QSTCAET	☐	DB2QSTAET	DB2DEC16	DEC	16	0	Time elapsed
25	QSTCSTLN	☐	DB2QSTSTLN	INT2	INT2	5	0	The length of the SQL Statement
26	QSTCSTMT	☐	DB2QSTSTMT		CHAR	255	0	Statement text
27	QW0316TM2	☐	DB2QW316TM2R		RAW	10	0	Time when stmt was inserted into cache - stored clock format
28	QW0316UT1	☐	DB2QW316UT1R		RAW	10	0	Time when the stmt stat was updated - stored clock format
29	QW0316UT2	☐	DB2QW316UT2R		RAW	10	0	Date/Time when the stmt stat was updated -in external format
30	QW0316L1	☐	DB2QW316L1	INT2	INT2	5	0	Length of program name
31	QW0316T1	☐	DB2QW316T1	CHAR128	CHAR	128	0	Program name
32	QW0316LX	☐	DB2QW316LX	DB2INT4	INT4	10	0	Statement Line Number
33	QW0316T2	☐	DB2QW316T2	DB2CHAR32	CHAR	32	0	Transaction name
34	QW0316L3	☐	DB2QW316L3	INT2	INT2	5	0	Length of user ID
35	QW0316T3	☐	DB2QW316T3	CHAR128	CHAR	128	0	User ID
36	QW0316X4	☐	DB2QW316X4	CHAR128	CHAR	128	0	User group
37	QW0316X5	☐	DB2QW316X5	CHAR128	CHAR	128	0	The value of QUALIFIER bind option
38	QW0316X6	☐	DB2QW316X6	DB2CHAR03	CHAR	3	0	ISOLATION
39	QW0316X7T	☐	DB2QW316X7	DB2CHAR03	CHAR	3	0	CURRENTDATA
40	QW0316X8T	☐	DB2QW316X8	DB2CHAR04	CHAR	4	0	DYNAMICRULES
41	QW0316X9T	☐	DB2QW316X9	DB2CHAR03	CHAR	3	0	CURRENT DEGREE
42	QW0316XAT	☐	DB2QW316XA	DB2CHAR03	CHAR	3	0	CURRENT RULES
43	QW0316XBT	☐	DB2QW316XB	DB2CHAR05	CHAR	5	0	CURRENT PRECISION
44	QW0316XCT	☐	DB2QW316XC	DB2CHAR03	CHAR	3	0	WITH HOLD
45	QW0316TS	☐	DB2QW316TS	DB2DEC16	DEC	16	0	Timestamp: Begin of Statistics Collection
46	QW0316CT	☐	DB2QW316CT	DB2DEC16	DEC	16	0	Accumulated CPU Time
47	QW0316W1	☐	DB2QW316W1	DB2DEC16	DEC	16	0	Accumulated Wait Time for Synchronous I/O
48	QW0316W2	☐	DB2QW316W2	DB2DEC16	DEC	16	0	Accumulated Wait Time for Lock and Latch Req.
49	QW0316W3	☐	DB2QW316W3	DB2DEC16	DEC	16	0	Accumulated Wait Time for Sync. Execution Unit Switch
50	QW0316W4	☐	DB2QW316W4	DB2DEC16	DEC	16	0	Accumulated Wait Time for Global Locks
51	QW0316W5	☐	DB2QW316W5	DB2DEC16	DEC	16	0	Accumulated Wait Time for Read Activity by Another Thread
52	QW0316W6	☐	DB2QW316W6	DB2DEC16	DEC	16	0	Accumulated Wait Time for Write Activity by Another Thread
53	QW0316W7	☐	DB2QW316W7		DEC	16	0	Accumulated wait time for latch req
54	QW0316W8	☐	DB2QW316W8		DEC	16	0	Accumulated wait time for page latch
55	QW0316W9	☐	DB2QW316W9		DEC	16	0	Accumulated wait time for drain lock
56	QW0316WA	☐	DB2QW316WA		DEC	16	0	Acc. wait for drain when waiting for claims to be released
57	QW0316WB	☐	DB2QW316WB		DEC	16	0	Accumulated wait time for logwriter
58	QW0316XE	☐	DB2QW316XE		CHAR	16	0	ENDuser ID - Value provided on RRS (re)signon
59	QW0316XF	☐	DB2QW316XF		CHAR	18	0	Workstation name - Value provided on RRS (re)signon
60	QW0316RT	☐	DB2QW316RT	DB2DEC19V	DEC	19	0	RID List Not Used due to DB2 Limits Exceeded
61	QW0316RS	☐	DB2QW316RS	DB2DEC19V	DEC	19	0	RID List Not Used due to Insufficient Storage
62	QW0316UI	☐	DB2QW316UI	CHAR128	CHAR	128	0	SAP provided identification of SQL statements
63	QW0316TD	☐	DB2QW316TD	CHAR128	CHAR	128	0	Name of the table referenced in the statement
64	.INCLUDE	☐				0	0	dynamic statement cache: SQL STATEMENT
65	QW0317NM	☐	DB2W0317NM	CHAR16	CHAR	16	0	SQL STATEMENT NAM
66	QW0317ID	☐	DB2W0317ID		INT4	10	0	SQL STATEMENT IDENTIFIER
67	QW0317LN	☐	DB2W0317LN		INT4	10	0	THE LENGTH OF THE SQL STMT
68	QW0317TX	☐	DB2W0317TX	DB2C30K	LCHR	30720	0	SQL statement text
69	QW03172LN	☐	DB2W0317LN		INT4	10	0	THE LENGTH OF THE SQL STMT
70	QW03172TX	☐	DB2QSTSTMT		CHAR	255	0	Statement text

History

Last changed by/on	SAP	20130604
SAP Release Created in