openapi: 3.0.0
info:
  title: SAP API
  version: 1.0.0
servers:
- url: http://localhost:8080
paths:
  /rfc/DB6_PM_DB6CSTRC_APPSERV:
    post:
      tags:
      - SDB6CSTRACE
      summary: 'DB6: Get Summary for Cumulative SQL Trace'
      operationId: /rfc/DB6_PM_DB6CSTRC_APPSERV
      requestBody:
        content:
          application/json:
            schema:
              properties:
                CONNECTION:
                  type: string
                  maxLength: 30
                  description: Logical name for a database connection
                OPTLEVEL:
                  type: string
                  maxLength: 1
                  description: Database Optimization Level
                STMT_STR:
                  type: string
                  maxLength: 200
                  description: First 200 Characters of the Statement Text
                STMT_STR_LEN:
                  type: integer
                  format: int32
                  description: Length of SQL Statement
                TABLENAME:
                  type: string
                  maxLength: 16
                  description: Name of the First Table in the SQL Statement
                APPSERVER:
                  type: array
                  items:
                    type: object
                    properties:
                      PID:
                        type: integer
                        format: int32
                        description: Process ID
                      DBNAME:
                        type: string
                        maxLength: 16
                        description: Database Name
                      APPSERV:
                        type: string
                        maxLength: 64
                        description: Application Server Name
                      DMODTYPE:
                        type: integer
                        format: int32
                        description: 'DBSL_STMTID: Module Type'
                      DMODULE:
                        type: string
                        maxLength: 40
                        description: 'DBSL_STMTID: Module'
                      TIMESTAMP:
                        type: string
                        maxLength: 15
                        description: 'DBSL_STMTID: Timestamp'
                      STMTNUM:
                        type: integer
                        format: int32
                        description: 'DBSL_STMTID: Statement Number'
                      OPTLEVEL:
                        type: string
                        maxLength: 1
                        description: Database Optimization Level
                      TABLENAME:
                        type: string
                        maxLength: 16
                        description: Name of the First Table in the SQL Statement
                      PROG:
                        type: string
                        maxLength: 40
                        description: Name of ABAP Program
                      CONT:
                        type: integer
                        format: int32
                        description: Position in ABAP Program
                      FIRST_TIME:
                        type: string
                        maxLength: 26
                        description: Time of First Execution
                      LAST_TIME:
                        type: string
                        maxLength: 26
                        description: Time of Last Execution
                      PREP_CNT:
                        type: integer
                        format: int32
                        description: Number of PREPARE Calls
                      EXEC_CNT:
                        type: integer
                        format: int32
                        description: Number of EXECUTE Calls
                      FET_CNT:
                        type: integer
                        format: int32
                        description: Number of FETCH Calls
                      EFET_CNT:
                        type: integer
                        format: int32
                        description: Number of Extended FETCH Calls
                      CLSE_CNT:
                        type: integer
                        format: int32
                        description: Number of CLOSE Calls
                      PREP_TIME:
                        type: integer
                        format: int32
                        description: Total Duration of PREPARE Calls
                      EXEC_TIME:
                        type: integer
                        format: int32
                        description: Total Duration of EXECUTE Calls
                      FET_TIME:
                        type: integer
                        format: int32
                        description: Total Duration of FETCH Calls
                      EFET_TIME:
                        type: integer
                        format: int32
                        description: Total Duration of Extended FETCH Calls
                      CLSE_TIME:
                        type: integer
                        format: int32
                        description: Total Duration of CLOSE Calls
                      PREP_5S:
                        type: integer
                        format: int32
                        description: Number of PREPARE Calls with Duration of 5s or More
                      PREP_1S:
                        type: integer
                        format: int32
                        description: Number of PREPARE Calls with Duration of 1s or More
                      PREP_500MS:
                        type: integer
                        format: int32
                        description: Number of PREPARE Calls with Duration of 500ms or More
                      PREP_100MS:
                        type: integer
                        format: int32
                        description: Number of PREPARE Calls with Duration of 100ms or More
                      PREP_50MS:
                        type: integer
                        format: int32
                        description: Number of PREPARE Calls with Duration of 50ms or More
                      PREP_20MS:
                        type: integer
                        format: int32
                        description: Number of PREPARE Calls with Duration of 20ms or More
                      PREP_10MS:
                        type: integer
                        format: int32
                        description: Number of PREPARE Calls with Duration of 10ms or More
                      PREP_5MS:
                        type: integer
                        format: int32
                        description: Number of PREPARE Calls with Duration of 5ms or More
                      PREP_2MS:
                        type: integer
                        format: int32
                        description: Number of PREPARE Calls with Duration of 2ms or More
                      PREP_1MS:
                        type: integer
                        format: int32
                        description: Number of PREPARE Calls with Duration of 1ms or More
                      PREP_LT1MS:
                        type: integer
                        format: int32
                        description: Number of PREPARE Calls with Duration Less than 100ms
                      EXEC_5S:
                        type: integer
                        format: int32
                        description: Number of EXECUTE Calls with Duration of 5s or More
                      EXEC_1S:
                        type: integer
                        format: int32
                        description: Number of EXECUTE Calls with Duration of 1s or More
                      EXEC_500MS:
                        type: integer
                        format: int32
                        description: Number of EXECUTE Calls with Duration of 500ms or More
                      EXEC_100MS:
                        type: integer
                        format: int32
                        description: Number of EXECUTE Calls with Duration of 100ms or More
                      EXEC_50MS:
                        type: integer
                        format: int32
                        description: Number of EXECUTE Calls with Duration of 50ms or More
                      EXEC_20MS:
                        type: integer
                        format: int32
                        description: Number of EXECUTE Calls with Duration of 20ms or More
                      EXEC_10MS:
                        type: integer
                        format: int32
                        description: Number of EXECUTE Calls with Duration of 10ms or More
                      EXEC_5MS:
                        type: integer
                        format: int32
                        description: Number of EXECUTE Calls with Duration of 5ms or More
                      EXEC_2MS:
                        type: integer
                        format: int32
                        description: Number of EXECUTE Calls with Duration of 2ms or More
                      EXEC_1MS:
                        type: integer
                        format: int32
                        description: Number of EXECUTE Calls with Duration of 1ms or More
                      EXEC_LT1MS:
                        type: integer
                        format: int32
                        description: Number of EXECUTE Calls with Duration less than 1ms
                      FET_5S:
                        type: integer
                        format: int32
                        description: Number of FETCH Calls with Duration of 5s or More
                      FET_1S:
                        type: integer
                        format: int32
                        description: Number of FETCH Calls with Duration of 1s or More
                      FET_500MS:
                        type: integer
                        format: int32
                        description: Number of FETCH Calls with Duration of 500ms or More
                      FET_100MS:
                        type: integer
                        format: int32
                        description: Number of FETCH Calls with Duration of 100ms or More
                      FET_50MS:
                        type: integer
                        format: int32
                        description: Number of FETCH Calls with Duration of 50ms or More
                      FET_20MS:
                        type: integer
                        format: int32
                        description: Number of FETCH Calls with Duration of 20ms or More
                      FET_10MS:
                        type: integer
                        format: int32
                        description: Number of FETCH Calls with Duration of 10ms or More
                      FET_5MS:
                        type: integer
                        format: int32
                        description: Number of FETCH Calls with Duration of 5ms or More
                      FET_2MS:
                        type: integer
                        format: int32
                        description: Number of FETCH Calls with Duration of 2ms or More
                      FET_1MS:
                        type: integer
                        format: int32
                        description: Number of FETCH Calls with Duration of 1ms or More
                      FET_LT1MS:
                        type: integer
                        format: int32
                        description: Number of FETCH Calls with Duration Less than 1ms
                      EFET_5S:
                        type: integer
                        format: int32
                        description: Number of FETCH Calls with Duration of 5s or More
                      EFET_1S:
                        type: integer
                        format: int32
                        description: No. of Extended FETCH Calls with Duration of 1s or More
                      EFET_500MS:
                        type: integer
                        format: int32
                        description: No. of Extended FETCH Calls with Duration of 500ms or More
                      EFET_100MS:
                        type: integer
                        format: int32
                        description: No. of Extended FETCH Calls with Duration of 100ms or More
                      EFET_50MS:
                        type: integer
                        format: int32
                        description: No. of Extended FETCH Calls with Duration of 50ms or More
                      EFET_20MS:
                        type: integer
                        format: int32
                        description: No. of Extended FETCH Calls with Duration of 20ms or More
                      EFET_10MS:
                        type: integer
                        format: int32
                        description: No. of Extended FETCH Calls with Duration of 10ms or More
                      EFET_5MS:
                        type: integer
                        format: int32
                        description: No. of Extended FETCH Calls with Duration of 5ms or More
                      EFET_2MS:
                        type: integer
                        format: int32
                        description: No. of Extended FETCH Calls with Duration of 2ms or More
                      EFET_1MS:
                        type: integer
                        format: int32
                        description: No. of Extended FETCH Calls with Duration of 1ms or More
                      EFET_LT1MS:
                        type: integer
                        format: int32
                        description: No. of Extended FETCH Calls with Duration Less than 1ms
                      CLSE_5S:
                        type: integer
                        format: int32
                        description: Number of CLOSE Calls with Duration of 5s or More
                      CLSE_1S:
                        type: integer
                        format: int32
                        description: Number of CLOSE Calls with Duration of 1s or More
                      CLSE_500MS:
                        type: integer
                        format: int32
                        description: Number of CLOSE Calls with Duration of 500ms or More
                      CLSE_100MS:
                        type: integer
                        format: int32
                        description: Number of CLOSE Calls with Duration of 100ms or More
                      CLSE_50MS:
                        type: integer
                        format: int32
                        description: Number of CLOSE Calls with Duration of 50ms or More
                      CLSE_20MS:
                        type: integer
                        format: int32
                        description: Number of CLOSE Calls with Duration of 20ms or More
                      CLSE_10MS:
                        type: integer
                        format: int32
                        description: Number of CLOSE Calls with Duration of 10ms or More
                      CLSE_5MS:
                        type: integer
                        format: int32
                        description: Number of CLOSE Calls with Duration of 5ms or More
                      CLSE_2MS:
                        type: integer
                        format: int32
                        description: Number of CLOSE Calls with Duration of 2ms or More
                      CLSE_1MS:
                        type: integer
                        format: int32
                        description: Number of CLOSE Calls with Duration of 1ms or More
                      CLSE_LT1MS:
                        type: integer
                        format: int32
                        description: Number of CLOSE Calls with Duration Less than 1ms
                      STMT_SUBST:
                        type: string
                        maxLength: 200
                        description: First 200 Characters of the Statement Text
                      STMT_LEN:
                        type: integer
                        format: int32
                        description: Length of SQL Statement
                      STMT_TEXT:
                        type: string
                        maxLength: 30000
                        description: SQL Statement Text
              required:
              - OPTLEVEL
              - STMT_STR
              - STMT_STR_LEN
              - TABLENAME
      responses:
        '200':
          description: OK
          content:
            application/json:
              schema:
                properties:
                  APPSERVER:
                    type: array
                    items:
                      type: object
                      properties:
                        PID:
                          type: integer
                          format: int32
                          description: Process ID
                        DBNAME:
                          type: string
                          maxLength: 16
                          description: Database Name
                        APPSERV:
                          type: string
                          maxLength: 64
                          description: Application Server Name
                        DMODTYPE:
                          type: integer
                          format: int32
                          description: 'DBSL_STMTID: Module Type'
                        DMODULE:
                          type: string
                          maxLength: 40
                          description: 'DBSL_STMTID: Module'
                        TIMESTAMP:
                          type: string
                          maxLength: 15
                          description: 'DBSL_STMTID: Timestamp'
                        STMTNUM:
                          type: integer
                          format: int32
                          description: 'DBSL_STMTID: Statement Number'
                        OPTLEVEL:
                          type: string
                          maxLength: 1
                          description: Database Optimization Level
                        TABLENAME:
                          type: string
                          maxLength: 16
                          description: Name of the First Table in the SQL Statement
                        PROG:
                          type: string
                          maxLength: 40
                          description: Name of ABAP Program
                        CONT:
                          type: integer
                          format: int32
                          description: Position in ABAP Program
                        FIRST_TIME:
                          type: string
                          maxLength: 26
                          description: Time of First Execution
                        LAST_TIME:
                          type: string
                          maxLength: 26
                          description: Time of Last Execution
                        PREP_CNT:
                          type: integer
                          format: int32
                          description: Number of PREPARE Calls
                        EXEC_CNT:
                          type: integer
                          format: int32
                          description: Number of EXECUTE Calls
                        FET_CNT:
                          type: integer
                          format: int32
                          description: Number of FETCH Calls
                        EFET_CNT:
                          type: integer
                          format: int32
                          description: Number of Extended FETCH Calls
                        CLSE_CNT:
                          type: integer
                          format: int32
                          description: Number of CLOSE Calls
                        PREP_TIME:
                          type: integer
                          format: int32
                          description: Total Duration of PREPARE Calls
                        EXEC_TIME:
                          type: integer
                          format: int32
                          description: Total Duration of EXECUTE Calls
                        FET_TIME:
                          type: integer
                          format: int32
                          description: Total Duration of FETCH Calls
                        EFET_TIME:
                          type: integer
                          format: int32
                          description: Total Duration of Extended FETCH Calls
                        CLSE_TIME:
                          type: integer
                          format: int32
                          description: Total Duration of CLOSE Calls
                        PREP_5S:
                          type: integer
                          format: int32
                          description: Number of PREPARE Calls with Duration of 5s or More
                        PREP_1S:
                          type: integer
                          format: int32
                          description: Number of PREPARE Calls with Duration of 1s or More
                        PREP_500MS:
                          type: integer
                          format: int32
                          description: Number of PREPARE Calls with Duration of 500ms or More
                        PREP_100MS:
                          type: integer
                          format: int32
                          description: Number of PREPARE Calls with Duration of 100ms or More
                        PREP_50MS:
                          type: integer
                          format: int32
                          description: Number of PREPARE Calls with Duration of 50ms or More
                        PREP_20MS:
                          type: integer
                          format: int32
                          description: Number of PREPARE Calls with Duration of 20ms or More
                        PREP_10MS:
                          type: integer
                          format: int32
                          description: Number of PREPARE Calls with Duration of 10ms or More
                        PREP_5MS:
                          type: integer
                          format: int32
                          description: Number of PREPARE Calls with Duration of 5ms or More
                        PREP_2MS:
                          type: integer
                          format: int32
                          description: Number of PREPARE Calls with Duration of 2ms or More
                        PREP_1MS:
                          type: integer
                          format: int32
                          description: Number of PREPARE Calls with Duration of 1ms or More
                        PREP_LT1MS:
                          type: integer
                          format: int32
                          description: Number of PREPARE Calls with Duration Less than 100ms
                        EXEC_5S:
                          type: integer
                          format: int32
                          description: Number of EXECUTE Calls with Duration of 5s or More
                        EXEC_1S:
                          type: integer
                          format: int32
                          description: Number of EXECUTE Calls with Duration of 1s or More
                        EXEC_500MS:
                          type: integer
                          format: int32
                          description: Number of EXECUTE Calls with Duration of 500ms or More
                        EXEC_100MS:
                          type: integer
                          format: int32
                          description: Number of EXECUTE Calls with Duration of 100ms or More
                        EXEC_50MS:
                          type: integer
                          format: int32
                          description: Number of EXECUTE Calls with Duration of 50ms or More
                        EXEC_20MS:
                          type: integer
                          format: int32
                          description: Number of EXECUTE Calls with Duration of 20ms or More
                        EXEC_10MS:
                          type: integer
                          format: int32
                          description: Number of EXECUTE Calls with Duration of 10ms or More
                        EXEC_5MS:
                          type: integer
                          format: int32
                          description: Number of EXECUTE Calls with Duration of 5ms or More
                        EXEC_2MS:
                          type: integer
                          format: int32
                          description: Number of EXECUTE Calls with Duration of 2ms or More
                        EXEC_1MS:
                          type: integer
                          format: int32
                          description: Number of EXECUTE Calls with Duration of 1ms or More
                        EXEC_LT1MS:
                          type: integer
                          format: int32
                          description: Number of EXECUTE Calls with Duration less than 1ms
                        FET_5S:
                          type: integer
                          format: int32
                          description: Number of FETCH Calls with Duration of 5s or More
                        FET_1S:
                          type: integer
                          format: int32
                          description: Number of FETCH Calls with Duration of 1s or More
                        FET_500MS:
                          type: integer
                          format: int32
                          description: Number of FETCH Calls with Duration of 500ms or More
                        FET_100MS:
                          type: integer
                          format: int32
                          description: Number of FETCH Calls with Duration of 100ms or More
                        FET_50MS:
                          type: integer
                          format: int32
                          description: Number of FETCH Calls with Duration of 50ms or More
                        FET_20MS:
                          type: integer
                          format: int32
                          description: Number of FETCH Calls with Duration of 20ms or More
                        FET_10MS:
                          type: integer
                          format: int32
                          description: Number of FETCH Calls with Duration of 10ms or More
                        FET_5MS:
                          type: integer
                          format: int32
                          description: Number of FETCH Calls with Duration of 5ms or More
                        FET_2MS:
                          type: integer
                          format: int32
                          description: Number of FETCH Calls with Duration of 2ms or More
                        FET_1MS:
                          type: integer
                          format: int32
                          description: Number of FETCH Calls with Duration of 1ms or More
                        FET_LT1MS:
                          type: integer
                          format: int32
                          description: Number of FETCH Calls with Duration Less than 1ms
                        EFET_5S:
                          type: integer
                          format: int32
                          description: Number of FETCH Calls with Duration of 5s or More
                        EFET_1S:
                          type: integer
                          format: int32
                          description: No. of Extended FETCH Calls with Duration of 1s or More
                        EFET_500MS:
                          type: integer
                          format: int32
                          description: No. of Extended FETCH Calls with Duration of 500ms or More
                        EFET_100MS:
                          type: integer
                          format: int32
                          description: No. of Extended FETCH Calls with Duration of 100ms or More
                        EFET_50MS:
                          type: integer
                          format: int32
                          description: No. of Extended FETCH Calls with Duration of 50ms or More
                        EFET_20MS:
                          type: integer
                          format: int32
                          description: No. of Extended FETCH Calls with Duration of 20ms or More
                        EFET_10MS:
                          type: integer
                          format: int32
                          description: No. of Extended FETCH Calls with Duration of 10ms or More
                        EFET_5MS:
                          type: integer
                          format: int32
                          description: No. of Extended FETCH Calls with Duration of 5ms or More
                        EFET_2MS:
                          type: integer
                          format: int32
                          description: No. of Extended FETCH Calls with Duration of 2ms or More
                        EFET_1MS:
                          type: integer
                          format: int32
                          description: No. of Extended FETCH Calls with Duration of 1ms or More
                        EFET_LT1MS:
                          type: integer
                          format: int32
                          description: No. of Extended FETCH Calls with Duration Less than 1ms
                        CLSE_5S:
                          type: integer
                          format: int32
                          description: Number of CLOSE Calls with Duration of 5s or More
                        CLSE_1S:
                          type: integer
                          format: int32
                          description: Number of CLOSE Calls with Duration of 1s or More
                        CLSE_500MS:
                          type: integer
                          format: int32
                          description: Number of CLOSE Calls with Duration of 500ms or More
                        CLSE_100MS:
                          type: integer
                          format: int32
                          description: Number of CLOSE Calls with Duration of 100ms or More
                        CLSE_50MS:
                          type: integer
                          format: int32
                          description: Number of CLOSE Calls with Duration of 50ms or More
                        CLSE_20MS:
                          type: integer
                          format: int32
                          description: Number of CLOSE Calls with Duration of 20ms or More
                        CLSE_10MS:
                          type: integer
                          format: int32
                          description: Number of CLOSE Calls with Duration of 10ms or More
                        CLSE_5MS:
                          type: integer
                          format: int32
                          description: Number of CLOSE Calls with Duration of 5ms or More
                        CLSE_2MS:
                          type: integer
                          format: int32
                          description: Number of CLOSE Calls with Duration of 2ms or More
                        CLSE_1MS:
                          type: integer
                          format: int32
                          description: Number of CLOSE Calls with Duration of 1ms or More
                        CLSE_LT1MS:
                          type: integer
                          format: int32
                          description: Number of CLOSE Calls with Duration Less than 1ms
                        STMT_SUBST:
                          type: string
                          maxLength: 200
                          description: First 200 Characters of the Statement Text
                        STMT_LEN:
                          type: integer
                          format: int32
                          description: Length of SQL Statement
                        STMT_TEXT:
                          type: string
                          maxLength: 30000
                          description: SQL Statement Text
        '400':
          description: Bad request.
        5XX:
          description: Unexpected error.
