SAP ABAP Table DB2QDSCCONT (Structure describing content of dynamic statement cache)

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	DB2QDSCCONT	Table Relationship Diagram
Short Description	Structure describing content of dynamic statement cache

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	QSTCUSE	☐	DB2QSTUSE	DB2DEC19V	DEC	19	0	Current Copies
3	QSTCCOPY	☐	DB2QSTCOPY	DB2INT4	INT4	10	0	Number of copies of the statement
4	QSTCSTAT	☐	DB2QSTSTAT	DB2CHAR30	CHAR	30	0	Status of the statement
5	QSTCISTM	☐	DB2QSTISTM	DB2RAW10	RAW	10	0	Time when statement was inserted into cache
6	QSTCEXEC	☐	DB2QSTEXEC	DB2DEC19V	DEC	19	0	Number of executions of the statement
7	QSTCRBUF	☐	DB2QSTRBUF	DB2DEC19V	DEC	19	0	Synchronous Reads
8	QSTCGPAG	☐	DB2QSTGPAG	DB2DEC19V	DEC	19	0	Getpages
9	DSTCGPAG	☐			DEC	16	0
10	QSTCEROW	☐	DB2QSTEROW	DB2DEC19V	DEC	19	0	Rows examined (Only data rows are taken into account)
11	DSTCEROW	☐			DEC	16	0
12	QSTCPROW	☐	DB2QSTPROW	DB2DEC19V	DEC	19	0	Rows Processed
13	DSTCPROW	☐			DEC	16	0
14	QSTCSORT	☐	DB2QSTSORT	DB2DEC19V	DEC	19	0	Number of sorts performed for statement
15	QSTCINDX	☐	DB2QSTINDX	DB2DEC19V	DEC	19	0	Number of index scans performed for statement
16	QSTCTSCN	☐	DB2QSTTSCN	DB2DEC19V	DEC	19	0	Number of tablespace scans performed for statement
17	QSTCPLGP	☐	DB2QSTPLGP	DB2DEC19V	DEC	19	0	Number of parallel groups created for statement
18	QSTCWRIT	☐	DB2QSTWRIT	DB2DEC19V	DEC	19	0	Synchronous Writes
19	QSTCAET	☐	DB2QSTAET	DB2DEC16	DEC	16	0	Time elapsed
20	QSTCSTLN	☐	DB2QSTSTLN	INT2	INT2	5	0	The length of the SQL Statement
21	QSTCSTMT	☐	DB2QSTSTMT		CHAR	255	0	Statement text
22	QW0316L1	☐	DB2QW316L1	INT2	INT2	5	0	Length of program name
23	QW0316T1	☐	DB2QW316T1	CHAR128	CHAR	128	0	Program name
24	QW0316LX	☐	DB2QW316LX	DB2INT4	INT4	10	0	Statement Line Number
25	QW0316L2	☐	DB2QW316L2	INT2	INT2	5	0	Length of transaction name
26	QW0316T2	☐	DB2QW316T2	DB2CHAR32	CHAR	32	0	Transaction name
27	QW0316L3	☐	DB2QW316L3	INT2	INT2	5	0	Length of user ID
28	QW0316T3	☐	DB2QW316T3	CHAR128	CHAR	128	0	User ID
29	QW0316X4	☐	DB2QW316X4	CHAR128	CHAR	128	0	User group
30	QW0316X5	☐	DB2QW316X5	CHAR128	CHAR	128	0	The value of QUALIFIER bind option
31	QW0316X6	☐	DB2QW316X6	DB2CHAR03	CHAR	3	0	ISOLATION
32	QW0316X7T	☐	DB2QW316X7	DB2CHAR03	CHAR	3	0	CURRENTDATA
33	QW0316X8T	☐	DB2QW316X8	DB2CHAR04	CHAR	4	0	DYNAMICRULES
34	QW0316X9T	☐	DB2QW316X9	DB2CHAR03	CHAR	3	0	CURRENT DEGREE
35	QW0316XAT	☐	DB2QW316XA	DB2CHAR03	CHAR	3	0	CURRENT RULES
36	QW0316XBT	☐	DB2QW316XB	DB2CHAR05	CHAR	5	0	CURRENT PRECISION
37	QW0316XCT	☐	DB2QW316XC	DB2CHAR03	CHAR	3	0	WITH HOLD
38	QW0316TS	☐	DB2QW316TS	DB2DEC16	DEC	16	0	Timestamp: Begin of Statistics Collection
39	QW0316CT	☐	DB2QW316CT	DB2DEC16	DEC	16	0	Accumulated CPU Time
40	QW0316W1	☐	DB2QW316W1	DB2DEC16	DEC	16	0	Accumulated Wait Time for Synchronous I/O
41	QW0316W2	☐	DB2QW316W2	DB2DEC16	DEC	16	0	Accumulated Wait Time for Lock and Latch Req.
42	QW0316W3	☐	DB2QW316W3	DB2DEC16	DEC	16	0	Accumulated Wait Time for Sync. Execution Unit Switch
43	QW0316W4	☐	DB2QW316W4	DB2DEC16	DEC	16	0	Accumulated Wait Time for Global Locks
44	QW0316W5	☐	DB2QW316W5	DB2DEC16	DEC	16	0	Accumulated Wait Time for Read Activity by Another Thread
45	QW0316W6	☐	DB2QW316W6	DB2DEC16	DEC	16	0	Accumulated Wait Time for Write Activity by Another Thread
46	QW0316RT	☐	DB2QW316RT	DB2DEC19V	DEC	19	0	RID List Not Used due to DB2 Limits Exceeded
47	QW0316RS	☐	DB2QW316RS	DB2DEC19V	DEC	19	0	RID List Not Used due to Insufficient Storage
48	QW0316UI	☐	DB2QW316UI	CHAR128	CHAR	128	0	SAP provided identification of SQL statements
49	QW0316TD	☐	DB2QW316TD	CHAR128	CHAR	128	0	Name of the table referenced in the statement
50	BIND_RA_TOT	☐			INT4	10	0
51	BIND_RO_TYPE	☐			CHAR	10	0
52	.INCLUDE	☐				0	0	dynamic statement cache: SQL STATEMENT
53	QW0317NM	☐	DB2W0317NM	CHAR16	CHAR	16	0	SQL STATEMENT NAM
54	QW0317ID	☐	DB2W0317ID		INT4	10	0	SQL STATEMENT IDENTIFIER
55	QW0317LN	☐	DB2W0317LN		INT4	10	0	THE LENGTH OF THE SQL STMT
56	QW0317TX	☐	DB2W0317TX	DB2C30K	LCHR	30720	0	SQL statement text
57	QW03172LN	☐	DB2W0317LN		INT4	10	0	THE LENGTH OF THE SQL STMT
58	QW03172TX	☐	DB2QSTSTMT		CHAR	255	0	Statement text

History

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