openapi: 3.0.0
info:
  title: SAP API
  version: 1.0.0
servers:
- url: http://localhost:8080
paths:
  /rfc/DB6_SYSCAT_GET_TABLESPACES:
    post:
      tags:
      - SDB6CAT
      summary: 'DB6: get SYSCAT.TABLESPACES'
      operationId: /rfc/DB6_SYSCAT_GET_TABLESPACES
      requestBody:
        content:
          application/json:
            schema:
              properties:
                CONNECTION:
                  type: string
                  maxLength: 30
                  description: Logical name for a database connection
                PARTITN:
                  type: integer
                  format: int32
                  description: Partition Number
                TSP_NAME:
                  type: string
                  maxLength: 30
                  description: 'DB6: Tablespace Name'
                TABLESPACES:
                  type: array
                  items:
                    type: object
                    properties:
                      DEFINER:
                        type: string
                        maxLength: 255
                        description: 'DB6: File Path'
                      TBS_NAME:
                        type: string
                        maxLength: 30
                        description: 'DB6: Tablespace Name'
                      TBS_ID:
                        type: integer
                        format: int32
                        description: Tablespace ID
                      TBS_TYPE:
                        type: string
                        maxLength: 1
                        description: Mgmt Type (DMS, SMS)
                      DATA_TYPE:
                        type: string
                        maxLength: 1
                        description: Contents (Regular,Long, Usertemp,Systemp)
                      EXTSIZE:
                        type: integer
                        format: int64
                        description: Extent size in pages
                      PF_SIZE:
                        type: integer
                        format: int64
                        description: Prefetch size in pages
                      OVERHEAD:
                        type: integer
                        format: int64
                        description: Controller overhead and disk seek and latency time in msec
                      TRANSFER:
                        type: integer
                        format: int64
                        description: Time to read one page of size PAGESIZE into the buffer
                      PAGESIZE:
                        type: integer
                        format: int64
                        description: Pagesize in byte
                      NGNAME:
                        type: string
                        maxLength: 20
                        description: 'DB6: General identifier'
                      BUFFERPOOL:
                        type: string
                        maxLength: 20
                        description: 'DB6: General identifier'
                      DROPRECOV:
                        type: string
                        maxLength: 1
                        description: 'Dropped table recovery: on =''X'',off= '' '''
              required:
              - PARTITN
      responses:
        '200':
          description: OK
          content:
            application/json:
              schema:
                properties:
                  TABLESPACES:
                    type: array
                    items:
                      type: object
                      properties:
                        DEFINER:
                          type: string
                          maxLength: 255
                          description: 'DB6: File Path'
                        TBS_NAME:
                          type: string
                          maxLength: 30
                          description: 'DB6: Tablespace Name'
                        TBS_ID:
                          type: integer
                          format: int32
                          description: Tablespace ID
                        TBS_TYPE:
                          type: string
                          maxLength: 1
                          description: Mgmt Type (DMS, SMS)
                        DATA_TYPE:
                          type: string
                          maxLength: 1
                          description: Contents (Regular,Long, Usertemp,Systemp)
                        EXTSIZE:
                          type: integer
                          format: int64
                          description: Extent size in pages
                        PF_SIZE:
                          type: integer
                          format: int64
                          description: Prefetch size in pages
                        OVERHEAD:
                          type: integer
                          format: int64
                          description: Controller overhead and disk seek and latency time in msec
                        TRANSFER:
                          type: integer
                          format: int64
                          description: Time to read one page of size PAGESIZE into the buffer
                        PAGESIZE:
                          type: integer
                          format: int64
                          description: Pagesize in byte
                        NGNAME:
                          type: string
                          maxLength: 20
                          description: 'DB6: General identifier'
                        BUFFERPOOL:
                          type: string
                          maxLength: 20
                          description: 'DB6: General identifier'
                        DROPRECOV:
                          type: string
                          maxLength: 1
                          description: 'Dropped table recovery: on =''X'',off= '' '''
        '400':
          description: Bad request.
        5XX:
          description: Unexpected error.
