openapi: 3.0.0
info:
  title: SAP API
  version: 1.0.0
servers:
- url: http://localhost:8080
paths:
  /rfc/DB6_PM_DBMSNAP:
    post:
      tags:
      - SDB6PM
      summary: 'DB6: Get Database Manager Snapshot'
      operationId: /rfc/DB6_PM_DBMSNAP
      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_DB6PMSM:
                  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
                      SRT_HP_ALO:
                        type: integer
                        format: int64
                        description: 'sort_heap_allocated: Sort Heap Currently Allocated'
                      PT_THSORTS:
                        type: integer
                        format: int64
                        description: 'post_threshold_sorts: # Sorts Started After Heap Threshold E'
                      PPD_SRT_RQ:
                        type: integer
                        format: int64
                        description: 'piped_sorts_requested: No of Piped Sorts Requested by RDS to'
                      PPD_SRT_AC:
                        type: integer
                        format: int64
                        description: 'piped_sorts_accepted: No. of Piped Sorts Accepted by SLS'
                      DB2_STRTTM:
                        type: string
                        maxLength: 14
                        description: 'DB6: Timestamp (Format: YYYYMMDDHHMMSS)'
                      LAST_RESET:
                        type: string
                        maxLength: 14
                        description: 'DB6: Timestamp (Format: YYYYMMDDHHMMSS)'
                      REM_CN_IN:
                        type: integer
                        format: int64
                        description: 'rem_cons_in: Remote Connects to Target DB2'
                      REM_CN_INE:
                        type: integer
                        format: int64
                        description: 'rem_cons_in_exec: Remote Connects to Target Exec. DB2'
                      LOCAL_CONS:
                        type: integer
                        format: int64
                        description: 'local_cons: Current Local Connections'
                      LOCL_CN_IE:
                        type: integer
                        format: int64
                        description: 'local_cons_in_exec: Local Connects Curr. Executed in DB2'
                      CN_LC_DBS:
                        type: integer
                        format: int64
                        description: 'con_local_dbases: Local Databases with Current Connects'
                      AGT_REG:
                        type: integer
                        format: int64
                        description: 'agents_registered: Number of Agents Registered in DB2'
                      AGT_WAI_TK:
                        type: integer
                        format: int64
                        description: 'agents_waiting_on_token: No. of Agents Waiting for a Token'
                      UOW_SW:
                        type: string
                        maxLength: 5
                        description: 'dbmon_sw_settings: SQLM_OFF, SQLM_ON'
                      UOW_SWSTM:
                        type: string
                        maxLength: 14
                        description: 'DB6: Timestamp (Format: YYYYMMDDHHMMSS)'
                      STMT_SW:
                        type: string
                        maxLength: 5
                        description: 'dbmon_sw_settings: SQLM_OFF, SQLM_ON'
                      STMT_SWSTM:
                        type: string
                        maxLength: 14
                        description: 'DB6: Timestamp (Format: YYYYMMDDHHMMSS)'
                      TAB_SW:
                        type: string
                        maxLength: 5
                        description: 'dbmon_sw_settings: SQLM_OFF, SQLM_ON'
                      TAB_SWSTM:
                        type: string
                        maxLength: 14
                        description: 'DB6: Timestamp (Format: YYYYMMDDHHMMSS)'
                      BP_SW:
                        type: string
                        maxLength: 5
                        description: 'dbmon_sw_settings: SQLM_OFF, SQLM_ON'
                      BP_SWSTM:
                        type: string
                        maxLength: 14
                        description: 'DB6: Timestamp (Format: YYYYMMDDHHMMSS)'
                      LCK_SW:
                        type: string
                        maxLength: 5
                        description: 'dbmon_sw_settings: SQLM_OFF, SQLM_ON'
                      LCK_SW_STM:
                        type: string
                        maxLength: 14
                        description: 'DB6: Timestamp (Format: YYYYMMDDHHMMSS)'
                      SRT_SW:
                        type: string
                        maxLength: 5
                        description: 'dbmon_sw_settings: SQLM_OFF, SQLM_ON'
                      SRT_SWSTM:
                        type: string
                        maxLength: 14
                        description: 'DB6: Timestamp (Format: YYYYMMDDHHMMSS)'
                      DB2_STATUS:
                        type: string
                        maxLength: 25
                        description: 'db2_status: Status of the DB2 Instance (Active, Quiesced ...'
                      AGT_REG_TP:
                        type: integer
                        format: int64
                        description: 'agents_registered_top: agents_registered High Water Mark'
                      AGT_WAI_TP:
                        type: integer
                        format: int64
                        description: 'agents_waiting_top: agents_waiting High Water Mark'
                      COMM_PIMEM:
                        type: integer
                        format: int64
                        description: 'comm_private_mem: Committed Private Memory (Bytes)'
                      IDEL_AG:
                        type: integer
                        format: int64
                        description: 'idle_agents: Number of Unassigned Agents in Pool'
                      AGT_FR_PO:
                        type: integer
                        format: int64
                        description: 'agents_from_pool: Number of Agents Assigned from Pool'
                      AGT_CR_EPO:
                        type: integer
                        format: int64
                        description: agents_created_empty_pool:# Agents Created due to Pool Empty
                      CRD_AG_TOP:
                        type: integer
                        format: int64
                        description: 'coord_agents_top: Coordinating Agents High Water Mark'
                      MX_AG_OF:
                        type: integer
                        format: int64
                        description: 'max_agent_overflows: # of Attempts Exceeding the MAXAGENTS C'
                      AGT_STOLEN:
                        type: integer
                        format: int64
                        description: 'agents_stolen: Number of Agents Stolen'
                      NUM_SCDBMS:
                        type: integer
                        format: int64
                        description: 'num_sec_dbm_structs: Secondary Database Manager Info'
                      PROD_NAME:
                        type: string
                        maxLength: 32
                        description: 'DB6: Long identifier'
                      COMPO_ID:
                        type: string
                        maxLength: 20
                        description: 'DB6: General identifier'
                      SVC_LEVEL:
                        type: string
                        maxLength: 8
                        description: 'service_level: Service Level'
                      GW_TIT_CN:
                        type: integer
                        format: int64
                        description: 'gw_total_cons: DDCS Total Number of Gateway Connections'
                      GW_CUR_CN:
                        type: integer
                        format: int64
                        description: 'gw_cur_cons: DDCS Current Number of Gateway Connections'
                      GW_CN_W_HT:
                        type: integer
                        format: int64
                        description: 'gw_cons_wait_host: DDCS # Gateway Conn. Waiting for Host Rep'
                      GW_CN_W_CL:
                        type: integer
                        format: int64
                        description: 'gw_cons_wait_client: DDCS Gateway Conn. Waiting for Client R'
                      PT_THHAJN:
                        type: integer
                        format: int64
                        description: 'post_threshold_hash_joins: DDCS #Hash Joins Started After He'
                      NUM_GW_CONN_SW:
                        type: integer
                        format: int64
                        description: num_gw_conn_switches
                      NUM_NODES_INST:
                        type: integer
                        format: int64
                        description: num_nodes_in_db2_instance
                      SORT_HEAP_TOP:
                        type: integer
                        format: int64
                        description: sort_heap_top
                      TM_SW:
                        type: string
                        maxLength: 5
                        description: 'dbmon_sw_settings: SQLM_OFF, SQLM_ON'
                      TM_SWSTM:
                        type: string
                        maxLength: 14
                        description: 'DB6: Timestamp (Format: YYYYMMDDHHMMSS)'
                IT_DB6PMSM_FC:
                  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
                      BF_FREE:
                        type: integer
                        format: int64
                        description: 'buff_free: Number of Free FCM Buffers'
                      BF_FREE_BT:
                        type: integer
                        format: int64
                        description: 'buff_free_bottom: Low Water Mark of Free Buffers'
                      MA_FREE:
                        type: integer
                        format: int64
                        description: 'MA_free: Number of Free FCM Message Anchors'
                      MA_FREE_BT:
                        type: integer
                        format: int64
                        description: 'MA_free_bottom: Low Water Mark of Free Anchors'
                      CE_FREE:
                        type: integer
                        format: int64
                        description: 'CE_free: Number of Free FCM Connection Entries'
                      CE_FREE_BT:
                        type: integer
                        format: int64
                        description: 'CE_free_bottom: Low Water Mark of Free CEs'
                      RB_FREE:
                        type: integer
                        format: int64
                        description: 'RB_free: Number of Free FCM Request Blocks'
                      RB_FREE_BT:
                        type: integer
                        format: int64
                        description: 'RB_free_bottom: Low Water Mark of Free Request Blocks'
                      NUM_NDS:
                        type: integer
                        format: int64
                        description: 'number_nodes: Number of FCM Node Structures that Follow'
                IT_DB6PMSM_FN:
                  type: array
                  items:
                    type: object
                    properties:
                      COMPTIME:
                        type: string
                        maxLength: 14
                        description: 'DB6: Timestamp (Format: YYYYMMDDHHMMSS)'
                      PARTITN:
                        type: integer
                        format: int32
                        description: Partition Number
                      ND_NUMBER:
                        type: integer
                        format: int32
                        description: 'node_number: Remote Node 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
                      CN_STATUS:
                        type: string
                        maxLength: 25
                        description: 'connection_status: FCM Connnection Status to Node'
                      TOT_BUFFST:
                        type: integer
                        format: int64
                        description: 'total_buffers_sent: Total Number of Buffers Sent'
                      TOT_BUFFRC:
                        type: integer
                        format: int64
                        description: 'total_buffers_rcvd: Total Number of Buffers Received'
              required:
              - ACTION
              - CALLERFLAG
              - PARTITN
      responses:
        '200':
          description: OK
          content:
            application/json:
              schema:
                properties:
                  IT_DB6PMSM:
                    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
                        SRT_HP_ALO:
                          type: integer
                          format: int64
                          description: 'sort_heap_allocated: Sort Heap Currently Allocated'
                        PT_THSORTS:
                          type: integer
                          format: int64
                          description: 'post_threshold_sorts: # Sorts Started After Heap Threshold E'
                        PPD_SRT_RQ:
                          type: integer
                          format: int64
                          description: 'piped_sorts_requested: No of Piped Sorts Requested by RDS to'
                        PPD_SRT_AC:
                          type: integer
                          format: int64
                          description: 'piped_sorts_accepted: No. of Piped Sorts Accepted by SLS'
                        DB2_STRTTM:
                          type: string
                          maxLength: 14
                          description: 'DB6: Timestamp (Format: YYYYMMDDHHMMSS)'
                        LAST_RESET:
                          type: string
                          maxLength: 14
                          description: 'DB6: Timestamp (Format: YYYYMMDDHHMMSS)'
                        REM_CN_IN:
                          type: integer
                          format: int64
                          description: 'rem_cons_in: Remote Connects to Target DB2'
                        REM_CN_INE:
                          type: integer
                          format: int64
                          description: 'rem_cons_in_exec: Remote Connects to Target Exec. DB2'
                        LOCAL_CONS:
                          type: integer
                          format: int64
                          description: 'local_cons: Current Local Connections'
                        LOCL_CN_IE:
                          type: integer
                          format: int64
                          description: 'local_cons_in_exec: Local Connects Curr. Executed in DB2'
                        CN_LC_DBS:
                          type: integer
                          format: int64
                          description: 'con_local_dbases: Local Databases with Current Connects'
                        AGT_REG:
                          type: integer
                          format: int64
                          description: 'agents_registered: Number of Agents Registered in DB2'
                        AGT_WAI_TK:
                          type: integer
                          format: int64
                          description: 'agents_waiting_on_token: No. of Agents Waiting for a Token'
                        UOW_SW:
                          type: string
                          maxLength: 5
                          description: 'dbmon_sw_settings: SQLM_OFF, SQLM_ON'
                        UOW_SWSTM:
                          type: string
                          maxLength: 14
                          description: 'DB6: Timestamp (Format: YYYYMMDDHHMMSS)'
                        STMT_SW:
                          type: string
                          maxLength: 5
                          description: 'dbmon_sw_settings: SQLM_OFF, SQLM_ON'
                        STMT_SWSTM:
                          type: string
                          maxLength: 14
                          description: 'DB6: Timestamp (Format: YYYYMMDDHHMMSS)'
                        TAB_SW:
                          type: string
                          maxLength: 5
                          description: 'dbmon_sw_settings: SQLM_OFF, SQLM_ON'
                        TAB_SWSTM:
                          type: string
                          maxLength: 14
                          description: 'DB6: Timestamp (Format: YYYYMMDDHHMMSS)'
                        BP_SW:
                          type: string
                          maxLength: 5
                          description: 'dbmon_sw_settings: SQLM_OFF, SQLM_ON'
                        BP_SWSTM:
                          type: string
                          maxLength: 14
                          description: 'DB6: Timestamp (Format: YYYYMMDDHHMMSS)'
                        LCK_SW:
                          type: string
                          maxLength: 5
                          description: 'dbmon_sw_settings: SQLM_OFF, SQLM_ON'
                        LCK_SW_STM:
                          type: string
                          maxLength: 14
                          description: 'DB6: Timestamp (Format: YYYYMMDDHHMMSS)'
                        SRT_SW:
                          type: string
                          maxLength: 5
                          description: 'dbmon_sw_settings: SQLM_OFF, SQLM_ON'
                        SRT_SWSTM:
                          type: string
                          maxLength: 14
                          description: 'DB6: Timestamp (Format: YYYYMMDDHHMMSS)'
                        DB2_STATUS:
                          type: string
                          maxLength: 25
                          description: 'db2_status: Status of the DB2 Instance (Active, Quiesced ...'
                        AGT_REG_TP:
                          type: integer
                          format: int64
                          description: 'agents_registered_top: agents_registered High Water Mark'
                        AGT_WAI_TP:
                          type: integer
                          format: int64
                          description: 'agents_waiting_top: agents_waiting High Water Mark'
                        COMM_PIMEM:
                          type: integer
                          format: int64
                          description: 'comm_private_mem: Committed Private Memory (Bytes)'
                        IDEL_AG:
                          type: integer
                          format: int64
                          description: 'idle_agents: Number of Unassigned Agents in Pool'
                        AGT_FR_PO:
                          type: integer
                          format: int64
                          description: 'agents_from_pool: Number of Agents Assigned from Pool'
                        AGT_CR_EPO:
                          type: integer
                          format: int64
                          description: agents_created_empty_pool:# Agents Created due to Pool Empty
                        CRD_AG_TOP:
                          type: integer
                          format: int64
                          description: 'coord_agents_top: Coordinating Agents High Water Mark'
                        MX_AG_OF:
                          type: integer
                          format: int64
                          description: 'max_agent_overflows: # of Attempts Exceeding the MAXAGENTS C'
                        AGT_STOLEN:
                          type: integer
                          format: int64
                          description: 'agents_stolen: Number of Agents Stolen'
                        NUM_SCDBMS:
                          type: integer
                          format: int64
                          description: 'num_sec_dbm_structs: Secondary Database Manager Info'
                        PROD_NAME:
                          type: string
                          maxLength: 32
                          description: 'DB6: Long identifier'
                        COMPO_ID:
                          type: string
                          maxLength: 20
                          description: 'DB6: General identifier'
                        SVC_LEVEL:
                          type: string
                          maxLength: 8
                          description: 'service_level: Service Level'
                        GW_TIT_CN:
                          type: integer
                          format: int64
                          description: 'gw_total_cons: DDCS Total Number of Gateway Connections'
                        GW_CUR_CN:
                          type: integer
                          format: int64
                          description: 'gw_cur_cons: DDCS Current Number of Gateway Connections'
                        GW_CN_W_HT:
                          type: integer
                          format: int64
                          description: 'gw_cons_wait_host: DDCS # Gateway Conn. Waiting for Host Rep'
                        GW_CN_W_CL:
                          type: integer
                          format: int64
                          description: 'gw_cons_wait_client: DDCS Gateway Conn. Waiting for Client R'
                        PT_THHAJN:
                          type: integer
                          format: int64
                          description: 'post_threshold_hash_joins: DDCS #Hash Joins Started After He'
                        NUM_GW_CONN_SW:
                          type: integer
                          format: int64
                          description: num_gw_conn_switches
                        NUM_NODES_INST:
                          type: integer
                          format: int64
                          description: num_nodes_in_db2_instance
                        SORT_HEAP_TOP:
                          type: integer
                          format: int64
                          description: sort_heap_top
                        TM_SW:
                          type: string
                          maxLength: 5
                          description: 'dbmon_sw_settings: SQLM_OFF, SQLM_ON'
                        TM_SWSTM:
                          type: string
                          maxLength: 14
                          description: 'DB6: Timestamp (Format: YYYYMMDDHHMMSS)'
                  IT_DB6PMSM_FC:
                    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
                        BF_FREE:
                          type: integer
                          format: int64
                          description: 'buff_free: Number of Free FCM Buffers'
                        BF_FREE_BT:
                          type: integer
                          format: int64
                          description: 'buff_free_bottom: Low Water Mark of Free Buffers'
                        MA_FREE:
                          type: integer
                          format: int64
                          description: 'MA_free: Number of Free FCM Message Anchors'
                        MA_FREE_BT:
                          type: integer
                          format: int64
                          description: 'MA_free_bottom: Low Water Mark of Free Anchors'
                        CE_FREE:
                          type: integer
                          format: int64
                          description: 'CE_free: Number of Free FCM Connection Entries'
                        CE_FREE_BT:
                          type: integer
                          format: int64
                          description: 'CE_free_bottom: Low Water Mark of Free CEs'
                        RB_FREE:
                          type: integer
                          format: int64
                          description: 'RB_free: Number of Free FCM Request Blocks'
                        RB_FREE_BT:
                          type: integer
                          format: int64
                          description: 'RB_free_bottom: Low Water Mark of Free Request Blocks'
                        NUM_NDS:
                          type: integer
                          format: int64
                          description: 'number_nodes: Number of FCM Node Structures that Follow'
                  IT_DB6PMSM_FN:
                    type: array
                    items:
                      type: object
                      properties:
                        COMPTIME:
                          type: string
                          maxLength: 14
                          description: 'DB6: Timestamp (Format: YYYYMMDDHHMMSS)'
                        PARTITN:
                          type: integer
                          format: int32
                          description: Partition Number
                        ND_NUMBER:
                          type: integer
                          format: int32
                          description: 'node_number: Remote Node 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
                        CN_STATUS:
                          type: string
                          maxLength: 25
                          description: 'connection_status: FCM Connnection Status to Node'
                        TOT_BUFFST:
                          type: integer
                          format: int64
                          description: 'total_buffers_sent: Total Number of Buffers Sent'
                        TOT_BUFFRC:
                          type: integer
                          format: int64
                          description: 'total_buffers_rcvd: Total Number of Buffers Received'
        '400':
          description: Bad request.
        5XX:
          description: Unexpected error.
