openapi: 3.0.0
info:
  title: SAP API
  version: 1.0.0
servers:
- url: http://localhost:8080
paths:
  /rfc/ST04_DB4_GET_SQR_INFO:
    post:
      tags:
      - STU4_ST04
      summary: 'AS/400: Get SQL Requests/Top50 info for ST04 Detail Analysis'
      operationId: /rfc/ST04_DB4_GET_SQR_INFO
      requestBody:
        content:
          application/json:
            schema:
              properties:
                CURRENT_SYSTEM:
                  type: object
                  properties:
                    SYSID:
                      type: string
                      maxLength: 8
                      description: Name of the SAP System
                    SAPREL:
                      type: string
                      maxLength: 4
                      description: Release Status of SAP System
                    DBREL:
                      type: string
                      maxLength: 10
                      description: 'DB6: Database Release Level'
                    RFCDEST:
                      type: string
                      maxLength: 32
                      description: Logical Destination (Specified in Function Call)
                    DBHOST:
                      type: string
                      maxLength: 255
                      description: 'DBA Cockpit: Server Name'
                    SCHEMANAME:
                      type: string
                      maxLength: 20
                      description: 'DB6: Schema Name'
                    ENTRYSTATE:
                      type: integer
                      format: int32
                      description: 'State of entry: 1=INITIAL,2=COMPLETE,3=DISABLED'
                    ENTRYTYPE:
                      type: integer
                      format: int32
                      description: 'kind of system: 1=R/3 ,2=Non R/3'
                    DBCNAME:
                      type: string
                      maxLength: 30
                      description: Logical name for a database connection
                    DBSYS:
                      type: string
                      maxLength: 3
                      description: 'Database system  enumValues: DB2=DB2 UDB for OS/390,MSS=Microsoft SQL Server,ADA=SAP DB (ADABAS/D),INF=Informix,ORA=Oracle,DB4=DB2 UDB for AS/400,DB6=DB2 UDB for Unix and Windows'
                      enum:
                      - DB2
                      - MSS
                      - ADA
                      - INF
                      - ORA
                      - DB4
                      - DB6
                    DB_OPSYS:
                      type: string
                      maxLength: 10
                      description: Operating System of Application Server
                    COCKREL:
                      type: string
                      maxLength: 4
                      description: Release Status of SAP System
                    REALSID:
                      type: string
                      maxLength: 8
                      description: Name of the SAP System
                    DBSID:
                      type: string
                      maxLength: 128
                      description: 'DBA Cockpit: Database Name'
                    RZ20_MON:
                      type: string
                      maxLength: 1
                      description: Remote Alert Monitoring active ('X')/inactive (' ')
                    HIST_MON:
                      type: string
                      maxLength: 1
                      description: Remote History Collection active('X')/inactive(' ')
                    DESCRIPTION:
                      type: string
                      maxLength: 80
                      description: ''
                    CHANGEDATE:
                      type: string
                      format: date
                      description: Current Date of Application Server
                    CHANGETIME:
                      type: string
                      maxLength: 6
                      description: Current Time of Application Server
                    CHANGED_BY:
                      type: string
                      maxLength: 12
                      description: User Name
                    SYSTEMTYPE:
                      type: string
                      maxLength: 7
                      description: 'SAP DB: Instance Type  enumValues: CS=Content Server Database,LVC=liveCache,BW=Business Warehouse Database,OLTP=Online Transaction Processing Database'
                      enum:
                      - CS
                      - LVC
                      - BW
                      - OLTP
                    RFCDEST_2:
                      type: string
                      maxLength: 32
                      description: Logical Destination (Specified in Function Call)
                    REMOTE_COLL:
                      type: string
                      maxLength: 1
                      description: Collect data remote('X') or local (' ')
                    DBCON_VIA_RFC:
                      type: string
                      maxLength: 1
                      description: DB Connection via RFC Destination
                    PROMPT_USER_DATA:
                      type: string
                      maxLength: 1
                      description: Store password permanent
                    SLD_NAME:
                      type: string
                      maxLength: 255
                      description: ''
                    SLD_UPDATE:
                      type: string
                      maxLength: 14
                      description: 'DB6: Timestamp (Format: YYYYMMDDHHMMSS)'
                    DB13C_MON:
                      type: string
                      maxLength: 1
                      description: DB13C Integration active('X')/inactive('')
                LIMIT_ROWS:
                  type: string
                  default: X
                  maxLength: 1
                  description: Only the 50 slowest statement are to be selected
                MAX_ROWS:
                  type: integer
                  format: int32
                  default: 300
                  description: Feld vom Typ CHAR z.Zt nicht verwendet
                RESETFLAG:
                  type: string
                  default: ' '
                  maxLength: 1
                  description: Feld vom Typ CHAR z.Zt nicht verwendet
                SELECTION_SET:
                  type: object
                  properties:
                    SYSID:
                      type: string
                      maxLength: 8
                      description: Name of the SAP System
                    IPLTIME:
                      type: string
                      maxLength: 14
                      description: Text field length 14
                    QQKEY:
                      type: string
                      maxLength: 17
                      description: 'iSeries: Key Field (Database Monitor)'
                    QQPLIB:
                      type: string
                      maxLength: 10
                      description: 'iSeries: Package/Program Library (Database Monitor)'
                    QQPNAM:
                      type: string
                      maxLength: 10
                      description: 'iSeries: Package/Program Name (Database Monitor)'
                    QQSNAM:
                      type: string
                      maxLength: 18
                      description: 'iSeries: Statement Name (Database Monitor)'
                    QQCNAM:
                      type: string
                      maxLength: 18
                      description: 'iSeries: Cursor Name (Database Monitor)'
                    QQSTF:
                      type: string
                      maxLength: 1
                      description: 'iSeries: Statement Function (Database Monitor)  enumValues: D=Delete,S=Select,O=Other (Commit, Rollback,...),I=Insert,U=Update,L=DDL'
                      enum:
                      - D
                      - S
                      - O
                      - I
                      - U
                      - L
                    TOTTIME:
                      type: integer
                      format: int64
                      description: 'iSeries: Total Time (Database Monitor)'
                    QQCNT:
                      type: integer
                      format: int64
                      description: 'iSeries: No. of Executions of a Statement (Database Monitor)'
                    QQARSS:
                      type: integer
                      format: int64
                      description: 'iSeries: Average Result Set Size (Database Monitor)'
                    QQAVGT:
                      type: integer
                      format: int64
                      description: 'iSeries:  Average Time (Database Monitor)'
                    QQMINT:
                      type: integer
                      format: int64
                      description: 'iSeries: Minimum Time  (Database Monitor)'
                    QQMAXT:
                      type: integer
                      format: int64
                      description: 'iSeries: Maximum Time (Database Monitor)'
                    QQOPNT:
                      type: integer
                      format: int64
                      description: 'iSeries: Open time (Database  Monitor)'
                    QQFETT:
                      type: integer
                      format: int64
                      description: 'iSeries: FETCH time (Database Monitor)'
                    QQCLST:
                      type: integer
                      format: int64
                      description: 'iSeries: CLOSE time (Database Monitor)'
                    QQOTHT:
                      type: integer
                      format: int64
                      description: 'iSeries: Any other time (Database Monitor)'
                    QQLTU:
                      type: string
                      maxLength: 26
                      description: 'iSeries: Time Last Used (Database Monitor)'
                    QQMETU:
                      type: string
                      maxLength: 26
                      description: 'iSeries: Timest. of Most Expensive Stmt.  (Database Monitor)'
                    PFILE:
                      type: string
                      maxLength: 30
                      description: 'iSeries: Table Name  (Database Monitor)'
                    QQSTTX_LEN:
                      type: integer
                      format: int32
                      description: 2 byte integer (signed)
                    QQSTTX:
                      type: string
                      maxLength: 8000
                      description: 'iSeries: Statement Text (Database Monitor)'
                    QQUSER:
                      type: string
                      maxLength: 10
                      description: 'iSeries: Job User (Database Monitor)'
                TAB_NAME:
                  type: string
                  default: ' '
                  maxLength: 30
                  description: Table name
                SQR0100:
                  type: array
                  items:
                    type: object
                    properties:
                      SYSID:
                        type: string
                        maxLength: 8
                        description: Name of the SAP System
                      IPLTIME:
                        type: string
                        maxLength: 14
                        description: Text field length 14
                      QQKEY:
                        type: string
                        maxLength: 17
                        description: 'iSeries: Key Field (Database Monitor)'
                      QQPLIB:
                        type: string
                        maxLength: 10
                        description: 'iSeries: Package/Program Library (Database Monitor)'
                      QQPNAM:
                        type: string
                        maxLength: 10
                        description: 'iSeries: Package/Program Name (Database Monitor)'
                      QQSNAM:
                        type: string
                        maxLength: 18
                        description: 'iSeries: Statement Name (Database Monitor)'
                      QQCNAM:
                        type: string
                        maxLength: 18
                        description: 'iSeries: Cursor Name (Database Monitor)'
                      QQSTF:
                        type: string
                        maxLength: 1
                        description: 'iSeries: Statement Function (Database Monitor)  enumValues: D=Delete,S=Select,O=Other (Commit, Rollback,...),I=Insert,U=Update,L=DDL'
                        enum:
                        - D
                        - S
                        - O
                        - I
                        - U
                        - L
                      TOTTIME:
                        type: integer
                        format: int64
                        description: 'iSeries: Total Time (Database Monitor)'
                      QQCNT:
                        type: integer
                        format: int64
                        description: 'iSeries: No. of Executions of a Statement (Database Monitor)'
                      QQARSS:
                        type: integer
                        format: int64
                        description: 'iSeries: Average Result Set Size (Database Monitor)'
                      QQAVGT:
                        type: integer
                        format: int64
                        description: 'iSeries:  Average Time (Database Monitor)'
                      QQMINT:
                        type: integer
                        format: int64
                        description: 'iSeries: Minimum Time  (Database Monitor)'
                      QQMAXT:
                        type: integer
                        format: int64
                        description: 'iSeries: Maximum Time (Database Monitor)'
                      QQOPNT:
                        type: integer
                        format: int64
                        description: 'iSeries: Open time (Database  Monitor)'
                      QQFETT:
                        type: integer
                        format: int64
                        description: 'iSeries: FETCH time (Database Monitor)'
                      QQCLST:
                        type: integer
                        format: int64
                        description: 'iSeries: CLOSE time (Database Monitor)'
                      QQOTHT:
                        type: integer
                        format: int64
                        description: 'iSeries: Any other time (Database Monitor)'
                      QQLTU:
                        type: string
                        maxLength: 26
                        description: 'iSeries: Time Last Used (Database Monitor)'
                      QQMETU:
                        type: string
                        maxLength: 26
                        description: 'iSeries: Timest. of Most Expensive Stmt.  (Database Monitor)'
                      PFILE:
                        type: string
                        maxLength: 30
                        description: 'iSeries: Table Name  (Database Monitor)'
                      QQSTTX_LEN:
                        type: integer
                        format: int32
                        description: 2 byte integer (signed)
                      QQSTTX:
                        type: string
                        maxLength: 8000
                        description: 'iSeries: Statement Text (Database Monitor)'
                      QQUSER:
                        type: string
                        maxLength: 10
                        description: 'iSeries: Job User (Database Monitor)'
      responses:
        '200':
          description: OK
          content:
            application/json:
              schema:
                properties:
                  SQR0100:
                    type: array
                    items:
                      type: object
                      properties:
                        SYSID:
                          type: string
                          maxLength: 8
                          description: Name of the SAP System
                        IPLTIME:
                          type: string
                          maxLength: 14
                          description: Text field length 14
                        QQKEY:
                          type: string
                          maxLength: 17
                          description: 'iSeries: Key Field (Database Monitor)'
                        QQPLIB:
                          type: string
                          maxLength: 10
                          description: 'iSeries: Package/Program Library (Database Monitor)'
                        QQPNAM:
                          type: string
                          maxLength: 10
                          description: 'iSeries: Package/Program Name (Database Monitor)'
                        QQSNAM:
                          type: string
                          maxLength: 18
                          description: 'iSeries: Statement Name (Database Monitor)'
                        QQCNAM:
                          type: string
                          maxLength: 18
                          description: 'iSeries: Cursor Name (Database Monitor)'
                        QQSTF:
                          type: string
                          maxLength: 1
                          description: 'iSeries: Statement Function (Database Monitor)  enumValues: D=Delete,S=Select,O=Other (Commit, Rollback,...),I=Insert,U=Update,L=DDL'
                          enum:
                          - D
                          - S
                          - O
                          - I
                          - U
                          - L
                        TOTTIME:
                          type: integer
                          format: int64
                          description: 'iSeries: Total Time (Database Monitor)'
                        QQCNT:
                          type: integer
                          format: int64
                          description: 'iSeries: No. of Executions of a Statement (Database Monitor)'
                        QQARSS:
                          type: integer
                          format: int64
                          description: 'iSeries: Average Result Set Size (Database Monitor)'
                        QQAVGT:
                          type: integer
                          format: int64
                          description: 'iSeries:  Average Time (Database Monitor)'
                        QQMINT:
                          type: integer
                          format: int64
                          description: 'iSeries: Minimum Time  (Database Monitor)'
                        QQMAXT:
                          type: integer
                          format: int64
                          description: 'iSeries: Maximum Time (Database Monitor)'
                        QQOPNT:
                          type: integer
                          format: int64
                          description: 'iSeries: Open time (Database  Monitor)'
                        QQFETT:
                          type: integer
                          format: int64
                          description: 'iSeries: FETCH time (Database Monitor)'
                        QQCLST:
                          type: integer
                          format: int64
                          description: 'iSeries: CLOSE time (Database Monitor)'
                        QQOTHT:
                          type: integer
                          format: int64
                          description: 'iSeries: Any other time (Database Monitor)'
                        QQLTU:
                          type: string
                          maxLength: 26
                          description: 'iSeries: Time Last Used (Database Monitor)'
                        QQMETU:
                          type: string
                          maxLength: 26
                          description: 'iSeries: Timest. of Most Expensive Stmt.  (Database Monitor)'
                        PFILE:
                          type: string
                          maxLength: 30
                          description: 'iSeries: Table Name  (Database Monitor)'
                        QQSTTX_LEN:
                          type: integer
                          format: int32
                          description: 2 byte integer (signed)
                        QQSTTX:
                          type: string
                          maxLength: 8000
                          description: 'iSeries: Statement Text (Database Monitor)'
                        QQUSER:
                          type: string
                          maxLength: 10
                          description: 'iSeries: Job User (Database Monitor)'
        '400':
          description: Bad request.
        5XX:
          description: Unexpected error.
