openapi: 3.0.0
info:
  title: SAP API
  version: 1.0.0
servers:
- url: http://localhost:8080
paths:
  /rfc/STU3_GET_SQLA_DATA:
    post:
      tags:
      - STU3
      operationId: /rfc/STU3_GET_SQLA_DATA
      requestBody:
        content:
          application/json:
            schema:
              properties:
                DS_MEMBER_SPEC:
                  type: string
                  maxLength: 8
                  description: Name of the data sharing group member
                FB_DATATYPE:
                  type: integer
                  format: int32
                FB_DB2THREADS:
                  type: object
                  properties:
                    HDSUBSYSID:
                      type: string
                      maxLength: 4
                      description: DB2 subsystem ID
                    HDATDAT:
                      type: string
                      format: date
                      description: Date when sampling is taken
                    HDATTIM:
                      type: string
                      maxLength: 6
                      description: Time when sampling is taken
                    HDLRESTIME:
                      type: string
                      maxLength: 6
                      description: Time of last reset
                    ACE:
                      type: integer
                      format: int32
                      description: Field type raw, length 8, 4 bytes
                    JOBNAME:
                      type: string
                      maxLength: 8
                      description: The job name of the thread.
                    DBPLAN:
                      type: string
                      maxLength: 128
                      description: DB2 plan name
                    AUTHID:
                      type: string
                      maxLength: 128
                      description: The authorization ID under which the transaction is running
                    CORRID:
                      type: string
                      maxLength: 16
                      description: The correlation ID of the thread (IP address)
                    CONNID:
                      type: string
                      maxLength: 8
                      description: The connection ID of the thread
                    THDSTAT:
                      type: string
                      maxLength: 16
                      description: The status of the thread
                    FILLER:
                      type: string
                      maxLength: 8
                      description: Field type char, length 8
                    SQLCNT:
                      type: integer
                      format: int32
                      description: The total number of executed SQL statements
                    DBCOMMIT:
                      type: integer
                      format: int32
                      description: The number of successful phase 2 or single-phase commits
                    ABORT:
                      type: integer
                      format: int32
                      description: Total number of rollback requests
                    GETPAGE:
                      type: integer
                      format: int32
                      description: Number of Getpage Requests
                    UPDPAGE:
                      type: integer
                      format: int32
                      description: The number of times a buffer update occurs for the agent
                    LOCKS:
                      type: integer
                      format: int32
                      description: The total number of currently hold locks.
                    CPUTIME:
                      type: integer
                      format: int32
                      description: The accumulated home CPU time a thread spent in DB2
                    ELTIME:
                      type: integer
                      format: int32
                      description: Time elapsed since DB2 thread was started
                    LOCKMOD:
                      type: string
                      maxLength: 6
                      description: The mode of the lock held on the resource
                    ACTTIME:
                      type: string
                      maxLength: 16
                      description: Activity time (Class 1 elapsed time)
                    TIMEINDB2:
                      type: string
                      maxLength: 8
                      description: Percentage of time spent in DB2
                    PROCINDB2:
                      type: string
                      maxLength: 8
                      description: Percentage of time spent processing in DB2
                    WPTYPE:
                      type: string
                      maxLength: 5
                      description: Corresponding R/3 work process type
                    WPNUMBER:
                      type: integer
                      format: int64
                      description: Work process number
                    WPID:
                      type: integer
                      format: int64
                      description: Work process ID
                    ASHOST:
                      type: string
                      maxLength: 32
                      description: Application server host name
                    THDREQ:
                      type: integer
                      format: int32
                      description: Number of Requests Sent to DB2
                    ADTHRSTA:
                      type: string
                      maxLength: 22
                      description: Status of the thread
                    PRCINDB2:
                      type: string
                      maxLength: 10
                      description: 'Thread activity: % processing in DB2'
                    SSPINDB2:
                      type: string
                      maxLength: 10
                      description: Prozent der Zeit für die DB2-Verarbeitung (CPU-Zeit)
                    DS_MEMBER:
                      type: string
                      maxLength: 8
                      description: Data sharing member to which the thread belongs to
                    THDMLOCKS:
                      type: integer
                      format: int64
                      description: Maximum locks held
                    CONNNAME:
                      type: string
                      maxLength: 30
                      description: Database connection name
                    QMDAPLAT:
                      type: string
                      maxLength: 18
                      description: Client platform from DB2's perspective
                    QWHDRQNM:
                      type: string
                      maxLength: 128
                      description: Client IP address from DB2's perspective
                    SAPSID:
                      type: string
                      maxLength: 3
                      description: SAP system ID (SAPSID)
                    SAPSYS:
                      type: integer
                      format: int32
                      description: SAP system number (SAPSYSTEM)
                    ABAPREP:
                      type: string
                      maxLength: 40
                      description: 'ABAP Program: Current Main Program'
                    TXCODE:
                      type: string
                      maxLength: 20
                      description: SAP transaction code
                    ENDUSER:
                      type: string
                      maxLength: 14
                      description: SAP end-user ID
                    J2EESERV:
                      type: string
                      maxLength: 20
                      description: J2EE service type
                    QWACPARR:
                      type: string
                      maxLength: 10
                      description: Accounting records represents accounting rollup bucket
                    QW0148CI:
                      type: string
                      maxLength: 128
                      description: DB2 collection ID
                FB_MY_USER:
                  type: integer
                  format: int32
                GET_OLD_DATA:
                  type: integer
                  format: int32
                  default: 0
                  description: Get new data from RFCOSCOL?
              required:
              - FB_DATATYPE
              - FB_DB2THREADS
              - FB_MY_USER
      responses:
        '200':
          description: OK
          content:
            application/json:
              schema:
                properties:
                  FB_DB2QXST:
                    type: object
                    properties:
                      QXSELECT:
                        type: integer
                        format: int32
                        description: Number of SELECT statements executed
                      QXINSRT:
                        type: integer
                        format: int32
                        description: Number of INSERT statements executed
                      QXUPDTE:
                        type: integer
                        format: int32
                        description: Number of UPDATE statements executed
                      QXDELET:
                        type: integer
                        format: int32
                        description: Number of DELETE statements executed
                      QXDESC:
                        type: integer
                        format: int32
                        description: Number of DESCRIBE statements executed
                      QXPREP:
                        type: integer
                        format: int32
                        description: Number of PREPARE statements executed
                      QXOPEN:
                        type: integer
                        format: int32
                        description: Number of OPEN CURSOR statements executed
                      QXCLOSE:
                        type: integer
                        format: int32
                        description: Number of CLOSE CURSOR statements executed
                      QXCRTAB:
                        type: integer
                        format: int32
                        description: Number of CREATE TABLE statements executed
                      QXCRINX:
                        type: integer
                        format: int32
                        description: Number of CREATE INDEX statements executed
                      QXCTABS:
                        type: integer
                        format: int32
                        description: Number of CREATE TABLE SPACE statements executed
                      QXCRSYN:
                        type: integer
                        format: int32
                        description: Number of CREATE SYNONYM statements executed
                      QXCRDAB:
                        type: integer
                        format: int32
                        description: Number of CREATE DATABASE statements executed
                      QXCRSTG:
                        type: integer
                        format: int32
                        description: Number of CREATE STORAGE GROUP statements executed
                      QXDEFVU:
                        type: integer
                        format: int32
                        description: Number of CREATE VIEW statements executed
                      QXDRPIX:
                        type: integer
                        format: int32
                        description: Number of DROP INDEX statements executed
                      QXDRPTA:
                        type: integer
                        format: int32
                        description: Number of DROP TABLE statements executed
                      QXDRPTS:
                        type: integer
                        format: int32
                        description: Number of DROP TABLE SPACE statements executed
                      QXDRPDB:
                        type: integer
                        format: int32
                        description: Number of DROP DATABASE statements executed
                      QXDRPSY:
                        type: integer
                        format: int32
                        description: Number of DROP SYNONYM statements executed
                      QXDRPST:
                        type: integer
                        format: int32
                        description: Number of DROP STORAGE GROUP statements executed
                      QXDRPVU:
                        type: integer
                        format: int32
                        description: Number of DROP VIEW statements executed
                      QXALTST:
                        type: integer
                        format: int32
                        description: Number of ALTER STORAGE GROUP statements executed
                      QXFETCH:
                        type: integer
                        format: int32
                        description: Number of FETCH statements executed
                      DXFETCH:
                        type: integer
                        format: int64
                        description: Number of FETCH statements executed
                      QXALTTS:
                        type: integer
                        format: int32
                        description: Number of ALTER TABLE SPACE statements executed
                      QXALTTA:
                        type: integer
                        format: int32
                        description: Number of ALTER TABLE statements executed
                      QXALTIX:
                        type: integer
                        format: int32
                        description: Number of ALTER INDEX statements executed
                      QXCMTON:
                        type: integer
                        format: int32
                        description: Number of COMMENT ON statements executed
                      QXLOCK:
                        type: integer
                        format: int32
                        description: Number of LOCK TABLE statements executed
                      QXGRANT:
                        type: integer
                        format: int32
                        description: Number of GRANT statements executed
                      QXREVOK:
                        type: integer
                        format: int32
                        description: Number of REVOKE statements executed
                      QXINCRB:
                        type: integer
                        format: int32
                        description: Number of INCREMENTAL BINDs executed
                      QXLABON:
                        type: integer
                        format: int32
                        description: Number of LABEL ON statements executed
                      QXSETSQL:
                        type: integer
                        format: int32
                        description: Number of SET CURRENT SQLID statements executed
                      QXCRALS:
                        type: integer
                        format: int32
                        description: Number of CREATE ALIAS statements executed
                      QXDRPAL:
                        type: integer
                        format: int32
                        description: Number of DROP ALIAS statements executed
                      QXMIAP:
                        type: integer
                        format: int32
                        description: Number of times RID list processing is used
                      QXNSMIAP:
                        type: integer
                        format: int32
                        description: RID list processing failed - no storage
                      QXMRMIAP:
                        type: integer
                        format: int32
                        description: RID list processing failed - limit exeeded
                      QXSETHV:
                        type: integer
                        format: int32
                        description: Number of SET HOST VARIABLE statements executed
                      QXALDAB:
                        type: integer
                        format: int32
                        description: Number of ALTER DATABASE statements executed
                      QXDRPPKG:
                        type: integer
                        format: int32
                        description: Number of DROP PACKAGE statements executed
                      QXDSCRTB:
                        type: integer
                        format: int32
                        description: Number of DESCRIBE TABLE statements executed
                      QXMAXDEG:
                        type: integer
                        format: int32
                        description: Field Type INT, Length 4
                      QXTOTGRP:
                        type: integer
                        format: int32
                        description: Field Type INT, Length 4
                      QXDEGCUR:
                        type: integer
                        format: int32
                        description: Field Type INT, Length 4
                      QXDEGESA:
                        type: integer
                        format: int32
                        description: Field Type INT, Length 4
                      QXDEGBUF:
                        type: integer
                        format: int32
                        description: Field Type INT, Length 4
                      QXREDGRP:
                        type: integer
                        format: int32
                        description: Field Type INT, Length 4
                      QXNORGRP:
                        type: integer
                        format: int32
                        description: Field Type INT, Length 4
                      QXCON1:
                        type: integer
                        format: int32
                        description: Number of CONNECT TYPE 1 statements executed
                      QXCON2:
                        type: integer
                        format: int32
                        description: Number of CONNECT TYPE 2 statements executed
                      QXREL:
                        type: integer
                        format: int32
                        description: Number of RELEASE statements executed
                      QXSETCON:
                        type: integer
                        format: int32
                        description: Number of SET CONNECTION statements executed
                      QXSETCDG:
                        type: integer
                        format: int32
                        description: Number of SET CURRENT DEGREE statements executed
                      QXSETCRL:
                        type: integer
                        format: int32
                        description: Number of SET CURRENT RULES statements executed
                      QXCALL:
                        type: integer
                        format: int32
                        description: Number of SQL CALL statements executed
                      QXCALLAB:
                        type: integer
                        format: int32
                        description: Field Type INT, Length 4
                      QXCALLTO:
                        type: integer
                        format: int32
                        description: Field Type INT, Length 4
                      QXCALLRJ:
                        type: integer
                        format: int32
                        description: Field Type INT, Length 4
                      QXDEGENC:
                        type: integer
                        format: int32
                        description: Field Type INT, Length 4
                      QXRLFDPA:
                        type: string
                        maxLength: 1
                        description: Field type char, length 1
                      QXSTRES1:
                        type: string
                        maxLength: 3
                        description: Field type char, length 3, reserved
                      QXCOORNO:
                        type: integer
                        format: int32
                        description: Field Type INT, Length 4
                      QXISORR:
                        type: integer
                        format: int32
                        description: Field Type INT, Length 4
                      QXCRGTT:
                        type: integer
                        format: int32
                        description: Field Type INT, Length 4
                      QXSTREOP:
                        type: integer
                        format: int32
                        description: Total Number of Times Reoptimization Occurs
                      QXXCBPNX:
                        type: integer
                        format: int32
                        description: Field Type INT, Length 4
                      QXXCSKIP:
                        type: integer
                        format: int32
                        description: Field Type INT, Length 4
                      QXALOCL:
                        type: integer
                        format: int32
                        description: Field Type INT, Length 4
                      QXALOCC:
                        type: integer
                        format: int32
                        description: Field Type INT, Length 4
                      QXSTFND:
                        type: integer
                        format: int32
                        description: Number of Times that DB2 Found the Statement in the Cache
                      QXSTNFND:
                        type: integer
                        format: int32
                        description: Number of times statement could not be found in cache
                      QXSTIPRP:
                        type: integer
                        format: int32
                        description: Number of implicit prepares
                      QXSTNPRP:
                        type: integer
                        format: int32
                        description: Number of avoided prepares
                      QXSTDEXP:
                        type: integer
                        format: int32
                        description: MAXKEEPD parameter exceeded
                      QXSTDINV:
                        type: integer
                        format: int32
                        description: Statement invalidated
                      QXRNTAB:
                        type: integer
                        format: int32
                        description: Field Type INT, Length 4
                      QXFULLP:
                        type: integer
                        format: int32
                        description: 'Total number of prepares: full prepares + short prepares'
                      QXCTRIG:
                        type: integer
                        format: int32
                        description: Number of SQL CREATE TRIGGER statements
                      QXDRPTR:
                        type: integer
                        format: int32
                        description: Number of SQL DROP TRIGGER statements
                      QXSETPTH:
                        type: integer
                        format: int32
                        description: Number of SQL SET CURRENT PATH statements
                      QXDRPFN:
                        type: integer
                        format: int32
                        description: Number of DROP UDF statements
                      QXDRPPR:
                        type: integer
                        format: int32
                        description: Number of DROP PROCEDURE statements
                      QXCDIST:
                        type: integer
                        format: int32
                        description: Number of CREATE DISTINCT TYPE statements
                      QXDDIST:
                        type: integer
                        format: int32
                        description: Number of DROP DISTINCT TYPE statements
                      QXCRUDF:
                        type: integer
                        format: int32
                        description: Number of CREATE FUNCTION statements
                      QXCRPRO:
                        type: integer
                        format: int32
                        description: Number of CREATE PROCEDURE statements
                      QXHOLDL:
                        type: integer
                        format: int32
                        description: Number of HOLD LOCATOR statements
                      QXFREEL:
                        type: integer
                        format: int32
                        description: Number of FREE LOCATOR statements
                      QXREPOP1:
                        type: integer
                        format: int32
                        description: Parallel groups with reformulated access path (Sysplex conf)
                      QXREPOP2:
                        type: integer
                        format: int32
                        description: Parallel groups with reformulated access path (buffer pool)
                      QXCRATB:
                        type: integer
                        format: int32
                        description: Number of CREATE AUXILIARY TABLE statements
                      QXSTLOBV:
                        type: integer
                        format: int32
                        description: Maximum storage used for LOB values (MB)
                      QXALUDF:
                        type: integer
                        format: int32
                        description: Number of ALTER FUNCTION statements
                      QXALPRO:
                        type: integer
                        format: int32
                        description: Number of ALTER PROCEDURE statements
                      QXROIMAT:
                        type: integer
                        format: int32
                        description: Number of times DB2 used dir. row access to locate a record
                      QXROIIDX:
                        type: integer
                        format: int32
                        description: Direct row access attempted, but reverted to using index
                      QXROITS:
                        type: integer
                        format: int32
                        description: Direct row access attempted, reverted to tablespace scan
                      QXSTTRG:
                        type: integer
                        format: int32
                        description: Number of times a statement trigger is activated
                      QXROWTRG:
                        type: integer
                        format: int32
                        description: Number of times a row trigger is activated
                      QXTRGERR:
                        type: integer
                        format: int32
                        description: No. of times an SQL error occurred during a triggered action
                      QXCASCDP:
                        type: integer
                        format: int32
                        description: Maximum level of nested SQL cascading
                      QXCAUD:
                        type: integer
                        format: int32
                        description: Number of user-defined functions executed
                      QXCAUDAB:
                        type: integer
                        format: int32
                        description: Number of times a user-defined function abended
                      QXCAUDTO:
                        type: integer
                        format: int32
                        description: No. of times a user-defined funct. timed out before sched.
                      QXCAUDRJ:
                        type: integer
                        format: int32
                        description: Number of times a user-defined function was rejected
                      GHITRATIO:
                        type: string
                        maxLength: 6
                        description: Dynamic Statement Cache Global Hit Ratio
                      LHITRATIO:
                        type: string
                        maxLength: 6
                        description: Dynamic Statement Cache Local Hit Ratio
                      REPREPRAT:
                        type: string
                        maxLength: 6
                        description: Reprepare Ratio
                      PREPREQ:
                        type: integer
                        format: int32
                        description: Number of Prepare Requests
                      SHORTPREP:
                        type: integer
                        format: int32
                        description: Number of Short Prepares
                      QXALTJR:
                        type: integer
                        format: int32
                        description: Number of ALTER JAR statements
                      QXMERGE:
                        type: integer
                        format: int32
                        description: Number of MERGE statements
                      QXTRTBL:
                        type: integer
                        format: int32
                        description: Number of TRUNCATE TABLE statements
                      QXCRROL:
                        type: integer
                        format: int32
                        description: Number of  CREATE ROLE statements
                      QXDRPROL:
                        type: integer
                        format: int32
                        description: Number of  DROP ROLE statements
                      QXCRCTX:
                        type: integer
                        format: int32
                        description: Number of  CREATE TRUSTED CONTEXT statements
                      QXALTCTX:
                        type: integer
                        format: int32
                        description: Number of  ALTER TRUSTED CONTEXT statements
                      QXDRPCTX:
                        type: integer
                        format: int32
                        description: Number of  DROP TRUSTED CONTEXT statements
                      QXRNIX:
                        type: integer
                        format: int32
                        description: Number of RENAME INDEX statements
                  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
        '400':
          description: Bad request.
        5XX:
          description: Unexpected error.
