openapi: 3.0.0
info:
  title: SAP API
  version: 1.0.0
servers:
- url: http://localhost:8080
paths:
  /rfc/DB6_PM_LOCKSNAP:
    post:
      tags:
      - SDB6PM
      summary: 'DB6: Get Lock Snapshot'
      operationId: /rfc/DB6_PM_LOCKSNAP
      requestBody:
        content:
          application/json:
            schema:
              properties:
                ACTION:
                  type: integer
                  format: int32
                CALLERFLAG:
                  type: string
                  maxLength: 1
                  description: Who Has Called this Program
                COMPTIME:
                  type: string
                  maxLength: 14
                  description: 'DB6: Timestamp (Format: YYYYMMDDHHMMSS)'
                CONNECTION:
                  type: string
                  maxLength: 30
                  description: Logical name for a database connection
                PARTITN:
                  type: integer
                  format: int32
                  description: Partition Number
                IT_DB6PMSL_AP:
                  type: array
                  items:
                    type: object
                    properties:
                      COMPTIME:
                        type: string
                        maxLength: 14
                        description: 'DB6: Timestamp (Format: YYYYMMDDHHMMSS)'
                      PARTITN:
                        type: integer
                        format: int32
                        description: Partition Number
                      AGENT_ID:
                        type: integer
                        format: int64
                        description: 'agent_id: Application Handle'
                      CALLERFLAG:
                        type: string
                        maxLength: 1
                        description: Who Has Called this Program
                      DBMSTRTTME:
                        type: string
                        maxLength: 14
                        description: 'DB6: Timestamp (Format: YYYYMMDDHHMMSS)'
                      PRGVERS:
                        type: string
                        maxLength: 20
                        description: Version of Program Inserted this Row
                      IPADDRESS:
                        type: string
                        maxLength: 15
                        description: 'ipaddress: IP Address Resolved from appl_id'
                      AP_STATUS:
                        type: string
                        maxLength: 50
                        description: 'appl_status: Application Status'
                      CODEPG_ID:
                        type: integer
                        format: int64
                        description: 'codepage_id: Codepage/CCSID at Node Where Appl. Started'
                      LCKS_HELD:
                        type: integer
                        format: int64
                        description: 'locks_held: Locks Currently Held by Application'
                      NUM_LOCKS:
                        type: integer
                        format: int64
                        description: 'num_locks: Number of sqlm_lock Structures Returned'
                      STAT_CHGTM:
                        type: string
                        maxLength: 14
                        description: 'DB6: Timestamp (Format: YYYYMMDDHHMMSS)'
                      APPL_ID:
                        type: string
                        maxLength: 32
                        description: 'DB6: Long identifier'
                      SEQU_NO:
                        type: string
                        maxLength: 5
                        description: 'sequence_no: Application ID Sequence Number'
                      APPL_NAME:
                        type: string
                        maxLength: 20
                        description: 'DB6: General identifier'
                      AUTH_ID:
                        type: string
                        maxLength: 20
                        description: 'DB6: General identifier'
                      CLI_DBALIA:
                        type: string
                        maxLength: 20
                        description: 'DB6: General identifier'
                      LCK_W_TM:
                        type: integer
                        format: int64
                        description: 'lock_wait_time: Total Wait Time in Milliseconds'
                      NUM_LCKWT:
                        type: integer
                        format: int64
                        description: 'num_lockwaits: Number of sqlm_lock_wait Following'
                IT_DB6PMSL_DB:
                  type: array
                  items:
                    type: object
                    properties:
                      COMPTIME:
                        type: string
                        maxLength: 14
                        description: 'DB6: Timestamp (Format: YYYYMMDDHHMMSS)'
                      PARTITN:
                        type: integer
                        format: int32
                        description: Partition Number
                      CALLERFLAG:
                        type: string
                        maxLength: 1
                        description: Who Has Called this Program
                      DBMSTRTTME:
                        type: string
                        maxLength: 14
                        description: 'DB6: Timestamp (Format: YYYYMMDDHHMMSS)'
                      PRGVERS:
                        type: string
                        maxLength: 20
                        description: Version of Program Inserted this Row
                      LCKS_HELD:
                        type: integer
                        format: int64
                        description: 'locks_held: Number of Locks Currently Held'
                      APL_CUR_CO:
                        type: integer
                        format: int64
                        description: 'appls_cur_cons: Applications Currently Connected'
                      NUM_APPLS:
                        type: integer
                        format: int64
                        description: 'num_appls: Number of sqlm_appl_lock Structures Returned'
                      LCK_WTING:
                        type: integer
                        format: int64
                        description: 'locks_waiting: Agents Currently Waiting for Locks'
                      IN_DB_ALIA:
                        type: string
                        maxLength: 20
                        description: 'DB6: General identifier'
                      DB_NAME:
                        type: string
                        maxLength: 20
                        description: 'DB6: General identifier'
                      DB_PATH:
                        type: string
                        maxLength: 255
                        description: 'DB6: File Path'
                IT_DB6PMSL_LK:
                  type: array
                  items:
                    type: object
                    properties:
                      COMPTIME:
                        type: string
                        maxLength: 14
                        description: 'DB6: Timestamp (Format: YYYYMMDDHHMMSS)'
                      PARTITN:
                        type: integer
                        format: int32
                        description: Partition Number
                      AGENT_ID:
                        type: integer
                        format: int64
                        description: 'agent_id: Application Handle'
                      ARTIF_KEY:
                        type: integer
                        format: int32
                        description: 'artif_key: Artificial Key for Uniqueness'
                      CALLERFLAG:
                        type: string
                        maxLength: 1
                        description: Who Has Called this Program
                      DBMSTRTTME:
                        type: string
                        maxLength: 14
                        description: 'DB6: Timestamp (Format: YYYYMMDDHHMMSS)'
                      PRGVERS:
                        type: string
                        maxLength: 20
                        description: Version of Program Inserted this Row
                      LCK_ESCLTN:
                        type: string
                        maxLength: 1
                        description: 'lock_escalation: Was this Lock Part of an Escalation'
                      TAB_FLE_ID:
                        type: integer
                        format: int64
                        description: 'table_file_id: FID of Table Involved in Lock'
                      LCK_OBJ_TY:
                        type: string
                        maxLength: 25
                        description: 'lock_object_type: Lock Object Type: Row, Table'
                      LOCK_MODE:
                        type: string
                        maxLength: 5
                        description: 'lock_mode: Lock Mode'
                      LCK_STATUS:
                        type: string
                        maxLength: 25
                        description: 'lock_status: Lock Status'
                      LCK_OBJ_NM:
                        type: integer
                        format: int64
                        description: 'lock_object_name: Lock Object Name - RID or FID of Lock Obj.'
                      TABLE_NAME:
                        type: string
                        maxLength: 20
                        description: 'DB6: General identifier'
                      TAB_SCHEMA:
                        type: string
                        maxLength: 20
                        description: 'DB6: General identifier'
                      TBS_NAME:
                        type: string
                        maxLength: 20
                        description: 'DB6: General identifier'
                IT_DB6PMSL_LW:
                  type: array
                  items:
                    type: object
                    properties:
                      COMPTIME:
                        type: string
                        maxLength: 14
                        description: 'DB6: Timestamp (Format: YYYYMMDDHHMMSS)'
                      PARTITN:
                        type: integer
                        format: int32
                        description: Partition Number
                      AGENT_ID:
                        type: integer
                        format: int64
                        description: 'agent_id: Application Handle'
                      ARTIF_KEY:
                        type: integer
                        format: int32
                        description: 'artif_key: Artificial Key for Uniqueness'
                      CALLERFLAG:
                        type: string
                        maxLength: 1
                        description: Who Has Called this Program
                      DBMSTRTTME:
                        type: string
                        maxLength: 14
                        description: 'DB6: Timestamp (Format: YYYYMMDDHHMMSS)'
                      PRGVERS:
                        type: string
                        maxLength: 20
                        description: Version of Program Inserted this Row
                      LCK_ESCLTN:
                        type: string
                        maxLength: 1
                        description: 'lock_escalation: Was this Lock Part of an Escalation'
                      SUBSEC_NUM:
                        type: integer
                        format: int64
                        description: 'subsection_number: Subsection Waiting for Lock'
                      LOCK_MODE:
                        type: string
                        maxLength: 5
                        description: 'lock_mode: Mode of Lock Waited For'
                      LCK_OBJ_TY:
                        type: string
                        maxLength: 25
                        description: 'lock_object_type: Lock Object Type: Row, Table, ...'
                      LCK_W_STTM:
                        type: string
                        maxLength: 14
                        description: 'DB6: Timestamp (Format: YYYYMMDDHHMMSS)'
                      TABLE_NAME:
                        type: string
                        maxLength: 20
                        description: 'DB6: General identifier'
                      TAB_SCHEMA:
                        type: string
                        maxLength: 20
                        description: 'DB6: General identifier'
                      TBS_NAME:
                        type: string
                        maxLength: 20
                        description: 'DB6: General identifier'
                      AGTID_HOLK:
                        type: integer
                        format: int64
                        description: 'agent_id_holding_lk: Application Holding the Lock'
                      APID_HOLK:
                        type: string
                        maxLength: 32
                        description: 'DB6: Long identifier'
                      LCK_MOD_RQ:
                        type: string
                        maxLength: 5
                        description: 'lock_mode_requested: Lock Mode'
              required:
              - ACTION
              - CALLERFLAG
              - PARTITN
      responses:
        '200':
          description: OK
          content:
            application/json:
              schema:
                properties:
                  IT_DB6PMSL_AP:
                    type: array
                    items:
                      type: object
                      properties:
                        COMPTIME:
                          type: string
                          maxLength: 14
                          description: 'DB6: Timestamp (Format: YYYYMMDDHHMMSS)'
                        PARTITN:
                          type: integer
                          format: int32
                          description: Partition Number
                        AGENT_ID:
                          type: integer
                          format: int64
                          description: 'agent_id: Application Handle'
                        CALLERFLAG:
                          type: string
                          maxLength: 1
                          description: Who Has Called this Program
                        DBMSTRTTME:
                          type: string
                          maxLength: 14
                          description: 'DB6: Timestamp (Format: YYYYMMDDHHMMSS)'
                        PRGVERS:
                          type: string
                          maxLength: 20
                          description: Version of Program Inserted this Row
                        IPADDRESS:
                          type: string
                          maxLength: 15
                          description: 'ipaddress: IP Address Resolved from appl_id'
                        AP_STATUS:
                          type: string
                          maxLength: 50
                          description: 'appl_status: Application Status'
                        CODEPG_ID:
                          type: integer
                          format: int64
                          description: 'codepage_id: Codepage/CCSID at Node Where Appl. Started'
                        LCKS_HELD:
                          type: integer
                          format: int64
                          description: 'locks_held: Locks Currently Held by Application'
                        NUM_LOCKS:
                          type: integer
                          format: int64
                          description: 'num_locks: Number of sqlm_lock Structures Returned'
                        STAT_CHGTM:
                          type: string
                          maxLength: 14
                          description: 'DB6: Timestamp (Format: YYYYMMDDHHMMSS)'
                        APPL_ID:
                          type: string
                          maxLength: 32
                          description: 'DB6: Long identifier'
                        SEQU_NO:
                          type: string
                          maxLength: 5
                          description: 'sequence_no: Application ID Sequence Number'
                        APPL_NAME:
                          type: string
                          maxLength: 20
                          description: 'DB6: General identifier'
                        AUTH_ID:
                          type: string
                          maxLength: 20
                          description: 'DB6: General identifier'
                        CLI_DBALIA:
                          type: string
                          maxLength: 20
                          description: 'DB6: General identifier'
                        LCK_W_TM:
                          type: integer
                          format: int64
                          description: 'lock_wait_time: Total Wait Time in Milliseconds'
                        NUM_LCKWT:
                          type: integer
                          format: int64
                          description: 'num_lockwaits: Number of sqlm_lock_wait Following'
                  IT_DB6PMSL_DB:
                    type: array
                    items:
                      type: object
                      properties:
                        COMPTIME:
                          type: string
                          maxLength: 14
                          description: 'DB6: Timestamp (Format: YYYYMMDDHHMMSS)'
                        PARTITN:
                          type: integer
                          format: int32
                          description: Partition Number
                        CALLERFLAG:
                          type: string
                          maxLength: 1
                          description: Who Has Called this Program
                        DBMSTRTTME:
                          type: string
                          maxLength: 14
                          description: 'DB6: Timestamp (Format: YYYYMMDDHHMMSS)'
                        PRGVERS:
                          type: string
                          maxLength: 20
                          description: Version of Program Inserted this Row
                        LCKS_HELD:
                          type: integer
                          format: int64
                          description: 'locks_held: Number of Locks Currently Held'
                        APL_CUR_CO:
                          type: integer
                          format: int64
                          description: 'appls_cur_cons: Applications Currently Connected'
                        NUM_APPLS:
                          type: integer
                          format: int64
                          description: 'num_appls: Number of sqlm_appl_lock Structures Returned'
                        LCK_WTING:
                          type: integer
                          format: int64
                          description: 'locks_waiting: Agents Currently Waiting for Locks'
                        IN_DB_ALIA:
                          type: string
                          maxLength: 20
                          description: 'DB6: General identifier'
                        DB_NAME:
                          type: string
                          maxLength: 20
                          description: 'DB6: General identifier'
                        DB_PATH:
                          type: string
                          maxLength: 255
                          description: 'DB6: File Path'
                  IT_DB6PMSL_LK:
                    type: array
                    items:
                      type: object
                      properties:
                        COMPTIME:
                          type: string
                          maxLength: 14
                          description: 'DB6: Timestamp (Format: YYYYMMDDHHMMSS)'
                        PARTITN:
                          type: integer
                          format: int32
                          description: Partition Number
                        AGENT_ID:
                          type: integer
                          format: int64
                          description: 'agent_id: Application Handle'
                        ARTIF_KEY:
                          type: integer
                          format: int32
                          description: 'artif_key: Artificial Key for Uniqueness'
                        CALLERFLAG:
                          type: string
                          maxLength: 1
                          description: Who Has Called this Program
                        DBMSTRTTME:
                          type: string
                          maxLength: 14
                          description: 'DB6: Timestamp (Format: YYYYMMDDHHMMSS)'
                        PRGVERS:
                          type: string
                          maxLength: 20
                          description: Version of Program Inserted this Row
                        LCK_ESCLTN:
                          type: string
                          maxLength: 1
                          description: 'lock_escalation: Was this Lock Part of an Escalation'
                        TAB_FLE_ID:
                          type: integer
                          format: int64
                          description: 'table_file_id: FID of Table Involved in Lock'
                        LCK_OBJ_TY:
                          type: string
                          maxLength: 25
                          description: 'lock_object_type: Lock Object Type: Row, Table'
                        LOCK_MODE:
                          type: string
                          maxLength: 5
                          description: 'lock_mode: Lock Mode'
                        LCK_STATUS:
                          type: string
                          maxLength: 25
                          description: 'lock_status: Lock Status'
                        LCK_OBJ_NM:
                          type: integer
                          format: int64
                          description: 'lock_object_name: Lock Object Name - RID or FID of Lock Obj.'
                        TABLE_NAME:
                          type: string
                          maxLength: 20
                          description: 'DB6: General identifier'
                        TAB_SCHEMA:
                          type: string
                          maxLength: 20
                          description: 'DB6: General identifier'
                        TBS_NAME:
                          type: string
                          maxLength: 20
                          description: 'DB6: General identifier'
                  IT_DB6PMSL_LW:
                    type: array
                    items:
                      type: object
                      properties:
                        COMPTIME:
                          type: string
                          maxLength: 14
                          description: 'DB6: Timestamp (Format: YYYYMMDDHHMMSS)'
                        PARTITN:
                          type: integer
                          format: int32
                          description: Partition Number
                        AGENT_ID:
                          type: integer
                          format: int64
                          description: 'agent_id: Application Handle'
                        ARTIF_KEY:
                          type: integer
                          format: int32
                          description: 'artif_key: Artificial Key for Uniqueness'
                        CALLERFLAG:
                          type: string
                          maxLength: 1
                          description: Who Has Called this Program
                        DBMSTRTTME:
                          type: string
                          maxLength: 14
                          description: 'DB6: Timestamp (Format: YYYYMMDDHHMMSS)'
                        PRGVERS:
                          type: string
                          maxLength: 20
                          description: Version of Program Inserted this Row
                        LCK_ESCLTN:
                          type: string
                          maxLength: 1
                          description: 'lock_escalation: Was this Lock Part of an Escalation'
                        SUBSEC_NUM:
                          type: integer
                          format: int64
                          description: 'subsection_number: Subsection Waiting for Lock'
                        LOCK_MODE:
                          type: string
                          maxLength: 5
                          description: 'lock_mode: Mode of Lock Waited For'
                        LCK_OBJ_TY:
                          type: string
                          maxLength: 25
                          description: 'lock_object_type: Lock Object Type: Row, Table, ...'
                        LCK_W_STTM:
                          type: string
                          maxLength: 14
                          description: 'DB6: Timestamp (Format: YYYYMMDDHHMMSS)'
                        TABLE_NAME:
                          type: string
                          maxLength: 20
                          description: 'DB6: General identifier'
                        TAB_SCHEMA:
                          type: string
                          maxLength: 20
                          description: 'DB6: General identifier'
                        TBS_NAME:
                          type: string
                          maxLength: 20
                          description: 'DB6: General identifier'
                        AGTID_HOLK:
                          type: integer
                          format: int64
                          description: 'agent_id_holding_lk: Application Holding the Lock'
                        APID_HOLK:
                          type: string
                          maxLength: 32
                          description: 'DB6: Long identifier'
                        LCK_MOD_RQ:
                          type: string
                          maxLength: 5
                          description: 'lock_mode_requested: Lock Mode'
        '400':
          description: Bad request.
        5XX:
          description: Unexpected error.
