openapi: 3.0.0
info:
  title: SAP API
  version: 1.0.0
servers:
- url: http://localhost:8080
paths:
  /rfc/STU3_GET_TIMES:
    post:
      tags:
      - STU3
      operationId: /rfc/STU3_GET_TIMES
      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: Natural number
              required:
              - FB_DATATYPE
              - FB_DB2THREADS
              - FB_MY_USER
      responses:
        '200':
          description: OK
          content:
            application/json:
              schema:
                properties:
                  FB_DB2TIMES:
                    type: object
                    properties:
                      THDTOUDB2:
                        type: string
                        maxLength: 16
                        description: Time spent out of DB2
                      THDTCPUTOT:
                        type: string
                        maxLength: 16
                        description: Total CPU time on System z including DB2
                      THDTINB2:
                        type: string
                        maxLength: 16
                        description: Accumulated elapsed time in DB2
                      THDTCPUIN:
                        type: string
                        maxLength: 16
                        description: CPU time spent in DB2
                      THDTSUSPIN:
                        type: string
                        maxLength: 16
                        description: Time spent suspended in DB2
                      THDTNAINDB:
                        type: string
                        maxLength: 16
                        description: Not attributed time in DB2
                      THDTIO:
                        type: string
                        maxLength: 16
                        description: I/O suspension time
                      THDTLKLA:
                        type: string
                        maxLength: 16
                        description: Lock/latch supension time
                      THDTOTHR:
                        type: string
                        maxLength: 16
                        description: Other read suspensions time
                      THDTOTHW:
                        type: string
                        maxLength: 16
                        description: Other write suspensions time
                      THDTSRVT:
                        type: string
                        maxLength: 16
                        description: Wait time for DB2 commit phase II processing
                      THDTARCHQ:
                        type: string
                        maxLength: 16
                        description: Archive log quiesce suspension time
                      THDTDRLK:
                        type: string
                        maxLength: 16
                        description: Drain lock suspension time
                      THDTCLREL:
                        type: string
                        maxLength: 16
                        description: Claim release suspension time
                      THDTARCHR:
                        type: string
                        maxLength: 16
                        description: Archive read suspension time
                      THDTPGLA:
                        type: string
                        maxLength: 16
                        description: Page latch suspension time
                      THDTNOTM:
                        type: string
                        maxLength: 16
                        description: Notify messages suspension time
                      THDTGLOBTM:
                        type: string
                        maxLength: 16
                        description: Global locking suspension time
                      THDTIOE:
                        type: integer
                        format: int64
                        description: Number of I/O suspensions
                      THDTLKLAE:
                        type: integer
                        format: int64
                        description: Number of Lock / Latch Suspensions
                      THDTOTHRE:
                        type: integer
                        format: int64
                        description: Number of other read suspensions
                      THDTOTHWE:
                        type: integer
                        format: int64
                        description: Number of other write suspensions
                      THDTSRVTE:
                        type: integer
                        format: int64
                        description: Number of waits for commit phase II or abort
                      THDTARCHQE:
                        type: integer
                        format: int64
                        description: Number of ARCHIVE LOG QUIESCE suspensions
                      THDTDRLKE:
                        type: integer
                        format: int64
                        description: Number of drain lock suspensions
                      THDTCLRELE:
                        type: integer
                        format: int64
                        description: Number of claim release suspensions
                      THDTARCHRE:
                        type: integer
                        format: int64
                        description: Number of archive read suspensions
                      THDTPGLAE:
                        type: integer
                        format: int64
                        description: Number of page latch suspensions
                      THDTNOTME:
                        type: integer
                        format: int64
                        description: Number of notify messages suspensions
                      THDTGLOBTE:
                        type: integer
                        format: int64
                        description: Number of global locking suspensions
                      THDTIOA:
                        type: string
                        maxLength: 10
                        description: Average duration of I/O suspension
                      THDTLKLAA:
                        type: string
                        maxLength: 10
                        description: Average duration of lock/latch supensions
                      THDTOTHRA:
                        type: string
                        maxLength: 10
                        description: Average duration of other read suspensions
                      THDTOTHWA:
                        type: string
                        maxLength: 10
                        description: Average duration of other write suspensions
                      THDTSRVTA:
                        type: string
                        maxLength: 10
                        description: Average waiting time for commit phase II or abort
                      THDTARCHQA:
                        type: string
                        maxLength: 10
                        description: Average duration of ARCHIVE LOG QUIESCE suspensions
                      THDTDRLKEA:
                        type: string
                        maxLength: 10
                        description: Average duration of drain lock suspensions
                      THDTCLRELA:
                        type: string
                        maxLength: 10
                        description: Average duration of claim release suspensions
                      THDTARCHRA:
                        type: string
                        maxLength: 10
                        description: Average duration of archive read suspensions
                      THDTPGLAA:
                        type: string
                        maxLength: 10
                        description: Average duration of page latch suspensions
                      THDTNOTMA:
                        type: string
                        maxLength: 10
                        description: Average duration of notify messages suspensions
                      THDTGLOBTA:
                        type: string
                        maxLength: 10
                        description: Average duration of global locking suspensions
                      THDTINDB2:
                        type: string
                        maxLength: 8
                        description: Percentage of time spent in DB2
                      THDTPRODB2:
                        type: string
                        maxLength: 8
                        description: Percentage of time spent processing in DB2
                      THDTSUSDB2:
                        type: string
                        maxLength: 8
                        description: Time spent suspended in DB2 / Time spent in DB2 (%)
                      THDTNAIDB2:
                        type: string
                        maxLength: 8
                        description: Time not attributed in DB2 / Time spent in DB2 (%)
                      THDTOUTDB2:
                        type: string
                        maxLength: 8
                        description: Time spent out of DB2 / Activity time (%)
                      THDTTCPU:
                        type: string
                        maxLength: 8
                        description: Total CPU time / Activity time
                      THDTACTT:
                        type: string
                        maxLength: 16
                        description: Activity time (Class 1 elapsed time)
                      THDTOCST:
                        type: string
                        maxLength: 16
                        description: Wait time for open/close service task (incl. HSM recall)
                      THDTSLST:
                        type: string
                        maxLength: 16
                        description: Wait time for SYSLGRNG recording service task
                      THDTDSST:
                        type: string
                        maxLength: 16
                        description: Wait time for data set extend/delete/define service task
                      THDTOTHRST:
                        type: string
                        maxLength: 16
                        description: Wait time for other service tasks
                      THDTOCSTE:
                        type: integer
                        format: int64
                        description: Number of waits for open/close service task
                      THDTSLSTE:
                        type: integer
                        format: int64
                        description: Number of waits for SYSLGRNG recording service task
                      THDTDSSTE:
                        type: integer
                        format: int64
                        description: Number of waits for data set ext./del./def. service task
                      THDTOTHRSE:
                        type: integer
                        format: int64
                        description: Number of waits for other service tasks
                      THDTOCSTA:
                        type: string
                        maxLength: 10
                        description: Average waiting time for open/close service task
                      THDTSLSTA:
                        type: string
                        maxLength: 10
                        description: Average waiting time for SYSLGRNG recording service task
                      THDTDSSTA:
                        type: string
                        maxLength: 10
                        description: Average waiting time for dataset ext./del./def. service task
                      THDTOTHRSA:
                        type: string
                        maxLength: 10
                        description: Average waiting time for other service tasks
                      THDTCOMM:
                        type: integer
                        format: int64
                        description: Number of successful phase 2 or single-phase commit requests
                      THDTABRT:
                        type: integer
                        format: int64
                        description: Number of rollback requests
                      THDTSPEP:
                        type: string
                        maxLength: 8
                        description: Total elapsed time spent executing SQL in stored procedures
                      THDTSPPP:
                        type: string
                        maxLength: 8
                        description: Accumulated TCB time spend in DB2 by stored procedures
                      THDTSPET:
                        type: string
                        maxLength: 16
                        description: Total elapsed time spent executing SQL in stored procedures
                      THDTSPPT:
                        type: string
                        maxLength: 16
                        description: Accumulated TCB time spend in DB2 by stored procedures
                      THDTSPEAT:
                        type: string
                        maxLength: 16
                        description: Total elapsed time spent in stored procedures
                      THDTSPCPT:
                        type: string
                        maxLength: 16
                        description: Accumulated TCB time spent
                      THDTEEDASC:
                        type: string
                        maxLength: 10
                        description: DB2 entry/exit duration elapsed time
                      THDTEEDJST:
                        type: string
                        maxLength: 10
                        description: DB2 entry/exit duration processing (CPU)
                      THDTEEDPEB:
                        type: string
                        maxLength: 10
                        description: Stored procedure entry/exit duration elapsed time
                      THDTEEDPTT:
                        type: string
                        maxLength: 10
                        description: Stored procedure entry/exit duration processing (CPU)
                      THDTUDEBT:
                        type: string
                        maxLength: 16
                        description: Total elapsed time spent for user-defined function
                      THDTUDTTT:
                        type: string
                        maxLength: 16
                        description: Accumulated TCB time in DB2 issued by user-defined functions
                      THDTUDEAT:
                        type: string
                        maxLength: 16
                        description: Total elapsed time spent in user-defined functions
                      THDTUDCPT:
                        type: string
                        maxLength: 16
                        description: Accumulated TCB time for user-defined function
                      THDTUDEP:
                        type: string
                        maxLength: 8
                        description: Elapsed time in percent for user-defined function
                      THDTUDPP:
                        type: string
                        maxLength: 8
                        description: Processing (CPU) for user-defined function
                      THDTUDFDEB:
                        type: string
                        maxLength: 10
                        description: UDF entry/exit duration elapsed time
                      THDTUDFDTT:
                        type: string
                        maxLength: 10
                        description: UDF entry/exit duration processing (CPU)
                      THDTTRETT:
                        type: string
                        maxLength: 16
                        description: Accumulated elapsed time used while executing
                      THDTTRTTT:
                        type: string
                        maxLength: 16
                        description: Accumulated TCB time used while executing
                      THDTTRTET:
                        type: string
                        maxLength: 16
                        description: Accumulated TCB time used for executing triggers
                      THDTTREET:
                        type: string
                        maxLength: 16
                        description: Accumulated elapsed time used for executing triggers
                      THDTPECDT:
                        type: string
                        maxLength: 16
                        description: Accumulated CPU time user for DB2
                      THDTPECTT:
                        type: string
                        maxLength: 16
                        description: Accumulated TCB time used before enclave is created
                      THDTIFAETT:
                        type: string
                        maxLength: 16
                        description: Accumulated elapsed time spent processing IFI calls
                      THDTIFATTT:
                        type: string
                        maxLength: 16
                        description: Accumulated CPU time spent processing IFI calls
                      THDTIFAETP:
                        type: string
                        maxLength: 8
                        description: Elapsed IFI time to total DB2 time in percent
                      THDTIFATTP:
                        type: string
                        maxLength: 8
                        description: Processing (CPU) times to total DB2 activity time in percent
                      THDTIFIELT:
                        type: string
                        maxLength: 10
                        description: IFI entry/exit duration elapsed time
                      THDTIFIPRT:
                        type: string
                        maxLength: 10
                        description: IFI entry/exit duration processing (CPU)
                      THDTLOGW:
                        type: string
                        maxLength: 16
                        description: Log writes suspension time
                      THDTCAST:
                        type: string
                        maxLength: 16
                        description: Stored procedures suspension time
                      THDTUDST:
                        type: string
                        maxLength: 16
                        description: User defined functions suspension time
                      THDTLOGWE:
                        type: integer
                        format: int64
                        description: Number of log writes
                      THDTCASTE:
                        type: integer
                        format: int64
                        description: Number of stored procedures
                      THDTUDSTE:
                        type: integer
                        format: int64
                        description: Number of user defined function
                      THDTIOP:
                        type: string
                        maxLength: 10
                        description: Percent of time in DB2 for synchronous reads and writes
                      THDTSRVTP:
                        type: string
                        maxLength: 10
                        description: Percent of time in DB2 for commit, abort, deallocate
                      THDTOTHRP:
                        type: string
                        maxLength: 10
                        description: Percent of time spent in DB2 for other agents' read
                      THDTOTHWP:
                        type: string
                        maxLength: 10
                        description: Percent of time spend in DB2 for other agents' writes
                      THDTLKLAP:
                        type: string
                        maxLength: 10
                        description: Percent of time spent in DB2 for locks and latches
                      THDTPGLAP:
                        type: string
                        maxLength: 10
                        description: Percent of time spent in DB2 for page latches
                      THDTOCSTP:
                        type: string
                        maxLength: 10
                        description: Percent of time spent in DB2 for open ,close, HSM recall
                      THDTDSSTP:
                        type: string
                        maxLength: 10
                        description: Percent of time spent in DB2 for dataspace manager service
                      THDTSLSTP:
                        type: string
                        maxLength: 10
                        description: Percent of time spent in DB2 for SYSLGRNX recording
                      THDTOTHRSP:
                        type: string
                        maxLength: 10
                        description: Percent time in DB2 for other synchronous EU switch services
                      THDTGLOBTP:
                        type: string
                        maxLength: 10
                        description: Percent of time spent in DB2 for global locks
                      THDTNOTMP:
                        type: string
                        maxLength: 10
                        description: Percent of time spent in DB2 for notify messages
                      THDTDRLKP:
                        type: string
                        maxLength: 10
                        description: Percent of time spent in DB2 for drain locks
                      THDTCLRELP:
                        type: string
                        maxLength: 10
                        description: Percent of time spent in DB2 for claim locks
                      THDTLOGWP:
                        type: string
                        maxLength: 10
                        description: Percent of time spent in DB2 for log writes
                      THDTARCHQP:
                        type: string
                        maxLength: 10
                        description: Percent of time spent in DB2 for ARCHIVE LOG QUIESCE command
                      THDTARCHRP:
                        type: string
                        maxLength: 10
                        description: Percent of time spent in DB2 for archive log read
                      THDTCASTP:
                        type: string
                        maxLength: 10
                        description: Percent of time spent in DB2 for stored procedures
                      THDTUDSTP:
                        type: string
                        maxLength: 10
                        description: Percent of time spent in DB2 for user defined functions
                      THDTLOGWA:
                        type: string
                        maxLength: 10
                        description: Average log writes
                      THDTCASTA:
                        type: string
                        maxLength: 10
                        description: Average of stored procedures
                      THDTAWLG:
                        type: string
                        maxLength: 16
                        description: Log writes suspension time
                      THDTARLG:
                        type: integer
                        format: int64
                        description: Number of log writes
                      THDTAWTK:
                        type: string
                        maxLength: 16
                        description: wait time due to global contention for child L-locks
                      THDTAWTM:
                        type: string
                        maxLength: 16
                        description: wait time due to global contention for other L-locks
                      THDTAWTN:
                        type: string
                        maxLength: 16
                        description: wait time due to global contention pageset/partition P-locks
                      THDTAWTO:
                        type: string
                        maxLength: 16
                        description: wait time due to global contention  for page P-locks
                      THDTAWTQ:
                        type: string
                        maxLength: 16
                        description: wait time due to global contention for other P-locks
                      THDTARTK:
                        type: integer
                        format: int64
                        description: Number of wait trace events for child L-locks
                      THDTARTM:
                        type: integer
                        format: int64
                        description: Number of wait trace events for other L-locks
                      THDTARTN:
                        type: integer
                        format: int64
                        description: Number of wait trace events pageset/partition P-locks
                      THDTARTO:
                        type: integer
                        format: int64
                        description: Number of wait trace events for page P-locks
                      THDTARTQ:
                        type: integer
                        format: int64
                        description: Number of wait trace events for other P-locks
                      THDTAWTKA:
                        type: string
                        maxLength: 10
                        description: Avg. dur. of wait time due to global cont. for child L-locks
                      THDTAWTMA:
                        type: string
                        maxLength: 10
                        description: Avg. dur. of wait time due to global cont. for other L-locks
                      THDTAWTNA:
                        type: string
                        maxLength: 10
                        description: Avg. dur. of wait time due to gl. cont. for pageset/p P-lock
                      THDTAWTOA:
                        type: string
                        maxLength: 10
                        description: Avg. dur. of wait time due to global cont. for page P-locks
                      THDTAWTQA:
                        type: string
                        maxLength: 10
                        description: Avg. dur. of wait time due to global cont. for other P-locks
                      THDTAWTKP:
                        type: string
                        maxLength: 10
                        description: Percent of wait time due to global cont. for child L-locks
                      THDTAWTMP:
                        type: string
                        maxLength: 10
                        description: Percent of wait time due to global cont. for other L-locks
                      THDTAWTNP:
                        type: string
                        maxLength: 10
                        description: Percent of wait time due to gl. cont. for pageset/p P-lock
                      THDTAWTOP:
                        type: string
                        maxLength: 10
                        description: Percent of wait time due to global cont. for page P-locks
                      THDTAWTQP:
                        type: string
                        maxLength: 10
                        description: Percent of wait time due to global cont. for other P-locks
                      QWACCLS1_ZIIP:
                        type: string
                        maxLength: 16
                        description: Accumulated CPU time executed on zIIP in all environments
                      QWACCLS2_ZIIP:
                        type: string
                        maxLength: 16
                        description: Accumulated CPU time executed on zIIP in DB2
                      QWACTRTT_ZIIP:
                        type: string
                        maxLength: 16
                        description: Accumulated CPU time consumed executing triggers on zIIP
                      QWACZIIP_ELIGIBLE:
                        type: string
                        maxLength: 16
                        description: Acumc. CPU time executed on standard CPU eligible for zIIP
                      QWACSPNF_ZIIP:
                        type: string
                        maxLength: 16
                        description: Accumulated CPU time executing stored procedures on zIIP
                      QWACUDFNF_ZIIP:
                        type: string
                        maxLength: 16
                        description: Reserved
                      ZIIP12ACT:
                        type: string
                        maxLength: 8
                        description: Total class 1 zIIP CPU time / Activity time
                      ZIIP2ACT:
                        type: string
                        maxLength: 8
                        description: Total zIIP CPU time / Activity time
                      ZIIPEL2ACT:
                        type: string
                        maxLength: 8
                        description: Total eligible zIIP CPU time / Activity time
                      ZIIP2DB2T:
                        type: string
                        maxLength: 8
                        description: Total zIIP CPU time / time spent in DB2
                      ZIIPEL2DB2T:
                        type: string
                        maxLength: 8
                        description: Total eligible zIIP CPU time / time spent in DB2
                  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.
