openapi: 3.0.0
info:
  title: SAP API
  version: 1.0.0
servers:
- url: http://localhost:8080
paths:
  /rfc/DB6_PM_APPSNAP1:
    post:
      tags:
      - SDB6PMST04
      summary: 'DB6: Application Snapshot (RFC Layer 1)'
      operationId: /rfc/DB6_PM_APPSNAP1
      requestBody:
        content:
          application/json:
            schema:
              properties:
                ACTION:
                  type: integer
                  format: int32
                  description: what the program should do
                ACTIVEAPP:
                  type: integer
                  format: int32
                  description: '''X'' if only active applications'
                CONNECTION:
                  type: string
                  maxLength: 30
                  description: Logical name for a database connection
                PARTITN:
                  type: integer
                  format: int32
                  description: Partition Number
                IT_DB6PMSAPP:
                  type: array
                  items:
                    type: object
                    properties:
                      COMPTIME:
                        type: string
                        maxLength: 14
                        description: 'DB6: Timestamp (Format: YYYYMMDDHHMMSS)'
                      PARTITN:
                        type: integer
                        format: int32
                        description: Partition Number
                      DBMSTRTTME:
                        type: string
                        maxLength: 14
                        description: 'DB6: Timestamp (Format: YYYYMMDDHHMMSS)'
                      AUTH_ID:
                        type: string
                        maxLength: 20
                        description: 'DB6: General identifier'
                      AGENT_ID:
                        type: integer
                        format: int64
                        description: Application Handle
                      AGENT_PID:
                        type: integer
                        format: int64
                        description: db2agent Process/Thread ID
                      APPL_NAME:
                        type: string
                        maxLength: 20
                        description: 'DB6: General identifier'
                      CLI_PID:
                        type: integer
                        format: int64
                        description: Process Thread ID of Client Application
                      CLI_HOST:
                        type: string
                        maxLength: 63
                        description: Host Name
                      CLI_PLATFO:
                        type: string
                        maxLength: 25
                        description: Platform of Client Application
                      AP_STATUS:
                        type: string
                        maxLength: 50
                        description: Application Status
                      BP_QAL:
                        type: integer
                        format: int64
                        description: Overall Buffer Quality (%)
                      BP_AV_RTM:
                        type: integer
                        format: int64
                        description: Average Physical Read Time (ms)
                      BP_AV_WTM:
                        type: integer
                        format: int64
                        description: Average Physical Write Time (ms)
                      BP_D_HITRT:
                        type: integer
                        format: int64
                        description: Buffer Pool Data Hit Ratio (%)
                      BP_I_HITRT:
                        type: integer
                        format: int64
                        description: Buffer Pool Index Hit Ratio (%)
                      PL_D_LRS:
                        type: integer
                        format: int64
                        description: Data Logical Reads
                      PL_D_PRS:
                        type: integer
                        format: int64
                        description: Data Physical Reads
                      PL_D_WS:
                        type: integer
                        format: int64
                        description: Data Physical Writes
                      PL_I_LRS:
                        type: integer
                        format: int64
                        description: Index Logical Reads
                      PL_I_PRS:
                        type: integer
                        format: int64
                        description: Index Physical Reads
                      PL_I_WS:
                        type: integer
                        format: int64
                        description: Index Physical Writes
                      PL_RD_TM:
                        type: integer
                        format: int64
                        description: Pool Read Time
                      PL_WT_TM:
                        type: integer
                        format: int64
                        description: Pool Write Time
                      DIRCT_RDS:
                        type: integer
                        format: int64
                        description: Direct Reads
                      DIRCT_WTS:
                        type: integer
                        format: int64
                        description: Direct Writes
                      DIRCT_RTM:
                        type: integer
                        format: int64
                        description: Direct Read Time
                      DIRCT_WTM:
                        type: integer
                        format: int64
                        description: Direct Write Time
                      DIRCT_RRQS:
                        type: integer
                        format: int64
                        description: Direct Read Requests
                      DIRCT_WRQS:
                        type: integer
                        format: int64
                        description: Direct Write Requests
                      AV_DCT_RTM:
                        type: integer
                        format: int64
                        description: Average Direct Read Time
                      AV_DCT_WTM:
                        type: integer
                        format: int64
                        description: Average Direct Write Time
                      AV_DCT_RDS:
                        type: integer
                        format: int64
                        description: Average Direct Reads
                      AV_DCT_WTS:
                        type: integer
                        format: int64
                        description: Average Direct Writes
                      PL_D_TE:
                        type: integer
                        format: int64
                        description: Pool Data to Extended Storage
                      PL_D_FE:
                        type: integer
                        format: int64
                        description: Pool Data from Extended Storage
                      PL_I_TE:
                        type: integer
                        format: int64
                        description: Pool Index to Extended Storage
                      PL_I_FE:
                        type: integer
                        format: int64
                        description: Pool Index from Extended Storage
                      LCK_ESCALS:
                        type: integer
                        format: int64
                        description: Lock Escalations
                      X_LCK_ESCA:
                        type: integer
                        format: int64
                        description: Exclusive Lock Escalations
                      LCK_WAITS:
                        type: integer
                        format: int64
                        description: Total Lock Waits
                      LCK_W_TM:
                        type: integer
                        format: int64
                        description: Time Waited for Locks (ms)
                      AV_WTM_LCK:
                        type: integer
                        format: int64
                        description: Average Wait Time per Lock (ms)
                      LCKS_HELD:
                        type: integer
                        format: int64
                        description: Locks Currently Held
                      DEADLOCKS:
                        type: integer
                        format: int64
                        description: Deadlocks Detected
                      LCK_TMOUT:
                        type: integer
                        format: int64
                        description: Lock Timeouts
                      CMMT_SQLST:
                        type: integer
                        format: int64
                        description: COMMITs
                      RBCK_SQLST:
                        type: integer
                        format: int64
                        description: ROLLBACKs
                      SELC_SQLST:
                        type: integer
                        format: int64
                        description: SELECT Statements
                      UID_SQLST:
                        type: integer
                        format: int64
                        description: UPDATE/INSERT/DELETE Statements
                      DYN_SQLST:
                        type: integer
                        format: int64
                        description: Dynamic SQL Statements Since Connect
                      STC_SQLST:
                        type: integer
                        format: int64
                        description: Static SQL Statements Since Connect
                      FAIL_SQLST:
                        type: integer
                        format: int64
                        description: Failed SQL Statements Since Connect
                      DDL_SQLST:
                        type: integer
                        format: int64
                        description: Data Definition Language Statements
                      RW_DELETED:
                        type: integer
                        format: int64
                        description: Rows Deleted
                      RW_INSRTED:
                        type: integer
                        format: int64
                        description: Rows Inserted
                      RW_SELECED:
                        type: integer
                        format: int64
                        description: Rows Selected
                      RW_UPDATED:
                        type: integer
                        format: int64
                        description: Rows Updated
                      TOT_SORTS:
                        type: integer
                        format: int64
                        description: Total Sorts
                      TOT_SRT_TM:
                        type: integer
                        format: int64
                        description: Total Sort Time (ms)
                      AV_SORT_TM:
                        type: integer
                        format: int64
                        description: Average Sort Time (ms)
                      SRT_OF:
                        type: integer
                        format: int64
                        description: Sort Overflows
                      CATCA_QAL:
                        type: integer
                        format: int64
                        description: Catalog Cache Quality %
                      PKG_CA_QAL:
                        type: integer
                        format: int64
                        description: Package Cache Quality (%)
                      CATCA_LKU:
                        type: integer
                        format: int64
                        description: Catalog Cache Lookups
                      CATCA_INS:
                        type: integer
                        format: int64
                        description: Catalog Cache Inserts
                      CATCA_OF:
                        type: integer
                        format: int64
                        description: Catalog Cache Overflows
                      CATCA_HPFL:
                        type: integer
                        format: int64
                        description: Catalog Cache Heap Full
                      PKG_CA_LKU:
                        type: integer
                        format: int64
                        description: Package Cache Lookups
                      PKG_CA_INS:
                        type: integer
                        format: int64
                        description: Package Cache Inserts
                      AP_CON_DT:
                        type: string
                        format: date
                        description: Application Connect Date
                      AP_CON_TM:
                        type: string
                        maxLength: 6
                        description: Application Connect Time
                      AP_IDLE_TM:
                        type: integer
                        format: int64
                        description: Application Idle Time (Seconds)
                      PF_WTTM:
                        type: integer
                        format: int64
                        description: Time Waited for Prefetch (ms)
                      AGT_UCP_S:
                        type: integer
                        format: int64
                        description: Total User CPU Time of Application
                      AGT_SCT_S:
                        type: integer
                        format: int64
                        description: Total Application System CPU time
                      CRD_AG_PID:
                        type: integer
                        format: int64
                        description: Coordinator Agent Process/Thread ID
                      NUM_ASS_AG:
                        type: integer
                        format: int64
                        description: Agents Currently Associated
                      ASS_AGT_TP:
                        type: integer
                        format: int64
                        description: Agents Associated with this Application
                      AGT_STOLEN:
                        type: integer
                        format: int64
                        description: Agents Stolen from Application
                      UOW_STRTDT:
                        type: string
                        format: date
                        description: UOW Start Time Date
                      UOW_STRTTM:
                        type: string
                        maxLength: 6
                        description: UOW Start Time
                      UOW_STOPDT:
                        type: string
                        format: date
                        description: UOW Stop Time Date
                      UOW_STOPTM:
                        type: string
                        maxLength: 6
                        description: UOW Stop Time
                      UOW_LWTM:
                        type: integer
                        format: int64
                        description: 'uow_lock_wait_time: Time UOW Waited for Locks (ms)'
                      UOW_LGSPUD:
                        type: integer
                        format: int64
                        description: 'uow_log_space_used: Log Space Used in Most Recent UOW'
                      PR_UOW_SDT:
                        type: string
                        format: date
                        description: Previous UOW completion Date
                      PR_UOW_STM:
                        type: string
                        maxLength: 6
                        description: Previous UOW completion Time
                      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'
                      UOW_CMPSTA:
                        type: string
                        maxLength: 50
                        description: 'uow_comp_status: Previous UOW Completion Status'
                      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'
                      PL_TD_LRS:
                        type: integer
                        format: int64
                        description: Pool_Temp_Data_Logical_Reads
                      PL_TD_PRS:
                        type: integer
                        format: int64
                        description: Pool_Temp_Data_Physical_Reads
                      PL_TI_LRS:
                        type: integer
                        format: int64
                        description: Pool_Temp_Index_Logical_Reads
                      PL_TI_PRS:
                        type: integer
                        format: int64
                        description: Pool_Temp_Index_Physical_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: ''
                IT_DB6PMSTMT:
                  type: array
                  items:
                    type: object
                    properties:
                      COMPTIME:
                        type: string
                        maxLength: 14
                        description: 'DB6: Timestamp (Format: YYYYMMDDHHMMSS)'
                      PARTITN:
                        type: integer
                        format: int32
                        description: Partition Number
                      DBMSTRTTME:
                        type: string
                        maxLength: 14
                        description: 'DB6: Timestamp (Format: YYYYMMDDHHMMSS)'
                      AGENT_ID:
                        type: integer
                        format: int64
                        description: Application Handle
                      STMT_TYPE:
                        type: string
                        maxLength: 25
                        description: 'Type of Statement: Dynamic or Static'
                      STMT_OPERA:
                        type: string
                        maxLength: 50
                        description: Current Operation
                      RW_READ:
                        type: integer
                        format: int64
                        description: Number of DMS Rows Read
                      RW_WRITTEN:
                        type: integer
                        format: int64
                        description: Number of DMS Rows Read
                      STMT_LEN:
                        type: integer
                        format: int32
                        description: Length of Dynamic SQL Text Blank Padded to 4 Byte Boundary
                      STMT_TEXT:
                        type: string
                        maxLength: 32000
                        description: SQL Statement
                      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
                      PL_D_LRS:
                        type: integer
                        format: int64
                        description: pool_data_l_reads
                      PL_D_PRS:
                        type: integer
                        format: int64
                        description: pool_data_p_reads
                      PL_I_LRS:
                        type: integer
                        format: int64
                        description: pool_index_l_reads
                      PL_I_PRS:
                        type: integer
                        format: int64
                        description: pool_index_p_reads
                      STMTSTRTDT:
                        type: string
                        format: date
                        description: statement_start_date
                      STMTSTRTTM:
                        type: string
                        maxLength: 6
                        description: statement_start_time
                      STMTSTOPDT:
                        type: string
                        format: date
                        description: statement_stop_date
                      STMTSTOPTM:
                        type: string
                        maxLength: 6
                        description: statement_stop_time
                      TOT_SRT_TM:
                        type: integer
                        format: int64
                        description: total_sort_time
                      STMT_SORTS:
                        type: integer
                        format: int64
                        description: statement_sorts
                      SRT_OF:
                        type: integer
                        format: int64
                        description: sort_overflows
              required:
              - ACTION
              - ACTIVEAPP
              - PARTITN
      responses:
        '200':
          description: OK
          content:
            application/json:
              schema:
                properties:
                  IT_DB6PMSAPP:
                    type: array
                    items:
                      type: object
                      properties:
                        COMPTIME:
                          type: string
                          maxLength: 14
                          description: 'DB6: Timestamp (Format: YYYYMMDDHHMMSS)'
                        PARTITN:
                          type: integer
                          format: int32
                          description: Partition Number
                        DBMSTRTTME:
                          type: string
                          maxLength: 14
                          description: 'DB6: Timestamp (Format: YYYYMMDDHHMMSS)'
                        AUTH_ID:
                          type: string
                          maxLength: 20
                          description: 'DB6: General identifier'
                        AGENT_ID:
                          type: integer
                          format: int64
                          description: Application Handle
                        AGENT_PID:
                          type: integer
                          format: int64
                          description: db2agent Process/Thread ID
                        APPL_NAME:
                          type: string
                          maxLength: 20
                          description: 'DB6: General identifier'
                        CLI_PID:
                          type: integer
                          format: int64
                          description: Process Thread ID of Client Application
                        CLI_HOST:
                          type: string
                          maxLength: 63
                          description: Host Name
                        CLI_PLATFO:
                          type: string
                          maxLength: 25
                          description: Platform of Client Application
                        AP_STATUS:
                          type: string
                          maxLength: 50
                          description: Application Status
                        BP_QAL:
                          type: integer
                          format: int64
                          description: Overall Buffer Quality (%)
                        BP_AV_RTM:
                          type: integer
                          format: int64
                          description: Average Physical Read Time (ms)
                        BP_AV_WTM:
                          type: integer
                          format: int64
                          description: Average Physical Write Time (ms)
                        BP_D_HITRT:
                          type: integer
                          format: int64
                          description: Buffer Pool Data Hit Ratio (%)
                        BP_I_HITRT:
                          type: integer
                          format: int64
                          description: Buffer Pool Index Hit Ratio (%)
                        PL_D_LRS:
                          type: integer
                          format: int64
                          description: Data Logical Reads
                        PL_D_PRS:
                          type: integer
                          format: int64
                          description: Data Physical Reads
                        PL_D_WS:
                          type: integer
                          format: int64
                          description: Data Physical Writes
                        PL_I_LRS:
                          type: integer
                          format: int64
                          description: Index Logical Reads
                        PL_I_PRS:
                          type: integer
                          format: int64
                          description: Index Physical Reads
                        PL_I_WS:
                          type: integer
                          format: int64
                          description: Index Physical Writes
                        PL_RD_TM:
                          type: integer
                          format: int64
                          description: Pool Read Time
                        PL_WT_TM:
                          type: integer
                          format: int64
                          description: Pool Write Time
                        DIRCT_RDS:
                          type: integer
                          format: int64
                          description: Direct Reads
                        DIRCT_WTS:
                          type: integer
                          format: int64
                          description: Direct Writes
                        DIRCT_RTM:
                          type: integer
                          format: int64
                          description: Direct Read Time
                        DIRCT_WTM:
                          type: integer
                          format: int64
                          description: Direct Write Time
                        DIRCT_RRQS:
                          type: integer
                          format: int64
                          description: Direct Read Requests
                        DIRCT_WRQS:
                          type: integer
                          format: int64
                          description: Direct Write Requests
                        AV_DCT_RTM:
                          type: integer
                          format: int64
                          description: Average Direct Read Time
                        AV_DCT_WTM:
                          type: integer
                          format: int64
                          description: Average Direct Write Time
                        AV_DCT_RDS:
                          type: integer
                          format: int64
                          description: Average Direct Reads
                        AV_DCT_WTS:
                          type: integer
                          format: int64
                          description: Average Direct Writes
                        PL_D_TE:
                          type: integer
                          format: int64
                          description: Pool Data to Extended Storage
                        PL_D_FE:
                          type: integer
                          format: int64
                          description: Pool Data from Extended Storage
                        PL_I_TE:
                          type: integer
                          format: int64
                          description: Pool Index to Extended Storage
                        PL_I_FE:
                          type: integer
                          format: int64
                          description: Pool Index from Extended Storage
                        LCK_ESCALS:
                          type: integer
                          format: int64
                          description: Lock Escalations
                        X_LCK_ESCA:
                          type: integer
                          format: int64
                          description: Exclusive Lock Escalations
                        LCK_WAITS:
                          type: integer
                          format: int64
                          description: Total Lock Waits
                        LCK_W_TM:
                          type: integer
                          format: int64
                          description: Time Waited for Locks (ms)
                        AV_WTM_LCK:
                          type: integer
                          format: int64
                          description: Average Wait Time per Lock (ms)
                        LCKS_HELD:
                          type: integer
                          format: int64
                          description: Locks Currently Held
                        DEADLOCKS:
                          type: integer
                          format: int64
                          description: Deadlocks Detected
                        LCK_TMOUT:
                          type: integer
                          format: int64
                          description: Lock Timeouts
                        CMMT_SQLST:
                          type: integer
                          format: int64
                          description: COMMITs
                        RBCK_SQLST:
                          type: integer
                          format: int64
                          description: ROLLBACKs
                        SELC_SQLST:
                          type: integer
                          format: int64
                          description: SELECT Statements
                        UID_SQLST:
                          type: integer
                          format: int64
                          description: UPDATE/INSERT/DELETE Statements
                        DYN_SQLST:
                          type: integer
                          format: int64
                          description: Dynamic SQL Statements Since Connect
                        STC_SQLST:
                          type: integer
                          format: int64
                          description: Static SQL Statements Since Connect
                        FAIL_SQLST:
                          type: integer
                          format: int64
                          description: Failed SQL Statements Since Connect
                        DDL_SQLST:
                          type: integer
                          format: int64
                          description: Data Definition Language Statements
                        RW_DELETED:
                          type: integer
                          format: int64
                          description: Rows Deleted
                        RW_INSRTED:
                          type: integer
                          format: int64
                          description: Rows Inserted
                        RW_SELECED:
                          type: integer
                          format: int64
                          description: Rows Selected
                        RW_UPDATED:
                          type: integer
                          format: int64
                          description: Rows Updated
                        TOT_SORTS:
                          type: integer
                          format: int64
                          description: Total Sorts
                        TOT_SRT_TM:
                          type: integer
                          format: int64
                          description: Total Sort Time (ms)
                        AV_SORT_TM:
                          type: integer
                          format: int64
                          description: Average Sort Time (ms)
                        SRT_OF:
                          type: integer
                          format: int64
                          description: Sort Overflows
                        CATCA_QAL:
                          type: integer
                          format: int64
                          description: Catalog Cache Quality %
                        PKG_CA_QAL:
                          type: integer
                          format: int64
                          description: Package Cache Quality (%)
                        CATCA_LKU:
                          type: integer
                          format: int64
                          description: Catalog Cache Lookups
                        CATCA_INS:
                          type: integer
                          format: int64
                          description: Catalog Cache Inserts
                        CATCA_OF:
                          type: integer
                          format: int64
                          description: Catalog Cache Overflows
                        CATCA_HPFL:
                          type: integer
                          format: int64
                          description: Catalog Cache Heap Full
                        PKG_CA_LKU:
                          type: integer
                          format: int64
                          description: Package Cache Lookups
                        PKG_CA_INS:
                          type: integer
                          format: int64
                          description: Package Cache Inserts
                        AP_CON_DT:
                          type: string
                          format: date
                          description: Application Connect Date
                        AP_CON_TM:
                          type: string
                          maxLength: 6
                          description: Application Connect Time
                        AP_IDLE_TM:
                          type: integer
                          format: int64
                          description: Application Idle Time (Seconds)
                        PF_WTTM:
                          type: integer
                          format: int64
                          description: Time Waited for Prefetch (ms)
                        AGT_UCP_S:
                          type: integer
                          format: int64
                          description: Total User CPU Time of Application
                        AGT_SCT_S:
                          type: integer
                          format: int64
                          description: Total Application System CPU time
                        CRD_AG_PID:
                          type: integer
                          format: int64
                          description: Coordinator Agent Process/Thread ID
                        NUM_ASS_AG:
                          type: integer
                          format: int64
                          description: Agents Currently Associated
                        ASS_AGT_TP:
                          type: integer
                          format: int64
                          description: Agents Associated with this Application
                        AGT_STOLEN:
                          type: integer
                          format: int64
                          description: Agents Stolen from Application
                        UOW_STRTDT:
                          type: string
                          format: date
                          description: UOW Start Time Date
                        UOW_STRTTM:
                          type: string
                          maxLength: 6
                          description: UOW Start Time
                        UOW_STOPDT:
                          type: string
                          format: date
                          description: UOW Stop Time Date
                        UOW_STOPTM:
                          type: string
                          maxLength: 6
                          description: UOW Stop Time
                        UOW_LWTM:
                          type: integer
                          format: int64
                          description: 'uow_lock_wait_time: Time UOW Waited for Locks (ms)'
                        UOW_LGSPUD:
                          type: integer
                          format: int64
                          description: 'uow_log_space_used: Log Space Used in Most Recent UOW'
                        PR_UOW_SDT:
                          type: string
                          format: date
                          description: Previous UOW completion Date
                        PR_UOW_STM:
                          type: string
                          maxLength: 6
                          description: Previous UOW completion Time
                        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'
                        UOW_CMPSTA:
                          type: string
                          maxLength: 50
                          description: 'uow_comp_status: Previous UOW Completion Status'
                        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'
                        PL_TD_LRS:
                          type: integer
                          format: int64
                          description: Pool_Temp_Data_Logical_Reads
                        PL_TD_PRS:
                          type: integer
                          format: int64
                          description: Pool_Temp_Data_Physical_Reads
                        PL_TI_LRS:
                          type: integer
                          format: int64
                          description: Pool_Temp_Index_Logical_Reads
                        PL_TI_PRS:
                          type: integer
                          format: int64
                          description: Pool_Temp_Index_Physical_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: ''
                  IT_DB6PMSTMT:
                    type: array
                    items:
                      type: object
                      properties:
                        COMPTIME:
                          type: string
                          maxLength: 14
                          description: 'DB6: Timestamp (Format: YYYYMMDDHHMMSS)'
                        PARTITN:
                          type: integer
                          format: int32
                          description: Partition Number
                        DBMSTRTTME:
                          type: string
                          maxLength: 14
                          description: 'DB6: Timestamp (Format: YYYYMMDDHHMMSS)'
                        AGENT_ID:
                          type: integer
                          format: int64
                          description: Application Handle
                        STMT_TYPE:
                          type: string
                          maxLength: 25
                          description: 'Type of Statement: Dynamic or Static'
                        STMT_OPERA:
                          type: string
                          maxLength: 50
                          description: Current Operation
                        RW_READ:
                          type: integer
                          format: int64
                          description: Number of DMS Rows Read
                        RW_WRITTEN:
                          type: integer
                          format: int64
                          description: Number of DMS Rows Read
                        STMT_LEN:
                          type: integer
                          format: int32
                          description: Length of Dynamic SQL Text Blank Padded to 4 Byte Boundary
                        STMT_TEXT:
                          type: string
                          maxLength: 32000
                          description: SQL Statement
                        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
                        PL_D_LRS:
                          type: integer
                          format: int64
                          description: pool_data_l_reads
                        PL_D_PRS:
                          type: integer
                          format: int64
                          description: pool_data_p_reads
                        PL_I_LRS:
                          type: integer
                          format: int64
                          description: pool_index_l_reads
                        PL_I_PRS:
                          type: integer
                          format: int64
                          description: pool_index_p_reads
                        STMTSTRTDT:
                          type: string
                          format: date
                          description: statement_start_date
                        STMTSTRTTM:
                          type: string
                          maxLength: 6
                          description: statement_start_time
                        STMTSTOPDT:
                          type: string
                          format: date
                          description: statement_stop_date
                        STMTSTOPTM:
                          type: string
                          maxLength: 6
                          description: statement_stop_time
                        TOT_SRT_TM:
                          type: integer
                          format: int64
                          description: total_sort_time
                        STMT_SORTS:
                          type: integer
                          format: int64
                          description: statement_sorts
                        SRT_OF:
                          type: integer
                          format: int64
                          description: sort_overflows
        '400':
          description: Bad request.
        5XX:
          description: Unexpected error.
