openapi: 3.0.0 info: title: SAP API version: 1.0.0 servers: - url: http://localhost:8080 paths: /rfc/DB4_GET_HISTORY_STATISTICS: post: tags: - STU4_ST04 summary: 'AS/400: Get the history-data for several values.' operationId: /rfc/DB4_GET_HISTORY_STATISTICS requestBody: content: application/json: schema: properties: DAY: type: string format: date description: The date for which the data shall returned WEEK_FLAG: type: string maxLength: 1 description: (=X, The statistic for a whole week will returne DUMP_LOG_BOOK: type: array items: type: object properties: HIS_DATE: type: string format: date description: 'iSeries: Date of DB monitor history dump ocurrence' DUMP_CNT: type: integer format: int32 description: 'iSeries: Number of available DB monitor history dumps' WEEK_FLAG: type: string maxLength: 1 description: 'iSeries: Flag to determine if weekly info is available' DUMP_STATISTIC: type: array items: type: object properties: QQDMPTIME: type: string maxLength: 26 description: 'iSeries: Timestamp of Database Monitor Dump' QQSUMCNT: type: integer format: int64 description: 'iSeries: Number of Executed SQL Statements' QQCOMCNT: type: integer format: int64 description: 'iSeries: No. of Executed COMMITs (Database Monitor)' QQRBKCNT: type: integer format: int64 description: 'iSeries: Number of Executed ROLLBACKs (Database Monitor)' QQSELCNT: type: integer format: int64 description: 'iSeries: Number of Executed SELECTs (Database Monitor)' QQINSCNT: type: integer format: int64 description: 'iSeries: Number of Executed INSERTs (Database Monitor)' QQUPDCNT: type: integer format: int64 description: 'iSeries: Number of Executed UPDATEs (Database Monitor)' QQDELCNT: type: integer format: int64 description: 'iSeries: Number of Executed DELETEs (Database Monitor)' QQDDLCNT: type: integer format: int64 description: 'iSeries: Number of Executed DDL Statements' QQOTHCNT: type: integer format: int64 description: 'iSeries: Number of Miscellaneous Statements' QQTSCCNT: type: integer format: int64 description: 'iSeries: Number of Table Scans' QQTSCTOTR: type: integer format: int64 description: 'iSeries: Total Rows Read by Table Scans' QQTSCTTIME: type: integer format: int64 description: 'iSeries: Total Time Used by Table Scans' QQSRTCNT: type: integer format: int64 description: 'iSeries: Number of Sorts (Database Monitor)' QQSRTTOTR: type: integer format: int64 description: 'iSeries: Total Rows Sorted (Database Monitor)' QQSRTTTIME: type: integer format: int64 description: 'iSeries: Total Time Used by Sorts (Database Monitor)' QQIDCCNT: type: integer format: int64 description: 'iSeries: Number of Index Creates (Database Monitor)' QQIDCTTIME: type: integer format: int64 description: 'iSeries: Total Time Used by Index Creates (Database Monitor)' QQTMFCNT: type: integer format: int64 description: 'iSeries: Number of Temporary Files Created' QQTMFTTIME: type: integer format: int64 description: 'iSeries: Total Time Used by Temp. File Creates' QQIDACNT: type: integer format: int64 description: 'iSeries: Index Advice (Database Monitor)' QQIDATBCNT: type: integer format: int64 description: 'iSeries: Number of Tables over which Indexes are Advised' QQIDAQRYCT: type: integer format: int64 description: 'iSeries: Number of Index Advices (Database Monitor)' QQODFTIME: type: string maxLength: 26 description: 'iSeries: Timestamp of Oldest Data (Database Monitor)' QQTOTAVGT: type: integer format: int64 description: 'iSeries: Overall Average Execution Time (Database Monitor)' QQTOTTIME: type: integer format: int64 description: 'iSeries: Total Database Processing Time (Database Monitor)' PHYSREAD: type: integer format: int64 description: 'iSeries: Number of Physical Reads' LOGICREAD: type: integer format: int64 description: 'iSeries: Number of Logical Reads' QUALITY: type: integer format: int64 description: 'iSeries: Hit Ratio' READPCALL: type: integer format: int64 description: 'iSeries: Number of Logical Reads per User Call' TIMEPCALL: type: integer format: int64 description: 'iSeries: Database Processing Time per User Call' DUMP_STATISTIC_SUM: type: array items: type: object properties: QQDMPTIME: type: string maxLength: 26 description: 'iSeries: Timestamp of Database Monitor Dump' QQSUMCNT: type: integer format: int64 description: 'iSeries: Number of Executed SQL Statements' QQCOMCNT: type: integer format: int64 description: 'iSeries: No. of Executed COMMITs (Database Monitor)' QQRBKCNT: type: integer format: int64 description: 'iSeries: Number of Executed ROLLBACKs (Database Monitor)' QQSELCNT: type: integer format: int64 description: 'iSeries: Number of Executed SELECTs (Database Monitor)' QQINSCNT: type: integer format: int64 description: 'iSeries: Number of Executed INSERTs (Database Monitor)' QQUPDCNT: type: integer format: int64 description: 'iSeries: Number of Executed UPDATEs (Database Monitor)' QQDELCNT: type: integer format: int64 description: 'iSeries: Number of Executed DELETEs (Database Monitor)' QQDDLCNT: type: integer format: int64 description: 'iSeries: Number of Executed DDL Statements' QQOTHCNT: type: integer format: int64 description: 'iSeries: Number of Miscellaneous Statements' QQTSCCNT: type: integer format: int64 description: 'iSeries: Number of Table Scans' QQTSCTOTR: type: integer format: int64 description: 'iSeries: Total Rows Read by Table Scans' QQTSCTTIME: type: integer format: int64 description: 'iSeries: Total Time Used by Table Scans' QQSRTCNT: type: integer format: int64 description: 'iSeries: Number of Sorts (Database Monitor)' QQSRTTOTR: type: integer format: int64 description: 'iSeries: Total Rows Sorted (Database Monitor)' QQSRTTTIME: type: integer format: int64 description: 'iSeries: Total Time Used by Sorts (Database Monitor)' QQIDCCNT: type: integer format: int64 description: 'iSeries: Number of Index Creates (Database Monitor)' QQIDCTTIME: type: integer format: int64 description: 'iSeries: Total Time Used by Index Creates (Database Monitor)' QQTMFCNT: type: integer format: int64 description: 'iSeries: Number of Temporary Files Created' QQTMFTTIME: type: integer format: int64 description: 'iSeries: Total Time Used by Temp. File Creates' QQIDACNT: type: integer format: int64 description: 'iSeries: Index Advice (Database Monitor)' QQIDATBCNT: type: integer format: int64 description: 'iSeries: Number of Tables over which Indexes are Advised' QQIDAQRYCT: type: integer format: int64 description: 'iSeries: Number of Index Advices (Database Monitor)' QQODFTIME: type: string maxLength: 26 description: 'iSeries: Timestamp of Oldest Data (Database Monitor)' QQTOTAVGT: type: integer format: int64 description: 'iSeries: Overall Average Execution Time (Database Monitor)' QQTOTTIME: type: integer format: int64 description: 'iSeries: Total Database Processing Time (Database Monitor)' PHYSREAD: type: integer format: int64 description: 'iSeries: Number of Physical Reads' LOGICREAD: type: integer format: int64 description: 'iSeries: Number of Logical Reads' QUALITY: type: integer format: int64 description: 'iSeries: Hit Ratio' READPCALL: type: integer format: int64 description: 'iSeries: Number of Logical Reads per User Call' TIMEPCALL: type: integer format: int64 description: 'iSeries: Database Processing Time per User Call' required: - DAY responses: '200': description: OK content: application/json: schema: properties: DUMP_LOG_BOOK: type: array items: type: object properties: HIS_DATE: type: string format: date description: 'iSeries: Date of DB monitor history dump ocurrence' DUMP_CNT: type: integer format: int32 description: 'iSeries: Number of available DB monitor history dumps' WEEK_FLAG: type: string maxLength: 1 description: 'iSeries: Flag to determine if weekly info is available' DUMP_STATISTIC: type: array items: type: object properties: QQDMPTIME: type: string maxLength: 26 description: 'iSeries: Timestamp of Database Monitor Dump' QQSUMCNT: type: integer format: int64 description: 'iSeries: Number of Executed SQL Statements' QQCOMCNT: type: integer format: int64 description: 'iSeries: No. of Executed COMMITs (Database Monitor)' QQRBKCNT: type: integer format: int64 description: 'iSeries: Number of Executed ROLLBACKs (Database Monitor)' QQSELCNT: type: integer format: int64 description: 'iSeries: Number of Executed SELECTs (Database Monitor)' QQINSCNT: type: integer format: int64 description: 'iSeries: Number of Executed INSERTs (Database Monitor)' QQUPDCNT: type: integer format: int64 description: 'iSeries: Number of Executed UPDATEs (Database Monitor)' QQDELCNT: type: integer format: int64 description: 'iSeries: Number of Executed DELETEs (Database Monitor)' QQDDLCNT: type: integer format: int64 description: 'iSeries: Number of Executed DDL Statements' QQOTHCNT: type: integer format: int64 description: 'iSeries: Number of Miscellaneous Statements' QQTSCCNT: type: integer format: int64 description: 'iSeries: Number of Table Scans' QQTSCTOTR: type: integer format: int64 description: 'iSeries: Total Rows Read by Table Scans' QQTSCTTIME: type: integer format: int64 description: 'iSeries: Total Time Used by Table Scans' QQSRTCNT: type: integer format: int64 description: 'iSeries: Number of Sorts (Database Monitor)' QQSRTTOTR: type: integer format: int64 description: 'iSeries: Total Rows Sorted (Database Monitor)' QQSRTTTIME: type: integer format: int64 description: 'iSeries: Total Time Used by Sorts (Database Monitor)' QQIDCCNT: type: integer format: int64 description: 'iSeries: Number of Index Creates (Database Monitor)' QQIDCTTIME: type: integer format: int64 description: 'iSeries: Total Time Used by Index Creates (Database Monitor)' QQTMFCNT: type: integer format: int64 description: 'iSeries: Number of Temporary Files Created' QQTMFTTIME: type: integer format: int64 description: 'iSeries: Total Time Used by Temp. File Creates' QQIDACNT: type: integer format: int64 description: 'iSeries: Index Advice (Database Monitor)' QQIDATBCNT: type: integer format: int64 description: 'iSeries: Number of Tables over which Indexes are Advised' QQIDAQRYCT: type: integer format: int64 description: 'iSeries: Number of Index Advices (Database Monitor)' QQODFTIME: type: string maxLength: 26 description: 'iSeries: Timestamp of Oldest Data (Database Monitor)' QQTOTAVGT: type: integer format: int64 description: 'iSeries: Overall Average Execution Time (Database Monitor)' QQTOTTIME: type: integer format: int64 description: 'iSeries: Total Database Processing Time (Database Monitor)' PHYSREAD: type: integer format: int64 description: 'iSeries: Number of Physical Reads' LOGICREAD: type: integer format: int64 description: 'iSeries: Number of Logical Reads' QUALITY: type: integer format: int64 description: 'iSeries: Hit Ratio' READPCALL: type: integer format: int64 description: 'iSeries: Number of Logical Reads per User Call' TIMEPCALL: type: integer format: int64 description: 'iSeries: Database Processing Time per User Call' DUMP_STATISTIC_SUM: type: array items: type: object properties: QQDMPTIME: type: string maxLength: 26 description: 'iSeries: Timestamp of Database Monitor Dump' QQSUMCNT: type: integer format: int64 description: 'iSeries: Number of Executed SQL Statements' QQCOMCNT: type: integer format: int64 description: 'iSeries: No. of Executed COMMITs (Database Monitor)' QQRBKCNT: type: integer format: int64 description: 'iSeries: Number of Executed ROLLBACKs (Database Monitor)' QQSELCNT: type: integer format: int64 description: 'iSeries: Number of Executed SELECTs (Database Monitor)' QQINSCNT: type: integer format: int64 description: 'iSeries: Number of Executed INSERTs (Database Monitor)' QQUPDCNT: type: integer format: int64 description: 'iSeries: Number of Executed UPDATEs (Database Monitor)' QQDELCNT: type: integer format: int64 description: 'iSeries: Number of Executed DELETEs (Database Monitor)' QQDDLCNT: type: integer format: int64 description: 'iSeries: Number of Executed DDL Statements' QQOTHCNT: type: integer format: int64 description: 'iSeries: Number of Miscellaneous Statements' QQTSCCNT: type: integer format: int64 description: 'iSeries: Number of Table Scans' QQTSCTOTR: type: integer format: int64 description: 'iSeries: Total Rows Read by Table Scans' QQTSCTTIME: type: integer format: int64 description: 'iSeries: Total Time Used by Table Scans' QQSRTCNT: type: integer format: int64 description: 'iSeries: Number of Sorts (Database Monitor)' QQSRTTOTR: type: integer format: int64 description: 'iSeries: Total Rows Sorted (Database Monitor)' QQSRTTTIME: type: integer format: int64 description: 'iSeries: Total Time Used by Sorts (Database Monitor)' QQIDCCNT: type: integer format: int64 description: 'iSeries: Number of Index Creates (Database Monitor)' QQIDCTTIME: type: integer format: int64 description: 'iSeries: Total Time Used by Index Creates (Database Monitor)' QQTMFCNT: type: integer format: int64 description: 'iSeries: Number of Temporary Files Created' QQTMFTTIME: type: integer format: int64 description: 'iSeries: Total Time Used by Temp. File Creates' QQIDACNT: type: integer format: int64 description: 'iSeries: Index Advice (Database Monitor)' QQIDATBCNT: type: integer format: int64 description: 'iSeries: Number of Tables over which Indexes are Advised' QQIDAQRYCT: type: integer format: int64 description: 'iSeries: Number of Index Advices (Database Monitor)' QQODFTIME: type: string maxLength: 26 description: 'iSeries: Timestamp of Oldest Data (Database Monitor)' QQTOTAVGT: type: integer format: int64 description: 'iSeries: Overall Average Execution Time (Database Monitor)' QQTOTTIME: type: integer format: int64 description: 'iSeries: Total Database Processing Time (Database Monitor)' PHYSREAD: type: integer format: int64 description: 'iSeries: Number of Physical Reads' LOGICREAD: type: integer format: int64 description: 'iSeries: Number of Logical Reads' QUALITY: type: integer format: int64 description: 'iSeries: Hit Ratio' READPCALL: type: integer format: int64 description: 'iSeries: Number of Logical Reads per User Call' TIMEPCALL: type: integer format: int64 description: 'iSeries: Database Processing Time per User Call' '400': description: Bad request. 5XX: description: Unexpected error.