openapi: 3.0.0
info:
  title: SAP API
  version: 1.0.0
servers:
- url: http://localhost:8080
paths:
  /rfc/DB02N_GET_TOP_TABLES_DB2:
    post:
      tags:
      - S_DB02N_DB2
      summary: Get top growing tables
      operationId: /rfc/DB02N_GET_TOP_TABLES_DB2
      requestBody:
        content:
          application/json:
            schema:
              properties:
                TABLE_TOP20:
                  type: array
                  items:
                    type: object
                    properties:
                      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
                      DBNAME:
                        type: string
                        maxLength: 8
                        description: Database name
                      TSNAME:
                        type: string
                        maxLength: 8
                        description: Name of the tablespace
                      TBSIZE:
                        type: number
                        description: 'Real Time Statistics: Table size = TOTALENTRIES*AvgRowLen KB'
                      TBSIZE_LAST:
                        type: number
                        description: 'Tx DB02: Absolute difference in comparison to previous run'
                      TBSIZE_PERC:
                        type: integer
                        format: int32
                        description: 'Tx DB02: Difference (percent) in comparison to previous run'
                      TBSIZE_FIRST:
                        type: number
                        description: 'Tx DB02: Absolute difference in comparison to first run'
                      D_TBSIZE:
                        type: number
                        description: RTS Table size (= TOTALENTRIES*AvgRowLen KB) daily changes
                      W_TBSIZE:
                        type: number
                        description: RTS Table size (= TOTALENTRIES*AvgRowLen KB) weekly changes
                      M_TBSIZE:
                        type: number
                        description: RTS Table size (= TOTALENTRIES*AvgRowLen KB) monthly changes
                      RTS_TOTALROWS:
                        type: number
                        description: 'DB2/zOS: Real-Time Statistics tablespace TOTALROWS'
                      TOTALROWS_LAST:
                        type: number
                        description: 'Tx DB02: Absolute difference in comparison to previous run'
                      TOTALROWS_PERC:
                        type: integer
                        format: int32
                        description: 'Tx DB02: Difference (percent) in comparison to previous run'
                      TOTALROWS_FIRST:
                        type: number
                        description: 'Tx DB02: Absolute difference in comparison to first run'
                      D_TOTALROWS:
                        type: number
                        description: 'Number of Rows: changes per day'
                      W_TOTALROWS:
                        type: number
                        description: 'Number of Rows: changes per week'
                      M_TOTALROWS:
                        type: number
                        description: 'Number of Rows: changes per month'
                      SPACEF:
                        type: number
                        description: 'Column SYSIBM.SYSTABLES(SPACEF): DASD space used for table'
                      SPACEF_LAST:
                        type: number
                        description: 'Tx DB02: Absolute difference in comparison to previous run'
                      SPACEF_PERC:
                        type: integer
                        format: int32
                        description: 'Tx DB02: Difference (percent) in comparison to previous run'
                      SPACEF_FIRST:
                        type: number
                        description: 'Tx DB02: Absolute difference in comparison to first run'
                      D_SPACEF:
                        type: number
                        description: Change/day for  DASD space (SYSIBM.SYSTABLES(SPACEF))
                      W_SPACEF:
                        type: number
                        description: Change/week for  DASD space (SYSIBM.SYSTABLES(SPACEF))
                      M_SPACEF:
                        type: number
                        description: Change/month for  DASD space (SYSIBM.SYSTABLES(SPACEF))
      responses:
        '200':
          description: OK
          content:
            application/json:
              schema:
                properties:
                  TABLE_TOP20:
                    type: array
                    items:
                      type: object
                      properties:
                        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
                        DBNAME:
                          type: string
                          maxLength: 8
                          description: Database name
                        TSNAME:
                          type: string
                          maxLength: 8
                          description: Name of the tablespace
                        TBSIZE:
                          type: number
                          description: 'Real Time Statistics: Table size = TOTALENTRIES*AvgRowLen KB'
                        TBSIZE_LAST:
                          type: number
                          description: 'Tx DB02: Absolute difference in comparison to previous run'
                        TBSIZE_PERC:
                          type: integer
                          format: int32
                          description: 'Tx DB02: Difference (percent) in comparison to previous run'
                        TBSIZE_FIRST:
                          type: number
                          description: 'Tx DB02: Absolute difference in comparison to first run'
                        D_TBSIZE:
                          type: number
                          description: RTS Table size (= TOTALENTRIES*AvgRowLen KB) daily changes
                        W_TBSIZE:
                          type: number
                          description: RTS Table size (= TOTALENTRIES*AvgRowLen KB) weekly changes
                        M_TBSIZE:
                          type: number
                          description: RTS Table size (= TOTALENTRIES*AvgRowLen KB) monthly changes
                        RTS_TOTALROWS:
                          type: number
                          description: 'DB2/zOS: Real-Time Statistics tablespace TOTALROWS'
                        TOTALROWS_LAST:
                          type: number
                          description: 'Tx DB02: Absolute difference in comparison to previous run'
                        TOTALROWS_PERC:
                          type: integer
                          format: int32
                          description: 'Tx DB02: Difference (percent) in comparison to previous run'
                        TOTALROWS_FIRST:
                          type: number
                          description: 'Tx DB02: Absolute difference in comparison to first run'
                        D_TOTALROWS:
                          type: number
                          description: 'Number of Rows: changes per day'
                        W_TOTALROWS:
                          type: number
                          description: 'Number of Rows: changes per week'
                        M_TOTALROWS:
                          type: number
                          description: 'Number of Rows: changes per month'
                        SPACEF:
                          type: number
                          description: 'Column SYSIBM.SYSTABLES(SPACEF): DASD space used for table'
                        SPACEF_LAST:
                          type: number
                          description: 'Tx DB02: Absolute difference in comparison to previous run'
                        SPACEF_PERC:
                          type: integer
                          format: int32
                          description: 'Tx DB02: Difference (percent) in comparison to previous run'
                        SPACEF_FIRST:
                          type: number
                          description: 'Tx DB02: Absolute difference in comparison to first run'
                        D_SPACEF:
                          type: number
                          description: Change/day for  DASD space (SYSIBM.SYSTABLES(SPACEF))
                        W_SPACEF:
                          type: number
                          description: Change/week for  DASD space (SYSIBM.SYSTABLES(SPACEF))
                        M_SPACEF:
                          type: number
                          description: Change/month for  DASD space (SYSIBM.SYSTABLES(SPACEF))
        '400':
          description: Bad request.
        5XX:
          description: Unexpected error.
