Table/Structure Field list used by SAP ABAP Function Module DB4_GET_WAIT_STATISTICS (AS/400: Get Wait Statistics for all App.Servers and their DB jobs)
SAP ABAP Function Module 
DB4_GET_WAIT_STATISTICS (AS/400: Get Wait Statistics for all App.Servers and their DB jobs) is using
-
Class (2)
-
Data Element (2)
-
Table/Structure Field (48)
-
Function Module (1)
-
Class Method (2)
-
Table (11)
| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
 |
|
|||
| 1 | Table/Structure Field |
DB4DBJOBS - PID | iSeries: Process ID of a Work Process | |
| 2 | Table/Structure Field |
DB4WAITSTS - WDB | Cumulative number of process waits for database locks | |
| 3 | Table/Structure Field |
DB4WAITSTS - WNDBT_AVG | Average of total cumulative non-database lock wait time | |
| 4 | Table/Structure Field |
DB4WAITSTS - WNDBT | Total cumulative time spent on non-database lock waits | |
| 5 | Table/Structure Field |
DB4WAITSTS - WNDB | Cumulative number of process waits for non-database locks | |
| 6 | Table/Structure Field |
DB4WAITSTS - WIMT_AVG | Average of total cumulative internal machine lock wait time | |
| 7 | Table/Structure Field |
DB4WAITSTS - WIMT | Total cumulative time spent on internal machine waits | |
| 8 | Table/Structure Field |
DB4WAITSTS - WIM | Cumulative no. of process waits for internal machine locks | |
| 9 | Table/Structure Field |
DB4WAITSTS - WDBT_AVG | Average of total cumulative database lock wait time | |
| 10 | Table/Structure Field |
DB4WAITSTS - WDBT | Total cumulative time spent on DB lock waits (all processes) | SOURCE VALUE(SUM_WAIT_TIMES) LIKE DB4WTSTS_S-WDBT |
| 11 | Table/Structure Field |
DB4WAITSTS - WDBT | Total cumulative time spent on DB lock waits (all processes) | |
| 12 | Table/Structure Field |
DB4WAITSTS - WDB | Cumulative number of process waits for database locks | SOURCE VALUE(SUM_WAITS) LIKE DB4WTSTS_S-WDB |
| 13 | Table/Structure Field |
DB4WTSTS_I - WDB | Cumulative number of process waits for database locks | |
| 14 | Table/Structure Field |
DB4WTSTS_I - WNDBT_AVG | Average of total cumulative non-database lock wait time | |
| 15 | Table/Structure Field |
DB4WTSTS_I - WNDBT | Total cumulative time spent on non-database lock waits | |
| 16 | Table/Structure Field |
DB4WTSTS_I - WNDB | Cumulative number of process waits for non-database locks | |
| 17 | Table/Structure Field |
DB4WTSTS_I - WIMT_AVG | Average of total cumulative internal machine lock wait time | |
| 18 | Table/Structure Field |
DB4WTSTS_I - WIMT | Total cumulative time spent on internal machine waits | |
| 19 | Table/Structure Field |
DB4WTSTS_I - WIM | Cumulative no. of process waits for internal machine locks | |
| 20 | Table/Structure Field |
DB4WTSTS_I - WDBT_AVG | Average of total cumulative database lock wait time | |
| 21 | Table/Structure Field |
DB4WTSTS_I - WDBT | Total cumulative time spent on DB lock waits (all processes) | |
| 22 | Table/Structure Field |
DB4WTSTS_I - INSTANCE | Server Name | |
| 23 | Table/Structure Field |
DB4WTSTS_P - WDBT | Cumulative time (millisec.) spent on database lock waits | |
| 24 | Table/Structure Field |
DB4WTSTS_P - WNDBT_AVG | Average process non-database lock wait time (ms) | |
| 25 | Table/Structure Field |
DB4WTSTS_P - WNDBT | Cumulative time (millisec.) spent on non-DB lock waits | |
| 26 | Table/Structure Field |
DB4WTSTS_P - WNDB | Number of times a process had to wait to obtain a nonDB lock | |
| 27 | Table/Structure Field |
DB4WTSTS_P - WIMT_AVG | Average process internal machine lock wait time (ms) | |
| 28 | Table/Structure Field |
DB4WTSTS_P - WIM | No. of times a process had to wait to obtain an IM lock | |
| 29 | Table/Structure Field |
DB4WTSTS_P - WDBT_AVG | Average process database lock wait time (ms) | |
| 30 | Table/Structure Field |
DB4WTSTS_P - WDB | Number of times a process had to wait to obtain a DB lock | |
| 31 | Table/Structure Field |
DB4WTSTS_P - INSTANCE_P | Server Name | |
| 32 | Table/Structure Field |
DB4WTSTS_P - WIMT | Cumulative time (millisec.) spent on internal machine waits | |
| 33 | Table/Structure Field |
DB4WTSTS_S - WDBT_AVG | Average of total cumulative database lock wait time | |
| 34 | Table/Structure Field |
DB4WTSTS_S - WNDBT_AVG | Average of total cumulative non-database lock wait time | |
| 35 | Table/Structure Field |
DB4WTSTS_S - WNDBT | Total cumulative time spent on non-database lock waits | |
| 36 | Table/Structure Field |
DB4WTSTS_S - WNDB | Cumulative number of process waits for non-database locks | |
| 37 | Table/Structure Field |
DB4WTSTS_S - WIMT_AVG | Average of total cumulative internal machine lock wait time | |
| 38 | Table/Structure Field |
DB4WTSTS_S - WIMT | Total cumulative time spent on internal machine waits | |
| 39 | Table/Structure Field |
DB4WTSTS_S - WIM | Cumulative no. of process waits for internal machine locks | |
| 40 | Table/Structure Field |
DB4WTSTS_S - WDBT | Total cumulative time spent on DB lock waits (all processes) | SOURCE VALUE(SUM_WAIT_TIMES) LIKE DB4WTSTS_S-WDBT |
| 41 | Table/Structure Field |
DB4WTSTS_S - WDBT | Total cumulative time spent on DB lock waits (all processes) | |
| 42 | Table/Structure Field |
DB4WTSTS_S - WDB | Cumulative number of process waits for database locks | SOURCE VALUE(SUM_WAITS) LIKE DB4WTSTS_S-WDB |
| 43 | Table/Structure Field |
DB4WTSTS_S - WDB | Cumulative number of process waits for database locks | |
| 44 | Table/Structure Field |
DB4WTSTS_S - NAME | Char 20 | |
| 45 | Table/Structure Field |
DB4_JOBSTS - PID | iSeries: Process ID of a Work Process | |
| 46 | Table/Structure Field |
MSXXLIST - NAME | Application Server Instance | |
| 47 | Table/Structure Field |
SYST - DATUM | ABAP System Field: Current Date of Application Server | |
| 48 | Table/Structure Field |
SYST - UZEIT | ABAP System Field: Current Time of Application Server |
