openapi: 3.0.0
info:
  title: SAP API
  version: 1.0.0
servers:
- url: http://localhost:8080
paths:
  /rfc/STU3_GET_LOCKING_CONFLICTS:
    post:
      tags:
      - STU3
      operationId: /rfc/STU3_GET_LOCKING_CONFLICTS
      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
                  description: Get new data from RFCOSCOL?
                FB_LOCK_TAB:
                  type: array
                  items:
                    type: object
                    properties:
                      USERID:
                        type: integer
                        format: int32
                        description: 'DB2/OS390: Unique counter'
                      LOCKID:
                        type: integer
                        format: int32
                        description: Small integer (2 bytes)
                      LOCKMOD:
                        type: string
                        maxLength: 6
                        description: The mode of the lock held on the resource
                      RESTYPE:
                        type: string
                        maxLength: 20
                        description: The type of resource held by a lock
                      DBOWNER:
                        type: string
                        maxLength: 16
                        description: The name of the DB2 database
                      PAGESET:
                        type: string
                        maxLength: 22
                        description: Object name
                      DURATION:
                        type: string
                        maxLength: 12
                        description: Lock duration of the thread holding the resource
                      LOCKTYPE:
                        type: string
                        maxLength: 10
                        description: State of lock
                      LOCKATRI:
                        type: string
                        maxLength: 6
                        description: Lock attribute (logical lock or physical lock)
                FB_THRDS_TAB:
                  type: array
                  items:
                    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
              required:
              - FB_DATATYPE
              - FB_DB2THREADS
              - FB_MY_USER
      responses:
        '200':
          description: OK
          content:
            application/json:
              schema:
                properties:
                  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_LOCK_TAB:
                    type: array
                    items:
                      type: object
                      properties:
                        USERID:
                          type: integer
                          format: int32
                          description: 'DB2/OS390: Unique counter'
                        LOCKID:
                          type: integer
                          format: int32
                          description: Small integer (2 bytes)
                        LOCKMOD:
                          type: string
                          maxLength: 6
                          description: The mode of the lock held on the resource
                        RESTYPE:
                          type: string
                          maxLength: 20
                          description: The type of resource held by a lock
                        DBOWNER:
                          type: string
                          maxLength: 16
                          description: The name of the DB2 database
                        PAGESET:
                          type: string
                          maxLength: 22
                          description: Object name
                        DURATION:
                          type: string
                          maxLength: 12
                          description: Lock duration of the thread holding the resource
                        LOCKTYPE:
                          type: string
                          maxLength: 10
                          description: State of lock
                        LOCKATRI:
                          type: string
                          maxLength: 6
                          description: Lock attribute (logical lock or physical lock)
                  FB_THRDS_TAB:
                    type: array
                    items:
                      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
        '400':
          description: Bad request.
        5XX:
          description: Unexpected error.
