openapi: 3.0.0
info:
  title: SAP API
  version: 1.0.0
servers:
- url: http://localhost:8080
paths:
  /rfc/STU3_GET_STATEMENT_STATISTICS:
    post:
      tags:
      - STU3
      operationId: /rfc/STU3_GET_STATEMENT_STATISTICS
      requestBody:
        content:
          application/json:
            schema:
              properties:
                DS_MEMBER_SPEC:
                  type: string
                  maxLength: 8
                  description: Name of the data sharing group member
                FB_DSCLIST:
                  type: integer
                  format: int32
                FB_DSCTYPE:
                  type: integer
                  format: int32
                FB_DSCVALUE:
                  type: integer
                  format: int32
                FB_DSCVALUE2:
                  type: integer
                  format: int32
                FB_RETRY:
                  type: integer
                  format: int32
                  description: retry count
                FB_STATEMENT_TAB:
                  type: array
                  items:
                    type: object
                    properties:
                      QSTCSTNM:
                        type: string
                        format: byte
                        description: DB2 statement name
                      QSTCTOKN:
                        type: integer
                        format: int32
                        description: Statement ID
                      QSTCUSE:
                        type: integer
                        format: int32
                        description: Current Copies
                      QSTCCOPY:
                        type: integer
                        format: int32
                        description: Number of copies of the statement
                      QSTCSTAT:
                        type: string
                        maxLength: 30
                        description: Status of the statement
                      QSTCIDDL:
                        type: string
                        maxLength: 5
                        description: Statement invalidated by DROP or ALTER
                      QSTCIRVK:
                        type: string
                        maxLength: 5
                        description: Statement invalidated by REVOKE
                      QSTCIRST:
                        type: string
                        maxLength: 5
                        description: Statement invalidated by RUNSTATS
                      QSTCCLRU:
                        type: string
                        maxLength: 5
                        description: Statement removed from cache by LRU (last recently used)
                      QSTCISTM:
                        type: string
                        maxLength: 14
                        description: Time when statement was inserted into cache
                      QSTCEXEC:
                        type: integer
                        format: int32
                        description: Number of executions of the statement
                      QSTCRBUF:
                        type: integer
                        format: int32
                        description: Synchronous Reads
                      QSTCGPAG:
                        type: integer
                        format: int32
                        description: Getpages
                      DSTCGPAG:
                        type: integer
                        format: int64
                        description: Getpages (new format)
                      QSTCEROW:
                        type: integer
                        format: int32
                        description: Rows Examined
                      DSTCEROW:
                        type: integer
                        format: int64
                        description: Rows Examined
                      QSTCPROW:
                        type: integer
                        format: int32
                        description: Rows Processed
                      DSTCPROW:
                        type: integer
                        format: int64
                        description: Rows Processed
                      QSTCSORT:
                        type: integer
                        format: int32
                        description: Number of sorts performed for statement
                      QSTCINDX:
                        type: integer
                        format: int32
                        description: Number of index scans performed for statement
                      QSTCTSCN:
                        type: integer
                        format: int32
                        description: Number of tablespace scans performed for statement
                      QSTCPLGP:
                        type: integer
                        format: int32
                        description: Number of parallel groups created for statement
                      QSTCWRIT:
                        type: integer
                        format: int32
                        description: Synchronous Writes
                      QSTCAET:
                        type: string
                        maxLength: 16
                        description: Time elapsed
                      QSTCSTLN:
                        type: integer
                        format: int32
                        description: The length of the SQL Statement
                      QSTCSTMT:
                        type: string
                        maxLength: 60
                        description: Statement text
                      QW0316L1:
                        type: integer
                        format: int32
                        description: Length of program name
                      QW0316T1:
                        type: string
                        maxLength: 128
                        description: Program name
                      QW0316LX:
                        type: integer
                        format: int32
                        description: Statement Line Number
                      QW0316L2:
                        type: integer
                        format: int32
                        description: Length of transaction name
                      QW0316T2:
                        type: string
                        maxLength: 32
                        description: Transaction name
                      QW0316L3:
                        type: integer
                        format: int32
                        description: Length of user ID
                      QW0316T3:
                        type: string
                        maxLength: 128
                        description: User ID
                      QW0316X4:
                        type: string
                        maxLength: 128
                        description: User group
                      QW0316X5:
                        type: string
                        maxLength: 128
                        description: The value of QUALIFIER bind option
                      QW0316X6:
                        type: string
                        maxLength: 3
                        description: ISOLATION
                      QW0316X7T:
                        type: string
                        maxLength: 3
                        description: CURRENTDATA
                      QW0316X8T:
                        type: string
                        maxLength: 4
                        description: DYNAMICRULES
                      QW0316X9T:
                        type: string
                        maxLength: 3
                        description: CURRENT DEGREE
                      QW0316XAT:
                        type: string
                        maxLength: 3
                        description: CURRENT RULES
                      QW0316XBT:
                        type: string
                        maxLength: 5
                        description: CURRENT PRECISION
                      QW0316XCT:
                        type: string
                        maxLength: 3
                        description: WITH HOLD
                      QW0316TS:
                        type: string
                        maxLength: 16
                        description: 'Timestamp: Begin of Statistics Collection'
                      QW0316CT:
                        type: string
                        maxLength: 16
                        description: Accumulated CPU Time
                      QW0316W1:
                        type: string
                        maxLength: 16
                        description: Accumulated Wait Time for Synchronous I/O
                      QW0316W2:
                        type: string
                        maxLength: 16
                        description: Accumulated Wait Time for Lock and Latch Req.
                      QW0316W3:
                        type: string
                        maxLength: 16
                        description: Accumulated Wait Time for Sync. Execution Unit Switch
                      QW0316W4:
                        type: string
                        maxLength: 16
                        description: Accumulated Wait Time for Global Locks
                      QW0316W5:
                        type: string
                        maxLength: 16
                        description: Accumulated Wait Time for Read Activity by Another Thread
                      QW0316W6:
                        type: string
                        maxLength: 16
                        description: Accumulated Wait Time for Write Activity by Another Thread
                      QW0316RT:
                        type: integer
                        format: int32
                        description: RID List Not Used due to DB2 Limits Exceeded
                      QW0316RS:
                        type: integer
                        format: int32
                        description: RID List Not Used due to Insufficient Storage
                      RRSAFPGM:
                        type: string
                        maxLength: 128
                        description: Program name
                      RRSAFLEN:
                        type: string
                        maxLength: 10
                        description: Statement Line Number
                      RETOEXECS:
                        type: integer
                        format: int64
                        description: Average rows examined
                      RPTOEXECS:
                        type: integer
                        format: int64
                        description: Average rows processed
                      RPTOROWEXE:
                        type: string
                        maxLength: 13
                        description: 'Ratio: Rows processed to rows examined of statement'
                      RAETOEXECS:
                        type: integer
                        format: int64
                        description: Average elapsed time
                      AVGCPU:
                        type: integer
                        format: int64
                        description: Average CPU time
                      AVGWAIT:
                        type: integer
                        format: int64
                        description: Average wait time
                      AVGSIOW:
                        type: integer
                        format: int64
                        description: Average synchronous I/O time
                      AVGSYIO:
                        type: integer
                        format: int64
                        description: Average synchronous I/Os
                      RIDFAIL:
                        type: string
                        maxLength: 10
                        description: RID list failures
                      GPRPROC:
                        type: integer
                        format: int64
                        description: Getpages per rows processed
                      RETOPROW:
                        type: integer
                        format: int64
                        description: Examined per processed Rows
                      STATTXT:
                        type: string
                        maxLength: 18
                        description: Status
                      AVGLOLA:
                        type: integer
                        format: int64
                        description: Average wait for lock/latch
                      AVGEUSW:
                        type: integer
                        format: int64
                        description: Average wait for EU switch
                      AVGGLLO:
                        type: integer
                        format: int64
                        description: Average wait for global lock
                      AVGREAD:
                        type: integer
                        format: int64
                        description: Average wait for other read
                      AVGWRIT:
                        type: integer
                        format: int64
                        description: Average wait for other write
                      AVGOTHE:
                        type: integer
                        format: int64
                        description: Average other wait time
                      TIMCPU:
                        type: string
                        maxLength: 13
                        description: CPU time
                      TIMWAIT:
                        type: string
                        maxLength: 13
                        description: Wait time
                      TIMSYIO:
                        type: string
                        maxLength: 13
                        description: Wait time for synchronous I/O
                      TIMLOLA:
                        type: string
                        maxLength: 13
                        description: Wait time for lock/latch
                      TIMEUSW:
                        type: string
                        maxLength: 13
                        description: Wait time for EU switch
                      TIMGLLO:
                        type: string
                        maxLength: 13
                        description: Wait time for global lock
                      TIMREAD:
                        type: string
                        maxLength: 13
                        description: Wait time for other read
                      TIMWRIT:
                        type: string
                        maxLength: 13
                        description: Wait time for other write
                      TIMOTHE:
                        type: string
                        maxLength: 13
                        description: Other wait time
                      RANBTONE:
                        type: integer
                        format: int64
                        description: Average synchronous reads
                      RANWTONE:
                        type: integer
                        format: int64
                        description: Average synchronous writes
                      RANGTONE:
                        type: integer
                        format: int64
                        description: Average getpages
                      RANSTONE:
                        type: integer
                        format: int64
                        description: Average sorts
                      RANITONE:
                        type: integer
                        format: int64
                        description: Average index scans
                      RANTTONE:
                        type: integer
                        format: int64
                        description: Average tablespace scans
                      RARSTONE:
                        type: integer
                        format: int64
                        description: Average RID failures - no storage
                      RARTTONE:
                        type: integer
                        format: int64
                        description: Average RID failures - limit
                      RANLTONE:
                        type: integer
                        format: int64
                        description: Average parallel groups
                      RANGTONP:
                        type: string
                        maxLength: 13
                        description: Getpages per rows processed
                      RANRTONP:
                        type: string
                        maxLength: 13
                        description: Examined per rows processed
                      RAW1TOBW:
                        type: string
                        maxLength: 13
                        description: Average duration of a synchronous I/O
                      EXECPSEC:
                        type: string
                        maxLength: 13
                        description: Average executions per second
                      QW0316W1N:
                        type: integer
                        format: int64
                        description: Accumulated Wait Time for Synchronous I/O
                      QW0316W2N:
                        type: integer
                        format: int64
                        description: Accumulated Wait Time for Lock and Latch Req.
                      QW0316W3N:
                        type: integer
                        format: int64
                        description: Accumulated Wait Time for Sync. Execution Unit Switch
                      QW0316W4N:
                        type: integer
                        format: int64
                        description: Accumulated Wait Time for Global Locks
                      QW0316W5N:
                        type: integer
                        format: int64
                        description: Accumulated Wait Time for Read Activity by Another Thread
                      QW0316W6N:
                        type: integer
                        format: int64
                        description: Accumulated Wait Time for Write Activity by Another Thread
                      QW0316CTN:
                        type: integer
                        format: int64
                        description: Accumulated CPU Time
                      QSTCAETN:
                        type: integer
                        format: int64
                        description: Time elapsed
                      QW0316TD:
                        type: string
                        maxLength: 128
                        description: Name of the table referenced in the statement
                      MEMBNM:
                        type: string
                        maxLength: 8
                        description: DB2 member name in data sharing environment
                      STATUID:
                        type: string
                        maxLength: 29
                        description: STATUID as used by SAP BW to identify OLAP queries
              required:
              - FB_DSCLIST
              - FB_DSCTYPE
              - FB_DSCVALUE
              - FB_DSCVALUE2
      responses:
        '200':
          description: OK
          content:
            application/json:
              schema:
                properties:
                  DS_MEMBER_USED:
                    type: string
                    maxLength: 8
                    description: Name of the data sharing group member
                  FB_DSCHDR:
                    type: object
                    properties:
                      SSID:
                        type: string
                        maxLength: 4
                        description: DB2 subsystem ID
                      INTFROMD:
                        type: string
                        format: date
                        description: Date when sampling is taken
                      INTFROMT:
                        type: string
                        maxLength: 6
                        description: Time when sampling is taken
                      INTTOD:
                        type: string
                        format: date
                        description: Date when sampling is taken
                      INTTOT:
                        type: string
                        maxLength: 6
                        description: Time when sampling is taken
                      SMPINT:
                        type: integer
                        format: int64
                        description: Sample interval
                      MODUS:
                        type: string
                        maxLength: 30
                        description: DB2 sample mode
                  FB_DSECNPROCD:
                    type: integer
                    format: int32
                    description: number of data sections not processed
                  FB_DSECPROCD:
                    type: integer
                    format: int32
                    description: number of data sections processed
                  FB_STATEMENT_TAB:
                    type: array
                    items:
                      type: object
                      properties:
                        QSTCSTNM:
                          type: string
                          format: byte
                          description: DB2 statement name
                        QSTCTOKN:
                          type: integer
                          format: int32
                          description: Statement ID
                        QSTCUSE:
                          type: integer
                          format: int32
                          description: Current Copies
                        QSTCCOPY:
                          type: integer
                          format: int32
                          description: Number of copies of the statement
                        QSTCSTAT:
                          type: string
                          maxLength: 30
                          description: Status of the statement
                        QSTCIDDL:
                          type: string
                          maxLength: 5
                          description: Statement invalidated by DROP or ALTER
                        QSTCIRVK:
                          type: string
                          maxLength: 5
                          description: Statement invalidated by REVOKE
                        QSTCIRST:
                          type: string
                          maxLength: 5
                          description: Statement invalidated by RUNSTATS
                        QSTCCLRU:
                          type: string
                          maxLength: 5
                          description: Statement removed from cache by LRU (last recently used)
                        QSTCISTM:
                          type: string
                          maxLength: 14
                          description: Time when statement was inserted into cache
                        QSTCEXEC:
                          type: integer
                          format: int32
                          description: Number of executions of the statement
                        QSTCRBUF:
                          type: integer
                          format: int32
                          description: Synchronous Reads
                        QSTCGPAG:
                          type: integer
                          format: int32
                          description: Getpages
                        DSTCGPAG:
                          type: integer
                          format: int64
                          description: Getpages (new format)
                        QSTCEROW:
                          type: integer
                          format: int32
                          description: Rows Examined
                        DSTCEROW:
                          type: integer
                          format: int64
                          description: Rows Examined
                        QSTCPROW:
                          type: integer
                          format: int32
                          description: Rows Processed
                        DSTCPROW:
                          type: integer
                          format: int64
                          description: Rows Processed
                        QSTCSORT:
                          type: integer
                          format: int32
                          description: Number of sorts performed for statement
                        QSTCINDX:
                          type: integer
                          format: int32
                          description: Number of index scans performed for statement
                        QSTCTSCN:
                          type: integer
                          format: int32
                          description: Number of tablespace scans performed for statement
                        QSTCPLGP:
                          type: integer
                          format: int32
                          description: Number of parallel groups created for statement
                        QSTCWRIT:
                          type: integer
                          format: int32
                          description: Synchronous Writes
                        QSTCAET:
                          type: string
                          maxLength: 16
                          description: Time elapsed
                        QSTCSTLN:
                          type: integer
                          format: int32
                          description: The length of the SQL Statement
                        QSTCSTMT:
                          type: string
                          maxLength: 60
                          description: Statement text
                        QW0316L1:
                          type: integer
                          format: int32
                          description: Length of program name
                        QW0316T1:
                          type: string
                          maxLength: 128
                          description: Program name
                        QW0316LX:
                          type: integer
                          format: int32
                          description: Statement Line Number
                        QW0316L2:
                          type: integer
                          format: int32
                          description: Length of transaction name
                        QW0316T2:
                          type: string
                          maxLength: 32
                          description: Transaction name
                        QW0316L3:
                          type: integer
                          format: int32
                          description: Length of user ID
                        QW0316T3:
                          type: string
                          maxLength: 128
                          description: User ID
                        QW0316X4:
                          type: string
                          maxLength: 128
                          description: User group
                        QW0316X5:
                          type: string
                          maxLength: 128
                          description: The value of QUALIFIER bind option
                        QW0316X6:
                          type: string
                          maxLength: 3
                          description: ISOLATION
                        QW0316X7T:
                          type: string
                          maxLength: 3
                          description: CURRENTDATA
                        QW0316X8T:
                          type: string
                          maxLength: 4
                          description: DYNAMICRULES
                        QW0316X9T:
                          type: string
                          maxLength: 3
                          description: CURRENT DEGREE
                        QW0316XAT:
                          type: string
                          maxLength: 3
                          description: CURRENT RULES
                        QW0316XBT:
                          type: string
                          maxLength: 5
                          description: CURRENT PRECISION
                        QW0316XCT:
                          type: string
                          maxLength: 3
                          description: WITH HOLD
                        QW0316TS:
                          type: string
                          maxLength: 16
                          description: 'Timestamp: Begin of Statistics Collection'
                        QW0316CT:
                          type: string
                          maxLength: 16
                          description: Accumulated CPU Time
                        QW0316W1:
                          type: string
                          maxLength: 16
                          description: Accumulated Wait Time for Synchronous I/O
                        QW0316W2:
                          type: string
                          maxLength: 16
                          description: Accumulated Wait Time for Lock and Latch Req.
                        QW0316W3:
                          type: string
                          maxLength: 16
                          description: Accumulated Wait Time for Sync. Execution Unit Switch
                        QW0316W4:
                          type: string
                          maxLength: 16
                          description: Accumulated Wait Time for Global Locks
                        QW0316W5:
                          type: string
                          maxLength: 16
                          description: Accumulated Wait Time for Read Activity by Another Thread
                        QW0316W6:
                          type: string
                          maxLength: 16
                          description: Accumulated Wait Time for Write Activity by Another Thread
                        QW0316RT:
                          type: integer
                          format: int32
                          description: RID List Not Used due to DB2 Limits Exceeded
                        QW0316RS:
                          type: integer
                          format: int32
                          description: RID List Not Used due to Insufficient Storage
                        RRSAFPGM:
                          type: string
                          maxLength: 128
                          description: Program name
                        RRSAFLEN:
                          type: string
                          maxLength: 10
                          description: Statement Line Number
                        RETOEXECS:
                          type: integer
                          format: int64
                          description: Average rows examined
                        RPTOEXECS:
                          type: integer
                          format: int64
                          description: Average rows processed
                        RPTOROWEXE:
                          type: string
                          maxLength: 13
                          description: 'Ratio: Rows processed to rows examined of statement'
                        RAETOEXECS:
                          type: integer
                          format: int64
                          description: Average elapsed time
                        AVGCPU:
                          type: integer
                          format: int64
                          description: Average CPU time
                        AVGWAIT:
                          type: integer
                          format: int64
                          description: Average wait time
                        AVGSIOW:
                          type: integer
                          format: int64
                          description: Average synchronous I/O time
                        AVGSYIO:
                          type: integer
                          format: int64
                          description: Average synchronous I/Os
                        RIDFAIL:
                          type: string
                          maxLength: 10
                          description: RID list failures
                        GPRPROC:
                          type: integer
                          format: int64
                          description: Getpages per rows processed
                        RETOPROW:
                          type: integer
                          format: int64
                          description: Examined per processed Rows
                        STATTXT:
                          type: string
                          maxLength: 18
                          description: Status
                        AVGLOLA:
                          type: integer
                          format: int64
                          description: Average wait for lock/latch
                        AVGEUSW:
                          type: integer
                          format: int64
                          description: Average wait for EU switch
                        AVGGLLO:
                          type: integer
                          format: int64
                          description: Average wait for global lock
                        AVGREAD:
                          type: integer
                          format: int64
                          description: Average wait for other read
                        AVGWRIT:
                          type: integer
                          format: int64
                          description: Average wait for other write
                        AVGOTHE:
                          type: integer
                          format: int64
                          description: Average other wait time
                        TIMCPU:
                          type: string
                          maxLength: 13
                          description: CPU time
                        TIMWAIT:
                          type: string
                          maxLength: 13
                          description: Wait time
                        TIMSYIO:
                          type: string
                          maxLength: 13
                          description: Wait time for synchronous I/O
                        TIMLOLA:
                          type: string
                          maxLength: 13
                          description: Wait time for lock/latch
                        TIMEUSW:
                          type: string
                          maxLength: 13
                          description: Wait time for EU switch
                        TIMGLLO:
                          type: string
                          maxLength: 13
                          description: Wait time for global lock
                        TIMREAD:
                          type: string
                          maxLength: 13
                          description: Wait time for other read
                        TIMWRIT:
                          type: string
                          maxLength: 13
                          description: Wait time for other write
                        TIMOTHE:
                          type: string
                          maxLength: 13
                          description: Other wait time
                        RANBTONE:
                          type: integer
                          format: int64
                          description: Average synchronous reads
                        RANWTONE:
                          type: integer
                          format: int64
                          description: Average synchronous writes
                        RANGTONE:
                          type: integer
                          format: int64
                          description: Average getpages
                        RANSTONE:
                          type: integer
                          format: int64
                          description: Average sorts
                        RANITONE:
                          type: integer
                          format: int64
                          description: Average index scans
                        RANTTONE:
                          type: integer
                          format: int64
                          description: Average tablespace scans
                        RARSTONE:
                          type: integer
                          format: int64
                          description: Average RID failures - no storage
                        RARTTONE:
                          type: integer
                          format: int64
                          description: Average RID failures - limit
                        RANLTONE:
                          type: integer
                          format: int64
                          description: Average parallel groups
                        RANGTONP:
                          type: string
                          maxLength: 13
                          description: Getpages per rows processed
                        RANRTONP:
                          type: string
                          maxLength: 13
                          description: Examined per rows processed
                        RAW1TOBW:
                          type: string
                          maxLength: 13
                          description: Average duration of a synchronous I/O
                        EXECPSEC:
                          type: string
                          maxLength: 13
                          description: Average executions per second
                        QW0316W1N:
                          type: integer
                          format: int64
                          description: Accumulated Wait Time for Synchronous I/O
                        QW0316W2N:
                          type: integer
                          format: int64
                          description: Accumulated Wait Time for Lock and Latch Req.
                        QW0316W3N:
                          type: integer
                          format: int64
                          description: Accumulated Wait Time for Sync. Execution Unit Switch
                        QW0316W4N:
                          type: integer
                          format: int64
                          description: Accumulated Wait Time for Global Locks
                        QW0316W5N:
                          type: integer
                          format: int64
                          description: Accumulated Wait Time for Read Activity by Another Thread
                        QW0316W6N:
                          type: integer
                          format: int64
                          description: Accumulated Wait Time for Write Activity by Another Thread
                        QW0316CTN:
                          type: integer
                          format: int64
                          description: Accumulated CPU Time
                        QSTCAETN:
                          type: integer
                          format: int64
                          description: Time elapsed
                        QW0316TD:
                          type: string
                          maxLength: 128
                          description: Name of the table referenced in the statement
                        MEMBNM:
                          type: string
                          maxLength: 8
                          description: DB2 member name in data sharing environment
                        STATUID:
                          type: string
                          maxLength: 29
                          description: STATUID as used by SAP BW to identify OLAP queries
        '400':
          description: Bad request.
        5XX:
          description: Unexpected error.
