openapi: 3.0.0
info:
  title: SAP API
  version: 1.0.0
servers:
- url: http://localhost:8080
paths:
  /rfc/DB02N_GET_TS_DETL_ANALYSIS_DB2:
    post:
      tags:
      - S_DB02N_DB2
      operationId: /rfc/DB02N_GET_TS_DETL_ANALYSIS_DB2
      requestBody:
        content:
          application/json:
            schema:
              properties:
                DATABASE:
                  type: string
                  maxLength: 8
                TABLESPACE:
                  type: string
                  maxLength: 8
                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
                PARTITION_INFO:
                  type: array
                  items:
                    type: object
                    properties:
                      NAME:
                        type: string
                        maxLength: 8
                        description: Name of the tablespace
                      DBNAME:
                        type: string
                        maxLength: 8
                        description: Database name
                      PART:
                        type: integer
                        format: int32
                        description: Partition number
                      IXNAME:
                        type: string
                        maxLength: 18
                        description: Name of the partitioned index
                      IXCREATOR:
                        type: string
                        maxLength: 8
                        description: Authorization ID of the creator of the partitioned index
                      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
                      CARD:
                        type: integer
                        format: int32
                        description: Number of rows in the tablespace or partition
                      FARINDREF:
                        type: integer
                        format: int32
                        description: Number of rows relocated far from their original page
                      NEARINDREF:
                        type: integer
                        format: int32
                        description: Number of rows relocated near their original page
                      PERCACTIVE:
                        type: integer
                        format: int32
                        description: Percentage of space occupied by rows of active tables
                      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
                      COMPRESS:
                        type: string
                        maxLength: 1
                        description: Indicates whether the COMPRESS attribute is YES
                      PAGESAVE:
                        type: integer
                        format: int32
                        description: Percentage of pages saved in the TS because of compression
                      STATSTIME:
                        type: string
                        maxLength: 26
                        description: Date and time of last RUNSTATS
                      SPACE:
                        type: integer
                        format: int32
                        description: Number of KB of DASD Storage Allocated to Tablespace
                      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
              required:
              - DATABASE
              - TABLESPACE
      responses:
        '200':
          description: OK
          content:
            application/json:
              schema:
                properties:
                  TABLESPACE_INFO:
                    type: object
                    properties:
                      NAME:
                        type: string
                        maxLength: 8
                        description: Name of the tablespace
                      DBNAME:
                        type: string
                        maxLength: 8
                        description: Database name
                      CREATOR:
                        type: string
                        maxLength: 8
                        description: DB2 creator name
                      BPOOL:
                        type: string
                        maxLength: 8
                        description: 'DB2/390: Buffer pool'
                      STATUS:
                        type: string
                        maxLength: 1
                        description: 'Availability status of the tablespace  enumValues: S=Check pending with scope less than entire tablespace,C=No partitioned index created,T=No table has been created,P=Check pending,A=Available'
                        enum:
                        - S
                        - C
                        - T
                        - P
                        - A
                      PARTITIONS:
                        type: integer
                        format: int32
                        description: Number of partitions of a tablespace or index
                      PGSIZE:
                        type: integer
                        format: int32
                        description: 'DB2 for OS/390 page size in KBytes  enumValues: 32=page size 32KB,4=page size 4KB'
                        enum:
                        - '32'
                        - '4'
                      NTABLES:
                        type: integer
                        format: int32
                        description: Number of tables defined in the tablespace
                      NACTIVE:
                        type: integer
                        format: int32
                        description: Number of active pages in the tablespace
                      SEGSIZE:
                        type: integer
                        format: int32
                        description: Number of pages in a segment of a segmented tablespace
                  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
                  PARTITION_INFO:
                    type: array
                    items:
                      type: object
                      properties:
                        NAME:
                          type: string
                          maxLength: 8
                          description: Name of the tablespace
                        DBNAME:
                          type: string
                          maxLength: 8
                          description: Database name
                        PART:
                          type: integer
                          format: int32
                          description: Partition number
                        IXNAME:
                          type: string
                          maxLength: 18
                          description: Name of the partitioned index
                        IXCREATOR:
                          type: string
                          maxLength: 8
                          description: Authorization ID of the creator of the partitioned index
                        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
                        CARD:
                          type: integer
                          format: int32
                          description: Number of rows in the tablespace or partition
                        FARINDREF:
                          type: integer
                          format: int32
                          description: Number of rows relocated far from their original page
                        NEARINDREF:
                          type: integer
                          format: int32
                          description: Number of rows relocated near their original page
                        PERCACTIVE:
                          type: integer
                          format: int32
                          description: Percentage of space occupied by rows of active tables
                        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
                        COMPRESS:
                          type: string
                          maxLength: 1
                          description: Indicates whether the COMPRESS attribute is YES
                        PAGESAVE:
                          type: integer
                          format: int32
                          description: Percentage of pages saved in the TS because of compression
                        STATSTIME:
                          type: string
                          maxLength: 26
                          description: Date and time of last RUNSTATS
                        SPACE:
                          type: integer
                          format: int32
                          description: Number of KB of DASD Storage Allocated to Tablespace
                        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
        '400':
          description: Bad request.
        5XX:
          description: Unexpected error.
