openapi: 3.0.0
info:
  title: SAP API
  version: 1.0.0
servers:
- url: http://localhost:8080
paths:
  /rfc/DB6_ADM_REORGCHK:
    post:
      tags:
      - SDB6ADM
      summary: 'DB6: RUNSTATS and REORGCHK of table'
      operationId: /rfc/DB6_ADM_REORGCHK
      requestBody:
        content:
          application/json:
            schema:
              properties:
                CONNECTION:
                  type: string
                  maxLength: 30
                  description: Logical name for a database connection
                SYSTEM_ID:
                  type: string
                  maxLength: 8
                  description: Logical name for a database connection
                TABNAME:
                  type: string
                  maxLength: 128
                  description: 'DB6: Table Name'
                TABSCHEMA:
                  type: string
                  maxLength: 20
                  description: 'DB6: Schema Name'
                IT_DB6IREORG:
                  type: array
                  items:
                    type: object
                    properties:
                      DB6IOWNER:
                        type: string
                        maxLength: 20
                        description: 'DB6: Schema Name'
                      DB6INAME:
                        type: string
                        maxLength: 128
                        description: 'DB6: Indexname'
                      DB6TOWNER:
                        type: string
                        maxLength: 20
                        description: 'DB6: Schema Name'
                      DB6TNAME:
                        type: string
                        maxLength: 18
                        description: Table Name
                      DB6TSPACE:
                        type: string
                        maxLength: 18
                        description: Tablespace Name
                      DB6CARD:
                        type: string
                        maxLength: 10
                        description: Cardinality (Number of Rows) in a Table
                      DB6ISIZE:
                        type: integer
                        format: int32
                        description: Index Size
                      DB6F4:
                        type: string
                        maxLength: 3
                        description: Formula 4 of REORGCHK Analysis
                      DB6F5:
                        type: string
                        maxLength: 3
                        description: Formula 5 of REORGCHK Analysis
                      DB6F6:
                        type: string
                        maxLength: 3
                        description: Formula 6 of REORGCHK Analysis
                      DB6REORG:
                        type: string
                        maxLength: 3
                        description: REORGCHK - Recommendation
                      DB6DATETIM:
                        type: string
                        maxLength: 26
                        description: 'DB6: Built-In UDB Type Timestamp'
                      DB6ITYPE:
                        type: string
                        maxLength: 1
                        description: 'Type of Index: U=unique P=primary D=duplicates'
                      DB6F7:
                        type: integer
                        format: int32
                        description: ''
                      DB6F8:
                        type: integer
                        format: int32
                        description: ''
                      DB6REORG2:
                        type: string
                        maxLength: 2
                        description: ''
              required:
              - TABNAME
      responses:
        '200':
          description: OK
          content:
            application/json:
              schema:
                properties:
                  DB6TREORG:
                    type: object
                    properties:
                      DB6TOWNER:
                        type: string
                        maxLength: 20
                        description: 'DB6: Schema Name'
                      DB6TNAME:
                        type: string
                        maxLength: 18
                        description: 'DB6: Table Name'
                      DB6TSPACE:
                        type: string
                        maxLength: 18
                        description: SYSCAT;Tablespace Name
                      DB6TSIZE:
                        type: integer
                        format: int32
                        description: 'ADMIN_GET_TAB_INFO: Table Size at last runstats'
                      DB6F1:
                        type: string
                        maxLength: 3
                        description: 'REORGCHK_TB_STATS: Formula 1 for REORGCHK Table'
                      DB6F2:
                        type: string
                        maxLength: 3
                        description: 'REORGCHK_TB_STATS: Formula 2 of REORGCHK Analysis'
                      DB6F3:
                        type: string
                        maxLength: 3
                        description: 'REORGCHK_TB_STATS: Formula 3 of REORGCHK Analysis'
                      DB6REORG:
                        type: string
                        maxLength: 3
                        description: REORGCHK_TB_STATS:REORGCHK - Recommendation
                      DB6DATETIM:
                        type: string
                        maxLength: 26
                        description: 'DB6: Built-In UDB Type Timestamp'
                      DB6RUNTIME:
                        type: string
                        maxLength: 6
                        description: 'SAP Reorg Jobs: Runtime of Last REORG'
                      DB6REODATE:
                        type: string
                        format: date
                        description: SAP Reorg Jobs:Date of Last REORG
                      DB6REOSIZE:
                        type: integer
                        format: int32
                        description: SAP Reorg Jobs:Table size at last reorg
                      TSPTYPE:
                        type: string
                        maxLength: 1
                        description: SYSCAT:Tablespace Type
                      PCTPAGESAVED:
                        type: integer
                        format: int32
                        description: 'SYSCAT: Percentage of pages saved by compression'
                      COMPRESSION:
                        type: string
                        maxLength: 1
                        description: 'SYSCAT: Type of compression'
                      DATA_OBJ_L_SIZE:
                        type: integer
                        format: int64
                        description: Number of logically allocated data pages
                      DATA_OBJ_P_SIZE:
                        type: integer
                        format: int64
                        description: Number of physically allocated data pages
                      INDEX_OBJ_L_SIZE:
                        type: integer
                        format: int64
                        description: Number of logically allocated  index pages
                      INDEX_OBJ_P_SIZE:
                        type: integer
                        format: int64
                        description: Number of physically allocated  index pages
                      LONG_OBJ_L_SIZE:
                        type: integer
                        format: int64
                        description: Number of logically allocated  long pages
                      LONG_OBJ_P_SIZE:
                        type: integer
                        format: int64
                        description: Number of physically allocated  long pages
                      LOB_OBJ_L_SIZE:
                        type: integer
                        format: int64
                        description: Number of logically allocated  LOB pages
                      LOB_OBJ_P_SIZE:
                        type: integer
                        format: int64
                        description: Number of physically allocated  LOG pages
                      XML_OBJ_L_SIZE:
                        type: integer
                        format: int64
                        description: Number of logically allocated  XML pages
                      XML_OBJ_P_SIZE:
                        type: integer
                        format: int64
                        description: Number of physically allocated  XML pages
                      LOAD_STATUS:
                        type: string
                        maxLength: 32
                        description: LOAD Status (IN_PROGRESS/PENDING)
                      LARGE_RIDS:
                        type: string
                        maxLength: 10
                        description: Large RIDs (YES/NO)
                      REORG_PENDING:
                        type: string
                        maxLength: 10
                        description: REORG pending (YES/NO)
                      INDEX_TYPE:
                        type: string
                        maxLength: 10
                        description: Index Type (Type-1/Type-2)
                      AVAILABLE:
                        type: string
                        maxLength: 10
                        description: Availability (YES/NO)
                  IT_DB6IREORG:
                    type: array
                    items:
                      type: object
                      properties:
                        DB6IOWNER:
                          type: string
                          maxLength: 20
                          description: 'DB6: Schema Name'
                        DB6INAME:
                          type: string
                          maxLength: 128
                          description: 'DB6: Indexname'
                        DB6TOWNER:
                          type: string
                          maxLength: 20
                          description: 'DB6: Schema Name'
                        DB6TNAME:
                          type: string
                          maxLength: 18
                          description: Table Name
                        DB6TSPACE:
                          type: string
                          maxLength: 18
                          description: Tablespace Name
                        DB6CARD:
                          type: string
                          maxLength: 10
                          description: Cardinality (Number of Rows) in a Table
                        DB6ISIZE:
                          type: integer
                          format: int32
                          description: Index Size
                        DB6F4:
                          type: string
                          maxLength: 3
                          description: Formula 4 of REORGCHK Analysis
                        DB6F5:
                          type: string
                          maxLength: 3
                          description: Formula 5 of REORGCHK Analysis
                        DB6F6:
                          type: string
                          maxLength: 3
                          description: Formula 6 of REORGCHK Analysis
                        DB6REORG:
                          type: string
                          maxLength: 3
                          description: REORGCHK - Recommendation
                        DB6DATETIM:
                          type: string
                          maxLength: 26
                          description: 'DB6: Built-In UDB Type Timestamp'
                        DB6ITYPE:
                          type: string
                          maxLength: 1
                          description: 'Type of Index: U=unique P=primary D=duplicates'
                        DB6F7:
                          type: integer
                          format: int32
                          description: ''
                        DB6F8:
                          type: integer
                          format: int32
                          description: ''
                        DB6REORG2:
                          type: string
                          maxLength: 2
                          description: ''
        '400':
          description: Bad request.
        5XX:
          description: Unexpected error.
