SAP ABAP Table DB4WAITSTS (Wait Statistics for DB2 UDB for iSeries)
Hierarchy
☛
SAP_BASIS (Software Component) SAP Basis Component
⤷
BC-DB-DB4 (Application Component) DB2 for AS/400
⤷
STU4 (Package) CCMS / AS/400
SAP_BASIS (Software Component) SAP Basis Component⤷
BC-DB-DB4 (Application Component) DB2 for AS/400⤷
STU4 (Package) CCMS / AS/400
Basic Data
| Table Category | INTTAB | Structure |
| Structure | DB4WAITSTS |
Table Relationship Diagram 
|
| Short Description | Wait Statistics for DB2 UDB for iSeries |
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 |  WDB |
WDB_SUM | INT4 | INT4 | 10 | 0 | Cumulative number of process waits for database locks | ||
| 2 | WNDB |
WNDB_SUM | INT4 | INT4 | 10 | 0 | Cumulative number of process waits for non-database locks | ||
| 3 | WIM |
WIM_SUM | INT4 | INT4 | 10 | 0 | Cumulative no. of process waits for internal machine locks | ||
| 4 | WDBT |
WDBT_SUM | DEC150_DB4 | DEC | 15 | 0 | Total cumulative time spent on DB lock waits (all processes) | ||
| 5 | WNDBT |
WNDBT_SUM | DEC150_DB4 | DEC | 15 | 0 | Total cumulative time spent on non-database lock waits | ||
| 6 | WIMT |
WIMT_SUM | DEC150_DB4 | DEC | 15 | 0 | Total cumulative time spent on internal machine waits | ||
| 7 | WDBT_AVG |
WDBT_S_AVG | DEC154_DB4 | DEC | 15 | 4 | Average of total cumulative database lock wait time | ||
| 8 | WNDBT_AVG |
WNDBT_S_AG | DEC154_DB4 | DEC | 15 | 4 | Average of total cumulative non-database lock wait time | ||
| 9 | WIMT_AVG |
WIMT_S_AVG | DEC154_DB4 | DEC | 15 | 4 | Average of total cumulative internal machine lock wait time |
History
| Last changed by/on | SAP | 20070813 |
| SAP Release Created in |
