openapi: 3.0.0
info:
  title: SAP API
  version: 1.0.0
servers:
- url: http://localhost:8080
paths:
  /rfc/STU3_GET_LOCK_ACT_DS:
    post:
      tags:
      - STU3
      summary: Get DB2 lock activity information for a thread
      operationId: /rfc/STU3_GET_LOCK_ACT_DS
      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_DB2QTGA:
                    type: object
                    properties:
                      QTGALPLK:
                        type: integer
                        format: int32
                        description: Number of lock requests for P-locks
                      QTGAUPLK:
                        type: integer
                        format: int32
                        description: Number of unlock requests for P-locks
                      QTGACPLK:
                        type: integer
                        format: int32
                        description: Number of Change Requests for P-Locks
                      QTGALSLM:
                        type: integer
                        format: int32
                        description: Number of lock requests propagated to MVS XES synchronously
                      QTGACSLM:
                        type: integer
                        format: int32
                        description: No. of Change Requests Propagated to MVS XES Synchronously
                      QTGAUSLM:
                        type: integer
                        format: int32
                        description: Number of IRLM unlock requests propagated to MVS XES synch.
                      QTGAIGLO:
                        type: integer
                        format: int32
                        description: Number of suspends caused by IRLM global resource contention
                      QTGASGLO:
                        type: integer
                        format: int32
                        description: Suspends caused by MVS XES global resource contention
                      QTGAFLSE:
                        type: integer
                        format: int32
                        description: Number of suspends because of false contentions
                      QTGADRTA:
                        type: integer
                        format: int32
                        description: Incompatible retained lock
                      QTGANTFY:
                        type: integer
                        format: int32
                        description: Number of Notification Messages Sent to Other Members
                      GCONTRATE:
                        type: string
                        maxLength: 10
                        description: Global contention rate
                      FCONTRATE:
                        type: string
                        maxLength: 10
                        description: False contention rate
                      TLOPTRATE:
                        type: string
                        maxLength: 10
                        description: Transaction locking optimization rate
                  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.
