Data Element list used by SAP ABAP Table DB2TIMES (DB2 Times)
SAP ABAP Table 
DB2TIMES (DB2 Times) is using
| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
 |
|
|||
| 1 |  Data Element |
DB2ARCHQP | Percent of time spent in DB2 for ARCHIVE LOG QUIESCE command | |
| 2 | Data Element |
DB2ARCHRP | Percent of time spent in DB2 for archive log read | |
| 3 | Data Element |
DB2CASTA | Average of stored procedures | |
| 4 | Data Element |
DB2CASTE | Number of stored procedures | |
| 5 | Data Element |
DB2CASTP | Percent of time spent in DB2 for stored procedures | |
| 6 | Data Element |
DB2CLRELP | Percent of time spent in DB2 for claim locks | |
| 7 | Data Element |
DB2DRLKP | Percent of time spent in DB2 for drain locks | |
| 8 | Data Element |
DB2DSSTP | Percent of time spent in DB2 for dataspace manager service | |
| 9 | Data Element |
DB2GLOBTP | Percent of time spent in DB2 for global locks | |
| 10 | Data Element |
DB2IFAETP | Elapsed IFI time to total DB2 time in percent | |
| 11 | Data Element |
DB2IFAETT | Accumulated elapsed time spent processing IFI calls | |
| 12 | Data Element |
DB2IFATTP | Processing (CPU) times to total DB2 activity time in percent | |
| 13 | Data Element |
DB2IFATTT | Accumulated CPU time spent processing IFI calls | |
| 14 | Data Element |
DB2INDB2 | Percentage of time spent in DB2 | |
| 15 | Data Element |
DB2LKLAP | Percent of time spent in DB2 for locks and latches | |
| 16 | Data Element |
DB2LOGW | Log writes suspension time | |
| 17 | Data Element |
DB2LOGW | Log writes suspension time | |
| 18 | Data Element |
DB2LOGWA | Average log writes | |
| 19 | Data Element |
DB2LOGWE | Number of log writes | |
| 20 | Data Element |
DB2LOGWE | Number of log writes | |
| 21 | Data Element |
DB2LOGWP | Percent of time spent in DB2 for log writes | |
| 22 | Data Element |
DB2NAIDB2 | Time not attributed in DB2 / Time spent in DB2 (%) | |
| 23 | Data Element |
DB2NOTMP | Percent of time spent in DB2 for notify messages | |
| 24 | Data Element |
DB2OCSTP | Percent of time spent in DB2 for open ,close, HSM recall | |
| 25 | Data Element |
DB2OTHRP | Percent of time spent in DB2 for other agents' read | |
| 26 | Data Element |
DB2OTHRSP | Percent time in DB2 for other synchronous EU switch services | |
| 27 | Data Element |
DB2OTHWP | Percent of time spend in DB2 for other agents' writes | |
| 28 | Data Element |
DB2OUTDB2 | Time spent out of DB2 | |
| 29 | Data Element |
DB2PECDT | Accumulated CPU time user for DB2 | |
| 30 | Data Element |
DB2PECTT | Accumulated TCB time used before enclave is created | |
| 31 | Data Element |
DB2PGLAP | Percent of time spent in DB2 for page latches | |
| 32 | Data Element |
DB2POUTDB2 | Time spent out of DB2 / Activity time (%) | |
| 33 | Data Element |
DB2PROCDB2 | Percentage of time spent processing in DB2 | |
| 34 | Data Element |
DB2PTCPU | Total CPU time / Activity time | |
| 35 | Data Element |
DB2SLSTP | Percent of time spent in DB2 for SYSLGRNX recording | |
| 36 | Data Element |
DB2SRVTP | Percent of time in DB2 for commit, abort, deallocate | |
| 37 | Data Element |
DB2SUSPDB2 | Time spent suspended in DB2 / Time spent in DB2 (%) | |
| 38 | Data Element |
DB2TABRT | Number of rollback requests | |
| 39 | Data Element |
DB2TARCHQ | Archive log quiesce suspension time | |
| 40 | Data Element |
DB2TARCHQA | Average duration of ARCHIVE LOG QUIESCE suspensions | |
| 41 | Data Element |
DB2TARCHQE | Number of ARCHIVE LOG QUIESCE suspensions | |
| 42 | Data Element |
DB2TARCHR | Archive read suspension time | |
| 43 | Data Element |
DB2TARCHRA | Average duration of archive read suspensions | |
| 44 | Data Element |
DB2TARCHRE | Number of archive read suspensions | |
| 45 | Data Element |
DB2TCLREL | Claim release suspension time | |
| 46 | Data Element |
DB2TCLRELA | Average duration of claim release suspensions | |
| 47 | Data Element |
DB2TCLRELE | Number of claim release suspensions | |
| 48 | Data Element |
DB2TCOMM | Number of successful phase 2 or single-phase commit requests | |
| 49 | Data Element |
DB2TCPUIN | CPU time spent in DB2 | |
| 50 | Data Element |
DB2TCPUTOT | Total CPU time on System z including DB2 | |
| 51 | Data Element |
DB2TDRLK | Drain lock suspension time | |
| 52 | Data Element |
DB2TDRLKA | Average duration of drain lock suspensions | |
| 53 | Data Element |
DB2TDRLKE | Number of drain lock suspensions | |
| 54 | Data Element |
DB2TDSST | Wait time for data set extend/delete/define service task | |
| 55 | Data Element |
DB2TDSSTA | Average waiting time for dataset ext./del./def. service task | |
| 56 | Data Element |
DB2TDSSTE | Number of waits for data set ext./del./def. service task | |
| 57 | Data Element |
DB2TEEDASC | DB2 entry/exit duration elapsed time | |
| 58 | Data Element |
DB2TEEDJST | DB2 entry/exit duration processing (CPU) | |
| 59 | Data Element |
DB2TEEDPEB | Stored procedure entry/exit duration elapsed time | |
| 60 | Data Element |
DB2TEEDPTT | Stored procedure entry/exit duration processing (CPU) | |
| 61 | Data Element |
DB2TGLOBTA | Average duration of global locking suspensions | |
| 62 | Data Element |
DB2TGLOBTE | Number of global locking suspensions | |
| 63 | Data Element |
DB2TGLOBTM | Global locking suspension time | |
| 64 | Data Element |
DB2THDTACT | Activity time (Class 1 elapsed time) | |
| 65 | Data Element |
DB2TIFIELT | IFI entry/exit duration elapsed time | |
| 66 | Data Element |
DB2TIFIPRT | IFI entry/exit duration processing (CPU) | |
| 67 | Data Element |
DB2TINDB2 | Accumulated elapsed time in DB2 | |
| 68 | Data Element |
DB2TIO | I/O suspension time | |
| 69 | Data Element |
DB2TIOA | Average duration of I/O suspension | |
| 70 | Data Element |
DB2TIOE | Number of I/O suspensions | |
| 71 | Data Element |
DB2TIOP | Percent of time in DB2 for synchronous reads and writes | |
| 72 | Data Element |
DB2TLKLA | Lock/latch supension time | |
| 73 | Data Element |
DB2TLKLAA | Average duration of lock/latch supensions | |
| 74 | Data Element |
DB2TLKLAE | Number of Lock / Latch Suspensions | |
| 75 | Data Element |
DB2TNAINDB | Not attributed time in DB2 | |
| 76 | Data Element |
DB2TNOTM | Notify messages suspension time | |
| 77 | Data Element |
DB2TNOTMA | Average duration of notify messages suspensions | |
| 78 | Data Element |
DB2TNOTME | Number of notify messages suspensions | |
| 79 | Data Element |
DB2TOCST | Wait time for open/close service task (incl. HSM recall) | |
| 80 | Data Element |
DB2TOCSTA | Average waiting time for open/close service task | |
| 81 | Data Element |
DB2TOCSTE | Number of waits for open/close service task | |
| 82 | Data Element |
DB2TOTHR | Other read suspensions time | |
| 83 | Data Element |
DB2TOTHRA | Average duration of other read suspensions | |
| 84 | Data Element |
DB2TOTHRE | Number of other read suspensions | |
| 85 | Data Element |
DB2TOTHRSA | Average waiting time for other service tasks | |
| 86 | Data Element |
DB2TOTHRSE | Number of waits for other service tasks | |
| 87 | Data Element |
DB2TOTHRST | Wait time for other service tasks | |
| 88 | Data Element |
DB2TOTHW | Other write suspensions time | |
| 89 | Data Element |
DB2TOTHWA | Average duration of other write suspensions | |
| 90 | Data Element |
DB2TOTHWE | Number of other write suspensions | |
| 91 | Data Element |
DB2TPGLA | Page latch suspension time | |
| 92 | Data Element |
DB2TPGLAA | Average duration of page latch suspensions | |
| 93 | Data Element |
DB2TPGLAE | Number of page latch suspensions | |
| 94 | Data Element |
DB2TREET | Accumulated elapsed time used for executing triggers | |
| 95 | Data Element |
DB2TRETT | Accumulated elapsed time used while executing | |
| 96 | Data Element |
DB2TRTET | Accumulated TCB time used for executing triggers | |
| 97 | Data Element |
DB2TRTTT | Accumulated TCB time used while executing | |
| 98 | Data Element |
DB2TSLST | Wait time for SYSLGRNG recording service task | |
| 99 | Data Element |
DB2TSLSTA | Average waiting time for SYSLGRNG recording service task | |
| 100 | Data Element |
DB2TSLSTE | Number of waits for SYSLGRNG recording service task | |
| 101 | Data Element |
DB2TSPCPT | Accumulated TCB time spent | |
| 102 | Data Element |
DB2TSPE | Total elapsed time spent executing SQL in stored procedures | |
| 103 | Data Element |
DB2TSPEAT | Total elapsed time spent in stored procedures | |
| 104 | Data Element |
DB2TSPET | Total elapsed time spent executing SQL in stored procedures | |
| 105 | Data Element |
DB2TSPP | Accumulated TCB time spend in DB2 by stored procedures | |
| 106 | Data Element |
DB2TSPPT | Accumulated TCB time spend in DB2 by stored procedures | |
| 107 | Data Element |
DB2TSRVT | Wait time for DB2 commit phase II processing | |
| 108 | Data Element |
DB2TSRVTA | Average waiting time for commit phase II or abort | |
| 109 | Data Element |
DB2TSRVTE | Number of waits for commit phase II or abort | |
| 110 | Data Element |
DB2TSUSPIN | Time spent suspended in DB2 | |
| 111 | Data Element |
DB2TUDCPT | Accumulated TCB time for user-defined function | |
| 112 | Data Element |
DB2TUDEAT | Total elapsed time spent in user-defined functions | |
| 113 | Data Element |
DB2TUDEBT | Total elapsed time spent for user-defined function | |
| 114 | Data Element |
DB2TUDEP | Elapsed time in percent for user-defined function | |
| 115 | Data Element |
DB2TUDPP | Processing (CPU) for user-defined function | |
| 116 | Data Element |
DB2TUDTTT | Accumulated TCB time in DB2 issued by user-defined functions | |
| 117 | Data Element |
DB2UDFDEB | UDF entry/exit duration elapsed time | |
| 118 | Data Element |
DB2UDFDTT | UDF entry/exit duration processing (CPU) | |
| 119 | Data Element |
DB2UDSTE | Number of user defined function | |
| 120 | Data Element |
DB2UDSTP | Percent of time spent in DB2 for user defined functions | |
| 121 | Data Element |
THDTCAST | Stored procedures suspension time | |
| 122 | Data Element |
THDTUDST | User defined functions suspension time |
