openapi: 3.0.0
info:
  title: SAP API
  version: 1.0.0
servers:
- url: http://localhost:8080
paths:
  /rfc/DB02_ORA_LAST_ANALYZED:
    post:
      tags:
      - STD4
      summary: 'DB02 (Oracle): Checks: Cost-based optimizer - Dates of table analysis'
      operationId: /rfc/DB02_ORA_LAST_ANALYZED
      requestBody:
        content:
          application/json:
            schema:
              properties:
                DBA_TAB_COLUMNS:
                  type: array
                  items:
                    type: object
                    properties:
                      OWNER:
                        type: string
                        maxLength: 30
                        description: Owner
                      TABLE_NAME:
                        type: string
                        maxLength: 30
                        description: Name of Object
                      LAST_ANAL:
                        type: string
                        format: date
                        description: date of the most recent analysis
                      SAMP_SIZE:
                        type: integer
                        format: int64
                        description: sample size used in analyzing this column
                      NUM_ROWS:
                        type: integer
                        format: int64
                        description: NUMBER OF ROWS
                      TAB_TYPE:
                        type: string
                        maxLength: 11
                        description: Table type
                NR_ANALYZED:
                  type: array
                  items:
                    type: object
                    properties:
                      DESC:
                        type: string
                        maxLength: 20
                        description: 'Oracle: Time interval when table was analyzed'
                      SAPR3:
                        type: integer
                        format: int32
                        description: 'Oracle: No. of tables analyzed in a certain time interval'
                      SYS:
                        type: integer
                        format: int32
                        description: 'Oracle: No. of tables analyzed in a certain time interval'
                      SONST:
                        type: integer
                        format: int32
                        description: 'Oracle: No. of tables analyzed in a certain time interval'
                SDBAH_INT:
                  type: array
                  items:
                    type: object
                    properties:
                      BEG:
                        type: string
                        maxLength: 14
                        description: Start of the DBA action
                      FUNCT:
                        type: string
                        maxLength: 3
                        description: Function ID for DBA action
                      SYSID:
                        type: string
                        maxLength: 8
                        description: Database System ID
                      OBJ:
                        type: string
                        maxLength: 16
                        description: Object of DB operation
                      RC:
                        type: integer
                        format: int64
                        description: 'Return code for DBA action  enumValues: 0001=Warning,0002=General error,0000=Everything OK,0003=Detailed error'
                        enum:
                        - '0001'
                        - '0002'
                        - '0000'
                        - '0003'
                      ENDE:
                        type: string
                        maxLength: 14
                        description: End of database operation
                      ACTID:
                        type: string
                        maxLength: 16
                        description: Name of DBA Log
                      LINE:
                        type: string
                        maxLength: 254
                        description: Text Line for DBA Logs
      responses:
        '200':
          description: OK
          content:
            application/json:
              schema:
                properties:
                  MULTIBLOCK_READ:
                    type: string
                    maxLength: 10
                  OPTIMIZER_MODE:
                    type: string
                    maxLength: 10
                  DBA_TAB_COLUMNS:
                    type: array
                    items:
                      type: object
                      properties:
                        OWNER:
                          type: string
                          maxLength: 30
                          description: Owner
                        TABLE_NAME:
                          type: string
                          maxLength: 30
                          description: Name of Object
                        LAST_ANAL:
                          type: string
                          format: date
                          description: date of the most recent analysis
                        SAMP_SIZE:
                          type: integer
                          format: int64
                          description: sample size used in analyzing this column
                        NUM_ROWS:
                          type: integer
                          format: int64
                          description: NUMBER OF ROWS
                        TAB_TYPE:
                          type: string
                          maxLength: 11
                          description: Table type
                  NR_ANALYZED:
                    type: array
                    items:
                      type: object
                      properties:
                        DESC:
                          type: string
                          maxLength: 20
                          description: 'Oracle: Time interval when table was analyzed'
                        SAPR3:
                          type: integer
                          format: int32
                          description: 'Oracle: No. of tables analyzed in a certain time interval'
                        SYS:
                          type: integer
                          format: int32
                          description: 'Oracle: No. of tables analyzed in a certain time interval'
                        SONST:
                          type: integer
                          format: int32
                          description: 'Oracle: No. of tables analyzed in a certain time interval'
                  SDBAH_INT:
                    type: array
                    items:
                      type: object
                      properties:
                        BEG:
                          type: string
                          maxLength: 14
                          description: Start of the DBA action
                        FUNCT:
                          type: string
                          maxLength: 3
                          description: Function ID for DBA action
                        SYSID:
                          type: string
                          maxLength: 8
                          description: Database System ID
                        OBJ:
                          type: string
                          maxLength: 16
                          description: Object of DB operation
                        RC:
                          type: integer
                          format: int64
                          description: 'Return code for DBA action  enumValues: 0001=Warning,0002=General error,0000=Everything OK,0003=Detailed error'
                          enum:
                          - '0001'
                          - '0002'
                          - '0000'
                          - '0003'
                        ENDE:
                          type: string
                          maxLength: 14
                          description: End of database operation
                        ACTID:
                          type: string
                          maxLength: 16
                          description: Name of DBA Log
                        LINE:
                          type: string
                          maxLength: 254
                          description: Text Line for DBA Logs
        '400':
          description: Bad request.
        5XX:
          description: Unexpected error.
