SAP ABAP Table DB2QDSCHIST (Content of dynamic statement cache history)
Hierarchy
☛
SAP_BASIS (Software Component) SAP Basis Component
⤷ BC-DB-DB2 (Application Component) DB2 for z/OS
⤷ STU3 (Package) Development Class for Database Monitor
⤷ BC-DB-DB2 (Application Component) DB2 for z/OS
⤷ STU3 (Package) Development Class for Database Monitor
Basic Data
Table Category | INTTAB | Structure |
Structure | DB2QDSCHIST | 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 | QSTCEXEC | DB2QSTEXEC | DB2DEC19V | DEC | 19 | 0 | Number of executions of the statement | ||
14 | QSTCRBUF | DB2QSTRBUF | DB2DEC19V | DEC | 19 | 0 | Synchronous Reads | ||
15 | QSTCGPAG | DB2QSTGPAG | DB2DEC19V | DEC | 19 | 0 | Getpages | ||
16 | DSTCGPAG | DEC | 16 | 0 | |||||
17 | QSTCEROW | DB2QSTEROW | DB2DEC19V | DEC | 19 | 0 | Rows examined (Only data rows are taken into account) | ||
18 | DSTCEROW | DEC | 16 | 0 | |||||
19 | QSTCPROW | DB2QSTPROW | DB2DEC19V | DEC | 19 | 0 | Rows Processed | ||
20 | DSTCPROW | DEC | 16 | 0 | |||||
21 | QSTCSORT | DB2QSTSORT | DB2DEC19V | DEC | 19 | 0 | Number of sorts performed for statement | ||
22 | QSTCINDX | DB2QSTINDX | DB2DEC19V | DEC | 19 | 0 | Number of index scans performed for statement | ||
23 | QSTCTSCN | DB2QSTTSCN | DB2DEC19V | DEC | 19 | 0 | Number of tablespace scans performed for statement | ||
24 | QSTCPLGP | DB2QSTPLGP | DB2DEC19V | DEC | 19 | 0 | Number of parallel groups created for statement | ||
25 | QSTCWRIT | DB2QSTWRIT | DB2DEC19V | DEC | 19 | 0 | Synchronous Writes | ||
26 | QSTCAET | DB2QSTAET | DB2DEC16 | DEC | 16 | 0 | Time elapsed | ||
27 | QSTCSTLN | DB2QSTSTLN | INT2 | INT2 | 5 | 0 | The length of the SQL Statement | ||
28 | QSTCSTMT | DB2QSTSTMT | CHAR | 255 | 0 | Statement text | |||
29 | QW0316L1 | DB2QW316L1 | INT2 | INT2 | 5 | 0 | Length of program name | ||
30 | QW0316T1 | DB2QW316T1 | CHAR128 | CHAR | 128 | 0 | Program name | ||
31 | QW0316LX | DB2QW316LX | DB2INT4 | INT4 | 10 | 0 | Statement Line Number | ||
32 | QW0316L2 | DB2QW316L2 | INT2 | INT2 | 5 | 0 | Length of transaction name | ||
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 | 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 | BIND_RA_TOT | INT4 | 10 | 0 | |||||
58 | BIND_RO_TYPE | CHAR | 10 | 0 | |||||
59 | .INCLUDE | 0 | 0 | dynamic statement cache: SQL STATEMENT | |||||
60 | QW0317NM | DB2W0317NM | CHAR16 | CHAR | 16 | 0 | SQL STATEMENT NAM | ||
61 | QW0317ID | DB2W0317ID | INT4 | 10 | 0 | SQL STATEMENT IDENTIFIER | |||
62 | QW0317LN | DB2W0317LN | INT4 | 10 | 0 | THE LENGTH OF THE SQL STMT | |||
63 | QW0317TX | DB2W0317TX | DB2C30K | LCHR | 30720 | 0 | SQL statement text | ||
64 | QW03172LN | DB2W0317LN | INT4 | 10 | 0 | THE LENGTH OF THE SQL STMT | |||
65 | QW03172TX | DB2QSTSTMT | CHAR | 255 | 0 | Statement text |
History
Last changed by/on | SAP | 20130604 |
SAP Release Created in | 700 |