openapi: 3.0.0
info:
  title: SAP API
  version: 1.0.0
servers:
- url: http://localhost:8080
paths:
  /rfc/GET_LOCKINFO_MSS:
    post:
      tags:
      - SFMSS_LM
      summary: retrieve blocking/locking data
      operationId: /rfc/GET_LOCKINFO_MSS
      requestBody:
        content:
          application/json:
            schema:
              properties:
                CON_NAME:
                  type: string
                  maxLength: 30
                  description: Logical name for a database connection
                LIGHTWEIGHT:
                  type: integer
                  format: int32
                  default: 0
                  description: 0 - normal, 1 - sm66
                SAVEDDATA:
                  type: integer
                  format: int32
                  default: 0
                  description: 0 - real time, 1-table sap_dblocks
                SCHEMA:
                  type: string
                  default: ' '
                  maxLength: 128
                  description: Schema name
                LOCKINFO:
                  type: array
                  items:
                    type: object
                    properties:
                      ACTFLAG:
                        type: integer
                        format: int32
                        description: ''
                      FIRSTOCCUR:
                        type: string
                        maxLength: 23
                        description: ''
                      REQSPID:
                        type: integer
                        format: int32
                        description: MS SQL Server process ID
                      HOLDSPID:
                        type: integer
                        format: int32
                        description: MS SQL Server process ID (blocking)
                      REQPID:
                        type: string
                        maxLength: 8
                        description: MS SQL-Server host process id (= OS work process ID)
                      OPEN_TRAN:
                        type: integer
                        format: int32
                        description: Number of open transactions for the SQL Server process
                      PROCSTAT:
                        type: string
                        maxLength: 10
                        description: MS SQL-Server process status
                      USERNAME:
                        type: string
                        maxLength: 30
                        description: MS SQL Server user name
                      HOSTNAME:
                        type: string
                        maxLength: 30
                        description: Hostname of the application server logged into SQL Server
                      PROGNAME:
                        type: string
                        maxLength: 30
                        description: Name of the application program which owns the connection
                      COMMAND:
                        type: string
                        maxLength: 16
                        description: MS SQL Server command
                      INPUTBUFF:
                        type: string
                        maxLength: 40
                        description: Output from DBCC INPUTBUFFER for  lock display
                      WAITTIME:
                        type: integer
                        format: int32
                        description: Current wait time of the process in milliseconds
                      WAITRSC:
                        type: string
                        maxLength: 40
                        description: Wait Resource as seen in sysprocesses
                      LASTWTYPE:
                        type: string
                        maxLength: 32
                        description: Last Wait Type as seen in sysprocesses
                      DBNAME:
                        type: string
                        maxLength: 30
                        description: 'MS SQL Server: Database name'
                      OBJNAME:
                        type: string
                        maxLength: 30
                        description: Table name
                      INDEXNAME:
                        type: string
                        maxLength: 30
                        description: MS SQL Server object name
                      LOCKRSC:
                        type: string
                        maxLength: 32
                        description: Textual description of a lock resource from syslockinfo
                      LOCKTYPE:
                        type: string
                        maxLength: 10
                        description: Char representation of rsc_type from syslockinfo
                      LOCKNAME:
                        type: string
                        maxLength: 35
                        description: MS SQL Server lock description text
                      LOCKSTAT:
                        type: string
                        maxLength: 10
                        description: req_mod from syslockinfo for blocking/blocked lock entry
                      REQ_REFCNT:
                        type: integer
                        format: int32
                        description: req_refcnt from syslockinfo for blocking/blocked lock entry
                      REQ_OWNERTYPE:
                        type: string
                        maxLength: 12
                        description: req_refcnt from syslockinfo for blocking/blocked lock entry
                LOCKINFO_SNAP:
                  type: array
                  items:
                    type: object
                    properties:
                      ACTFLAG:
                        type: integer
                        format: int32
                        description: ''
                      FIRSTOCCUR:
                        type: string
                        maxLength: 23
                        description: ''
                      REQSPID:
                        type: integer
                        format: int32
                        description: MS SQL Server process ID
                      HOLDSPID:
                        type: integer
                        format: int32
                        description: MS SQL Server process ID (blocking)
                      REQPID:
                        type: string
                        maxLength: 8
                        description: MS SQL-Server host process id (= OS work process ID)
                      OPEN_TRAN:
                        type: integer
                        format: int32
                        description: Number of open transactions for the SQL Server process
                      PROCSTAT:
                        type: string
                        maxLength: 10
                        description: MS SQL-Server process status
                      USERNAME:
                        type: string
                        maxLength: 30
                        description: MS SQL Server user name
                      HOSTNAME:
                        type: string
                        maxLength: 30
                        description: Hostname of the application server logged into SQL Server
                      PROGNAME:
                        type: string
                        maxLength: 30
                        description: Name of the application program which owns the connection
                      COMMAND:
                        type: string
                        maxLength: 16
                        description: MS SQL Server command
                      INPUTBUFF:
                        type: string
                        maxLength: 40
                        description: Output from DBCC INPUTBUFFER for  lock display
                      WAITTIME:
                        type: integer
                        format: int32
                        description: Current wait time of the process in milliseconds
                      WAITRSC:
                        type: string
                        maxLength: 40
                        description: Wait Resource as seen in sysprocesses
                      LASTWTYPE:
                        type: string
                        maxLength: 32
                        description: Last Wait Type as seen in sysprocesses
                      DBNAME:
                        type: string
                        maxLength: 30
                        description: 'MS SQL Server: Database name'
                      OBJNAME:
                        type: string
                        maxLength: 30
                        description: Table name
                      INDEXNAME:
                        type: string
                        maxLength: 30
                        description: MS SQL Server object name
                      LOCKRSC:
                        type: string
                        maxLength: 32
                        description: Textual description of a lock resource from syslockinfo
                      LOCKTYPE:
                        type: string
                        maxLength: 10
                        description: Char representation of rsc_type from syslockinfo
                      LOCKNAME:
                        type: string
                        maxLength: 35
                        description: MS SQL Server lock description text
                      LOCKSTAT:
                        type: string
                        maxLength: 10
                        description: req_mod from syslockinfo for blocking/blocked lock entry
                      REQ_REFCNT:
                        type: integer
                        format: int32
                        description: req_refcnt from syslockinfo for blocking/blocked lock entry
                      REQ_OWNERTYPE:
                        type: string
                        maxLength: 12
                        description: req_refcnt from syslockinfo for blocking/blocked lock entry
                      SQLHANDLE:
                        type: string
                        maxLength: 128
                        description: handle pointing to sql statment  or procedure
                      STMT_START_OFFSET:
                        type: integer
                        format: int32
                        description: SQL Server int4
                      STMT_END_OFFSET:
                        type: integer
                        format: int32
                        description: SQL Server int4
                      PLAN_HANDLE:
                        type: string
                        maxLength: 128
                        description: handle pointing to plan used in execution of sql stmt/proc
      responses:
        '200':
          description: OK
          content:
            application/json:
              schema:
                properties:
                  LOCKINFO:
                    type: array
                    items:
                      type: object
                      properties:
                        ACTFLAG:
                          type: integer
                          format: int32
                          description: ''
                        FIRSTOCCUR:
                          type: string
                          maxLength: 23
                          description: ''
                        REQSPID:
                          type: integer
                          format: int32
                          description: MS SQL Server process ID
                        HOLDSPID:
                          type: integer
                          format: int32
                          description: MS SQL Server process ID (blocking)
                        REQPID:
                          type: string
                          maxLength: 8
                          description: MS SQL-Server host process id (= OS work process ID)
                        OPEN_TRAN:
                          type: integer
                          format: int32
                          description: Number of open transactions for the SQL Server process
                        PROCSTAT:
                          type: string
                          maxLength: 10
                          description: MS SQL-Server process status
                        USERNAME:
                          type: string
                          maxLength: 30
                          description: MS SQL Server user name
                        HOSTNAME:
                          type: string
                          maxLength: 30
                          description: Hostname of the application server logged into SQL Server
                        PROGNAME:
                          type: string
                          maxLength: 30
                          description: Name of the application program which owns the connection
                        COMMAND:
                          type: string
                          maxLength: 16
                          description: MS SQL Server command
                        INPUTBUFF:
                          type: string
                          maxLength: 40
                          description: Output from DBCC INPUTBUFFER for  lock display
                        WAITTIME:
                          type: integer
                          format: int32
                          description: Current wait time of the process in milliseconds
                        WAITRSC:
                          type: string
                          maxLength: 40
                          description: Wait Resource as seen in sysprocesses
                        LASTWTYPE:
                          type: string
                          maxLength: 32
                          description: Last Wait Type as seen in sysprocesses
                        DBNAME:
                          type: string
                          maxLength: 30
                          description: 'MS SQL Server: Database name'
                        OBJNAME:
                          type: string
                          maxLength: 30
                          description: Table name
                        INDEXNAME:
                          type: string
                          maxLength: 30
                          description: MS SQL Server object name
                        LOCKRSC:
                          type: string
                          maxLength: 32
                          description: Textual description of a lock resource from syslockinfo
                        LOCKTYPE:
                          type: string
                          maxLength: 10
                          description: Char representation of rsc_type from syslockinfo
                        LOCKNAME:
                          type: string
                          maxLength: 35
                          description: MS SQL Server lock description text
                        LOCKSTAT:
                          type: string
                          maxLength: 10
                          description: req_mod from syslockinfo for blocking/blocked lock entry
                        REQ_REFCNT:
                          type: integer
                          format: int32
                          description: req_refcnt from syslockinfo for blocking/blocked lock entry
                        REQ_OWNERTYPE:
                          type: string
                          maxLength: 12
                          description: req_refcnt from syslockinfo for blocking/blocked lock entry
                  LOCKINFO_SNAP:
                    type: array
                    items:
                      type: object
                      properties:
                        ACTFLAG:
                          type: integer
                          format: int32
                          description: ''
                        FIRSTOCCUR:
                          type: string
                          maxLength: 23
                          description: ''
                        REQSPID:
                          type: integer
                          format: int32
                          description: MS SQL Server process ID
                        HOLDSPID:
                          type: integer
                          format: int32
                          description: MS SQL Server process ID (blocking)
                        REQPID:
                          type: string
                          maxLength: 8
                          description: MS SQL-Server host process id (= OS work process ID)
                        OPEN_TRAN:
                          type: integer
                          format: int32
                          description: Number of open transactions for the SQL Server process
                        PROCSTAT:
                          type: string
                          maxLength: 10
                          description: MS SQL-Server process status
                        USERNAME:
                          type: string
                          maxLength: 30
                          description: MS SQL Server user name
                        HOSTNAME:
                          type: string
                          maxLength: 30
                          description: Hostname of the application server logged into SQL Server
                        PROGNAME:
                          type: string
                          maxLength: 30
                          description: Name of the application program which owns the connection
                        COMMAND:
                          type: string
                          maxLength: 16
                          description: MS SQL Server command
                        INPUTBUFF:
                          type: string
                          maxLength: 40
                          description: Output from DBCC INPUTBUFFER for  lock display
                        WAITTIME:
                          type: integer
                          format: int32
                          description: Current wait time of the process in milliseconds
                        WAITRSC:
                          type: string
                          maxLength: 40
                          description: Wait Resource as seen in sysprocesses
                        LASTWTYPE:
                          type: string
                          maxLength: 32
                          description: Last Wait Type as seen in sysprocesses
                        DBNAME:
                          type: string
                          maxLength: 30
                          description: 'MS SQL Server: Database name'
                        OBJNAME:
                          type: string
                          maxLength: 30
                          description: Table name
                        INDEXNAME:
                          type: string
                          maxLength: 30
                          description: MS SQL Server object name
                        LOCKRSC:
                          type: string
                          maxLength: 32
                          description: Textual description of a lock resource from syslockinfo
                        LOCKTYPE:
                          type: string
                          maxLength: 10
                          description: Char representation of rsc_type from syslockinfo
                        LOCKNAME:
                          type: string
                          maxLength: 35
                          description: MS SQL Server lock description text
                        LOCKSTAT:
                          type: string
                          maxLength: 10
                          description: req_mod from syslockinfo for blocking/blocked lock entry
                        REQ_REFCNT:
                          type: integer
                          format: int32
                          description: req_refcnt from syslockinfo for blocking/blocked lock entry
                        REQ_OWNERTYPE:
                          type: string
                          maxLength: 12
                          description: req_refcnt from syslockinfo for blocking/blocked lock entry
                        SQLHANDLE:
                          type: string
                          maxLength: 128
                          description: handle pointing to sql statment  or procedure
                        STMT_START_OFFSET:
                          type: integer
                          format: int32
                          description: SQL Server int4
                        STMT_END_OFFSET:
                          type: integer
                          format: int32
                          description: SQL Server int4
                        PLAN_HANDLE:
                          type: string
                          maxLength: 128
                          description: handle pointing to plan used in execution of sql stmt/proc
        '400':
          description: Bad request.
        5XX:
          description: Unexpected error.
