openapi: 3.0.0
info:
  title: SAP API
  version: 1.0.0
servers:
- url: http://localhost:8080
paths:
  /rfc/DB6_PM_BPSNAP:
    post:
      tags:
      - SDB6PMST04
      summary: 'DB6: Calculation of Bufferpool Snapshot Data'
      operationId: /rfc/DB6_PM_BPSNAP
      requestBody:
        content:
          application/json:
            schema:
              properties:
                ACTION:
                  type: integer
                  format: int32
                  description: Layer 1 Action
                CONNECTION:
                  type: string
                  maxLength: 30
                  description: Logical name for a database connection
                PARTITN:
                  type: integer
                  format: int32
                  description: Partition Number
                IT_DB6PMSBP:
                  type: array
                  items:
                    type: object
                    properties:
                      DBMSTRTTME:
                        type: string
                        maxLength: 14
                        description: 'DB6: Timestamp (Format: YYYYMMDDHHMMSS)'
                      COMPTIME:
                        type: string
                        maxLength: 14
                        description: 'DB6: Timestamp (Format: YYYYMMDDHHMMSS)'
                      PARTITN:
                        type: integer
                        format: int32
                        description: Partition Number
                      BP_NAME:
                        type: string
                        maxLength: 20
                        description: 'DB6: General identifier'
                      BUFFPAGE:
                        type: integer
                        format: int64
                        description: Default Buffer Pool Size of DB CFG (4 KB Pages)
                      BP_SZ:
                        type: integer
                        format: int64
                        description: Total Buffer Pool Size (KB)
                      BP_QAL:
                        type: integer
                        format: int64
                        description: Overall Buffer Quality (%)
                      BP_AV_RTM:
                        type: integer
                        format: int64
                        description: Average Physical Read Time (ms)
                      BP_AV_WTM:
                        type: integer
                        format: int64
                        description: Average Physical Write Time (ms)
                      BP_D_HITRT:
                        type: integer
                        format: int64
                        description: Buffer Pool Data Hit Ratio (%)
                      BP_I_HITRT:
                        type: integer
                        format: int64
                        description: Buffer Pool Index Hit Ratio (%)
                      PL_D_LRS:
                        type: integer
                        format: int64
                        description: Data Logical Reads
                      PL_D_PRS:
                        type: integer
                        format: int64
                        description: Data Physical Reads
                      PL_D_WS:
                        type: integer
                        format: int64
                        description: Data Physical Writes
                      BP_D_SPRS:
                        type: integer
                        format: int64
                        description: Data Synchronous Physical Reads
                      BP_D_SWS:
                        type: integer
                        format: int64
                        description: Data Synchronous Physical Writes
                      PL_I_LRS:
                        type: integer
                        format: int64
                        description: Index Logical Reads
                      PL_I_PRS:
                        type: integer
                        format: int64
                        description: Index Physical Reads
                      PL_I_WS:
                        type: integer
                        format: int64
                        description: Index Physical Writes
                      BP_I_SPRS:
                        type: integer
                        format: int64
                        description: Index Synchronous Physical Reads
                      BP_I_SWS:
                        type: integer
                        format: int64
                        description: Index Synchronous Physical Writes
                      PL_RD_TM:
                        type: integer
                        format: int64
                        description: Pool Read Time
                      PL_WT_TM:
                        type: integer
                        format: int64
                        description: Pool Write Time
                      AV_ASP_RTM:
                        type: integer
                        format: int64
                        description: Average Asynchronous Physical Read Time (ms)
                      AV_ASP_WTM:
                        type: integer
                        format: int64
                        description: Average Asynchronous Physical Write Time (ms)
                      PL_A_DRS:
                        type: integer
                        format: int64
                        description: Data Asynchronous Physical Reads
                      PL_A_DWS:
                        type: integer
                        format: int64
                        description: Data Asynchronous Physical Writes
                      PL_A_IRS:
                        type: integer
                        format: int64
                        description: Index Asynchronous Physical Reads
                      PL_A_IWS:
                        type: integer
                        format: int64
                        description: Index Asynchronous Physical Writes
                      PL_A_RTM:
                        type: integer
                        format: int64
                        description: Asynchronous Read Time
                      PL_A_WTM:
                        type: integer
                        format: int64
                        description: Asynchronous Write Time
                      DIRCT_RDS:
                        type: integer
                        format: int64
                        description: Direct Reads
                      DIRCT_WTS:
                        type: integer
                        format: int64
                        description: Direct Writes
                      DIRCT_RTM:
                        type: integer
                        format: int64
                        description: Direct Read Time
                      DIRCT_WTM:
                        type: integer
                        format: int64
                        description: Direct Write Time
                      DIRCT_RRQS:
                        type: integer
                        format: int64
                        description: Direct Read Requests
                      DIRCT_WRQS:
                        type: integer
                        format: int64
                        description: Direct Write Requests
                      AV_DCT_RTM:
                        type: integer
                        format: int64
                        description: Average Direct Read Time
                      AV_DCT_WTM:
                        type: integer
                        format: int64
                        description: Average Direct Write Time
                      AV_DCT_RDS:
                        type: integer
                        format: int64
                        description: Average Direct Reads
                      AV_DCT_WTS:
                        type: integer
                        format: int64
                        description: Average Direct Writes
                      PL_D_TE:
                        type: integer
                        format: int64
                        description: Pool Data to Extended Storage
                      PL_D_FE:
                        type: integer
                        format: int64
                        description: Pool Data from Extended Storage
                      PL_I_TE:
                        type: integer
                        format: int64
                        description: Pool Index to Extended Storage
                      PL_I_FE:
                        type: integer
                        format: int64
                        description: Pool Index from Extended Storage
                      PL_TD_LRS:
                        type: integer
                        format: int64
                        description: pool_temp_data_l_reads
                      PL_TD_PRS:
                        type: integer
                        format: int64
                        description: pool_temp_data_p_reads
                      PL_TI_LRS:
                        type: integer
                        format: int64
                        description: pool_temp_index_l_reads
                      PL_TI_PRS:
                        type: integer
                        format: int64
                        description: pool_temp_index_p_reads
                      PL_A_DRRQ:
                        type: integer
                        format: int64
                        description: pool_async_data_read_reqs
                      PL_A_IRRQ:
                        type: integer
                        format: int64
                        description: pool_async_index_read_reqs
                      CURBUFFSZ:
                        type: integer
                        format: int64
                        description: curent BP size in pages (pagesize depends on buffpool pages)
                      NEWBUFFSZ:
                        type: integer
                        format: int64
                        description: new BP size in pages
                      AUTOSIZE:
                        type: string
                        maxLength: 1
                        description: AUTOMATIC flag
                      PGS_FROM_BLOCKIO:
                        type: integer
                        format: int64
                        description: pages_from_block_ios
                      PGS_FROM_VECTRIO:
                        type: integer
                        format: int64
                        description: pages_from_vectored_ios
                      PHYS_PAGE_MAPS:
                        type: integer
                        format: int64
                        description: physical_page_maps
                      PL_ASYNC_XDA_RD:
                        type: integer
                        format: int64
                        description: pool_async_xda_reads
                      PL_ASYNC_XDA_RRQ:
                        type: integer
                        format: int64
                        description: pool_async_xda_read_reqs
                      PL_ASYNC_XDA_WRT:
                        type: integer
                        format: int64
                        description: pool_aysnc_xda_writes
                      PL_NO_VICTIM_BUF:
                        type: integer
                        format: int64
                        description: pool_no_victim_buffer
                      POOL_XDA_L_READS:
                        type: integer
                        format: int64
                        description: pool_xda_l_reads
                      POOL_XDA_P_READS:
                        type: integer
                        format: int64
                        description: pool_xda_p_reads
                      POOL_XDA_WRITES:
                        type: integer
                        format: int64
                        description: pool_xda_writes
                      PL_TEMP_XDA_L_RD:
                        type: integer
                        format: int64
                        description: pool_temp_xda_l_reads
                      PL_TEMP_XDA_P_RD:
                        type: integer
                        format: int64
                        description: pool_temp_xda_p_reads
                      VECTORED_IOS:
                        type: integer
                        format: int64
                        description: vectored_ios
                      BP_PAGES_LEFT:
                        type: integer
                        format: int64
                        description: bp_pages_left_to_remove
                      BP_TBSP_USE_CNT:
                        type: integer
                        format: int64
                        description: bp_tbsp_use_count
                      PCT_SIZE:
                        type: integer
                        format: int64
                        description: ''
                      PCT_LREADS:
                        type: integer
                        format: int64
                        description: ''
                      PCT_PREADS:
                        type: integer
                        format: int64
                        description: ''
                      PCT_ASYNC_READS:
                        type: integer
                        format: int64
                        description: ''
              required:
              - ACTION
              - PARTITN
      responses:
        '200':
          description: OK
          content:
            application/json:
              schema:
                properties:
                  IT_DB6PMSBP:
                    type: array
                    items:
                      type: object
                      properties:
                        DBMSTRTTME:
                          type: string
                          maxLength: 14
                          description: 'DB6: Timestamp (Format: YYYYMMDDHHMMSS)'
                        COMPTIME:
                          type: string
                          maxLength: 14
                          description: 'DB6: Timestamp (Format: YYYYMMDDHHMMSS)'
                        PARTITN:
                          type: integer
                          format: int32
                          description: Partition Number
                        BP_NAME:
                          type: string
                          maxLength: 20
                          description: 'DB6: General identifier'
                        BUFFPAGE:
                          type: integer
                          format: int64
                          description: Default Buffer Pool Size of DB CFG (4 KB Pages)
                        BP_SZ:
                          type: integer
                          format: int64
                          description: Total Buffer Pool Size (KB)
                        BP_QAL:
                          type: integer
                          format: int64
                          description: Overall Buffer Quality (%)
                        BP_AV_RTM:
                          type: integer
                          format: int64
                          description: Average Physical Read Time (ms)
                        BP_AV_WTM:
                          type: integer
                          format: int64
                          description: Average Physical Write Time (ms)
                        BP_D_HITRT:
                          type: integer
                          format: int64
                          description: Buffer Pool Data Hit Ratio (%)
                        BP_I_HITRT:
                          type: integer
                          format: int64
                          description: Buffer Pool Index Hit Ratio (%)
                        PL_D_LRS:
                          type: integer
                          format: int64
                          description: Data Logical Reads
                        PL_D_PRS:
                          type: integer
                          format: int64
                          description: Data Physical Reads
                        PL_D_WS:
                          type: integer
                          format: int64
                          description: Data Physical Writes
                        BP_D_SPRS:
                          type: integer
                          format: int64
                          description: Data Synchronous Physical Reads
                        BP_D_SWS:
                          type: integer
                          format: int64
                          description: Data Synchronous Physical Writes
                        PL_I_LRS:
                          type: integer
                          format: int64
                          description: Index Logical Reads
                        PL_I_PRS:
                          type: integer
                          format: int64
                          description: Index Physical Reads
                        PL_I_WS:
                          type: integer
                          format: int64
                          description: Index Physical Writes
                        BP_I_SPRS:
                          type: integer
                          format: int64
                          description: Index Synchronous Physical Reads
                        BP_I_SWS:
                          type: integer
                          format: int64
                          description: Index Synchronous Physical Writes
                        PL_RD_TM:
                          type: integer
                          format: int64
                          description: Pool Read Time
                        PL_WT_TM:
                          type: integer
                          format: int64
                          description: Pool Write Time
                        AV_ASP_RTM:
                          type: integer
                          format: int64
                          description: Average Asynchronous Physical Read Time (ms)
                        AV_ASP_WTM:
                          type: integer
                          format: int64
                          description: Average Asynchronous Physical Write Time (ms)
                        PL_A_DRS:
                          type: integer
                          format: int64
                          description: Data Asynchronous Physical Reads
                        PL_A_DWS:
                          type: integer
                          format: int64
                          description: Data Asynchronous Physical Writes
                        PL_A_IRS:
                          type: integer
                          format: int64
                          description: Index Asynchronous Physical Reads
                        PL_A_IWS:
                          type: integer
                          format: int64
                          description: Index Asynchronous Physical Writes
                        PL_A_RTM:
                          type: integer
                          format: int64
                          description: Asynchronous Read Time
                        PL_A_WTM:
                          type: integer
                          format: int64
                          description: Asynchronous Write Time
                        DIRCT_RDS:
                          type: integer
                          format: int64
                          description: Direct Reads
                        DIRCT_WTS:
                          type: integer
                          format: int64
                          description: Direct Writes
                        DIRCT_RTM:
                          type: integer
                          format: int64
                          description: Direct Read Time
                        DIRCT_WTM:
                          type: integer
                          format: int64
                          description: Direct Write Time
                        DIRCT_RRQS:
                          type: integer
                          format: int64
                          description: Direct Read Requests
                        DIRCT_WRQS:
                          type: integer
                          format: int64
                          description: Direct Write Requests
                        AV_DCT_RTM:
                          type: integer
                          format: int64
                          description: Average Direct Read Time
                        AV_DCT_WTM:
                          type: integer
                          format: int64
                          description: Average Direct Write Time
                        AV_DCT_RDS:
                          type: integer
                          format: int64
                          description: Average Direct Reads
                        AV_DCT_WTS:
                          type: integer
                          format: int64
                          description: Average Direct Writes
                        PL_D_TE:
                          type: integer
                          format: int64
                          description: Pool Data to Extended Storage
                        PL_D_FE:
                          type: integer
                          format: int64
                          description: Pool Data from Extended Storage
                        PL_I_TE:
                          type: integer
                          format: int64
                          description: Pool Index to Extended Storage
                        PL_I_FE:
                          type: integer
                          format: int64
                          description: Pool Index from Extended Storage
                        PL_TD_LRS:
                          type: integer
                          format: int64
                          description: pool_temp_data_l_reads
                        PL_TD_PRS:
                          type: integer
                          format: int64
                          description: pool_temp_data_p_reads
                        PL_TI_LRS:
                          type: integer
                          format: int64
                          description: pool_temp_index_l_reads
                        PL_TI_PRS:
                          type: integer
                          format: int64
                          description: pool_temp_index_p_reads
                        PL_A_DRRQ:
                          type: integer
                          format: int64
                          description: pool_async_data_read_reqs
                        PL_A_IRRQ:
                          type: integer
                          format: int64
                          description: pool_async_index_read_reqs
                        CURBUFFSZ:
                          type: integer
                          format: int64
                          description: curent BP size in pages (pagesize depends on buffpool pages)
                        NEWBUFFSZ:
                          type: integer
                          format: int64
                          description: new BP size in pages
                        AUTOSIZE:
                          type: string
                          maxLength: 1
                          description: AUTOMATIC flag
                        PGS_FROM_BLOCKIO:
                          type: integer
                          format: int64
                          description: pages_from_block_ios
                        PGS_FROM_VECTRIO:
                          type: integer
                          format: int64
                          description: pages_from_vectored_ios
                        PHYS_PAGE_MAPS:
                          type: integer
                          format: int64
                          description: physical_page_maps
                        PL_ASYNC_XDA_RD:
                          type: integer
                          format: int64
                          description: pool_async_xda_reads
                        PL_ASYNC_XDA_RRQ:
                          type: integer
                          format: int64
                          description: pool_async_xda_read_reqs
                        PL_ASYNC_XDA_WRT:
                          type: integer
                          format: int64
                          description: pool_aysnc_xda_writes
                        PL_NO_VICTIM_BUF:
                          type: integer
                          format: int64
                          description: pool_no_victim_buffer
                        POOL_XDA_L_READS:
                          type: integer
                          format: int64
                          description: pool_xda_l_reads
                        POOL_XDA_P_READS:
                          type: integer
                          format: int64
                          description: pool_xda_p_reads
                        POOL_XDA_WRITES:
                          type: integer
                          format: int64
                          description: pool_xda_writes
                        PL_TEMP_XDA_L_RD:
                          type: integer
                          format: int64
                          description: pool_temp_xda_l_reads
                        PL_TEMP_XDA_P_RD:
                          type: integer
                          format: int64
                          description: pool_temp_xda_p_reads
                        VECTORED_IOS:
                          type: integer
                          format: int64
                          description: vectored_ios
                        BP_PAGES_LEFT:
                          type: integer
                          format: int64
                          description: bp_pages_left_to_remove
                        BP_TBSP_USE_CNT:
                          type: integer
                          format: int64
                          description: bp_tbsp_use_count
                        PCT_SIZE:
                          type: integer
                          format: int64
                          description: ''
                        PCT_LREADS:
                          type: integer
                          format: int64
                          description: ''
                        PCT_PREADS:
                          type: integer
                          format: int64
                          description: ''
                        PCT_ASYNC_READS:
                          type: integer
                          format: int64
                          description: ''
        '400':
          description: Bad request.
        5XX:
          description: Unexpected error.
