Data Element list used by SAP ABAP Table DB2QTHDDSC (content dynamic statement cache)
SAP ABAP Table DB2QTHDDSC (content dynamic statement cache) is using
# | Object Type | Object Name | Object Description | Note |
---|---|---|---|---|
1 | Data Element | DB2MEMN | DB2 member name in data sharing environment | |
2 | Data Element | DB2QSTAET | Time elapsed | |
3 | Data Element | DB2QSTCOPY | Number of copies of the statement | |
4 | Data Element | DB2QSTEROW | Rows examined (Only data rows are taken into account) | |
5 | Data Element | DB2QSTEXEC | Number of executions of the statement | |
6 | Data Element | DB2QSTGPAG | Getpages | |
7 | Data Element | DB2QSTINDX | Number of index scans performed for statement | |
8 | Data Element | DB2QSTISTM | Time when statement was inserted into cache | |
9 | Data Element | DB2QSTPLGP | Number of parallel groups created for statement | |
10 | Data Element | DB2QSTPROW | Rows Processed | |
11 | Data Element | DB2QSTRBUF | Synchronous Reads | |
12 | Data Element | DB2QSTSORT | Number of sorts performed for statement | |
13 | Data Element | DB2QSTSTAT | Status of the statement | |
14 | Data Element | DB2QSTSTLN | The length of the SQL Statement | |
15 | Data Element | DB2QSTSTMT | Statement text | |
16 | Data Element | DB2QSTSTMT | Statement text | |
17 | Data Element | DB2QSTSTNM | DB2 statement name | |
18 | Data Element | DB2QSTTOKN | Statement ID | |
19 | Data Element | DB2QSTTSCN | Number of tablespace scans performed for statement | |
20 | Data Element | DB2QSTUSE | Current Copies | |
21 | Data Element | DB2QSTWRIT | Synchronous Writes | |
22 | Data Element | DB2QW316CT | Accumulated CPU Time | |
23 | Data Element | DB2QW316L1 | Length of program name | |
24 | Data Element | DB2QW316L2 | Length of transaction name | |
25 | Data Element | DB2QW316L3 | Length of user ID | |
26 | Data Element | DB2QW316LX | Statement Line Number | |
27 | Data Element | DB2QW316RS | RID List Not Used due to Insufficient Storage | |
28 | Data Element | DB2QW316RT | RID List Not Used due to DB2 Limits Exceeded | |
29 | Data Element | DB2QW316T1 | Program name | |
30 | Data Element | DB2QW316T2 | Transaction name | |
31 | Data Element | DB2QW316T3 | User ID | |
32 | Data Element | DB2QW316TD | Name of the table referenced in the statement | |
33 | Data Element | DB2QW316TS | Timestamp: Begin of Statistics Collection | |
34 | Data Element | DB2QW316UI | SAP provided identification of SQL statements | |
35 | Data Element | DB2QW316W1 | Accumulated Wait Time for Synchronous I/O | |
36 | Data Element | DB2QW316W2 | Accumulated Wait Time for Lock and Latch Req. | |
37 | Data Element | DB2QW316W3 | Accumulated Wait Time for Sync. Execution Unit Switch | |
38 | Data Element | DB2QW316W4 | Accumulated Wait Time for Global Locks | |
39 | Data Element | DB2QW316W5 | Accumulated Wait Time for Read Activity by Another Thread | |
40 | Data Element | DB2QW316W6 | Accumulated Wait Time for Write Activity by Another Thread | |
41 | Data Element | DB2QW316X4 | User group | |
42 | Data Element | DB2QW316X5 | The value of QUALIFIER bind option | |
43 | Data Element | DB2QW316X6 | ISOLATION | |
44 | Data Element | DB2QW316X7 | CURRENTDATA | |
45 | Data Element | DB2QW316X8 | DYNAMICRULES | |
46 | Data Element | DB2QW316X9 | CURRENT DEGREE | |
47 | Data Element | DB2QW316XA | CURRENT RULES | |
48 | Data Element | DB2QW316XB | CURRENT PRECISION | |
49 | Data Element | DB2QW316XC | WITH HOLD | |
50 | Data Element | DB2USERID | DB2USERID- | |
51 | Data Element | DB2W0317ID | SQL STATEMENT IDENTIFIER | |
52 | Data Element | DB2W0317LN | THE LENGTH OF THE SQL STMT | |
53 | Data Element | DB2W0317LN | THE LENGTH OF THE SQL STMT | |
54 | Data Element | DB2W0317NM | SQL STATEMENT NAM | |
55 | Data Element | DB2W0317TX | SQL statement text |