Data Element list used by SAP ABAP Table DB2QDSCHIST_V10 (Content of dynamic statement cache history)
SAP ABAP Table 
DB2QDSCHIST_V10 (Content of dynamic statement cache history) is using
| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
 |
|
|||
| 1 |  Data Element |
DATS | Field of type DATS | |
| 2 | Data Element |
DB2EVTTMS | Event time stamp (milliseconds) | |
| 3 | Data Element |
DB2MEMN | DB2 member name in data sharing environment | |
| 4 | Data Element |
DB2QSTAET | Time elapsed | |
| 5 | Data Element |
DB2QSTCOPY | Number of copies of the statement | |
| 6 | Data Element |
DB2QSTEROW | Rows examined (Only data rows are taken into account) | |
| 7 | Data Element |
DB2QSTEXEC | Number of executions of the statement | |
| 8 | Data Element |
DB2QSTGPAG | Getpages | |
| 9 | Data Element |
DB2QSTINDX | Number of index scans performed for statement | |
| 10 | Data Element |
DB2QSTISTM | Time when statement was inserted into cache | |
| 11 | Data Element |
DB2QSTLR | Cache literal replacement indicator | |
| 12 | Data Element |
DB2QSTPLGP | Number of parallel groups created for statement | |
| 13 | Data Element |
DB2QSTPROW | Rows Processed | |
| 14 | Data Element |
DB2QSTRBUF | Synchronous Reads | |
| 15 | Data Element |
DB2QSTSORT | Number of sorts performed for statement | |
| 16 | Data Element |
DB2QSTSTAT | Status of the statement | |
| 17 | Data Element |
DB2QSTSTLN | The length of the SQL Statement | |
| 18 | Data Element |
DB2QSTSTMT | Statement text | |
| 19 | Data Element |
DB2QSTSTMT | Statement text | |
| 20 | Data Element |
DB2QSTSTNM | DB2 statement name | |
| 21 | Data Element |
DB2QSTTOKN | Statement ID | |
| 22 | Data Element |
DB2QSTTSCN | Number of tablespace scans performed for statement | |
| 23 | Data Element |
DB2QSTUSE | Current Copies | |
| 24 | Data Element |
DB2QSTWRIT | Synchronous Writes | |
| 25 | Data Element |
DB2QW316CT | Accumulated CPU Time | |
| 26 | Data Element |
DB2QW316L1 | Length of program name | |
| 27 | Data Element |
DB2QW316L3 | Length of user ID | |
| 28 | Data Element |
DB2QW316LX | Statement Line Number | |
| 29 | Data Element |
DB2QW316RS | RID List Not Used due to Insufficient Storage | |
| 30 | Data Element |
DB2QW316RT | RID List Not Used due to DB2 Limits Exceeded | |
| 31 | Data Element |
DB2QW316T1 | Program name | |
| 32 | Data Element |
DB2QW316T2 | Transaction name | |
| 33 | Data Element |
DB2QW316T3 | User ID | |
| 34 | Data Element |
DB2QW316TD | Name of the table referenced in the statement | |
| 35 | Data Element |
DB2QW316TM2R | Time when stmt was inserted into cache - stored clock format | |
| 36 | Data Element |
DB2QW316TS | Timestamp: Begin of Statistics Collection | |
| 37 | Data Element |
DB2QW316UI | SAP provided identification of SQL statements | |
| 38 | Data Element |
DB2QW316UT1R | Time when the stmt stat was updated - stored clock format | |
| 39 | Data Element |
DB2QW316UT2R | Date/Time when the stmt stat was updated -in external format | |
| 40 | Data Element |
DB2QW316W1 | Accumulated Wait Time for Synchronous I/O | |
| 41 | Data Element |
DB2QW316W2 | Accumulated Wait Time for Lock and Latch Req. | |
| 42 | Data Element |
DB2QW316W3 | Accumulated Wait Time for Sync. Execution Unit Switch | |
| 43 | Data Element |
DB2QW316W4 | Accumulated Wait Time for Global Locks | |
| 44 | Data Element |
DB2QW316W5 | Accumulated Wait Time for Read Activity by Another Thread | |
| 45 | Data Element |
DB2QW316W6 | Accumulated Wait Time for Write Activity by Another Thread | |
| 46 | Data Element |
DB2QW316W7 | Accumulated wait time for latch req | |
| 47 | Data Element |
DB2QW316W8 | Accumulated wait time for page latch | |
| 48 | Data Element |
DB2QW316W9 | Accumulated wait time for drain lock | |
| 49 | Data Element |
DB2QW316WA | Acc. wait for drain when waiting for claims to be released | |
| 50 | Data Element |
DB2QW316WB | Accumulated wait time for logwriter | |
| 51 | Data Element |
DB2QW316X4 | User group | |
| 52 | Data Element |
DB2QW316X5 | The value of QUALIFIER bind option | |
| 53 | Data Element |
DB2QW316X6 | ISOLATION | |
| 54 | Data Element |
DB2QW316X7 | CURRENTDATA | |
| 55 | Data Element |
DB2QW316X8 | DYNAMICRULES | |
| 56 | Data Element |
DB2QW316X9 | CURRENT DEGREE | |
| 57 | Data Element |
DB2QW316XA | CURRENT RULES | |
| 58 | Data Element |
DB2QW316XB | CURRENT PRECISION | |
| 59 | Data Element |
DB2QW316XC | WITH HOLD | |
| 60 | Data Element |
DB2QW316XE | ENDuser ID - Value provided on RRS (re)signon | |
| 61 | Data Element |
DB2QW316XF | Workstation name - Value provided on RRS (re)signon | |
| 62 | Data Element |
DB2USERID | DB2USERID- | |
| 63 | Data Element |
DB2W0317ID | SQL STATEMENT IDENTIFIER | |
| 64 | Data Element |
DB2W0317LN | THE LENGTH OF THE SQL STMT | |
| 65 | Data Element |
DB2W0317LN | THE LENGTH OF THE SQL STMT | |
| 66 | Data Element |
DB2W0317NM | SQL STATEMENT NAM | |
| 67 | Data Element |
DB2W0317TX | SQL statement text | |
| 68 | Data Element |
TIMS | Field of type TIMS |
