openapi: 3.0.0
info:
  title: SAP API
  version: 1.0.0
servers:
- url: http://localhost:8080
paths:
  /rfc/DB6_PM_TABSPACESNAP:
    post:
      tags:
      - SDB6PM
      summary: 'DB6: Get Tablespace Snapshot'
      operationId: /rfc/DB6_PM_TABSPACESNAP
      requestBody:
        content:
          application/json:
            schema:
              properties:
                ACTION:
                  type: integer
                  format: int32
                CALLERFLAG:
                  type: string
                  maxLength: 1
                  description: Who Has Called this Program
                COMPTIME:
                  type: string
                  maxLength: 14
                  description: 'DB6: Timestamp (Format: YYYYMMDDHHMMSS)'
                CONNECTION:
                  type: string
                  maxLength: 30
                  description: Logical name for a database connection
                PARTITN:
                  type: integer
                  format: int32
                  description: Partition Number
                IT_DB6PMSP:
                  type: array
                  items:
                    type: object
                    properties:
                      COMPTIME:
                        type: string
                        maxLength: 14
                        description: 'DB6: Timestamp (Format: YYYYMMDDHHMMSS)'
                      PARTITN:
                        type: integer
                        format: int32
                        description: Partition Number
                      TBS_NAME:
                        type: string
                        maxLength: 30
                        description: 'DB6: Tablespace Name'
                      CALLERFLAG:
                        type: string
                        maxLength: 1
                        description: Who Has Called this Program
                      DBMSTRTTME:
                        type: string
                        maxLength: 14
                        description: 'DB6: Timestamp (Format: YYYYMMDDHHMMSS)'
                      PRGVERS:
                        type: string
                        maxLength: 20
                        description: Version of Program Inserted this Row
                      PL_D_LRS:
                        type: integer
                        format: int64
                        description: 'pool_data_l_reads: Pool Data Logical Reads Since Connect'
                      PL_D_PRS:
                        type: integer
                        format: int64
                        description: 'pool_data_p_reads: Pool Data Physical Reads Since Connect'
                      PL_A_DRS:
                        type: integer
                        format: int64
                        description: 'pool_async_data_reads: Asynchronous Pool Data Reads'
                      PL_D_WS:
                        type: integer
                        format: int64
                        description: 'pool_data_writes: Pool Data Writes Since Connect'
                      PL_A_DWS:
                        type: integer
                        format: int64
                        description: 'pool_async_data_writes: Asynchronous Pool Data Writes'
                      PL_I_LRS:
                        type: integer
                        format: int64
                        description: 'pool_index_l_reads: Pool Index Logical Reads Since Connect'
                      PL_I_PRS:
                        type: integer
                        format: int64
                        description: 'pool_index_p_reads: Pool Index Physical Reads Since Connect'
                      PL_I_WS:
                        type: integer
                        format: int64
                        description: 'pool_index_writes: Pool Index Writes Since Connect'
                      PL_A_IWS:
                        type: integer
                        format: int64
                        description: 'pool_async_index_writes: Asynchronous Pool Index Writes'
                      PL_RD_TM:
                        type: integer
                        format: int64
                        description: 'pool_read_time: Buffer Pool Read Time Since First Connect'
                      PL_WT_TM:
                        type: integer
                        format: int64
                        description: 'pool_write_time: Buffer Pool Write Time Since First Connect'
                      PL_A_RTM:
                        type: integer
                        format: int64
                        description: 'pool_async_read_time: Asynchronous Read Time'
                      PL_A_WTM:
                        type: integer
                        format: int64
                        description: 'pool_async_write_time: Asynchronous Write Time'
                      PL_A_DRRQ:
                        type: integer
                        format: int64
                        description: 'pool_async_data_read_reqs: No. of Asynchronous Read Requests'
                      DIRCT_RDS:
                        type: integer
                        format: int64
                        description: 'direct_reads: Direct Reads Since First Connect'
                      DIRCT_WTS:
                        type: integer
                        format: int64
                        description: 'direct_writes: Direct Writes Since First Connect'
                      DIRCT_RRQS:
                        type: integer
                        format: int64
                        description: 'direct_read_reqs: Direct Read Requests'
                      DIRCT_WRQS:
                        type: integer
                        format: int64
                        description: 'direct_write_reqs: Direct Write Requests'
                      DIRCT_RTM:
                        type: integer
                        format: int64
                        description: 'direct_read_time: Direct Read Time Since First Connect'
                      DIRCT_WTM:
                        type: integer
                        format: int64
                        description: 'direct_write_time: Direct Write Time Since First Connect'
                      FLS_CLOSED:
                        type: integer
                        format: int64
                        description: 'files_closed: Files Closed for Tablespace'
                      PL_A_IRS:
                        type: integer
                        format: int64
                        description: 'pool_async_index_reads: Asynchronous Pool Index Reads'
                      PL_D_TE:
                        type: integer
                        format: int64
                        description: 'pool_data_to_estore: No. of Pages Copied from BP to ExStor.'
                      PL_I_TE:
                        type: integer
                        format: int64
                        description: 'pool_index_to_estore: No. of Pages Copied from BP to ExStor.'
                      PL_I_FE:
                        type: integer
                        format: int64
                        description: 'pool_index_from_estore: No of Pages Copied from ExStor to BP'
                      PL_D_FE:
                        type: integer
                        format: int64
                        description: 'pool_data_from_estore: No. of Pages Copied from ExStor to BP'
                      UNREADPFPG:
                        type: integer
                        format: int64
                        description: 'unread_prefetch_pages: Unread prefetched pages'
                      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_IRRQ:
                        type: integer
                        format: int64
                        description: pool_async_index_read_reqs
                      PL_ASYNC_XDA_RDS:
                        type: integer
                        format: int64
                        description: ''
                      PL_ASYNC_XDA_RRQ:
                        type: integer
                        format: int64
                        description: ''
                      PL_ASYNC_XDA_WRT:
                        type: integer
                        format: int64
                        description: ''
                      PL_TEMP_XDA_L_RD:
                        type: integer
                        format: int64
                        description: ''
                      PL_TEMP_XDA_P_RD:
                        type: integer
                        format: int64
                        description: ''
                      POOL_XDA_L_READS:
                        type: integer
                        format: int64
                        description: ''
                      POOL_XDA_P_READS:
                        type: integer
                        format: int64
                        description: ''
                      POOL_XDA_WRITES:
                        type: integer
                        format: int64
                        description: ''
                      PL_NO_VICTIM_BUF:
                        type: integer
                        format: int64
                        description: pool_no_victim_buffer
                IT_DB6PMSP_HD:
                  type: array
                  items:
                    type: object
                    properties:
                      COMPTIME:
                        type: string
                        maxLength: 14
                        description: 'DB6: Timestamp (Format: YYYYMMDDHHMMSS)'
                      PARTITN:
                        type: integer
                        format: int32
                        description: Partition Number
                      CALLERFLAG:
                        type: string
                        maxLength: 1
                        description: Who Has Called this Program
                      DBMSTRTTME:
                        type: string
                        maxLength: 14
                        description: 'DB6: Timestamp (Format: YYYYMMDDHHMMSS)'
                      PRGVERS:
                        type: string
                        maxLength: 20
                        description: Version of Program Inserted this Row
                      NUM_TBS:
                        type: integer
                        format: int64
                        description: sqlm_tablespace Structures Returned
                      DB_CN_TM:
                        type: string
                        maxLength: 14
                        description: 'DB6: Timestamp (Format: YYYYMMDDHHMMSS)'
                      LAST_RESET:
                        type: string
                        maxLength: 14
                        description: 'DB6: Timestamp (Format: YYYYMMDDHHMMSS)'
                      IN_DB_ALIA:
                        type: string
                        maxLength: 20
                        description: 'DB6: General identifier'
                      DB_NAME:
                        type: string
                        maxLength: 20
                        description: 'DB6: General identifier'
                      DB_PATH:
                        type: string
                        maxLength: 255
                        description: 'DB6: File Path'
              required:
              - ACTION
              - CALLERFLAG
              - PARTITN
      responses:
        '200':
          description: OK
          content:
            application/json:
              schema:
                properties:
                  IT_DB6PMSP:
                    type: array
                    items:
                      type: object
                      properties:
                        COMPTIME:
                          type: string
                          maxLength: 14
                          description: 'DB6: Timestamp (Format: YYYYMMDDHHMMSS)'
                        PARTITN:
                          type: integer
                          format: int32
                          description: Partition Number
                        TBS_NAME:
                          type: string
                          maxLength: 30
                          description: 'DB6: Tablespace Name'
                        CALLERFLAG:
                          type: string
                          maxLength: 1
                          description: Who Has Called this Program
                        DBMSTRTTME:
                          type: string
                          maxLength: 14
                          description: 'DB6: Timestamp (Format: YYYYMMDDHHMMSS)'
                        PRGVERS:
                          type: string
                          maxLength: 20
                          description: Version of Program Inserted this Row
                        PL_D_LRS:
                          type: integer
                          format: int64
                          description: 'pool_data_l_reads: Pool Data Logical Reads Since Connect'
                        PL_D_PRS:
                          type: integer
                          format: int64
                          description: 'pool_data_p_reads: Pool Data Physical Reads Since Connect'
                        PL_A_DRS:
                          type: integer
                          format: int64
                          description: 'pool_async_data_reads: Asynchronous Pool Data Reads'
                        PL_D_WS:
                          type: integer
                          format: int64
                          description: 'pool_data_writes: Pool Data Writes Since Connect'
                        PL_A_DWS:
                          type: integer
                          format: int64
                          description: 'pool_async_data_writes: Asynchronous Pool Data Writes'
                        PL_I_LRS:
                          type: integer
                          format: int64
                          description: 'pool_index_l_reads: Pool Index Logical Reads Since Connect'
                        PL_I_PRS:
                          type: integer
                          format: int64
                          description: 'pool_index_p_reads: Pool Index Physical Reads Since Connect'
                        PL_I_WS:
                          type: integer
                          format: int64
                          description: 'pool_index_writes: Pool Index Writes Since Connect'
                        PL_A_IWS:
                          type: integer
                          format: int64
                          description: 'pool_async_index_writes: Asynchronous Pool Index Writes'
                        PL_RD_TM:
                          type: integer
                          format: int64
                          description: 'pool_read_time: Buffer Pool Read Time Since First Connect'
                        PL_WT_TM:
                          type: integer
                          format: int64
                          description: 'pool_write_time: Buffer Pool Write Time Since First Connect'
                        PL_A_RTM:
                          type: integer
                          format: int64
                          description: 'pool_async_read_time: Asynchronous Read Time'
                        PL_A_WTM:
                          type: integer
                          format: int64
                          description: 'pool_async_write_time: Asynchronous Write Time'
                        PL_A_DRRQ:
                          type: integer
                          format: int64
                          description: 'pool_async_data_read_reqs: No. of Asynchronous Read Requests'
                        DIRCT_RDS:
                          type: integer
                          format: int64
                          description: 'direct_reads: Direct Reads Since First Connect'
                        DIRCT_WTS:
                          type: integer
                          format: int64
                          description: 'direct_writes: Direct Writes Since First Connect'
                        DIRCT_RRQS:
                          type: integer
                          format: int64
                          description: 'direct_read_reqs: Direct Read Requests'
                        DIRCT_WRQS:
                          type: integer
                          format: int64
                          description: 'direct_write_reqs: Direct Write Requests'
                        DIRCT_RTM:
                          type: integer
                          format: int64
                          description: 'direct_read_time: Direct Read Time Since First Connect'
                        DIRCT_WTM:
                          type: integer
                          format: int64
                          description: 'direct_write_time: Direct Write Time Since First Connect'
                        FLS_CLOSED:
                          type: integer
                          format: int64
                          description: 'files_closed: Files Closed for Tablespace'
                        PL_A_IRS:
                          type: integer
                          format: int64
                          description: 'pool_async_index_reads: Asynchronous Pool Index Reads'
                        PL_D_TE:
                          type: integer
                          format: int64
                          description: 'pool_data_to_estore: No. of Pages Copied from BP to ExStor.'
                        PL_I_TE:
                          type: integer
                          format: int64
                          description: 'pool_index_to_estore: No. of Pages Copied from BP to ExStor.'
                        PL_I_FE:
                          type: integer
                          format: int64
                          description: 'pool_index_from_estore: No of Pages Copied from ExStor to BP'
                        PL_D_FE:
                          type: integer
                          format: int64
                          description: 'pool_data_from_estore: No. of Pages Copied from ExStor to BP'
                        UNREADPFPG:
                          type: integer
                          format: int64
                          description: 'unread_prefetch_pages: Unread prefetched pages'
                        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_IRRQ:
                          type: integer
                          format: int64
                          description: pool_async_index_read_reqs
                        PL_ASYNC_XDA_RDS:
                          type: integer
                          format: int64
                          description: ''
                        PL_ASYNC_XDA_RRQ:
                          type: integer
                          format: int64
                          description: ''
                        PL_ASYNC_XDA_WRT:
                          type: integer
                          format: int64
                          description: ''
                        PL_TEMP_XDA_L_RD:
                          type: integer
                          format: int64
                          description: ''
                        PL_TEMP_XDA_P_RD:
                          type: integer
                          format: int64
                          description: ''
                        POOL_XDA_L_READS:
                          type: integer
                          format: int64
                          description: ''
                        POOL_XDA_P_READS:
                          type: integer
                          format: int64
                          description: ''
                        POOL_XDA_WRITES:
                          type: integer
                          format: int64
                          description: ''
                        PL_NO_VICTIM_BUF:
                          type: integer
                          format: int64
                          description: pool_no_victim_buffer
                  IT_DB6PMSP_HD:
                    type: array
                    items:
                      type: object
                      properties:
                        COMPTIME:
                          type: string
                          maxLength: 14
                          description: 'DB6: Timestamp (Format: YYYYMMDDHHMMSS)'
                        PARTITN:
                          type: integer
                          format: int32
                          description: Partition Number
                        CALLERFLAG:
                          type: string
                          maxLength: 1
                          description: Who Has Called this Program
                        DBMSTRTTME:
                          type: string
                          maxLength: 14
                          description: 'DB6: Timestamp (Format: YYYYMMDDHHMMSS)'
                        PRGVERS:
                          type: string
                          maxLength: 20
                          description: Version of Program Inserted this Row
                        NUM_TBS:
                          type: integer
                          format: int64
                          description: sqlm_tablespace Structures Returned
                        DB_CN_TM:
                          type: string
                          maxLength: 14
                          description: 'DB6: Timestamp (Format: YYYYMMDDHHMMSS)'
                        LAST_RESET:
                          type: string
                          maxLength: 14
                          description: 'DB6: Timestamp (Format: YYYYMMDDHHMMSS)'
                        IN_DB_ALIA:
                          type: string
                          maxLength: 20
                          description: 'DB6: General identifier'
                        DB_NAME:
                          type: string
                          maxLength: 20
                          description: 'DB6: General identifier'
                        DB_PATH:
                          type: string
                          maxLength: 255
                          description: 'DB6: File Path'
        '400':
          description: Bad request.
        5XX:
          description: Unexpected error.
