Data Element list used by SAP ABAP Table DB2TIMESC1 (DB2 Times)
SAP ABAP Table
DB2TIMESC1 (DB2 Times) is using
| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
| 1 | DB2INDB2 | Percentage of time spent in DB2 | ||
| 2 | DB2NAIDB2 | Time not attributed in DB2 / Time spent in DB2 (%) | ||
| 3 | DB2OUTDB2 | Time spent out of DB2 | ||
| 4 | DB2POUTDB2 | Time spent out of DB2 / Activity time (%) | ||
| 5 | DB2PROCDB2 | Percentage of time spent processing in DB2 | ||
| 6 | DB2PTCPU | Total CPU time / Activity time | ||
| 7 | DB2SUSPDB2 | Time spent suspended in DB2 / Time spent in DB2 (%) | ||
| 8 | DB2TABRTC | Number of rollback requests | ||
| 9 | DB2TARCHQ | Archive log quiesce suspension time | ||
| 10 | DB2TARCHQA | Average duration of ARCHIVE LOG QUIESCE suspensions | ||
| 11 | DB2TARCHQC | Number of archive log quiesce suspensions | ||
| 12 | DB2TARCHR | Archive read suspension time | ||
| 13 | DB2TARCHRA | Average duration of archive read suspensions | ||
| 14 | DB2TARCHRC | Number of Archive Read Suspensions | ||
| 15 | DB2TCLREL | Claim release suspension time | ||
| 16 | DB2TCLRELA | Average duration of claim release suspensions | ||
| 17 | DB2TCLRELC | Number of Claim Release Suspensions | ||
| 18 | DB2TCOMMC | Number of successful phase 2 or single-phase commit requests | ||
| 19 | DB2TCPUIN | CPU time spent in DB2 | ||
| 20 | DB2TCPUTOT | Total CPU time on System z including DB2 | ||
| 21 | DB2TDRLK | Drain lock suspension time | ||
| 22 | DB2TDRLKA | Average duration of drain lock suspensions | ||
| 23 | DB2TDRLKEC | Number of Drain Lock Suspensions | ||
| 24 | DB2TDSST | Wait time for data set extend/delete/define service task | ||
| 25 | DB2TDSSTA | Average waiting time for dataset ext./del./def. service task | ||
| 26 | DB2TDSSTEC | Number of waits for data set ext./del./def. service task | ||
| 27 | DB2TGLOBTA | Average duration of global locking suspensions | ||
| 28 | DB2TGLOBTC | Number of Global Locking Suspensions | ||
| 29 | DB2TGLOBTM | Global locking suspension time | ||
| 30 | DB2THDTACT | Activity time (Class 1 elapsed time) | ||
| 31 | DB2TINDB2 | Accumulated elapsed time in DB2 | ||
| 32 | DB2TIO | I/O suspension time | ||
| 33 | DB2TIOA | Average duration of I/O suspension | ||
| 34 | DB2TIOEC | Number of I/O suspensions | ||
| 35 | DB2TLKLA | Lock/latch supension time | ||
| 36 | DB2TLKLAA | Average duration of lock/latch supensions | ||
| 37 | DB2TLKLAEC | Number of Lock / Latch Suspensions | ||
| 38 | DB2TNAINDB | Not attributed time in DB2 | ||
| 39 | DB2TNOTM | Notify messages suspension time | ||
| 40 | DB2TNOTMA | Average duration of notify messages suspensions | ||
| 41 | DB2TNOTMEC | Number of Notify Messages Suspensions | ||
| 42 | DB2TOCST | Wait time for open/close service task (incl. HSM recall) | ||
| 43 | DB2TOCSTA | Average waiting time for open/close service task | ||
| 44 | DB2TOCSTEC | Number of waits for open/close service task | ||
| 45 | DB2TOTHR | Other read suspensions time | ||
| 46 | DB2TOTHRA | Average duration of other read suspensions | ||
| 47 | DB2TOTHREC | Number of other read suspensions | ||
| 48 | DB2TOTHRSA | Average waiting time for other service tasks | ||
| 49 | DB2TOTHRSC | Number of waits for other service tasks | ||
| 50 | DB2TOTHRST | Wait time for other service tasks | ||
| 51 | DB2TOTHW | Other write suspensions time | ||
| 52 | DB2TOTHWA | Average duration of other write suspensions | ||
| 53 | DB2TOTHWEC | Number of other write suspensions | ||
| 54 | DB2TPGLA | Page latch suspension time | ||
| 55 | DB2TPGLAA | Average duration of page latch suspensions | ||
| 56 | DB2TPGLAEC | Number of Page Latch Suspensions | ||
| 57 | DB2TSLST | Wait time for SYSLGRNG recording service task | ||
| 58 | DB2TSLSTA | Average waiting time for SYSLGRNG recording service task | ||
| 59 | DB2TSLSTEC | Number of waits for SYSLGRNG recording service task | ||
| 60 | DB2TSRVT | Wait time for DB2 commit phase II processing | ||
| 61 | DB2TSRVTA | Average waiting time for commit phase II or abort | ||
| 62 | DB2TSRVTEC | Number of waits for commit phase II or abort | ||
| 63 | DB2TSUSPIN | Time spent suspended in DB2 |