Data Element list used by SAP ABAP Table DB2TIMEG (DB2 for OS/390 Times over all Threads)
SAP ABAP Table
DB2TIMEG (DB2 for OS/390 Times over all Threads) is using
| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
| 1 | DB2LOGWRA | Average duration of a suspension for log write I/O | ||
| 2 | DB2PARCHQ | Archive log quiesce suspension time / time spent in DB2 (%) | ||
| 3 | DB2PARCHR | Archive read suspension time / Time spent in DB2 (%) | ||
| 4 | DB2PCLREL | Claim release suspension time / Time spent in DB2 (%) | ||
| 5 | DB2PCPUIN | CPU time spent in DB2 / Time spent in DB2 (%) | ||
| 6 | DB2PDRLK | Drain lock suspension time / Time spent in DB2 (%) | ||
| 7 | DB2PDSST | Time dataset service task / time spent in DB2 (%) | ||
| 8 | DB2PGLOBTM | Global locking suspension time / Time spent in DB2 (%) | ||
| 9 | DB2PINDB2 | Time spent in DB2 / Activity time (%) | ||
| 10 | DB2PIO | I/O suspension time / Time spent in DB2 (%) | ||
| 11 | DB2PLKLA | Lock (Latch) supension time / Time spent in DB2 (%) | ||
| 12 | DB2PLOGWR | Percent of time spent in DB2 for log write I/O | ||
| 13 | DB2PNAINDB | Not attributed time in DB2 / Time spent in DB2 | ||
| 14 | DB2PNOTM | Notify messages suspension time / Time spent in DB2 (%) | ||
| 15 | DB2POCST | Time for open/close ST / time spent in DB2 (%) | ||
| 16 | DB2POTHR | Other read suspensions time / Time spent in db2 (%) | ||
| 17 | DB2POTHRST | Time for other service task / time spent in DB2 (%) | ||
| 18 | DB2POTHW | Other write suspensions time / Time spent in DB2 (%) | ||
| 19 | DB2POUDB2 | Time spent out of DB2 / Activity time (%) | ||
| 20 | DB2PPGLA | Page latch suspension time / Time spent in DB2 (%) | ||
| 21 | DB2PSLST | Time SYSLGRNG recording service task / time spent in DB2 (%) | ||
| 22 | DB2PSRVT | Time commit phase 2 or abort / Time spent in DB2 (%) | ||
| 23 | DB2PSUSPIN | Time spent suspended in DB2 / Time spent in DB2 (%) | ||
| 24 | DB2STOPRA | Average duration: stored procedures | ||
| 25 | DB2STOPRO | Stored procedures | ||
| 26 | DB2TARCHQA | Average duration of ARCHIVE LOG QUIESCE suspensions | ||
| 27 | DB2TARCHRA | Average duration of archive read suspensions | ||
| 28 | DB2TCLRELA | Average duration of claim release suspensions | ||
| 29 | DB2TDRLKA | Average duration of drain lock suspensions | ||
| 30 | DB2TDSSTA | Average waiting time for dataset ext./del./def. service task | ||
| 31 | DB2TGLOBTA | Average duration of global locking suspensions | ||
| 32 | DB2TIOA | Average duration of I/O suspension | ||
| 33 | DB2TLKLAA | Average duration of lock/latch supensions | ||
| 34 | DB2TNOTMA | Average duration of notify messages suspensions | ||
| 35 | DB2TOCSTA | Average waiting time for open/close service task | ||
| 36 | DB2TOTHRA | Average duration of other read suspensions | ||
| 37 | DB2TOTHRSA | Average waiting time for other service tasks | ||
| 38 | DB2TOTHWA | Average duration of other write suspensions | ||
| 39 | DB2TPGLAA | Average duration of page latch suspensions | ||
| 40 | DB2TSLSTA | Average waiting time for SYSLGRNG recording service task | ||
| 41 | DB2TSRVTA | Average waiting time for commit phase II or abort | ||
| 42 | DB2USDEFF | User defined functions |