openapi: 3.0.0 info: title: SAP API version: 1.0.0 servers: - url: http://localhost:8080 paths: /rfc/DB4_GET_WAIT_STATISTICS: post: tags: - STU4_ST04 summary: 'AS/400: Get Wait Statistics for all App.Servers and their DB jobs' operationId: /rfc/DB4_GET_WAIT_STATISTICS requestBody: content: application/json: schema: properties: WAITSTS_PER_INSTANCE_TAB: type: array items: type: object properties: INSTANCE: type: string maxLength: 20 description: Server Name WDB: type: integer format: int32 description: Cumulative number of process waits for database locks WNDB: type: integer format: int32 description: Cumulative number of process waits for non-database locks WIM: type: integer format: int32 description: Cumulative no. of process waits for internal machine locks WDBT: type: integer format: int64 description: Total cumulative time spent on DB lock waits (all processes) WNDBT: type: integer format: int64 description: Total cumulative time spent on non-database lock waits WIMT: type: integer format: int64 description: Total cumulative time spent on internal machine waits WDBT_AVG: type: integer format: int64 description: Average of total cumulative database lock wait time WNDBT_AVG: type: integer format: int64 description: Average of total cumulative non-database lock wait time WIMT_AVG: type: integer format: int64 description: Average of total cumulative internal machine lock wait time WAITSTS_PER_PROCESS_TAB: type: array items: type: object properties: INSTANCE_P: type: string maxLength: 20 description: Server Name PID: type: string maxLength: 8 description: Process Identification JOBNUM: type: string maxLength: 6 description: 'iSeries: Job Number (Database Monitor)' WDB: type: integer format: int32 description: Number of times a process had to wait to obtain a DB lock WNDB: type: integer format: int32 description: Number of times a process had to wait to obtain a nonDB lock WIM: type: integer format: int32 description: No. of times a process had to wait to obtain an IM lock WDBT: type: integer format: int32 description: Cumulative time (millisec.) spent on database lock waits WNDBT: type: integer format: int32 description: Cumulative time (millisec.) spent on non-DB lock waits WIMT: type: integer format: int32 description: Cumulative time (millisec.) spent on internal machine waits WDBT_AVG: type: integer format: int64 description: Average process database lock wait time (ms) WNDBT_AVG: type: integer format: int64 description: Average process non-database lock wait time (ms) WIMT_AVG: type: integer format: int64 description: Average process internal machine lock wait time (ms) responses: '200': description: OK content: application/json: schema: properties: API_RC: type: integer format: int32 description: Error code from API call DATE: type: string format: date description: Date of wait statistic analysis SUM_WAITS: type: integer format: int32 description: Sum of waits (db + non-db + int.machine) SUM_WAIT_TIMES: type: integer format: int64 description: Sum of wait times (db + non-db + int.machine) TIME: type: string maxLength: 6 description: Time of wait statistic analysis WAIT_STATS_SUMMARY: type: object properties: NAME: type: string maxLength: 20 description: Char 20 WDB: type: integer format: int32 description: Cumulative number of process waits for database locks WNDB: type: integer format: int32 description: Cumulative number of process waits for non-database locks WIM: type: integer format: int32 description: Cumulative no. of process waits for internal machine locks WDBT: type: integer format: int64 description: Total cumulative time spent on DB lock waits (all processes) WNDBT: type: integer format: int64 description: Total cumulative time spent on non-database lock waits WIMT: type: integer format: int64 description: Total cumulative time spent on internal machine waits WDBT_AVG: type: integer format: int64 description: Average of total cumulative database lock wait time WNDBT_AVG: type: integer format: int64 description: Average of total cumulative non-database lock wait time WIMT_AVG: type: integer format: int64 description: Average of total cumulative internal machine lock wait time WAITSTS_PER_INSTANCE_TAB: type: array items: type: object properties: INSTANCE: type: string maxLength: 20 description: Server Name WDB: type: integer format: int32 description: Cumulative number of process waits for database locks WNDB: type: integer format: int32 description: Cumulative number of process waits for non-database locks WIM: type: integer format: int32 description: Cumulative no. of process waits for internal machine locks WDBT: type: integer format: int64 description: Total cumulative time spent on DB lock waits (all processes) WNDBT: type: integer format: int64 description: Total cumulative time spent on non-database lock waits WIMT: type: integer format: int64 description: Total cumulative time spent on internal machine waits WDBT_AVG: type: integer format: int64 description: Average of total cumulative database lock wait time WNDBT_AVG: type: integer format: int64 description: Average of total cumulative non-database lock wait time WIMT_AVG: type: integer format: int64 description: Average of total cumulative internal machine lock wait time WAITSTS_PER_PROCESS_TAB: type: array items: type: object properties: INSTANCE_P: type: string maxLength: 20 description: Server Name PID: type: string maxLength: 8 description: Process Identification JOBNUM: type: string maxLength: 6 description: 'iSeries: Job Number (Database Monitor)' WDB: type: integer format: int32 description: Number of times a process had to wait to obtain a DB lock WNDB: type: integer format: int32 description: Number of times a process had to wait to obtain a nonDB lock WIM: type: integer format: int32 description: No. of times a process had to wait to obtain an IM lock WDBT: type: integer format: int32 description: Cumulative time (millisec.) spent on database lock waits WNDBT: type: integer format: int32 description: Cumulative time (millisec.) spent on non-DB lock waits WIMT: type: integer format: int32 description: Cumulative time (millisec.) spent on internal machine waits WDBT_AVG: type: integer format: int64 description: Average process database lock wait time (ms) WNDBT_AVG: type: integer format: int64 description: Average process non-database lock wait time (ms) WIMT_AVG: type: integer format: int64 description: Average process internal machine lock wait time (ms) '400': description: Bad request. 5XX: description: Unexpected error.