Data Element list used by SAP ABAP Table DB2QSTCC (Structure for Statement Trace)
SAP ABAP Table 
DB2QSTCC (Structure for Statement Trace) is using
| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
 |
|
|||
| 1 |  Data Element |
DB2AETOEXE | Average elapsed time | |
| 2 | Data Element |
DB2AVGCPU | Average CPU time | |
| 3 | Data Element |
DB2AVGEUSW | Average wait for EU switch | |
| 4 | Data Element |
DB2AVGGLLO | Average wait for global lock | |
| 5 | Data Element |
DB2AVGLOLA | Average wait for lock/latch | |
| 6 | Data Element |
DB2AVGOTHE | Average other wait time | |
| 7 | Data Element |
DB2AVGREAD | Average wait for other read | |
| 8 | Data Element |
DB2AVGSIOW | Average synchronous I/O time | |
| 9 | Data Element |
DB2AVGSYIO | Average synchronous I/Os | |
| 10 | Data Element |
DB2AVGWAIT | Average wait time | |
| 11 | Data Element |
DB2AVGWRIT | Average wait for other write | |
| 12 | Data Element |
DB2EXESEC | Average executions per second | |
| 13 | Data Element |
DB2GPRPROC | Getpages per rows processed | |
| 14 | Data Element |
DB2NGTONP | Getpages per rows processed | |
| 15 | Data Element |
DB2NRTONP | Examined/rows processed (Only data rows are taken into acc.) | |
| 16 | Data Element |
DB2Q316CCT | Accumulated CPU Time | |
| 17 | Data Element |
DB2Q316CLX | Statement Line Number | |
| 18 | Data Element |
DB2Q316CLX | Statement Line Number | |
| 19 | Data Element |
DB2Q316CRS | RID List Not Used due to Insufficient Storage | |
| 20 | Data Element |
DB2Q316CRT | RID List Not Used due to DB2 Limits Exceeded | |
| 21 | Data Element |
DB2QSTAETC | Time elapsed | |
| 22 | Data Element |
DB2QSTCCOP | Number of copies of the statement | |
| 23 | Data Element |
DB2QSTCERO | Rows Examined | |
| 24 | Data Element |
DB2QSTCEXE | Number of executions of the statement | |
| 25 | Data Element |
DB2QSTCGPA | Getpages | |
| 26 | Data Element |
DB2QSTCIND | Number of index scans performed for statement | |
| 27 | Data Element |
DB2QSTCLRU | Statement removed from cache by LRU (last recently used) | |
| 28 | Data Element |
DB2QSTCPLG | Number of parallel groups created for statement | |
| 29 | Data Element |
DB2QSTCPRO | Rows Processed | |
| 30 | Data Element |
DB2QSTCRBU | Synchronous Reads | |
| 31 | Data Element |
DB2QSTCSOR | Number of sorts performed for statement | |
| 32 | Data Element |
DB2QSTCSTN | DB2 statement name | |
| 33 | Data Element |
DB2QSTCTOK | Statement ID | |
| 34 | Data Element |
DB2QSTCTSC | Number of tablespace scans performed for statement | |
| 35 | Data Element |
DB2QSTCUSE | Current Copies | |
| 36 | Data Element |
DB2QSTCWRI | Synchronous Writes | |
| 37 | Data Element |
DB2QSTIDDL | Statement invalidated by DROP or ALTER | |
| 38 | Data Element |
DB2QSTIRST | Statement invalidated by RUNSTATS | |
| 39 | Data Element |
DB2QSTIRVK | Statement invalidated by REVOKE | |
| 40 | Data Element |
DB2QSTISTC | Time when statement was inserted into cache | |
| 41 | Data Element |
DB2QSTSTAT | Status of the statement | |
| 42 | Data Element |
DB2QSTSTLN | The length of the SQL Statement | |
| 43 | Data Element |
DB2QSTSTMT | Statement text | |
| 44 | Data Element |
DB2QW316L1 | Length of program name | |
| 45 | Data Element |
DB2QW316L2 | Length of transaction name | |
| 46 | Data Element |
DB2QW316L3 | Length of user ID | |
| 47 | Data Element |
DB2QW316T1 | Program name | |
| 48 | Data Element |
DB2QW316T1 | Program name | |
| 49 | Data Element |
DB2QW316T2 | Transaction name | |
| 50 | Data Element |
DB2QW316T3 | User ID | |
| 51 | Data Element |
DB2QW316TD | Name of the table referenced in the statement | |
| 52 | Data Element |
DB2QW316TS | Timestamp: Begin of Statistics Collection | |
| 53 | Data Element |
DB2QW316W7C | Accumulated wait time for latch req | |
| 54 | Data Element |
DB2QW316W8C | Accumulated wait time for page latch | |
| 55 | Data Element |
DB2QW316W9C | Accumulated wait time for drain lock | |
| 56 | Data Element |
DB2QW316WAC | Acc. wait for drain when waiting for claims to be released | |
| 57 | Data Element |
DB2QW316WBC | Accumulated wait time for logwriter | |
| 58 | Data Element |
DB2QW316X4 | User group | |
| 59 | Data Element |
DB2QW316X5 | The value of QUALIFIER bind option | |
| 60 | Data Element |
DB2QW316X6 | ISOLATION | |
| 61 | Data Element |
DB2QW316X7 | CURRENTDATA | |
| 62 | Data Element |
DB2QW316X8 | DYNAMICRULES | |
| 63 | Data Element |
DB2QW316X9 | CURRENT DEGREE | |
| 64 | Data Element |
DB2QW316XA | CURRENT RULES | |
| 65 | Data Element |
DB2QW316XB | CURRENT PRECISION | |
| 66 | Data Element |
DB2QW316XC | WITH HOLD | |
| 67 | Data Element |
DB2QW31W1C | Accumulated Wait Time for Synchronous I/O | |
| 68 | Data Element |
DB2QW31W2C | Accumulated Wait Time for Lock and Latch Req. | |
| 69 | Data Element |
DB2QW31W3C | Accumulated Wait Time for Sync. Execution Unit Switch | |
| 70 | Data Element |
DB2QW31W4C | Accumulated Wait Time for Global Locks | |
| 71 | Data Element |
DB2QW31W5C | Accumulated Wait Time for Read Activity by Another Thread | |
| 72 | Data Element |
DB2QW31W6C | Accumulated Wait Time for Write Activity by Another Thread | |
| 73 | Data Element |
DB2RETOEXE | Average rows examined(Only data rows are taken into account) | |
| 74 | Data Element |
DB2RETOPRW | Examined/Processed Rows (Only data rows are taken into acc.) | |
| 75 | Data Element |
DB2RIDFAIL | RID list failures | |
| 76 | Data Element |
DB2RNBTONE | Average synchronous reads | |
| 77 | Data Element |
DB2RNGTONE | Average getpages | |
| 78 | Data Element |
DB2RNITONE | Average index scans | |
| 79 | Data Element |
DB2RNLTONE | Average parallel groups | |
| 80 | Data Element |
DB2RNSTONE | Average sorts | |
| 81 | Data Element |
DB2RNTTONE | Average tablespace scans | |
| 82 | Data Element |
DB2RNWTONE | Average synchronous writes | |
| 83 | Data Element |
DB2RPTOEXE | Average rows processed | |
| 84 | Data Element |
DB2RPTOREX | Ratio: Rows processed to rows examined of statement | |
| 85 | Data Element |
DB2RRSTONE | Average RID failures - no storage | |
| 86 | Data Element |
DB2RRTTONE | Average RID failures - limit | |
| 87 | Data Element |
DB2STATTXT | Status | |
| 88 | Data Element |
DB2THCTIM | DB2 Thread times | |
| 89 | Data Element |
DB2THCTIM | DB2 Thread times | |
| 90 | Data Element |
DB2TIMCPU | CPU time | |
| 91 | Data Element |
DB2TIMEUSW | Wait time for EU switch | |
| 92 | Data Element |
DB2TIMGLLO | Wait time for global lock | |
| 93 | Data Element |
DB2TIMLOLA | Wait time for lock/latch | |
| 94 | Data Element |
DB2TIMOTHE | Other wait time | |
| 95 | Data Element |
DB2TIMREAD | Wait time for other read | |
| 96 | Data Element |
DB2TIMSYIO | Wait time for synchronous I/O | |
| 97 | Data Element |
DB2TIMWAIT | Wait time | |
| 98 | Data Element |
DB2TIMWRIT | Wait time for other write | |
| 99 | Data Element |
DB2W1TOBW | Average duration of a synchronous I/O |
