SAP ABAP Table DB2TIMEGC (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
⤷ STU2 (Package) CCMS for DB2 for OS/390
⤷ BC-DB-DB2 (Application Component) DB2 for z/OS
⤷ STU2 (Package) CCMS for DB2 for OS/390
Basic Data
Table Category | INTTAB | Structure |
Structure | DB2TIMEGC | 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 |
History
Last changed by/on | SAP | 20070813 |
SAP Release Created in | 710 |