openapi: 3.0.0
info:
  title: SAP API
  version: 1.0.0
servers:
- url: http://localhost:8080
paths:
  /rfc/DB6_PM_APPLSNAP:
    post:
      tags:
      - SDB6PM
      summary: 'DB6: Get Application Snapshot'
      operationId: /rfc/DB6_PM_APPLSNAP
      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_DB6PMSA:
                  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
                      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'
                      STAT_CHGTM:
                        type: string
                        maxLength: 14
                        description: 'DB6: Timestamp (Format: YYYYMMDDHHMMSS)'
                      APPL_NAME:
                        type: string
                        maxLength: 20
                        description: 'DB6: General identifier'
                      IPADDRESS:
                        type: string
                        maxLength: 45
                        description: IP Address
                      APPL_ID:
                        type: string
                        maxLength: 128
                        description: ''
                      SEQU_NO:
                        type: string
                        maxLength: 5
                        description: 'sequence_no: Application ID Sequence Number'
                      AUTH_ID:
                        type: string
                        maxLength: 20
                        description: 'DB6: General identifier'
                      CLI_NAME:
                        type: string
                        maxLength: 20
                        description: 'DB6: General identifier'
                      CLI_PRDID:
                        type: string
                        maxLength: 20
                        description: 'DB6: General identifier'
                      IN_DB_ALIA:
                        type: string
                        maxLength: 20
                        description: 'DB6: General identifier'
                      CLI_DBALIA:
                        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'
                      LCKS_HELD:
                        type: integer
                        format: int64
                        description: 'locks_held: Locks Currently Held by Application'
                      LCK_WAITS:
                        type: integer
                        format: int64
                        description: 'lock_waits: Lock Waits Since Application Connect'
                      LCK_W_TM:
                        type: integer
                        format: int64
                        description: 'lock_wait_time: Total Time Application Waited for Locks'
                      LCK_ESCALS:
                        type: integer
                        format: int64
                        description: 'lock_escals: Lock Escalations Since Application Connect'
                      X_LCK_ESCA:
                        type: integer
                        format: int64
                        description: 'x_lock_escals: X Lock Escalations Since Application Connect'
                      DEADLOCKS:
                        type: integer
                        format: int64
                        description: 'deadlocks: Deadlocks Since Application Connect'
                      UOW_LWTM:
                        type: integer
                        format: int64
                        description: 'uow_lock_wait_time: Time UOW Waited for Locks (ms)'
                      TOT_SORTS:
                        type: integer
                        format: int64
                        description: 'total_sorts: Total Sorts Since Connect'
                      TOT_SRT_TM:
                        type: integer
                        format: int64
                        description: 'total_sort_time: Elapsed Time Spent in Sorts'
                      SRT_OF:
                        type: integer
                        format: int64
                        description: 'sort_overflows: Number of Sort Overflows'
                      PL_D_LRS:
                        type: integer
                        format: int64
                        description: 'pool_data_l_reads: Pool Data Logical Reads Since Connect'
                      PL_D_PRS:
                        type: integer
                        format: int64
                        description: 'pool_data_p_reads: Pool Data Reads Since First Connect'
                      PL_D_WS:
                        type: integer
                        format: int64
                        description: 'pool_data_writes: Pool Data Writes Since First Connect'
                      PL_I_LRS:
                        type: integer
                        format: int64
                        description: 'pool_index_l_reads: Pool Index Logical Reads Since Connect'
                      PL_I_PRS:
                        type: integer
                        format: int64
                        description: 'pool_index_p_reads: Pool Index Reads Since First Connect'
                      PL_I_WS:
                        type: integer
                        format: int64
                        description: 'pool_index_writes: Pool Index Writes Since First Connect'
                      PL_RD_TM:
                        type: integer
                        format: int64
                        description: 'pool_read_time: Buffer Pool Read Time Since First Connect'
                      PL_WT_TM:
                        type: integer
                        format: int64
                        description: 'pool_write_time: Buffer Pool Write Time Since First Connect'
                      CMMT_SQLST:
                        type: integer
                        format: int64
                        description: 'commit_sql_stmts: Number of COMMIT SQL Statements Since Conn'
                      RBCK_SQLST:
                        type: integer
                        format: int64
                        description: 'rollback_sql_stmts: No. of ROLLBACK SQL Stmts Since Connect'
                      DYN_SQLST:
                        type: integer
                        format: int64
                        description: 'dynamic_sql_stmts: Number of Dynamic SQL Stmts Since Connect'
                      STC_SQLST:
                        type: integer
                        format: int64
                        description: 'static_sql_stmts: Number of Static SQL Statements Since Conn'
                      FAIL_SQLST:
                        type: integer
                        format: int64
                        description: 'failed_sql_stmts: Number of Failed SQL Stmts Since Connect'
                      SELC_SQLST:
                        type: integer
                        format: int64
                        description: 'select_sql_stmts: Number of SQL SELECT Stmts Since Connect'
                      DDL_SQLST:
                        type: integer
                        format: int64
                        description: 'ddl_sql_stmts: Number of Data Definition Language Statements'
                      UID_SQLST:
                        type: integer
                        format: int64
                        description: 'uid_sql_stmts: Number of UPDATE/INSERT/DELETE Statements'
                      INT_ATRBND:
                        type: integer
                        format: int64
                        description: 'int_auto_rebinds: Number of Auto Rebinds Since First Connect'
                      INT_RW_DEL:
                        type: integer
                        format: int64
                        description: 'int_rows_deleted: No. of Casc. Deletes Since First Connect'
                      INT_RW_UPD:
                        type: integer
                        format: int64
                        description: 'int_rows_updated: Number of Set Null Deletes Since Connect'
                      INT_CMMTS:
                        type: integer
                        format: int64
                        description: 'int_commits: Number of Int. COMMITs Since First Connect'
                      INT_RB:
                        type: integer
                        format: int64
                        description: 'int_rollbacks: Number of Int. ROLLBACKs Since First Connect'
                      INT_DL_RB:
                        type: integer
                        format: int64
                        description: 'int_deadlock_rollbacks: # of ROLLBACKs due to Deadlck S. Con'
                      RW_DELETED:
                        type: integer
                        format: int64
                        description: 'rows_deleted: Number of Rows Deleted Since Connect'
                      RW_INSRTED:
                        type: integer
                        format: int64
                        description: 'rows_inserted: Number of Rows Inserted Since Connect'
                      RW_UPDATED:
                        type: integer
                        format: int64
                        description: 'rows_updated: Number of Rows Updated Since Connect'
                      RW_SELECED:
                        type: integer
                        format: int64
                        description: 'rows_selected: Number of Rows Selected Since Connect'
                      BIND_PRECC:
                        type: integer
                        format: int64
                        description: 'binds_precompiles: # of BINDs/PRECOMPILEs Since First Conn.'
                      UOW_LGSPUD:
                        type: integer
                        format: int64
                        description: 'uow_log_space_used: Log Space Used in Most Recent UOW'
                      UOW_CMPSTA:
                        type: string
                        maxLength: 50
                        description: 'uow_comp_status: Previous UOW Completion Status'
                      PR_UOW_STM:
                        type: string
                        maxLength: 14
                        description: 'DB6: Timestamp (Format: YYYYMMDDHHMMSS)'
                      UOW_STRTTM:
                        type: string
                        maxLength: 14
                        description: 'DB6: Timestamp (Format: YYYYMMDDHHMMSS)'
                      UOW_STOPTM:
                        type: string
                        maxLength: 14
                        description: 'DB6: Timestamp (Format: YYYYMMDDHHMMSS)'
                      OPN_RM_CR:
                        type: integer
                        format: int64
                        description: 'open_rem_curs: Remote Cursors Currently Open'
                      OPN_RM_CRB:
                        type: integer
                        format: int64
                        description: 'open_rem_curs_blk: Remote Cursors Curr. Open Within Block'
                      REJ_CR_BLK:
                        type: integer
                        format: int64
                        description: 'rej_curs_blk: Rejected Block Remote Cursor Requests'
                      ACC_CU_BLK:
                        type: integer
                        format: int64
                        description: 'acc_curs_blk: Acc. Block Remote Cursor Requests'
                      AP_CON_TM:
                        type: string
                        maxLength: 14
                        description: 'DB6: Timestamp (Format: YYYYMMDDHHMMSS)'
                      CN_CMPL_TM:
                        type: string
                        maxLength: 14
                        description: 'DB6: Timestamp (Format: YYYYMMDDHHMMSS)'
                      LAST_RESET:
                        type: string
                        maxLength: 14
                        description: 'DB6: Timestamp (Format: YYYYMMDDHHMMSS)'
                      AP_IDLE_TM:
                        type: integer
                        format: int64
                        description: 'appl_idle_time: Application Idle Time (Seconds)'
                      PL_D_TE:
                        type: integer
                        format: int64
                        description: 'pool_data_to_estore: No. of Pages Copied from BP to ExStor.'
                      PL_I_TE:
                        type: integer
                        format: int64
                        description: 'pool_index_to_estore: No. of Pages Copied from BP to ExStor.'
                      PL_I_FE:
                        type: integer
                        format: int64
                        description: 'pool_index_from_estore: No of Pages Copied from ExStor to BP'
                      PL_D_FE:
                        type: integer
                        format: int64
                        description: 'pool_data_from_estore: No. of Pages Copied from ExStor to BP'
                      AUTHO_LVL:
                        type: integer
                        format: int64
                        description: 'authority_lvl: User Authorizations'
                      SQL_RSCMMT:
                        type: integer
                        format: int64
                        description: 'sql_reqs_since_commit: No. of SQL Requests Since Last COMMIT'
                      NUM_SCAPS:
                        type: integer
                        format: int64
                        description: 'num_sec_appl_structs: Secondary Application Information'
                      LCK_TMOUT:
                        type: integer
                        format: int64
                        description: 'lock_timeouts: Number of Lock Timeouts Since Connect'
                      AGT_UCP_S:
                        type: integer
                        format: int64
                        description: 'agent_usr_cpu_time.seconds: Total User CPU Time of Appl.'
                      AGT_UPT_MS:
                        type: integer
                        format: int64
                        description: 'agent_usr_cpu_time.microsec: Total User CPU Time of Appl.'
                      AGT_SCT_S:
                        type: integer
                        format: int64
                        description: 'agent_sys_cpu_time.seconds: Total Application System CPU Tim'
                      AGT_SPT_MS:
                        type: integer
                        format: int64
                        description: 'agent_sys_cpu_time.microsec: Total Appl. System CPU Time'
                      INT_RW_INS:
                        type: integer
                        format: int64
                        description: 'int_rows_inserted: Number of Rows Inserted for Trigger'
                      RW_READ:
                        type: integer
                        format: int64
                        description: 'rows_read: Number of Rows Read Since Connection'
                      RW_WRITTEN:
                        type: integer
                        format: int64
                        description: 'rows_written: Number of Rows Written Since Connection'
                      DIRCT_RDS:
                        type: integer
                        format: int64
                        description: 'direct_reads: Direct Reads Since Connect'
                      DIRCT_WTS:
                        type: integer
                        format: int64
                        description: 'direct_writes: Direct Writes Since Connect'
                      DIRCT_RRQS:
                        type: integer
                        format: int64
                        description: 'direct_read_reqs: Direct Read Requests Since Connect'
                      DIRCT_WRQS:
                        type: integer
                        format: int64
                        description: 'direct_write_reqs: Direct Write Requests Since Connect'
                      DIRCT_RTM:
                        type: integer
                        format: int64
                        description: 'direct_read_time: Direct Read Time Since Connect'
                      DIRCT_WTM:
                        type: integer
                        format: int64
                        description: 'direct_write_time: Direct Write Time Since Connect'
                      OPN_LC_CR:
                        type: integer
                        format: int64
                        description: 'open_loc_curs: Local Cursors Currently Open'
                      OPN_LC_CRB:
                        type: integer
                        format: int64
                        description: 'open_loc_curs_blk: Local Cursors Currently Open Within Block'
                      EXEC_ID:
                        type: string
                        maxLength: 20
                        description: 'DB6: General identifier'
                      CORR_TOKEN:
                        type: string
                        maxLength: 32
                        description: 'DB6: Long identifier'
                      CLI_PID:
                        type: integer
                        format: int64
                        description: 'client_pid: Process Thread ID of Client Application'
                      CLI_PLATFO:
                        type: string
                        maxLength: 25
                        description: 'client_platform: Platform of Client Application'
                      CLI_PRTC:
                        type: string
                        maxLength: 25
                        description: 'client_protocol: Communications Protocol of Client'
                      COUNTRY_CD:
                        type: integer
                        format: int32
                        description: 'country_code: Country Code of Client Application'
                      PKG_CA_LKU:
                        type: integer
                        format: int64
                        description: 'pkg_cache_lookups: Number of Section Lookups'
                      PKG_CA_INS:
                        type: integer
                        format: int64
                        description: 'pkg_cache_inserts: Number of Sections Inserted into Cache'
                      CATCA_LKU:
                        type: integer
                        format: int64
                        description: 'cat_cache_lookups: Number of Table Descriptor Lookups'
                      CATCA_INS:
                        type: integer
                        format: int64
                        description: 'cat_cache_inserts: Number of Table Descriptors Inserted'
                      CATCA_OF:
                        type: integer
                        format: int64
                        description: 'cat_cache_overflows: Number of Catalog Cache Overflows'
                      CATCA_HPFL:
                        type: integer
                        format: int64
                        description: 'cat_cache_heap_full: Number of Overflows due to DB Heap Full'
                      CRD_NODE:
                        type: integer
                        format: int64
                        description: 'coord_node: Coordinating Node Number'
                      NUM_ASS_AG:
                        type: integer
                        format: int64
                        description: 'num_assoc_agents: Number of Agents Currently Associated'
                      NUM_AGENTS:
                        type: integer
                        format: int64
                        description: 'num_agents: Number of Agents Currently Active'
                      AGT_STOLEN:
                        type: integer
                        format: int64
                        description: 'agents_stolen: Total Number of Agents Stolen from Appl.'
                      ASS_AGT_TP:
                        type: integer
                        format: int64
                        description: 'associated_agents_top: # of Agents Associated with this Appl'
                      AP_PRIO:
                        type: integer
                        format: int64
                        description: 'appl_priority: Priority with Which Application Agents Work'
                      AP_PRIO_TY:
                        type: string
                        maxLength: 25
                        description: 'appl_priority_type: Dynamic or Static'
                      PF_WTTM:
                        type: integer
                        format: int64
                        description: 'prefetch_wait_time: Time Waited for Prefetch (ms)'
                      CRD_AG_PID:
                        type: integer
                        format: int64
                        description: 'coord_agent_pid: Coordinator Agent Process/Thread ID'
                      AP_SEC_LKU:
                        type: integer
                        format: int64
                        description: 'appl_section_lookups: Number of Section Lookups'
                      AP_SEC_INS:
                        type: integer
                        format: int64
                        description: 'appl_section_inserts: Number of Sections Inserted'
                      LCK_WTING:
                        type: integer
                        format: int64
                        description: 'locks_waiting: Number of Agents Currently Waiting for Locks'
                      OB_CN_ADDR:
                        type: string
                        maxLength: 32
                        description: 'DB6: Long identifier'
                      INBND_CNAD:
                        type: string
                        maxLength: 32
                        description: 'DB6: Long identifier'
                      OB_CN_PRTC:
                        type: integer
                        format: int32
                        description: 'outbound_comm_protocol: Outbound Communications Protocol'
                      TOT_HAJN:
                        type: integer
                        format: int64
                        description: 'total_hash_joins: Number of Hash Joins'
                      TOT_HALOOP:
                        type: integer
                        format: int64
                        description: 'total_hash_loops: Number of Hash Loops'
                      HAJN_OF:
                        type: integer
                        format: int64
                        description: 'hash_join_overflows: Number of Hash Join Overflows'
                      HAJN_SM_OF:
                        type: integer
                        format: int64
                        description: 'hash_join_small_overflows: Small Hash Join Overflows'
                      UOW_ELA_S:
                        type: integer
                        format: int64
                        description: 'uow_elapsed_time_s: Unit of Work elapse time sec'
                      UOW_ELA_MS:
                        type: integer
                        format: int64
                        description: 'uow_elapsed_time_ms: Unit of Work elapse time ms'
                      UNREADPFPG:
                        type: integer
                        format: int64
                        description: 'unread_prefetch_pages: Unread prefetched pages'
                      PL_TD_LRS:
                        type: integer
                        format: int64
                        description: pool_temp_data_l_reads
                      PL_TD_PRS:
                        type: integer
                        format: int64
                        description: pool_temp_data_p_reads
                      PL_TI_LRS:
                        type: integer
                        format: int64
                        description: pool_temp_index_l_reads
                      PL_TI_PRS:
                        type: integer
                        format: int64
                        description: pool_temp_index_p_reads
                      POOL_XDA_L_READS:
                        type: integer
                        format: int64
                        description: ''
                      POOL_XDA_P_READS:
                        type: integer
                        format: int64
                        description: ''
                      POOL_XDA_WRITES:
                        type: integer
                        format: int64
                        description: ''
                      PL_TEMP_XDA_L_RD:
                        type: integer
                        format: int64
                        description: ''
                      PL_TEMP_XDA_P_RD:
                        type: integer
                        format: int64
                        description: ''
                      ELPSD_EXC_TIM_MS:
                        type: integer
                        format: int64
                        description: ''
                      ELPSD_EXC_TIM_S:
                        type: integer
                        format: int64
                        description: ''
                      INACT_STMTHISTSZ:
                        type: integer
                        format: int64
                        description: ''
                      LOCK_TIMEOUT_VAL:
                        type: integer
                        format: int64
                        description: ''
                      PRV_WS_NUM_OVFL:
                        type: integer
                        format: int64
                        description: ''
                      PRV_WS_SCT_INSRT:
                        type: integer
                        format: int64
                        description: ''
                      PRV_WS_SCT_LKUP:
                        type: integer
                        format: int64
                        description: ''
                      PRV_WS_SIZE_TOP:
                        type: integer
                        format: int64
                        description: ''
                      SHR_WS_NUM_OVFL:
                        type: integer
                        format: int64
                        description: ''
                      SHR_WS_SCT_INSRT:
                        type: integer
                        format: int64
                        description: ''
                      SHR_WS_SCT_LKUP:
                        type: integer
                        format: int64
                        description: ''
                      SHR_WS_SIZE_TOP:
                        type: integer
                        format: int64
                        description: ''
                      SESSION_AUTH_ID:
                        type: string
                        maxLength: 128
                        description: ''
                      TPMON_ACC_STR:
                        type: string
                        maxLength: 200
                        description: ''
                      TPMON_CLIENT_APP:
                        type: string
                        maxLength: 256
                        description: ''
                      TPMON_CLIENT_UID:
                        type: string
                        maxLength: 256
                        description: ''
                      TPMON_CLIENT_WKS:
                        type: string
                        maxLength: 256
                        description: ''
                      AUTHORITY_LEVEL:
                        type: string
                        maxLength: 512
                        description: authority level in visible format
                IT_DB6PMSA_AG:
                  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
                      AGENT_PID:
                        type: integer
                        format: int64
                        description: 'agent_pid: db2agent Process/Thread ID'
                      LOCK_TIMEOUT_VAL:
                        type: integer
                        format: int64
                        description: ''
                      DB_NAME:
                        type: string
                        maxLength: 128
                        description: ''
                IT_DB6PMSA_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'
                IT_DB6PMSA_SS:
                  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
                      SS_NUMBER:
                        type: integer
                        format: int32
                        description: 'ss_number: Subsection Number'
                      SS_STATUS:
                        type: integer
                        format: int32
                        description: 'ss_status: Subsection Status'
                      SS_ND_NUM:
                        type: integer
                        format: int32
                        description: 'ss_node_number: Node Where the Subsection is Executing'
                      SS_EXEC_TM:
                        type: integer
                        format: int64
                        description: 'ss_exec_time: Elapsed Execution Time in Seconds'
                      SS_USRCTS:
                        type: integer
                        format: int64
                        description: 'ss_usr_cpu_time.seconds: Total User CPU Time'
                      SS_USRCTMS:
                        type: integer
                        format: int64
                        description: 'ss_usr_cpu_time.micrsec: Total User CPU Time'
                      SS_SYSCTS:
                        type: integer
                        format: int64
                        description: 'ss_sys_cpu_time.seconds: Total System CPU Time'
                      SS_SYSCTMS:
                        type: integer
                        format: int64
                        description: 'ss_sys_cpu_time.microsec: Total System CPU Time'
                      TQ_NDWFOR:
                        type: integer
                        format: int32
                        description: 'tq_node_waited_for: Node for Which We Wait if Blocked'
                      TQ_WFANY:
                        type: integer
                        format: int32
                        description: 'tq_wait_for_any: TRUE if Waiting for any Node to Send'
                      TQ_IDWOM:
                        type: integer
                        format: int32
                        description: 'tq_id_waiting_on: Table Queue Waiting to Send/Receive'
                      TQ_TTSNDSP:
                        type: integer
                        format: int64
                        description: 'tq_tot_send_spills: Total No of Buffers Overflowed to a Temp'
                      TQ_CRSNDSP:
                        type: integer
                        format: int64
                        description: 'tq_cur_send_spills: Current No of TQ Send Buffers Overflowed'
                      TQ_MXSNDSP:
                        type: integer
                        format: int64
                        description: 'tq_max_send_spills: Maximum No of TQ Send Buffers Overflowed'
                      TQ_RW_RD:
                        type: integer
                        format: int64
                        description: 'tq_rows_read: Total # Rows Received in Table Queues'
                      TQ_RW_WR:
                        type: integer
                        format: int64
                        description: 'tq_rows_written: Total Number of Rows Sent to Table Queues'
                      RW_READ:
                        type: integer
                        format: int64
                        description: 'rows_read: Number of Data Manager (DMS) Rows Read'
                      RW_WRITTEN:
                        type: integer
                        format: int64
                        description: 'rows_written: Number of DMS Rows Written'
                      NUM_AGENTS:
                        type: integer
                        format: int64
                        description: 'num_agents: Number of Agents Currently Working on Subs.'
                      STMT_TEXT:
                        type: string
                        maxLength: 32000
                        description: ''
                IT_DB6PMSA_ST:
                  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
                      STMT_NDNUM:
                        type: integer
                        format: int32
                        description: 'stmt_node_number: Node Where the Statement is Executing'
                      STMT_TYPE:
                        type: string
                        maxLength: 25
                        description: 'stmt_type: Type of Statement: Dynamic or Static'
                      STMT_OPERA:
                        type: string
                        maxLength: 50
                        description: 'stmt_operation: Current Operation'
                      SECTIONNUM:
                        type: integer
                        format: int64
                        description: 'section_number: Section Number'
                      QY_COSTEST:
                        type: integer
                        format: int64
                        description: 'query_cost_estimate: SQL Compiler Estimated in TIMERONS'
                      QY_CARDEST:
                        type: integer
                        format: int64
                        description: 'query_card_estimate: SQL Compiler Estimated Number of Rows'
                      DG_PARA:
                        type: integer
                        format: int64
                        description: 'degree_parallelism: SMP Intraquery Parallelism Requested'
                      STMT_SORTS:
                        type: integer
                        format: int64
                        description: 'stmt_sorts: Number of Sorts for this Statement'
                      TOT_SRT_TM:
                        type: integer
                        format: int64
                        description: 'total_sort_time: Total Sort Time for this Statement'
                      SRT_OF:
                        type: integer
                        format: int64
                        description: 'sort_overflows: Number of Sort Overflows for this Stmt'
                      RW_READ:
                        type: integer
                        format: int64
                        description: 'rows_read: Number of DMS Rows Read'
                      RW_WRITTEN:
                        type: integer
                        format: int64
                        description: 'rows_written: Number of DMS Rows Read'
                      INT_RW_DEL:
                        type: integer
                        format: int64
                        description: 'int_rows_deleted: Number of Internal DELETEs by the Stmt'
                      INT_RW_UPD:
                        type: integer
                        format: int64
                        description: 'int_rows_updated: Number of internal UPDATEs by the Stmt'
                      INT_RW_INS:
                        type: integer
                        format: int64
                        description: 'int_rows_inserted: Number of internal INSERTs by the Stmt'
                      FETCH_CNT:
                        type: integer
                        format: int64
                        description: 'fetch_count: Fetch Count'
                      STMT_START:
                        type: string
                        maxLength: 14
                        description: 'DB6: Timestamp (Format: YYYYMMDDHHMMSS)'
                      STMT_STOP:
                        type: string
                        maxLength: 14
                        description: 'DB6: Timestamp (Format: YYYYMMDDHHMMSS)'
                      CUR_NAME:
                        type: string
                        maxLength: 20
                        description: 'DB6: General identifier'
                      CREATOR:
                        type: string
                        maxLength: 20
                        description: 'DB6: General identifier'
                      PKG_NAME:
                        type: string
                        maxLength: 20
                        description: 'DB6: General identifier'
                      STMTURCTS:
                        type: integer
                        format: int64
                        description: 'stmt_usr_cpu_time.seconds: Total User CPU Time of SQL Stmt'
                      STMTURCTMS:
                        type: integer
                        format: int64
                        description: 'stmt_usr_cpu_time.microsec: Total User CPU Time of SQL Stmt'
                      STMTSYCTS:
                        type: integer
                        format: int64
                        description: 'stmt_sys_cpu_time.seconds: Total System CPU Time for SQL Stm'
                      STMTSYCTMS:
                        type: integer
                        format: int64
                        description: 'stmt_sys_cpu_time.microsec: Total System CPU Time for SQL St'
                      NUM_SS:
                        type: integer
                        format: int64
                        description: 'num_ss: Number of Subsections'
                      NUM_AGENTS:
                        type: integer
                        format: int64
                        description: 'num_agents: Number of Agents Currently Working on Stmt'
                      AGENTS_TOP:
                        type: integer
                        format: int64
                        description: 'agents_top: Number of Agents Created for Statement'
                      PL_D_LRS:
                        type: integer
                        format: int64
                        description: 'pool_data_l_reads: Pool Data Logical Reads Since Connect'
                      PL_D_PRS:
                        type: integer
                        format: int64
                        description: 'pool_data_p_reads: Pool Data Reads Since First Connect'
                      PL_I_LRS:
                        type: integer
                        format: int64
                        description: 'pool_index_l_reads: Pool Index Logical Reads Since Connect'
                      PL_I_PRS:
                        type: integer
                        format: int64
                        description: pool_index_p_reads
                      PL_TD_LRS:
                        type: integer
                        format: int64
                        description: pool_temp_data_l_reads
                      PL_TD_PRS:
                        type: integer
                        format: int64
                        description: pool_temp_data_p_reads
                      PL_TI_LRS:
                        type: integer
                        format: int64
                        description: pool_temp_index_l_reads
                      PL_TI_PRS:
                        type: integer
                        format: int64
                        description: pool_temp_index_p_reads
                      BLKCURSOR:
                        type: string
                        maxLength: 10
                        description: blocking_cursor
                      STMTELAS:
                        type: integer
                        format: int64
                        description: elapsed_time seconds
                      STMTELAMS:
                        type: integer
                        format: int64
                        description: elapsed_time microseconds
                      CONSISTNCY_TOKEN:
                        type: string
                        maxLength: 128
                        description: consistency_token
                      PACKAGE_VERS_ID:
                        type: string
                        maxLength: 128
                        description: package_version_id
                      PL_TEMP_XDA_L_RD:
                        type: integer
                        format: int64
                        description: ''
                      PL_TEMP_XDA_P_RD:
                        type: integer
                        format: int64
                        description: ''
                      POOL_XDA_L_READS:
                        type: integer
                        format: int64
                        description: ''
                      POOL_XDA_P_READS:
                        type: integer
                        format: int64
                        description: ''
                      STMT_LEN:
                        type: integer
                        format: int32
                        description: 'stmt_length: Lth of Dyn SQL Text Blank Padded to 4Byte Bndry'
                      STMT_TEXT:
                        type: string
                        maxLength: 32000
                        description: 'stmt_text: SQL Statement'
              required:
              - ACTION
              - PARTITN
      responses:
        '200':
          description: OK
          content:
            application/json:
              schema:
                properties:
                  IT_DB6PMSA:
                    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
                        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'
                        STAT_CHGTM:
                          type: string
                          maxLength: 14
                          description: 'DB6: Timestamp (Format: YYYYMMDDHHMMSS)'
                        APPL_NAME:
                          type: string
                          maxLength: 20
                          description: 'DB6: General identifier'
                        IPADDRESS:
                          type: string
                          maxLength: 45
                          description: IP Address
                        APPL_ID:
                          type: string
                          maxLength: 128
                          description: ''
                        SEQU_NO:
                          type: string
                          maxLength: 5
                          description: 'sequence_no: Application ID Sequence Number'
                        AUTH_ID:
                          type: string
                          maxLength: 20
                          description: 'DB6: General identifier'
                        CLI_NAME:
                          type: string
                          maxLength: 20
                          description: 'DB6: General identifier'
                        CLI_PRDID:
                          type: string
                          maxLength: 20
                          description: 'DB6: General identifier'
                        IN_DB_ALIA:
                          type: string
                          maxLength: 20
                          description: 'DB6: General identifier'
                        CLI_DBALIA:
                          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'
                        LCKS_HELD:
                          type: integer
                          format: int64
                          description: 'locks_held: Locks Currently Held by Application'
                        LCK_WAITS:
                          type: integer
                          format: int64
                          description: 'lock_waits: Lock Waits Since Application Connect'
                        LCK_W_TM:
                          type: integer
                          format: int64
                          description: 'lock_wait_time: Total Time Application Waited for Locks'
                        LCK_ESCALS:
                          type: integer
                          format: int64
                          description: 'lock_escals: Lock Escalations Since Application Connect'
                        X_LCK_ESCA:
                          type: integer
                          format: int64
                          description: 'x_lock_escals: X Lock Escalations Since Application Connect'
                        DEADLOCKS:
                          type: integer
                          format: int64
                          description: 'deadlocks: Deadlocks Since Application Connect'
                        UOW_LWTM:
                          type: integer
                          format: int64
                          description: 'uow_lock_wait_time: Time UOW Waited for Locks (ms)'
                        TOT_SORTS:
                          type: integer
                          format: int64
                          description: 'total_sorts: Total Sorts Since Connect'
                        TOT_SRT_TM:
                          type: integer
                          format: int64
                          description: 'total_sort_time: Elapsed Time Spent in Sorts'
                        SRT_OF:
                          type: integer
                          format: int64
                          description: 'sort_overflows: Number of Sort Overflows'
                        PL_D_LRS:
                          type: integer
                          format: int64
                          description: 'pool_data_l_reads: Pool Data Logical Reads Since Connect'
                        PL_D_PRS:
                          type: integer
                          format: int64
                          description: 'pool_data_p_reads: Pool Data Reads Since First Connect'
                        PL_D_WS:
                          type: integer
                          format: int64
                          description: 'pool_data_writes: Pool Data Writes Since First Connect'
                        PL_I_LRS:
                          type: integer
                          format: int64
                          description: 'pool_index_l_reads: Pool Index Logical Reads Since Connect'
                        PL_I_PRS:
                          type: integer
                          format: int64
                          description: 'pool_index_p_reads: Pool Index Reads Since First Connect'
                        PL_I_WS:
                          type: integer
                          format: int64
                          description: 'pool_index_writes: Pool Index Writes Since First Connect'
                        PL_RD_TM:
                          type: integer
                          format: int64
                          description: 'pool_read_time: Buffer Pool Read Time Since First Connect'
                        PL_WT_TM:
                          type: integer
                          format: int64
                          description: 'pool_write_time: Buffer Pool Write Time Since First Connect'
                        CMMT_SQLST:
                          type: integer
                          format: int64
                          description: 'commit_sql_stmts: Number of COMMIT SQL Statements Since Conn'
                        RBCK_SQLST:
                          type: integer
                          format: int64
                          description: 'rollback_sql_stmts: No. of ROLLBACK SQL Stmts Since Connect'
                        DYN_SQLST:
                          type: integer
                          format: int64
                          description: 'dynamic_sql_stmts: Number of Dynamic SQL Stmts Since Connect'
                        STC_SQLST:
                          type: integer
                          format: int64
                          description: 'static_sql_stmts: Number of Static SQL Statements Since Conn'
                        FAIL_SQLST:
                          type: integer
                          format: int64
                          description: 'failed_sql_stmts: Number of Failed SQL Stmts Since Connect'
                        SELC_SQLST:
                          type: integer
                          format: int64
                          description: 'select_sql_stmts: Number of SQL SELECT Stmts Since Connect'
                        DDL_SQLST:
                          type: integer
                          format: int64
                          description: 'ddl_sql_stmts: Number of Data Definition Language Statements'
                        UID_SQLST:
                          type: integer
                          format: int64
                          description: 'uid_sql_stmts: Number of UPDATE/INSERT/DELETE Statements'
                        INT_ATRBND:
                          type: integer
                          format: int64
                          description: 'int_auto_rebinds: Number of Auto Rebinds Since First Connect'
                        INT_RW_DEL:
                          type: integer
                          format: int64
                          description: 'int_rows_deleted: No. of Casc. Deletes Since First Connect'
                        INT_RW_UPD:
                          type: integer
                          format: int64
                          description: 'int_rows_updated: Number of Set Null Deletes Since Connect'
                        INT_CMMTS:
                          type: integer
                          format: int64
                          description: 'int_commits: Number of Int. COMMITs Since First Connect'
                        INT_RB:
                          type: integer
                          format: int64
                          description: 'int_rollbacks: Number of Int. ROLLBACKs Since First Connect'
                        INT_DL_RB:
                          type: integer
                          format: int64
                          description: 'int_deadlock_rollbacks: # of ROLLBACKs due to Deadlck S. Con'
                        RW_DELETED:
                          type: integer
                          format: int64
                          description: 'rows_deleted: Number of Rows Deleted Since Connect'
                        RW_INSRTED:
                          type: integer
                          format: int64
                          description: 'rows_inserted: Number of Rows Inserted Since Connect'
                        RW_UPDATED:
                          type: integer
                          format: int64
                          description: 'rows_updated: Number of Rows Updated Since Connect'
                        RW_SELECED:
                          type: integer
                          format: int64
                          description: 'rows_selected: Number of Rows Selected Since Connect'
                        BIND_PRECC:
                          type: integer
                          format: int64
                          description: 'binds_precompiles: # of BINDs/PRECOMPILEs Since First Conn.'
                        UOW_LGSPUD:
                          type: integer
                          format: int64
                          description: 'uow_log_space_used: Log Space Used in Most Recent UOW'
                        UOW_CMPSTA:
                          type: string
                          maxLength: 50
                          description: 'uow_comp_status: Previous UOW Completion Status'
                        PR_UOW_STM:
                          type: string
                          maxLength: 14
                          description: 'DB6: Timestamp (Format: YYYYMMDDHHMMSS)'
                        UOW_STRTTM:
                          type: string
                          maxLength: 14
                          description: 'DB6: Timestamp (Format: YYYYMMDDHHMMSS)'
                        UOW_STOPTM:
                          type: string
                          maxLength: 14
                          description: 'DB6: Timestamp (Format: YYYYMMDDHHMMSS)'
                        OPN_RM_CR:
                          type: integer
                          format: int64
                          description: 'open_rem_curs: Remote Cursors Currently Open'
                        OPN_RM_CRB:
                          type: integer
                          format: int64
                          description: 'open_rem_curs_blk: Remote Cursors Curr. Open Within Block'
                        REJ_CR_BLK:
                          type: integer
                          format: int64
                          description: 'rej_curs_blk: Rejected Block Remote Cursor Requests'
                        ACC_CU_BLK:
                          type: integer
                          format: int64
                          description: 'acc_curs_blk: Acc. Block Remote Cursor Requests'
                        AP_CON_TM:
                          type: string
                          maxLength: 14
                          description: 'DB6: Timestamp (Format: YYYYMMDDHHMMSS)'
                        CN_CMPL_TM:
                          type: string
                          maxLength: 14
                          description: 'DB6: Timestamp (Format: YYYYMMDDHHMMSS)'
                        LAST_RESET:
                          type: string
                          maxLength: 14
                          description: 'DB6: Timestamp (Format: YYYYMMDDHHMMSS)'
                        AP_IDLE_TM:
                          type: integer
                          format: int64
                          description: 'appl_idle_time: Application Idle Time (Seconds)'
                        PL_D_TE:
                          type: integer
                          format: int64
                          description: 'pool_data_to_estore: No. of Pages Copied from BP to ExStor.'
                        PL_I_TE:
                          type: integer
                          format: int64
                          description: 'pool_index_to_estore: No. of Pages Copied from BP to ExStor.'
                        PL_I_FE:
                          type: integer
                          format: int64
                          description: 'pool_index_from_estore: No of Pages Copied from ExStor to BP'
                        PL_D_FE:
                          type: integer
                          format: int64
                          description: 'pool_data_from_estore: No. of Pages Copied from ExStor to BP'
                        AUTHO_LVL:
                          type: integer
                          format: int64
                          description: 'authority_lvl: User Authorizations'
                        SQL_RSCMMT:
                          type: integer
                          format: int64
                          description: 'sql_reqs_since_commit: No. of SQL Requests Since Last COMMIT'
                        NUM_SCAPS:
                          type: integer
                          format: int64
                          description: 'num_sec_appl_structs: Secondary Application Information'
                        LCK_TMOUT:
                          type: integer
                          format: int64
                          description: 'lock_timeouts: Number of Lock Timeouts Since Connect'
                        AGT_UCP_S:
                          type: integer
                          format: int64
                          description: 'agent_usr_cpu_time.seconds: Total User CPU Time of Appl.'
                        AGT_UPT_MS:
                          type: integer
                          format: int64
                          description: 'agent_usr_cpu_time.microsec: Total User CPU Time of Appl.'
                        AGT_SCT_S:
                          type: integer
                          format: int64
                          description: 'agent_sys_cpu_time.seconds: Total Application System CPU Tim'
                        AGT_SPT_MS:
                          type: integer
                          format: int64
                          description: 'agent_sys_cpu_time.microsec: Total Appl. System CPU Time'
                        INT_RW_INS:
                          type: integer
                          format: int64
                          description: 'int_rows_inserted: Number of Rows Inserted for Trigger'
                        RW_READ:
                          type: integer
                          format: int64
                          description: 'rows_read: Number of Rows Read Since Connection'
                        RW_WRITTEN:
                          type: integer
                          format: int64
                          description: 'rows_written: Number of Rows Written Since Connection'
                        DIRCT_RDS:
                          type: integer
                          format: int64
                          description: 'direct_reads: Direct Reads Since Connect'
                        DIRCT_WTS:
                          type: integer
                          format: int64
                          description: 'direct_writes: Direct Writes Since Connect'
                        DIRCT_RRQS:
                          type: integer
                          format: int64
                          description: 'direct_read_reqs: Direct Read Requests Since Connect'
                        DIRCT_WRQS:
                          type: integer
                          format: int64
                          description: 'direct_write_reqs: Direct Write Requests Since Connect'
                        DIRCT_RTM:
                          type: integer
                          format: int64
                          description: 'direct_read_time: Direct Read Time Since Connect'
                        DIRCT_WTM:
                          type: integer
                          format: int64
                          description: 'direct_write_time: Direct Write Time Since Connect'
                        OPN_LC_CR:
                          type: integer
                          format: int64
                          description: 'open_loc_curs: Local Cursors Currently Open'
                        OPN_LC_CRB:
                          type: integer
                          format: int64
                          description: 'open_loc_curs_blk: Local Cursors Currently Open Within Block'
                        EXEC_ID:
                          type: string
                          maxLength: 20
                          description: 'DB6: General identifier'
                        CORR_TOKEN:
                          type: string
                          maxLength: 32
                          description: 'DB6: Long identifier'
                        CLI_PID:
                          type: integer
                          format: int64
                          description: 'client_pid: Process Thread ID of Client Application'
                        CLI_PLATFO:
                          type: string
                          maxLength: 25
                          description: 'client_platform: Platform of Client Application'
                        CLI_PRTC:
                          type: string
                          maxLength: 25
                          description: 'client_protocol: Communications Protocol of Client'
                        COUNTRY_CD:
                          type: integer
                          format: int32
                          description: 'country_code: Country Code of Client Application'
                        PKG_CA_LKU:
                          type: integer
                          format: int64
                          description: 'pkg_cache_lookups: Number of Section Lookups'
                        PKG_CA_INS:
                          type: integer
                          format: int64
                          description: 'pkg_cache_inserts: Number of Sections Inserted into Cache'
                        CATCA_LKU:
                          type: integer
                          format: int64
                          description: 'cat_cache_lookups: Number of Table Descriptor Lookups'
                        CATCA_INS:
                          type: integer
                          format: int64
                          description: 'cat_cache_inserts: Number of Table Descriptors Inserted'
                        CATCA_OF:
                          type: integer
                          format: int64
                          description: 'cat_cache_overflows: Number of Catalog Cache Overflows'
                        CATCA_HPFL:
                          type: integer
                          format: int64
                          description: 'cat_cache_heap_full: Number of Overflows due to DB Heap Full'
                        CRD_NODE:
                          type: integer
                          format: int64
                          description: 'coord_node: Coordinating Node Number'
                        NUM_ASS_AG:
                          type: integer
                          format: int64
                          description: 'num_assoc_agents: Number of Agents Currently Associated'
                        NUM_AGENTS:
                          type: integer
                          format: int64
                          description: 'num_agents: Number of Agents Currently Active'
                        AGT_STOLEN:
                          type: integer
                          format: int64
                          description: 'agents_stolen: Total Number of Agents Stolen from Appl.'
                        ASS_AGT_TP:
                          type: integer
                          format: int64
                          description: 'associated_agents_top: # of Agents Associated with this Appl'
                        AP_PRIO:
                          type: integer
                          format: int64
                          description: 'appl_priority: Priority with Which Application Agents Work'
                        AP_PRIO_TY:
                          type: string
                          maxLength: 25
                          description: 'appl_priority_type: Dynamic or Static'
                        PF_WTTM:
                          type: integer
                          format: int64
                          description: 'prefetch_wait_time: Time Waited for Prefetch (ms)'
                        CRD_AG_PID:
                          type: integer
                          format: int64
                          description: 'coord_agent_pid: Coordinator Agent Process/Thread ID'
                        AP_SEC_LKU:
                          type: integer
                          format: int64
                          description: 'appl_section_lookups: Number of Section Lookups'
                        AP_SEC_INS:
                          type: integer
                          format: int64
                          description: 'appl_section_inserts: Number of Sections Inserted'
                        LCK_WTING:
                          type: integer
                          format: int64
                          description: 'locks_waiting: Number of Agents Currently Waiting for Locks'
                        OB_CN_ADDR:
                          type: string
                          maxLength: 32
                          description: 'DB6: Long identifier'
                        INBND_CNAD:
                          type: string
                          maxLength: 32
                          description: 'DB6: Long identifier'
                        OB_CN_PRTC:
                          type: integer
                          format: int32
                          description: 'outbound_comm_protocol: Outbound Communications Protocol'
                        TOT_HAJN:
                          type: integer
                          format: int64
                          description: 'total_hash_joins: Number of Hash Joins'
                        TOT_HALOOP:
                          type: integer
                          format: int64
                          description: 'total_hash_loops: Number of Hash Loops'
                        HAJN_OF:
                          type: integer
                          format: int64
                          description: 'hash_join_overflows: Number of Hash Join Overflows'
                        HAJN_SM_OF:
                          type: integer
                          format: int64
                          description: 'hash_join_small_overflows: Small Hash Join Overflows'
                        UOW_ELA_S:
                          type: integer
                          format: int64
                          description: 'uow_elapsed_time_s: Unit of Work elapse time sec'
                        UOW_ELA_MS:
                          type: integer
                          format: int64
                          description: 'uow_elapsed_time_ms: Unit of Work elapse time ms'
                        UNREADPFPG:
                          type: integer
                          format: int64
                          description: 'unread_prefetch_pages: Unread prefetched pages'
                        PL_TD_LRS:
                          type: integer
                          format: int64
                          description: pool_temp_data_l_reads
                        PL_TD_PRS:
                          type: integer
                          format: int64
                          description: pool_temp_data_p_reads
                        PL_TI_LRS:
                          type: integer
                          format: int64
                          description: pool_temp_index_l_reads
                        PL_TI_PRS:
                          type: integer
                          format: int64
                          description: pool_temp_index_p_reads
                        POOL_XDA_L_READS:
                          type: integer
                          format: int64
                          description: ''
                        POOL_XDA_P_READS:
                          type: integer
                          format: int64
                          description: ''
                        POOL_XDA_WRITES:
                          type: integer
                          format: int64
                          description: ''
                        PL_TEMP_XDA_L_RD:
                          type: integer
                          format: int64
                          description: ''
                        PL_TEMP_XDA_P_RD:
                          type: integer
                          format: int64
                          description: ''
                        ELPSD_EXC_TIM_MS:
                          type: integer
                          format: int64
                          description: ''
                        ELPSD_EXC_TIM_S:
                          type: integer
                          format: int64
                          description: ''
                        INACT_STMTHISTSZ:
                          type: integer
                          format: int64
                          description: ''
                        LOCK_TIMEOUT_VAL:
                          type: integer
                          format: int64
                          description: ''
                        PRV_WS_NUM_OVFL:
                          type: integer
                          format: int64
                          description: ''
                        PRV_WS_SCT_INSRT:
                          type: integer
                          format: int64
                          description: ''
                        PRV_WS_SCT_LKUP:
                          type: integer
                          format: int64
                          description: ''
                        PRV_WS_SIZE_TOP:
                          type: integer
                          format: int64
                          description: ''
                        SHR_WS_NUM_OVFL:
                          type: integer
                          format: int64
                          description: ''
                        SHR_WS_SCT_INSRT:
                          type: integer
                          format: int64
                          description: ''
                        SHR_WS_SCT_LKUP:
                          type: integer
                          format: int64
                          description: ''
                        SHR_WS_SIZE_TOP:
                          type: integer
                          format: int64
                          description: ''
                        SESSION_AUTH_ID:
                          type: string
                          maxLength: 128
                          description: ''
                        TPMON_ACC_STR:
                          type: string
                          maxLength: 200
                          description: ''
                        TPMON_CLIENT_APP:
                          type: string
                          maxLength: 256
                          description: ''
                        TPMON_CLIENT_UID:
                          type: string
                          maxLength: 256
                          description: ''
                        TPMON_CLIENT_WKS:
                          type: string
                          maxLength: 256
                          description: ''
                        AUTHORITY_LEVEL:
                          type: string
                          maxLength: 512
                          description: authority level in visible format
                  IT_DB6PMSA_AG:
                    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
                        AGENT_PID:
                          type: integer
                          format: int64
                          description: 'agent_pid: db2agent Process/Thread ID'
                        LOCK_TIMEOUT_VAL:
                          type: integer
                          format: int64
                          description: ''
                        DB_NAME:
                          type: string
                          maxLength: 128
                          description: ''
                  IT_DB6PMSA_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'
                  IT_DB6PMSA_SS:
                    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
                        SS_NUMBER:
                          type: integer
                          format: int32
                          description: 'ss_number: Subsection Number'
                        SS_STATUS:
                          type: integer
                          format: int32
                          description: 'ss_status: Subsection Status'
                        SS_ND_NUM:
                          type: integer
                          format: int32
                          description: 'ss_node_number: Node Where the Subsection is Executing'
                        SS_EXEC_TM:
                          type: integer
                          format: int64
                          description: 'ss_exec_time: Elapsed Execution Time in Seconds'
                        SS_USRCTS:
                          type: integer
                          format: int64
                          description: 'ss_usr_cpu_time.seconds: Total User CPU Time'
                        SS_USRCTMS:
                          type: integer
                          format: int64
                          description: 'ss_usr_cpu_time.micrsec: Total User CPU Time'
                        SS_SYSCTS:
                          type: integer
                          format: int64
                          description: 'ss_sys_cpu_time.seconds: Total System CPU Time'
                        SS_SYSCTMS:
                          type: integer
                          format: int64
                          description: 'ss_sys_cpu_time.microsec: Total System CPU Time'
                        TQ_NDWFOR:
                          type: integer
                          format: int32
                          description: 'tq_node_waited_for: Node for Which We Wait if Blocked'
                        TQ_WFANY:
                          type: integer
                          format: int32
                          description: 'tq_wait_for_any: TRUE if Waiting for any Node to Send'
                        TQ_IDWOM:
                          type: integer
                          format: int32
                          description: 'tq_id_waiting_on: Table Queue Waiting to Send/Receive'
                        TQ_TTSNDSP:
                          type: integer
                          format: int64
                          description: 'tq_tot_send_spills: Total No of Buffers Overflowed to a Temp'
                        TQ_CRSNDSP:
                          type: integer
                          format: int64
                          description: 'tq_cur_send_spills: Current No of TQ Send Buffers Overflowed'
                        TQ_MXSNDSP:
                          type: integer
                          format: int64
                          description: 'tq_max_send_spills: Maximum No of TQ Send Buffers Overflowed'
                        TQ_RW_RD:
                          type: integer
                          format: int64
                          description: 'tq_rows_read: Total # Rows Received in Table Queues'
                        TQ_RW_WR:
                          type: integer
                          format: int64
                          description: 'tq_rows_written: Total Number of Rows Sent to Table Queues'
                        RW_READ:
                          type: integer
                          format: int64
                          description: 'rows_read: Number of Data Manager (DMS) Rows Read'
                        RW_WRITTEN:
                          type: integer
                          format: int64
                          description: 'rows_written: Number of DMS Rows Written'
                        NUM_AGENTS:
                          type: integer
                          format: int64
                          description: 'num_agents: Number of Agents Currently Working on Subs.'
                        STMT_TEXT:
                          type: string
                          maxLength: 32000
                          description: ''
                  IT_DB6PMSA_ST:
                    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
                        STMT_NDNUM:
                          type: integer
                          format: int32
                          description: 'stmt_node_number: Node Where the Statement is Executing'
                        STMT_TYPE:
                          type: string
                          maxLength: 25
                          description: 'stmt_type: Type of Statement: Dynamic or Static'
                        STMT_OPERA:
                          type: string
                          maxLength: 50
                          description: 'stmt_operation: Current Operation'
                        SECTIONNUM:
                          type: integer
                          format: int64
                          description: 'section_number: Section Number'
                        QY_COSTEST:
                          type: integer
                          format: int64
                          description: 'query_cost_estimate: SQL Compiler Estimated in TIMERONS'
                        QY_CARDEST:
                          type: integer
                          format: int64
                          description: 'query_card_estimate: SQL Compiler Estimated Number of Rows'
                        DG_PARA:
                          type: integer
                          format: int64
                          description: 'degree_parallelism: SMP Intraquery Parallelism Requested'
                        STMT_SORTS:
                          type: integer
                          format: int64
                          description: 'stmt_sorts: Number of Sorts for this Statement'
                        TOT_SRT_TM:
                          type: integer
                          format: int64
                          description: 'total_sort_time: Total Sort Time for this Statement'
                        SRT_OF:
                          type: integer
                          format: int64
                          description: 'sort_overflows: Number of Sort Overflows for this Stmt'
                        RW_READ:
                          type: integer
                          format: int64
                          description: 'rows_read: Number of DMS Rows Read'
                        RW_WRITTEN:
                          type: integer
                          format: int64
                          description: 'rows_written: Number of DMS Rows Read'
                        INT_RW_DEL:
                          type: integer
                          format: int64
                          description: 'int_rows_deleted: Number of Internal DELETEs by the Stmt'
                        INT_RW_UPD:
                          type: integer
                          format: int64
                          description: 'int_rows_updated: Number of internal UPDATEs by the Stmt'
                        INT_RW_INS:
                          type: integer
                          format: int64
                          description: 'int_rows_inserted: Number of internal INSERTs by the Stmt'
                        FETCH_CNT:
                          type: integer
                          format: int64
                          description: 'fetch_count: Fetch Count'
                        STMT_START:
                          type: string
                          maxLength: 14
                          description: 'DB6: Timestamp (Format: YYYYMMDDHHMMSS)'
                        STMT_STOP:
                          type: string
                          maxLength: 14
                          description: 'DB6: Timestamp (Format: YYYYMMDDHHMMSS)'
                        CUR_NAME:
                          type: string
                          maxLength: 20
                          description: 'DB6: General identifier'
                        CREATOR:
                          type: string
                          maxLength: 20
                          description: 'DB6: General identifier'
                        PKG_NAME:
                          type: string
                          maxLength: 20
                          description: 'DB6: General identifier'
                        STMTURCTS:
                          type: integer
                          format: int64
                          description: 'stmt_usr_cpu_time.seconds: Total User CPU Time of SQL Stmt'
                        STMTURCTMS:
                          type: integer
                          format: int64
                          description: 'stmt_usr_cpu_time.microsec: Total User CPU Time of SQL Stmt'
                        STMTSYCTS:
                          type: integer
                          format: int64
                          description: 'stmt_sys_cpu_time.seconds: Total System CPU Time for SQL Stm'
                        STMTSYCTMS:
                          type: integer
                          format: int64
                          description: 'stmt_sys_cpu_time.microsec: Total System CPU Time for SQL St'
                        NUM_SS:
                          type: integer
                          format: int64
                          description: 'num_ss: Number of Subsections'
                        NUM_AGENTS:
                          type: integer
                          format: int64
                          description: 'num_agents: Number of Agents Currently Working on Stmt'
                        AGENTS_TOP:
                          type: integer
                          format: int64
                          description: 'agents_top: Number of Agents Created for Statement'
                        PL_D_LRS:
                          type: integer
                          format: int64
                          description: 'pool_data_l_reads: Pool Data Logical Reads Since Connect'
                        PL_D_PRS:
                          type: integer
                          format: int64
                          description: 'pool_data_p_reads: Pool Data Reads Since First Connect'
                        PL_I_LRS:
                          type: integer
                          format: int64
                          description: 'pool_index_l_reads: Pool Index Logical Reads Since Connect'
                        PL_I_PRS:
                          type: integer
                          format: int64
                          description: pool_index_p_reads
                        PL_TD_LRS:
                          type: integer
                          format: int64
                          description: pool_temp_data_l_reads
                        PL_TD_PRS:
                          type: integer
                          format: int64
                          description: pool_temp_data_p_reads
                        PL_TI_LRS:
                          type: integer
                          format: int64
                          description: pool_temp_index_l_reads
                        PL_TI_PRS:
                          type: integer
                          format: int64
                          description: pool_temp_index_p_reads
                        BLKCURSOR:
                          type: string
                          maxLength: 10
                          description: blocking_cursor
                        STMTELAS:
                          type: integer
                          format: int64
                          description: elapsed_time seconds
                        STMTELAMS:
                          type: integer
                          format: int64
                          description: elapsed_time microseconds
                        CONSISTNCY_TOKEN:
                          type: string
                          maxLength: 128
                          description: consistency_token
                        PACKAGE_VERS_ID:
                          type: string
                          maxLength: 128
                          description: package_version_id
                        PL_TEMP_XDA_L_RD:
                          type: integer
                          format: int64
                          description: ''
                        PL_TEMP_XDA_P_RD:
                          type: integer
                          format: int64
                          description: ''
                        POOL_XDA_L_READS:
                          type: integer
                          format: int64
                          description: ''
                        POOL_XDA_P_READS:
                          type: integer
                          format: int64
                          description: ''
                        STMT_LEN:
                          type: integer
                          format: int32
                          description: 'stmt_length: Lth of Dyn SQL Text Blank Padded to 4Byte Bndry'
                        STMT_TEXT:
                          type: string
                          maxLength: 32000
                          description: 'stmt_text: SQL Statement'
        '400':
          description: Bad request.
        5XX:
          description: Unexpected error.
