Table/Structure Field list used by SAP ABAP Program RSDB4007 (iSeries: Display Wait Statistics by SAP Instance)
SAP ABAP Program
RSDB4007 (iSeries: Display Wait Statistics by SAP Instance) is using
| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
| 1 | DB4WAITSTS - WDBT | Total cumulative time spent on DB lock waits (all processes) | ||
| 2 | DB4WAITSTS - WDBT_AVG | Average of total cumulative database lock wait time | ||
| 3 | DB4WAITSTS - WIM | Cumulative no. of process waits for internal machine locks | ||
| 4 | DB4WAITSTS - WIMT | Total cumulative time spent on internal machine waits | ||
| 5 | DB4WAITSTS - WIMT_AVG | Average of total cumulative internal machine lock wait time | ||
| 6 | DB4WAITSTS - WNDB | Cumulative number of process waits for non-database locks | ||
| 7 | DB4WAITSTS - WNDBT | Total cumulative time spent on non-database lock waits | ||
| 8 | DB4WAITSTS - WNDBT_AVG | Average of total cumulative non-database lock wait time | ||
| 9 | DB4WAITSTS - WDB | Cumulative number of process waits for database locks | ||
| 10 | DB4WTSTS_I - WDBT_AVG | Average of total cumulative database lock wait time | ||
| 11 | DB4WTSTS_I - WNDBT_AVG | Average of total cumulative non-database lock wait time | ||
| 12 | DB4WTSTS_I - WNDBT | Total cumulative time spent on non-database lock waits | ||
| 13 | DB4WTSTS_I - WNDB | Cumulative number of process waits for non-database locks | ||
| 14 | DB4WTSTS_I - WIMT_AVG | Average of total cumulative internal machine lock wait time | ||
| 15 | DB4WTSTS_I - WIMT | Total cumulative time spent on internal machine waits | ||
| 16 | DB4WTSTS_I - WIM | Cumulative no. of process waits for internal machine locks | ||
| 17 | DB4WTSTS_I - WDBT | Total cumulative time spent on DB lock waits (all processes) | ||
| 18 | DB4WTSTS_I - WDB | Cumulative number of process waits for database locks | ||
| 19 | DB4WTSTS_I - INSTANCE | Server Name | ||
| 20 | DB4WTSTS_P - WNDB | Number of times a process had to wait to obtain a nonDB lock | ||
| 21 | DB4WTSTS_P - WNDBT_AVG | Average process non-database lock wait time (ms) | ||
| 22 | DB4WTSTS_P - WNDBT | Cumulative time (millisec.) spent on non-DB lock waits | ||
| 23 | DB4WTSTS_P - WIMT_AVG | Average process internal machine lock wait time (ms) | ||
| 24 | DB4WTSTS_P - WIMT | Cumulative time (millisec.) spent on internal machine waits | ||
| 25 | DB4WTSTS_P - WIM | No. of times a process had to wait to obtain an IM lock | ||
| 26 | DB4WTSTS_P - WDBT | Cumulative time (millisec.) spent on database lock waits | ||
| 27 | DB4WTSTS_P - WDB | Number of times a process had to wait to obtain a DB lock | ||
| 28 | DB4WTSTS_P - PID | Process Identification | ||
| 29 | DB4WTSTS_P - JOBNUM | iSeries: Job Number (Database Monitor) | ||
| 30 | DB4WTSTS_P - INSTANCE_P | Server Name | ||
| 31 | DB4WTSTS_P - WDBT_AVG | Average process database lock wait time (ms) | ||
| 32 | DB4WTSTS_S - WNDBT_AVG | Average of total cumulative non-database lock wait time | ||
| 33 | DB4WTSTS_S - WNDBT | Total cumulative time spent on non-database lock waits | ||
| 34 | DB4WTSTS_S - WNDB | Cumulative number of process waits for non-database locks | ||
| 35 | DB4WTSTS_S - WIMT_AVG | Average of total cumulative internal machine lock wait time | ||
| 36 | DB4WTSTS_S - WIMT | Total cumulative time spent on internal machine waits | ||
| 37 | DB4WTSTS_S - WDBT_AVG | Average of total cumulative database lock wait time | ||
| 38 | DB4WTSTS_S - WDBT | Total cumulative time spent on DB lock waits (all processes) | ||
| 39 | DB4WTSTS_S - WDB | Cumulative number of process waits for database locks | ||
| 40 | DB4WTSTS_S - NAME | Char 20 | ||
| 41 | DB4WTSTS_S - WIM | Cumulative no. of process waits for internal machine locks | ||
| 42 | MSXXLIST - NAME | Application Server Instance | ||
| 43 | SYST - VLINE | ABAP System Field: Vertical Line for List | ||
| 44 | SYST - UZEIT | ABAP System Field: Current Time of Application Server | ||
| 45 | SYST - UCOMM | ABAP System Field: PAI-Triggering Function Code | ||
| 46 | SYST - PFKEY | ABAP System Field: Current GUI Status | ||
| 47 | SYST - MSGV4 | ABAP System Field: Message Variable | ||
| 48 | SYST - MSGV3 | ABAP System Field: Message Variable | ||
| 49 | SYST - MSGV2 | ABAP System Field: Message Variable | ||
| 50 | SYST - MSGV1 | ABAP System Field: Message Variable | ||
| 51 | SYST - MSGTY | ABAP System Field: Message Type | ||
| 52 | SYST - MSGNO | ABAP System Field: Message Number | ||
| 53 | SYST - MSGID | ABAP System Field: Message ID | ||
| 54 | SYST - LSIND | ABAP System Field: Current List Level | ||
| 55 | SYST - DBSYS | ABAP System Field: Central Database System | ||
| 56 | SYST - DATUM | ABAP System Field: Current Date of Application Server |