openapi: 3.0.0
info:
  title: SAP API
  version: 1.0.0
servers:
- url: http://localhost:8080
paths:
  /rfc/DB6_HIS_PERFORMANCE_DETAIL:
    post:
      tags:
      - SDB6DB02
      summary: 'DB6: get database performance history details'
      operationId: /rfc/DB6_HIS_PERFORMANCE_DETAIL
      requestBody:
        content:
          application/json:
            schema:
              properties:
                COMPDATS:
                  type: string
                  format: date
                  description: 'DB6: Row insert date'
                CONNECTION:
                  type: string
                  maxLength: 30
                  description: Logical name for a database connection
                PARTITN:
                  type: integer
                  format: int32
                  description: 'DB6: partition number'
                IT_DB6PM_SD_INTERVALL:
                  type: array
                  items:
                    type: object
                    properties:
                      PARTITN:
                        type: integer
                        format: int32
                        description: 'DB6: partition number'
                      COMPDATS:
                        type: string
                        format: date
                        description: 'DB6: Row insert date'
                      COMPTIMS:
                        type: string
                        maxLength: 6
                        description: 'DB6: Row insert time'
                      COMPTIMS2:
                        type: string
                        maxLength: 6
                        description: 'DB6: Row insert time of next record (for intervall calc)'
                      PL_D_LRS:
                        type: integer
                        format: int64
                        description: 'DB6: data logical reads'
                      PL_D_PRS:
                        type: integer
                        format: int64
                        description: 'DB6: data physical reads'
                      PL_D_WS:
                        type: integer
                        format: int64
                        description: 'DB6: data physical writes'
                      PL_I_LRS:
                        type: integer
                        format: int64
                        description: 'DB6: index logical reads'
                      PL_I_PRS:
                        type: integer
                        format: int64
                        description: 'DB6: index physical reads'
                      PL_I_WS:
                        type: integer
                        format: int64
                        description: 'DB6: index physical writes'
                      CMMT_SQLST:
                        type: integer
                        format: int64
                        description: 'DB6: commit statements'
                      RBCK_SQLST:
                        type: integer
                        format: int64
                        description: 'DB6: rollback statements'
                      LCK_WAITS:
                        type: integer
                        format: int64
                        description: 'DB6: lockwaits since 1st db connection'
                      LCK_W_TM:
                        type: integer
                        format: int64
                        description: 'DB6: total time db waited on locks in milliseconds'
                      DEADLOCKS:
                        type: integer
                        format: int64
                        description: 'DB6: deadlocks since 1st db connection'
                      LCK_ESCALS:
                        type: integer
                        format: int64
                        description: 'DB6: lock escalations since 1st db connection'
                      XLK_ESCALS:
                        type: integer
                        format: int64
                        description: 'DB6: X lock escalations since 1st db connection'
                      BP_AV_RTM:
                        type: integer
                        format: int64
                        description: 'DB6: Average Physical Read Time (ms)'
                      BP_AV_WTM:
                        type: integer
                        format: int64
                        description: 'DB6: Average Physical Write Time (ms)'
                IT_DB6PM_SD_SNAPSHOT:
                  type: array
                  items:
                    type: object
                    properties:
                      PARTITN:
                        type: integer
                        format: int32
                        description: 'DB6: partition number'
                      COMPDATS:
                        type: string
                        format: date
                        description: 'DB6: Row insert date'
                      COMPTIMS:
                        type: string
                        maxLength: 6
                        description: 'DB6: Row insert time'
                      COMPTIMS2:
                        type: string
                        maxLength: 6
                        description: 'DB6: Row insert time of next record (for intervall calc)'
                      PL_D_LRS:
                        type: integer
                        format: int64
                        description: 'DB6: data logical reads'
                      PL_D_PRS:
                        type: integer
                        format: int64
                        description: 'DB6: data physical reads'
                      PL_D_WS:
                        type: integer
                        format: int64
                        description: 'DB6: data physical writes'
                      PL_I_LRS:
                        type: integer
                        format: int64
                        description: 'DB6: index logical reads'
                      PL_I_PRS:
                        type: integer
                        format: int64
                        description: 'DB6: index physical reads'
                      PL_I_WS:
                        type: integer
                        format: int64
                        description: 'DB6: index physical writes'
                      CMMT_SQLST:
                        type: integer
                        format: int64
                        description: 'DB6: commit statements'
                      RBCK_SQLST:
                        type: integer
                        format: int64
                        description: 'DB6: rollback statements'
                      LCK_WAITS:
                        type: integer
                        format: int64
                        description: 'DB6: lockwaits since 1st db connection'
                      LCK_W_TM:
                        type: integer
                        format: int64
                        description: 'DB6: total time db waited on locks in milliseconds'
                      DEADLOCKS:
                        type: integer
                        format: int64
                        description: 'DB6: deadlocks since 1st db connection'
                      LCK_ESCALS:
                        type: integer
                        format: int64
                        description: 'DB6: lock escalations since 1st db connection'
                      XLK_ESCALS:
                        type: integer
                        format: int64
                        description: 'DB6: X lock escalations since 1st db connection'
                      BP_AV_RTM:
                        type: integer
                        format: int64
                        description: 'DB6: Average Physical Read Time (ms)'
                      BP_AV_WTM:
                        type: integer
                        format: int64
                        description: 'DB6: Average Physical Write Time (ms)'
              required:
              - COMPDATS
              - PARTITN
      responses:
        '200':
          description: OK
          content:
            application/json:
              schema:
                properties:
                  IT_DB6PM_SD_INTERVALL:
                    type: array
                    items:
                      type: object
                      properties:
                        PARTITN:
                          type: integer
                          format: int32
                          description: 'DB6: partition number'
                        COMPDATS:
                          type: string
                          format: date
                          description: 'DB6: Row insert date'
                        COMPTIMS:
                          type: string
                          maxLength: 6
                          description: 'DB6: Row insert time'
                        COMPTIMS2:
                          type: string
                          maxLength: 6
                          description: 'DB6: Row insert time of next record (for intervall calc)'
                        PL_D_LRS:
                          type: integer
                          format: int64
                          description: 'DB6: data logical reads'
                        PL_D_PRS:
                          type: integer
                          format: int64
                          description: 'DB6: data physical reads'
                        PL_D_WS:
                          type: integer
                          format: int64
                          description: 'DB6: data physical writes'
                        PL_I_LRS:
                          type: integer
                          format: int64
                          description: 'DB6: index logical reads'
                        PL_I_PRS:
                          type: integer
                          format: int64
                          description: 'DB6: index physical reads'
                        PL_I_WS:
                          type: integer
                          format: int64
                          description: 'DB6: index physical writes'
                        CMMT_SQLST:
                          type: integer
                          format: int64
                          description: 'DB6: commit statements'
                        RBCK_SQLST:
                          type: integer
                          format: int64
                          description: 'DB6: rollback statements'
                        LCK_WAITS:
                          type: integer
                          format: int64
                          description: 'DB6: lockwaits since 1st db connection'
                        LCK_W_TM:
                          type: integer
                          format: int64
                          description: 'DB6: total time db waited on locks in milliseconds'
                        DEADLOCKS:
                          type: integer
                          format: int64
                          description: 'DB6: deadlocks since 1st db connection'
                        LCK_ESCALS:
                          type: integer
                          format: int64
                          description: 'DB6: lock escalations since 1st db connection'
                        XLK_ESCALS:
                          type: integer
                          format: int64
                          description: 'DB6: X lock escalations since 1st db connection'
                        BP_AV_RTM:
                          type: integer
                          format: int64
                          description: 'DB6: Average Physical Read Time (ms)'
                        BP_AV_WTM:
                          type: integer
                          format: int64
                          description: 'DB6: Average Physical Write Time (ms)'
                  IT_DB6PM_SD_SNAPSHOT:
                    type: array
                    items:
                      type: object
                      properties:
                        PARTITN:
                          type: integer
                          format: int32
                          description: 'DB6: partition number'
                        COMPDATS:
                          type: string
                          format: date
                          description: 'DB6: Row insert date'
                        COMPTIMS:
                          type: string
                          maxLength: 6
                          description: 'DB6: Row insert time'
                        COMPTIMS2:
                          type: string
                          maxLength: 6
                          description: 'DB6: Row insert time of next record (for intervall calc)'
                        PL_D_LRS:
                          type: integer
                          format: int64
                          description: 'DB6: data logical reads'
                        PL_D_PRS:
                          type: integer
                          format: int64
                          description: 'DB6: data physical reads'
                        PL_D_WS:
                          type: integer
                          format: int64
                          description: 'DB6: data physical writes'
                        PL_I_LRS:
                          type: integer
                          format: int64
                          description: 'DB6: index logical reads'
                        PL_I_PRS:
                          type: integer
                          format: int64
                          description: 'DB6: index physical reads'
                        PL_I_WS:
                          type: integer
                          format: int64
                          description: 'DB6: index physical writes'
                        CMMT_SQLST:
                          type: integer
                          format: int64
                          description: 'DB6: commit statements'
                        RBCK_SQLST:
                          type: integer
                          format: int64
                          description: 'DB6: rollback statements'
                        LCK_WAITS:
                          type: integer
                          format: int64
                          description: 'DB6: lockwaits since 1st db connection'
                        LCK_W_TM:
                          type: integer
                          format: int64
                          description: 'DB6: total time db waited on locks in milliseconds'
                        DEADLOCKS:
                          type: integer
                          format: int64
                          description: 'DB6: deadlocks since 1st db connection'
                        LCK_ESCALS:
                          type: integer
                          format: int64
                          description: 'DB6: lock escalations since 1st db connection'
                        XLK_ESCALS:
                          type: integer
                          format: int64
                          description: 'DB6: X lock escalations since 1st db connection'
                        BP_AV_RTM:
                          type: integer
                          format: int64
                          description: 'DB6: Average Physical Read Time (ms)'
                        BP_AV_WTM:
                          type: integer
                          format: int64
                          description: 'DB6: Average Physical Write Time (ms)'
        '400':
          description: Bad request.
        5XX:
          description: Unexpected error.
