openapi: 3.0.0
info:
  title: SAP API
  version: 1.0.0
servers:
- url: http://localhost:8080
paths:
  /rfc/MSS_EXEC_DBCC_SHOWCONTIG:
    post:
      tags:
      - SFMSS_DBUTIL
      summary: Execute DBCC SHOWCONTIG for a given table (and index)
      operationId: /rfc/MSS_EXEC_DBCC_SHOWCONTIG
      requestBody:
        content:
          application/json:
            schema:
              properties:
                ALL_LEVELS:
                  type: string
                  maxLength: 1
                  description: If 'X', then the ALL_LEVELS option is used.
                CON_NAME:
                  type: string
                  default: DEFAULT
                  maxLength: 30
                  description: DBCON name
                DB_NAME:
                  type: string
                  maxLength: 128
                  description: Database name
                FAST:
                  type: string
                  maxLength: 1
                  description: If 'X', then the FAST option is used.
                INDEX_NAME:
                  type: string
                  maxLength: 128
                  description: Index name
                SCHEMA:
                  type: string
                  default: ' '
                  maxLength: 128
                  description: Target Schema
                SCHEMA_NAME:
                  type: string
                  maxLength: 128
                  description: Schema name
                TABLE_NAME:
                  type: string
                  maxLength: 128
                  description: Table name
                FRAG_INFO:
                  type: array
                  items:
                    type: object
                    properties:
                      TABLENAME:
                        type: string
                        maxLength: 128
                        description: Table name
                      OBJECTID:
                        type: integer
                        format: int32
                        description: Object id
                      INDEXNAME:
                        type: string
                        maxLength: 128
                        description: Index name
                      INDEXID:
                        type: integer
                        format: int32
                        description: Index id
                      LEVEL:
                        type: integer
                        format: int32
                        description: Index level
                      PAGES:
                        type: integer
                        format: int32
                        description: Number of pages in index level
                      ROWS:
                        type: integer
                        format: int32
                        description: Number of data or index rows in index level
                      ROWMINLEN:
                        type: integer
                        format: int32
                        description: Minimum row size in index level
                      ROWMAXLEN:
                        type: integer
                        format: int32
                        description: Maximum row size in index level
                      ROWAVGLEN:
                        type: integer
                        format: int64
                        description: Average row size in index level
                      FORWARDEDROWS:
                        type: integer
                        format: int32
                        description: Number of forwarded rows in index level
                      EXTENTS:
                        type: integer
                        format: int32
                        description: Number of extents in index level
                      EXTENTSWITCHES:
                        type: integer
                        format: int32
                        description: Number of extent switches
                      AVGFREEBYTES:
                        type: integer
                        format: int64
                        description: Average number of bytes free per page
                      AVGPAGEDENSITY:
                        type: integer
                        format: int64
                        description: Average page density
                      SCANDENSITY:
                        type: integer
                        format: int64
                        description: Scan density
                      BESTCOUNT:
                        type: integer
                        format: int32
                        description: Ideal number of extent changes
                      ACTUALCOUNT:
                        type: integer
                        format: int32
                        description: Actual number of extent changes
                      LOGICALFRAG:
                        type: integer
                        format: int64
                        description: Logical scan fragmentation
                      EXTENTFRAG:
                        type: integer
                        format: int64
                        description: Extent scan fragmentation
              required:
              - TABLE_NAME
      responses:
        '200':
          description: OK
          content:
            application/json:
              schema:
                properties:
                  FRAG_INFO:
                    type: array
                    items:
                      type: object
                      properties:
                        TABLENAME:
                          type: string
                          maxLength: 128
                          description: Table name
                        OBJECTID:
                          type: integer
                          format: int32
                          description: Object id
                        INDEXNAME:
                          type: string
                          maxLength: 128
                          description: Index name
                        INDEXID:
                          type: integer
                          format: int32
                          description: Index id
                        LEVEL:
                          type: integer
                          format: int32
                          description: Index level
                        PAGES:
                          type: integer
                          format: int32
                          description: Number of pages in index level
                        ROWS:
                          type: integer
                          format: int32
                          description: Number of data or index rows in index level
                        ROWMINLEN:
                          type: integer
                          format: int32
                          description: Minimum row size in index level
                        ROWMAXLEN:
                          type: integer
                          format: int32
                          description: Maximum row size in index level
                        ROWAVGLEN:
                          type: integer
                          format: int64
                          description: Average row size in index level
                        FORWARDEDROWS:
                          type: integer
                          format: int32
                          description: Number of forwarded rows in index level
                        EXTENTS:
                          type: integer
                          format: int32
                          description: Number of extents in index level
                        EXTENTSWITCHES:
                          type: integer
                          format: int32
                          description: Number of extent switches
                        AVGFREEBYTES:
                          type: integer
                          format: int64
                          description: Average number of bytes free per page
                        AVGPAGEDENSITY:
                          type: integer
                          format: int64
                          description: Average page density
                        SCANDENSITY:
                          type: integer
                          format: int64
                          description: Scan density
                        BESTCOUNT:
                          type: integer
                          format: int32
                          description: Ideal number of extent changes
                        ACTUALCOUNT:
                          type: integer
                          format: int32
                          description: Actual number of extent changes
                        LOGICALFRAG:
                          type: integer
                          format: int64
                          description: Logical scan fragmentation
                        EXTENTFRAG:
                          type: integer
                          format: int64
                          description: Extent scan fragmentation
        '400':
          description: Bad request.
        5XX:
          description: Unexpected error.
