openapi: 3.0.0
info:
  title: SAP API
  version: 1.0.0
servers:
- url: http://localhost:8080
paths:
  /rfc/DB02N_GET_IX_DETL_ANALYSIS_DB2:
    post:
      tags:
      - S_DB02N_DB2
      operationId: /rfc/DB02N_GET_IX_DETL_ANALYSIS_DB2
      requestBody:
        content:
          application/json:
            schema:
              properties:
                CREATOR:
                  type: string
                  maxLength: 8
                INDEX:
                  type: string
                  maxLength: 18
                DATASET_VOLUME_LIST:
                  type: array
                  items:
                    type: object
                    properties:
                      DSNAME:
                        type: string
                        maxLength: 44
                        description: Dataset name
                      VOLUME:
                        type: string
                        maxLength: 6
                        description: Serial number of the volume
                INDEX_PARTITION_INFO:
                  type: array
                  items:
                    type: object
                    properties:
                      NAME:
                        type: string
                        maxLength: 18
                        description: Name of a DB2 for OS/390 index
                      CREATOR:
                        type: string
                        maxLength: 8
                        description: DB2 creator name
                      PART:
                        type: integer
                        format: int32
                        description: Partition number
                      STORNAME:
                        type: string
                        maxLength: 8
                        description: Name of the storage group used for space allocation
                      VCATNAME:
                        type: string
                        maxLength: 8
                        description: Name of the integrated catalog facility catalog
                      LEAFDIST:
                        type: integer
                        format: int32
                        description: 100 * avg number of leaf pages between successive leaf pages
                      FREEPAGE:
                        type: integer
                        format: int32
                        description: Number of pages loaded before a page is left as free space
                      PCTFREE:
                        type: integer
                        format: int32
                        description: Percentage of each page left as free space
                      STATSTIME:
                        type: string
                        maxLength: 26
                        description: Date and time of last RUNSTATS
                      GBPCACHE:
                        type: string
                        maxLength: 1
                        description: 'Group buffer pool cache option  enumValues: ""=Only changed pages are cached in the group buffer pool,A=Changed & unchanged pages are cached in the group bufferpool'
                        enum:
                        - ''
                        - A
                      FAROFFPOSF:
                        type: number
                        description: Number of referred to rows far from optimal position
                      NEAROFFPOS:
                        type: number
                        description: Number of referred to rows near the optimal position
                      CARDF:
                        type: number
                        description: Number of keys in the index that refer to data rows or LOBs
                      SPACE:
                        type: integer
                        format: int32
                        description: Number of KB of DASD Storage Allocated to Tablespace
              required:
              - CREATOR
              - INDEX
      responses:
        '200':
          description: OK
          content:
            application/json:
              schema:
                properties:
                  INDEX_INFO:
                    type: object
                    properties:
                      NAME:
                        type: string
                        maxLength: 18
                        description: Name of a DB2 for OS/390 index
                      CREATOR:
                        type: string
                        maxLength: 8
                        description: DB2 creator name
                      TBNAME:
                        type: string
                        maxLength: 18
                        description: Name of the table on which the index is defined
                      TBCREATOR:
                        type: string
                        maxLength: 8
                        description: Authorization ID of the owner of the table
                      UNIQUERULE:
                        type: string
                        maxLength: 1
                        description: 'Whether the index is unique  enumValues: N=Yes; defined with UNIQUE WHERE NOT NULL,P=Yes; primary index,R=Yes; enforces uniqueness of a non-primary parent key,D=No (duplicates allowed),U=Yes,C=Yes; used to enforce UNIQUE constraint'
                        enum:
                        - N
                        - P
                        - R
                        - D
                        - U
                        - C
                      COLCOUNT:
                        type: integer
                        format: int32
                        description: Number of columns in the key
                      CLUSTERING:
                        type: string
                        maxLength: 1
                        description: 'Whether CLUSTER was specified when the index was created  enumValues: N=No,Y=Yes'
                        enum:
                        - N
                        - Y
                      CLUSTERED:
                        type: string
                        maxLength: 1
                        description: 'Whether the table is actually clustered by the index  enumValues: N=No,Y=Yes'
                        enum:
                        - N
                        - Y
                      DBNAME:
                        type: string
                        maxLength: 8
                        description: Database name
                      INDEXSPACE:
                        type: string
                        maxLength: 8
                        description: Name of the indexspace that contains the index
                      PARTITIONS:
                        type: integer
                        format: int32
                        description: Number of partitions of a tablespace or index
                      NLEAF:
                        type: integer
                        format: int32
                        description: Number of active leaf pages in the index
                      NLEVELS:
                        type: integer
                        format: int32
                        description: DB2 for OS/390 number of levels in the index tree
                      BPOOL:
                        type: string
                        maxLength: 8
                        description: 'DB2/390: Buffer pool'
                      PGSIZE:
                        type: integer
                        format: int32
                        description: Size in bytes of the leaf pages in the index
                      CLURATIO:
                        type: integer
                        format: int32
                        description: 'Clusterratio: Percentage of rows in clustering order'
                      STATSTIME:
                        type: string
                        maxLength: 26
                        description: Date and time of last RUNSTATS
                      INDEXTYPE:
                        type: string
                        maxLength: 1
                        description: 'Index type  enumValues: 2=Type 2 index,""=Type 1 index'
                        enum:
                        - '2'
                        - ''
                      FIRSTKEY:
                        type: number
                        description: Number of distinct values in the first key column
                      FULLKEY:
                        type: number
                        description: Number of distinct values of the key
                      CREATEDTS:
                        type: string
                        maxLength: 26
                        description: Time when the CREATE statement was executed
                      ALTEREDTS:
                        type: string
                        maxLength: 26
                        description: Time of most recent ALTER statement on the object
                  DATASET_VOLUME_LIST:
                    type: array
                    items:
                      type: object
                      properties:
                        DSNAME:
                          type: string
                          maxLength: 44
                          description: Dataset name
                        VOLUME:
                          type: string
                          maxLength: 6
                          description: Serial number of the volume
                  INDEX_PARTITION_INFO:
                    type: array
                    items:
                      type: object
                      properties:
                        NAME:
                          type: string
                          maxLength: 18
                          description: Name of a DB2 for OS/390 index
                        CREATOR:
                          type: string
                          maxLength: 8
                          description: DB2 creator name
                        PART:
                          type: integer
                          format: int32
                          description: Partition number
                        STORNAME:
                          type: string
                          maxLength: 8
                          description: Name of the storage group used for space allocation
                        VCATNAME:
                          type: string
                          maxLength: 8
                          description: Name of the integrated catalog facility catalog
                        LEAFDIST:
                          type: integer
                          format: int32
                          description: 100 * avg number of leaf pages between successive leaf pages
                        FREEPAGE:
                          type: integer
                          format: int32
                          description: Number of pages loaded before a page is left as free space
                        PCTFREE:
                          type: integer
                          format: int32
                          description: Percentage of each page left as free space
                        STATSTIME:
                          type: string
                          maxLength: 26
                          description: Date and time of last RUNSTATS
                        GBPCACHE:
                          type: string
                          maxLength: 1
                          description: 'Group buffer pool cache option  enumValues: ""=Only changed pages are cached in the group buffer pool,A=Changed & unchanged pages are cached in the group bufferpool'
                          enum:
                          - ''
                          - A
                        FAROFFPOSF:
                          type: number
                          description: Number of referred to rows far from optimal position
                        NEAROFFPOS:
                          type: number
                          description: Number of referred to rows near the optimal position
                        CARDF:
                          type: number
                          description: Number of keys in the index that refer to data rows or LOBs
                        SPACE:
                          type: integer
                          format: int32
                          description: Number of KB of DASD Storage Allocated to Tablespace
        '400':
          description: Bad request.
        5XX:
          description: Unexpected error.
