SAP ABAP Table DB2TIMEG (DB2 for OS/390 Times over all Threads)
Hierarchy
☛
SAP_BASIS (Software Component) SAP Basis Component
⤷
BC-DB-DB2 (Application Component) DB2 for z/OS
⤷
STU3 (Package) Development Class for Database Monitor
SAP_BASIS (Software Component) SAP Basis Component⤷
BC-DB-DB2 (Application Component) DB2 for z/OS⤷
STU3 (Package) Development Class for Database Monitor
Basic Data
| Table Category | INTTAB | Structure |
| Structure | DB2TIMEG |
Table Relationship Diagram 
|
| Short Description | DB2 for OS/390 Times over all Threads |
Delivery and Maintenance
| Pool/cluster | ||
| Delivery Class | ||
| Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
 |
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|---|---|---|---|---|---|---|---|---|---|
| 1 |  POUDB2 |
DB2POUDB2 | DB2CHAR10 | CHAR | 10 | 0 | Time spent out of DB2 / Activity time (%) | ||
| 2 | PINDB2 |
DB2PINDB2 | DB2CHAR10 | CHAR | 10 | 0 | Time spent in DB2 / Activity time (%) | ||
| 3 | PCPUIN |
DB2PCPUIN | DB2CHAR10 | CHAR | 10 | 0 | CPU time spent in DB2 / Time spent in DB2 (%) | ||
| 4 | PSUSPIN |
DB2PSUSPIN | DB2CHAR10 | CHAR | 10 | 0 | Time spent suspended in DB2 / Time spent in DB2 (%) | ||
| 5 | PNAINDB |
DB2PNAINDB | DB2CHAR10 | CHAR | 10 | 0 | Not attributed time in DB2 / Time spent in DB2 | ||
| 6 | PIO |
DB2PIO | DB2CHAR10 | CHAR | 10 | 0 | I/O suspension time / Time spent in DB2 (%) | ||
| 7 | PLKLA |
DB2PLKLA | DB2CHAR10 | CHAR | 10 | 0 | Lock (Latch) supension time / Time spent in DB2 (%) | ||
| 8 | POTHR |
DB2POTHR | DB2CHAR10 | CHAR | 10 | 0 | Other read suspensions time / Time spent in db2 (%) | ||
| 9 | POTHW |
DB2POTHW | DB2CHAR10 | CHAR | 10 | 0 | Other write suspensions time / Time spent in DB2 (%) | ||
| 10 | PSRVT |
DB2PSRVT | DB2CHAR10 | CHAR | 10 | 0 | Time commit phase 2 or abort / Time spent in DB2 (%) | ||
| 11 | POCST |
DB2POCST | DB2CHAR10 | CHAR | 10 | 0 | Time for open/close ST / time spent in DB2 (%) | ||
| 12 | PSLST |
DB2PSLST | DB2CHAR10 | CHAR | 10 | 0 | Time SYSLGRNG recording service task / time spent in DB2 (%) | ||
| 13 | PDSST |
DB2PDSST | DB2CHAR10 | CHAR | 10 | 0 | Time dataset service task / time spent in DB2 (%) | ||
| 14 | POTHRST |
DB2POTHRST | DB2CHAR10 | CHAR | 10 | 0 | Time for other service task / time spent in DB2 (%) | ||
| 15 | PARCHQ |
DB2PARCHQ | DB2CHAR10 | CHAR | 10 | 0 | Archive log quiesce suspension time / time spent in DB2 (%) | ||
| 16 | PDRLK |
DB2PDRLK | DB2CHAR10 | CHAR | 10 | 0 | Drain lock suspension time / Time spent in DB2 (%) | ||
| 17 | PCLREL |
DB2PCLREL | DB2CHAR10 | CHAR | 10 | 0 | Claim release suspension time / Time spent in DB2 (%) | ||
| 18 | PARCHR |
DB2PARCHR | DB2CHAR10 | CHAR | 10 | 0 | Archive read suspension time / Time spent in DB2 (%) | ||
| 19 | PPGLA |
DB2PPGLA | DB2CHAR10 | CHAR | 10 | 0 | Page latch suspension time / Time spent in DB2 (%) | ||
| 20 | PNOTM |
DB2PNOTM | DB2CHAR10 | CHAR | 10 | 0 | Notify messages suspension time / Time spent in DB2 (%) | ||
| 21 | PGLOBTM |
DB2PGLOBTM | DB2CHAR10 | CHAR | 10 | 0 | Global locking suspension time / Time spent in DB2 (%) | ||
| 22 | PIOA |
DB2TIOA | DB2CHAR10 | CHAR | 10 | 0 | Average duration of I/O suspension | ||
| 23 | PLKLAA |
DB2TLKLAA | DB2CHAR10 | CHAR | 10 | 0 | Average duration of lock/latch supensions | ||
| 24 | POTHRA |
DB2TOTHRA | DB2CHAR10 | CHAR | 10 | 0 | Average duration of other read suspensions | ||
| 25 | POTHWA |
DB2TOTHWA | DB2CHAR10 | CHAR | 10 | 0 | Average duration of other write suspensions | ||
| 26 | PSRVTA |
DB2TSRVTA | DB2CHAR10 | CHAR | 10 | 0 | Average waiting time for commit phase II or abort | ||
| 27 | POCSTA |
DB2TOCSTA | DB2CHAR10 | CHAR | 10 | 0 | Average waiting time for open/close service task | ||
| 28 | PSLSTA |
DB2TSLSTA | DB2CHAR10 | CHAR | 10 | 0 | Average waiting time for SYSLGRNG recording service task | ||
| 29 | PDSSTA |
DB2TDSSTA | DB2CHAR10 | CHAR | 10 | 0 | Average waiting time for dataset ext./del./def. service task | ||
| 30 | POTHRSTA |
DB2TOTHRSA | DB2CHAR10 | CHAR | 10 | 0 | Average waiting time for other service tasks | ||
| 31 | PARCHQA |
DB2TARCHQA | DB2CHAR10 | CHAR | 10 | 0 | Average duration of ARCHIVE LOG QUIESCE suspensions | ||
| 32 | PDRLKEA |
DB2TDRLKA | DB2CHAR10 | CHAR | 10 | 0 | Average duration of drain lock suspensions | ||
| 33 | PCLRELA |
DB2TCLRELA | DB2CHAR10 | CHAR | 10 | 0 | Average duration of claim release suspensions | ||
| 34 | PARCHRA |
DB2TARCHRA | DB2CHAR10 | CHAR | 10 | 0 | Average duration of archive read suspensions | ||
| 35 | PPGLAA |
DB2TPGLAA | DB2CHAR10 | CHAR | 10 | 0 | Average duration of page latch suspensions | ||
| 36 | PNOTMA |
DB2TNOTMA | DB2CHAR10 | CHAR | 10 | 0 | Average duration of notify messages suspensions | ||
| 37 | PGLOBTA |
DB2TGLOBTA | DB2CHAR10 | CHAR | 10 | 0 | Average duration of global locking suspensions | ||
| 38 | PLOGWRIT |
DB2PLOGWR | DB2CHAR10 | CHAR | 10 | 0 | Percent of time spent in DB2 for log write I/O | ||
| 39 | PSTOPROC |
DB2STOPRO | DB2CHAR10 | CHAR | 10 | 0 | Stored procedures | ||
| 40 | PUSEDEFF |
DB2USDEFF | DB2CHAR10 | CHAR | 10 | 0 | User defined functions | ||
| 41 | PLOGWRITA |
DB2LOGWRA | DB2CHAR10 | CHAR | 10 | 0 | Average duration of a suspension for log write I/O | ||
| 42 | PSTOPROCA |
DB2STOPRA | DB2CHAR10 | CHAR | 10 | 0 | Average duration: stored procedures | ||
| 43 | PARCLOGR |
CHAR | 10 | 0 | |||||
| 44 | PARCLOGRA |
CHAR | 10 | 0 | |||||
| 45 | ZIIP2DB2T |
CHAR | 10 | 0 | |||||
| 46 | ZIIPEL2DB2T |
CHAR | 10 | 0 |
History
| Last changed by/on | SAP | 20070813 |
| SAP Release Created in |
