Data Element list used by SAP ABAP Table DB2QSTC (Structure for Statement Trace)
SAP ABAP Table 
DB2QSTC (Structure for Statement Trace) is using
| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
 |
|
|||
| 1 |  Data Element |
DB2AVG316RS | Average RID failures - no storage | |
| 2 | Data Element |
DB2AVG316RT | Average RID failures - limit | |
| 3 | Data Element |
DB2AVGCT | Average CPU time | |
| 4 | Data Element |
DB2AVGGPAG | Average getpages | |
| 5 | Data Element |
DB2AVGINDX | Average index scans | |
| 6 | Data Element |
DB2AVGOTHED | Average other wait time (dec) | |
| 7 | Data Element |
DB2AVGPLGP | Average parallel groups | |
| 8 | Data Element |
DB2AVGRBUF | Average synchronous reads | |
| 9 | Data Element |
DB2AVGSORT | Average sorts | |
| 10 | Data Element |
DB2AVGTSCN | Average tablespace scans | |
| 11 | Data Element |
DB2AVGW | Average wait time | |
| 12 | Data Element |
DB2AVGW1 | Average synchronous I/O time | |
| 13 | Data Element |
DB2AVGW2 | Average wait for lock/latch | |
| 14 | Data Element |
DB2AVGW3 | Average wait for EU switch | |
| 15 | Data Element |
DB2AVGW4 | Average wait for global lock | |
| 16 | Data Element |
DB2AVGW5 | Average wait for other read | |
| 17 | Data Element |
DB2AVGW6 | Average wait for other write | |
| 18 | Data Element |
DB2AVGW7 | Average wait time for latch req | |
| 19 | Data Element |
DB2AVGW8 | Average wait time for page latch | |
| 20 | Data Element |
DB2AVGW9 | Average wait time for drain lock | |
| 21 | Data Element |
DB2AVGWA | Average wait for drain when waiting for claims to be rel. | |
| 22 | Data Element |
DB2AVGWB | Average wait time for logwriter | |
| 23 | Data Element |
DB2AVGWRITE | Average synchronous writes | |
| 24 | Data Element |
DB2EXESEC | Average executions per second | |
| 25 | Data Element |
DB2GPPRPROC | Getpages per rows processed | |
| 26 | Data Element |
DB2MEMN | DB2 member name in data sharing environment | |
| 27 | Data Element |
DB2NGTONP | Getpages per rows processed | |
| 28 | Data Element |
DB2NRTONP | Examined/rows processed (Only data rows are taken into acc.) | |
| 29 | Data Element |
DB2Q316CLX | Statement Line Number | |
| 30 | Data Element |
DB2QM316CT | Accumulated CPU Time | |
| 31 | Data Element |
DB2QM316TS | Timestamp: Begin of Statistics Collection | |
| 32 | Data Element |
DB2QM316W1 | Accumulated Wait Time for Synchronous I/O | |
| 33 | Data Element |
DB2QM316W2 | Accumulated Wait Time for Lock and Latch Req. | |
| 34 | Data Element |
DB2QM316W3 | Accumulated Wait Time for Sync. Execution Unit Switch | |
| 35 | Data Element |
DB2QM316W4 | Accumulated Wait Time for Global Locks | |
| 36 | Data Element |
DB2QM316W5 | Accumulated Wait Time for Read Activity by Another Thread | |
| 37 | Data Element |
DB2QM316W6 | Accumulated Wait Time for Write Activity by Another Thread | |
| 38 | Data Element |
DB2QSTAET | Time elapsed | |
| 39 | Data Element |
DB2QSTCAET | Time elapsed | |
| 40 | Data Element |
DB2QSTCLRU | Statement removed from cache by LRU (last recently used) | |
| 41 | Data Element |
DB2QSTCOPY | Number of copies of the statement | |
| 42 | Data Element |
DB2QSTEROW | Rows examined (Only data rows are taken into account) | |
| 43 | Data Element |
DB2QSTEXEC | Number of executions of the statement | |
| 44 | Data Element |
DB2QSTGPAG | Getpages | |
| 45 | Data Element |
DB2QSTIDDL | Statement invalidated by DROP or ALTER | |
| 46 | Data Element |
DB2QSTINDX | Number of index scans performed for statement | |
| 47 | Data Element |
DB2QSTIRST | Statement invalidated by RUNSTATS | |
| 48 | Data Element |
DB2QSTIRVK | Statement invalidated by REVOKE | |
| 49 | Data Element |
DB2QSTISTC | Time when statement was inserted into cache | |
| 50 | Data Element |
DB2QSTLR | Cache literal replacement indicator | |
| 51 | Data Element |
DB2QSTPLGP | Number of parallel groups created for statement | |
| 52 | Data Element |
DB2QSTPROW | Rows Processed | |
| 53 | Data Element |
DB2QSTRBUF | Synchronous Reads | |
| 54 | Data Element |
DB2QSTSORT | Number of sorts performed for statement | |
| 55 | Data Element |
DB2QSTSTAT | Status of the statement | |
| 56 | Data Element |
DB2QSTSTLN | The length of the SQL Statement | |
| 57 | Data Element |
DB2QSTSTMT | Statement text | |
| 58 | Data Element |
DB2QSTSTNM | DB2 statement name | |
| 59 | Data Element |
DB2QSTTOKN | Statement ID | |
| 60 | Data Element |
DB2QSTTSCN | Number of tablespace scans performed for statement | |
| 61 | Data Element |
DB2QSTUSE | Current Copies | |
| 62 | Data Element |
DB2QSTWRIT | Synchronous Writes | |
| 63 | Data Element |
DB2QW316CT | Accumulated CPU Time | |
| 64 | Data Element |
DB2QW316L1 | Length of program name | |
| 65 | Data Element |
DB2QW316L3 | Length of user ID | |
| 66 | Data Element |
DB2QW316LX | Statement Line Number | |
| 67 | Data Element |
DB2QW316RS | RID List Not Used due to Insufficient Storage | |
| 68 | Data Element |
DB2QW316RT | RID List Not Used due to DB2 Limits Exceeded | |
| 69 | Data Element |
DB2QW316T1 | Program name | |
| 70 | Data Element |
DB2QW316T1 | Program name | |
| 71 | Data Element |
DB2QW316T2 | Transaction name | |
| 72 | Data Element |
DB2QW316T3 | User ID | |
| 73 | Data Element |
DB2QW316TD | Name of the table referenced in the statement | |
| 74 | Data Element |
DB2QW316TM2 | Time when stmt was inserted into cache - stored clock format | |
| 75 | Data Element |
DB2QW316UT1 | Date/Time when stmt stat was updated -in stored clock format | |
| 76 | Data Element |
DB2QW316UT2 | Date/Time when the stmt stat was updated -in external format | |
| 77 | Data Element |
DB2QW316W1 | Accumulated Wait Time for Synchronous I/O | |
| 78 | Data Element |
DB2QW316W2 | Accumulated Wait Time for Lock and Latch Req. | |
| 79 | Data Element |
DB2QW316W3 | Accumulated Wait Time for Sync. Execution Unit Switch | |
| 80 | Data Element |
DB2QW316W4 | Accumulated Wait Time for Global Locks | |
| 81 | Data Element |
DB2QW316W5 | Accumulated Wait Time for Read Activity by Another Thread | |
| 82 | Data Element |
DB2QW316W6 | Accumulated Wait Time for Write Activity by Another Thread | |
| 83 | Data Element |
DB2QW316W7 | Accumulated wait time for latch req | |
| 84 | Data Element |
DB2QW316W7C | Accumulated wait time for latch req | |
| 85 | Data Element |
DB2QW316W8 | Accumulated wait time for page latch | |
| 86 | Data Element |
DB2QW316W8C | Accumulated wait time for page latch | |
| 87 | Data Element |
DB2QW316W9 | Accumulated wait time for drain lock | |
| 88 | Data Element |
DB2QW316W9C | Accumulated wait time for drain lock | |
| 89 | Data Element |
DB2QW316WA | Acc. wait for drain when waiting for claims to be released | |
| 90 | Data Element |
DB2QW316WAC | Acc. wait for drain when waiting for claims to be released | |
| 91 | Data Element |
DB2QW316WB | Accumulated wait time for logwriter | |
| 92 | Data Element |
DB2QW316WBC | Accumulated wait time for logwriter | |
| 93 | Data Element |
DB2QW316X4 | User group | |
| 94 | Data Element |
DB2QW316X5 | The value of QUALIFIER bind option | |
| 95 | Data Element |
DB2QW316X6 | ISOLATION | |
| 96 | Data Element |
DB2QW316X7 | CURRENTDATA | |
| 97 | Data Element |
DB2QW316X8 | DYNAMICRULES | |
| 98 | Data Element |
DB2QW316X9 | CURRENT DEGREE | |
| 99 | Data Element |
DB2QW316XA | CURRENT RULES | |
| 100 | Data Element |
DB2QW316XB | CURRENT PRECISION | |
| 101 | Data Element |
DB2QW316XC | WITH HOLD | |
| 102 | Data Element |
DB2QW316XE | ENDuser ID - Value provided on RRS (re)signon | |
| 103 | Data Element |
DB2QW316XF | Workstation name - Value provided on RRS (re)signon | |
| 104 | Data Element |
DB2RAETOEXECS | Average elapsed time | |
| 105 | Data Element |
DB2RAETOROWS | Average elapsed time / row | |
| 106 | Data Element |
DB2RETOEXECS | Average rows examined(Only data rows are taken into account) | |
| 107 | Data Element |
DB2RETOPROW | Examined/processed Rows (Only data rows are taken into acc.) | |
| 108 | Data Element |
DB2RIDFAIL | RID list failures | |
| 109 | Data Element |
DB2RPTOEXECS | Average rows processed | |
| 110 | Data Element |
DB2RPTOREX | Ratio: Rows processed to rows examined of statement | |
| 111 | Data Element |
DB2STATTXT | Status | |
| 112 | Data Element |
DB2TIMCPU | CPU time | |
| 113 | Data Element |
DB2TIMEUSW | Wait time for EU switch | |
| 114 | Data Element |
DB2TIMGLLO | Wait time for global lock | |
| 115 | Data Element |
DB2TIMLOLA | Wait time for lock/latch | |
| 116 | Data Element |
DB2TIMOTHE | Other wait time | |
| 117 | Data Element |
DB2TIMREAD | Wait time for other read | |
| 118 | Data Element |
DB2TIMSYIO | Wait time for synchronous I/O | |
| 119 | Data Element |
DB2TIMWAIT | Wait time | |
| 120 | Data Element |
DB2TIMWRIT | Wait time for other write | |
| 121 | Data Element |
DB2W1TOBW | Average duration of a synchronous I/O | |
| 122 | Data Element |
DB2XVGSYIO | Average synchronous I/Os |
