SAP ABAP Table DB2QDSCCONT_V10 (Structure describing content of dynamic statement cache)
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
⤷ BC-DB-DB2 (Application Component) DB2 for z/OS
⤷ STU2 (Package) CCMS for DB2 for OS/390
Basic Data
Table Category | INTTAB | Structure |
Structure | DB2QDSCCONT_V10 | 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 | QSTCLR | DB2QSTLR | CHAR | 10 | 0 | Cache literal replacement indicator | |||
7 | QSTCEXEC | DB2QSTEXEC | DB2DEC19V | DEC | 19 | 0 | Number of executions of the statement | ||
8 | QSTCRBUF | DB2QSTRBUF | DB2DEC19V | DEC | 19 | 0 | Synchronous Reads | ||
9 | QSTCGPAG | DB2QSTGPAG | DB2DEC19V | DEC | 19 | 0 | Getpages | ||
10 | QSTCEROW | DB2QSTEROW | DB2DEC19V | DEC | 19 | 0 | Rows examined (Only data rows are taken into account) | ||
11 | QSTCPROW | DB2QSTPROW | DB2DEC19V | DEC | 19 | 0 | Rows Processed | ||
12 | QSTCSORT | DB2QSTSORT | DB2DEC19V | DEC | 19 | 0 | Number of sorts performed for statement | ||
13 | QSTCINDX | DB2QSTINDX | DB2DEC19V | DEC | 19 | 0 | Number of index scans performed for statement | ||
14 | QSTCTSCN | DB2QSTTSCN | DB2DEC19V | DEC | 19 | 0 | Number of tablespace scans performed for statement | ||
15 | QSTCPLGP | DB2QSTPLGP | DB2DEC19V | DEC | 19 | 0 | Number of parallel groups created for statement | ||
16 | QSTCWRIT | DB2QSTWRIT | DB2DEC19V | DEC | 19 | 0 | Synchronous Writes | ||
17 | QSTCAET | DB2QSTAET | DB2DEC16 | DEC | 16 | 0 | Time elapsed | ||
18 | QSTCSTLN | DB2QSTSTLN | INT2 | INT2 | 5 | 0 | The length of the SQL Statement | ||
19 | QSTCSTMT | DB2QSTSTMT | CHAR | 255 | 0 | Statement text | |||
20 | QW0316TM2 | DB2QW316TM2R | RAW | 10 | 0 | Time when stmt was inserted into cache - stored clock format | |||
21 | QW0316UT1 | DB2QW316UT1R | RAW | 10 | 0 | Time when the stmt stat was updated - stored clock format | |||
22 | QW0316UT2 | DB2QW316UT2R | RAW | 10 | 0 | Date/Time when the stmt stat was updated -in external format | |||
23 | QW0316L1 | DB2QW316L1 | INT2 | INT2 | 5 | 0 | Length of program name | ||
24 | QW0316T1 | DB2QW316T1 | CHAR128 | CHAR | 128 | 0 | Program name | ||
25 | QW0316LX | DB2QW316LX | DB2INT4 | INT4 | 10 | 0 | Statement Line Number | ||
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 | QW0316W7 | DB2QW316W7 | DEC | 16 | 0 | Accumulated wait time for latch req | |||
47 | QW0316W8 | DB2QW316W8 | DEC | 16 | 0 | Accumulated wait time for page latch | |||
48 | QW0316W9 | DB2QW316W9 | DEC | 16 | 0 | Accumulated wait time for drain lock | |||
49 | QW0316WA | DB2QW316WA | DEC | 16 | 0 | Acc. wait for drain when waiting for claims to be released | |||
50 | QW0316WB | DB2QW316WB | DEC | 16 | 0 | Accumulated wait time for logwriter | |||
51 | QW0316XE | DB2QW316XE | CHAR | 16 | 0 | ENDuser ID - Value provided on RRS (re)signon | |||
52 | QW0316XF | DB2QW316XF | CHAR | 18 | 0 | Workstation name - Value provided on RRS (re)signon | |||
53 | QW0316RT | DB2QW316RT | DB2DEC19V | DEC | 19 | 0 | RID List Not Used due to DB2 Limits Exceeded | ||
54 | QW0316RS | DB2QW316RS | DB2DEC19V | DEC | 19 | 0 | RID List Not Used due to Insufficient Storage | ||
55 | QW0316UI | DB2QW316UI | CHAR128 | CHAR | 128 | 0 | SAP provided identification of SQL statements | ||
56 | QW0316TD | DB2QW316TD | CHAR128 | CHAR | 128 | 0 | Name of the table referenced in the statement | ||
57 | .INCLUDE | 0 | 0 | dynamic statement cache: SQL STATEMENT | |||||
58 | QW0317NM | DB2W0317NM | CHAR16 | CHAR | 16 | 0 | SQL STATEMENT NAM | ||
59 | QW0317ID | DB2W0317ID | INT4 | 10 | 0 | SQL STATEMENT IDENTIFIER | |||
60 | QW0317LN | DB2W0317LN | INT4 | 10 | 0 | THE LENGTH OF THE SQL STMT | |||
61 | QW0317TX | DB2W0317TX | DB2C30K | LCHR | 30720 | 0 | SQL statement text | ||
62 | QW03172LN | DB2W0317LN | INT4 | 10 | 0 | THE LENGTH OF THE SQL STMT | |||
63 | QW03172TX | DB2QSTSTMT | CHAR | 255 | 0 | Statement text |
History
Last changed by/on | SAP | 20130604 |
SAP Release Created in |