Event mapping

The Tivoli® Event Integration Facility (EIF) interface is used to forward situation events to Tivoli Netcool/OMNIbus or Tivoli Enterprise Console®.

EIF events specify an event class, and the event data is specified as name-value pairs that identify the name of an event slot and the value for the slot. An event class can have subclasses. IBM® Tivoli Monitoring provides the base event class definitions and a set of base slots that are included in all monitoring events. Agents extend the base event classes to define subclasses that include agent-specific slots. For DB2® agent events, the event classes correspond to the agent attribute groups, and the agent-specific slots correspond to the attributes in the attribute group.

The situation editor in the Tivoli Enterprise Portal can be used to perform custom mapping of data to EIF slots instead of using the default mapping described in this topic. For more information about EIF slot customization, see the Tivoli Enterprise Portal User's Guide.

Tivoli Enterprise Console requires that event classes and their slots are defined in BAROC (Basic Recorder of Objects in C) files. Each agent provides a BAROC file that contains event class definitions for the agent and is installed on the Tivoli Enterprise Monitoring Server in the TECLIB directory (install_dir/cms/TECLIB for Windows systems and install_dir/tables/TEMS_hostname/TECLIB for UNIX systems) when application support for the agent is installed. The BAROC file for the agent and the base BAROC files provided with Tivoli Monitoring must also be installed onto the Tivoli Enterprise Console. For details, see Setting up event forwarding to Tivoli Enterprise Console in the IBM Tivoli Monitoring Installation and Setup Guide.

Each of the event classes is a child of KUD_Base and is defined in the kud.baroc (version 7.1) file. The KUD_Base event class can be used for generic rules processing for any event from the Monitoring Agent for DB2.

Table 1. Overview of attribute groups to event classes and slots
Event slots IBM Tivoli Enterprise Console event class
KUDINFO00 attribute group
  • node_name: STRING
  • db2_status: STRING
  • db2_status_enum: STRING
  • db2start_time: STRING
  • last_reset: STRING
  • snapshot_time: STRING
  • prdid: STRING
  • instance_name: STRING
  • instance_name_enum: STRING
  • version: STRING
  • version_enum: STRING
  • server_db2_type: STRING
  • server_db2_type_enum: STRING
  • sort_heap_allocated: INTEGER
  • sort_heap_allocated_enum: STRING
  • post_threshold_sorts: INTEGER
  • post_threshold_sorts_enum: STRING
  • piped_sorts_requested: INTEGER
  • piped_sorts_requested_enum: STRING
  • piped_sorts_accepted: INTEGER
  • piped_sorts_accepted_enum: STRING
  • piped_sorts_accepted_pct: INTEGER
  • piped_sorts_accepted_pct_enum: STRING
  • rem_cons_in: INTEGER
  • rem_cons_in_enum: STRING
  • rem_cons_in_exec: INTEGER
  • rem_cons_in_exec_enum: STRING
  • local_cons: INTEGER
  • local_cons_enum: STRING
  • local_cons_in_exec: INTEGER
  • local_cons_in_exec_enum: STRING
  • con_local_dbases: INTEGER
  • con_local_dbases_enum: STRING
  • agents_registered: INTEGER
  • agents_registered_enum: STRING
  • agents_waiting_on_token: INTEGER
  • agents_waiting_on_token_enum: STRING
  • agents_waiting_on_token_pct: INTEGER
  • agents_waiting_on_token_pct_enum: STRING
  • agents_from_pool: INTEGER
  • agents_from_pool_enum: STRING
  • agents_created_empty_pool: INTEGER
  • agents_created_empty_pool_enum: STRING
  • agents_created_empty_pool_ratio: INTEGER
  • agents_created_empty_pool_ratio_enum: STRING
  • coord_agents_top: INTEGER
  • coord_agents_top_enum: STRING
  • max_agent_overflows: INTEGER
  • max_agent_overflows_enum: STRING
(Continued on the next page.)
ITM_KUDINFO00
  • agents_stolen: INTEGER
  • agents_stolen_enum: STRING
  • agents_registered_top: INTEGER
  • agents_registered_top_enum: STRING
  • agents_waiting_top: INTEGER
  • agents_waiting_top_enum: STRING
  • comm_private_mem: INTEGER
  • comm_private_mem_enum: STRING
  • idle_agents: INTEGER
  • idle_agents_enum: STRING
  • gw_total_cons: INTEGER
  • gw_total_cons_enum: STRING
  • gw_cur_cons: INTEGER
  • gw_cur_cons_enum: STRING
  • gw_cons_wait_host: INTEGER
  • gw_cons_wait_host_enum: STRING
  • gw_cons_wait_client: INTEGER
  • gw_cons_wait_client_enum: STRING
  • post_threshold_hash_joins: INTEGER
  • piped_sort_hit_ratio_pct_for_int: INTEGER
  • agentpri: INTEGER
  • agentpri_enum: STRING
  • aslheapsz: INTEGER
  • aslheapsz_enum: STRING
  • fcm_num_anchors: INTEGER
  • fcm_num_anchors_enum: STRING
  • fcm_num_buffers: INTEGER
  • fcm_num_buffers_enum: STRING
  • fcm_num_connect: INTEGER
  • fcm_num_connect_enum: STRING
  • fcm_num_rqb: INTEGER
  • fcm_num_rqb_enum: STRING
  • maxagents: INTEGER
  • maxagents_enum: STRING
  • max_coordagents: INTEGER
  • max_coordagents_enum: STRING
  • maxcagents: INTEGER
  • maxcagents_enum: STRING
  • mon_heap_sz: INTEGER
  • mon_heap_sz_enum: STRING
  • query_heap_sz: INTEGER
  • query_heap_sz_enum: STRING
  • rqrioblk: INTEGER
  • rqrioblk_enum: STRING
  • piped_sorts_rejected_pct_for_int: INTEGER
  • piped_sorts_rejected_pct_for_int_enum: STRING
  • piped_sorts_rejected_pct_for_int: INTEGER
  • piped_sorts_rejected_pct_for_int_enum: STRING
  • sheapthres: INTEGER
  • sheapthres_enum: STRING
(Continued on the next page.)
ITM_KUDINFO00
(Continued)
  • connection_status: INTEGER
  • connection_status_enum: STRING
  • buff_free: INTEGER
  • buff_free_enum: STRING
  • ce_free: INTEGER
  • ce_free_enum: STRING
  • rb_free: INTEGER
  • rb_free_enum: STRING
  • connection_status: INTEGER
  • connection_status_enum: STRING
  • buff_free: INTEGER
  • buff_free_enum: STRING
  • ce_free: INTEGER
  • ce_free_enum: STRING
  • rb_free: INTEGER
  • rb_free_enum: STRING
  • buff_free_bottom: INTEGER
  • buff_free_bottom_enum: STRING
  • ce_free_bottom: INTEGER
  • ce_free_bottom_enum: STRING
  • ma_free_bottom: INTEGER
  • ma_free_bottom_enum: STRING
  • rb_free_bottom: INTEGER
  • rb_free_bottom_enum: STRING
  • buf_used_pct: INTEGER
  • buf_used_pct_enum: STRING
  • rb_used_pct: INTEGER
  • rb_used_pct_enum: STRING
  • ce_used_pct: INTEGER
  • ce_used_pct_enum: STRING
  • buff_max_used_pct: INTEGER
  • buff_max_used_pct_enum: STRING
  • ce_max_used_pct: INTEGER
  • ce_max_used_pct_enum: STRING
  • ma_max_used_pct: INTEGER
  • ma_max_used_pct_enum: STRING
  • rb_max_used_pct: INTEGER
  • rb_max_used_pct_enum: STRING
  • total_buffers_rcvd: INTEGER
  • total_buffers_rcvd_enum: STRING
  • total_buffers_sent: INTEGER
  • total_buffers_sent_enum: STRING
  • piped_sorts_rejected_for_int: INTEGER
  • piped_sorts_rejected_for_int_enum: STRING
  • dbpg_node_status: STRING
  • instance_name_u: STRING
  • instance_name_u_enum: STRING
  • comm_private_mem_enum: STRING
  • db2_avail: INTEGER
  • db2start_time_timestamp: STRING
  • last_reset_timestamp: STRING
  • snapshot_time_timestamp: STRING
  • comm_private_mem_kb: INTEGER
  • comm_private_mem_kb_enum: STRING
(Continued on the next page.)
ITM_KUDINFO00
(Continued)
  • cons_in_exec_pct: INTEGER
  • cons_in_exec_pct_enum: STRING
  • db_partition: STRING
  • db_partition_enum: STRING
  • sort_heap_used_pct: INTEGER
  • sort_heap_used_pct_enum: STRING
ITM_KUDINFO00
(Continued)
KUDDBASEGROUP00 attribute group
  • node_name: STRING
  • db_name: STRING
  • input_db_alias: STRING
  • db_path: STRING
  • dbase_status: STRING
  • dbase_status_enum: STRING
  • db_conn_time: STRING
  • last_backup: STRING
  • total_cons: INTEGER
  • total_cons_enum: STRING
  • appls_cur_cons: INTEGER
  • appls_cur_cons_enum: STRING
  • snapshot_time: STRING
  • int_rollbacks: INTEGER
  • int_rollbacks_enum: STRING
  • int_deadlock_rollbacks: INTEGER
  • int_deadlock_rollbacks_enum: STRING
  • rollback_sql_stmts: INTEGER
  • rollback_sql_stmts_enum: STRING
  • failed_sql_stmts: INTEGER
  • failed_sql_stmts_enum: STRING
  • prefetch_wait_time: INTEGER
  • prefetch_wait_time_enum: STRING
  • agents_top: INTEGER
  • agents_top_enum: STRING
  • coord_agents_top: INTEGER
  • coord_agents_top_enum: STRING
  • db_location: STRING
  • db_location_enum: STRING
  • server_platform: STRING
  • connections_top: INTEGER
  • connections_top_enum: STRING
  • db_heap_top: INTEGER
  • db_heap_top_enum: STRING
  • locks_held: INTEGER
  • locks_held_enum: STRING
  • lock_waits: INTEGER
  • lock_waits_enum: STRING
  • lock_wait_time: INTEGER
  • lock_wait_time_enum: STRING
  • lock_list_in_use: INTEGER
  • lock_list_in_use_enum: STRING
  • deadlocks: INTEGER
  • deadlocks_enum: STRING
  • lock_escals: INTEGER
  • lock_escals_enum: STRING
  • x_lock_escals: INTEGER
  • x_lock_escals_enum: STRING
  • locks_waiting: INTEGER
  • locks_waiting_enum: STRING
  • lock_timeouts: INTEGER
  • lock_timeouts_enum: STRING
  • avg_lock_wait_time: INTEGER
  • avg_lock_wait_time_enum: STRING
(Continued on the next page.)
ITM_KUDDBASEGROUP00
  • avg_lock_wait_time: INTEGER
  • avg_lock_wait_time_enum: STRING
  • sort_heap_allocated: INTEGER
  • sort_heap_allocated_enum: STRING
  • total_sorts: INTEGER
  • total_sorts_enum: STRING
  • total_sort_time: INTEGER
  • total_sort_time_enum: STRING
  • sort_overflows: INTEGER
  • sort_overflows_enum: STRING
  • active_sorts: INTEGER
  • active_sorts_enum: STRING
  • avg_sort_time: INTEGER
  • avg_sort_time_enum: STRING
  • sort_overflows_pct: INTEGER
  • sort_overflows_pct_enum: STRING
  • pool_data_l_reads: INTEGER
  • pool_data_l_reads_enum: STRING
  • pool_data_p_reads: INTEGER
  • pool_data_p_reads_enum: STRING
  • pool_data_writes: INTEGER
  • pool_data_writes_enum: STRING
  • pool_index_l_reads: INTEGER
  • pool_index_l_reads_enum: STRING
  • pool_index_p_reads: INTEGER
  • pool_index_p_reads_enum: STRING
  • pool_index_writes: INTEGER
  • pool_index_writes_enum: STRING
  • pool_read_time: INTEGER
  • pool_read_time_enum: STRING
  • pool_write_time: INTEGER
  • pool_write_time_enum: STRING
  • files_closed: INTEGER
  • files_closed_enum: STRING
  • pool_async_index_reads: INTEGER
  • pool_async_index_reads_enum: STRING
  • pool_data_to_estore: INTEGER
  • pool_data_to_estore_enum: STRING
  • pool_index_to_estore: INTEGER
  • pool_index_to_estore_enum: STRING
  • pool_index_from_estore: INTEGER
  • pool_index_from_estore_enum: STRING
  • pool_data_from_estore: INTEGER
  • pool_data_from_estore_enum: STRING
  • pool_async_data_reads: INTEGER
  • pool_async_data_reads_enum: STRING
  • pool_async_data_writes: INTEGER
  • pool_async_data_writes_enum: STRING
  • pool_async_index_writes: INTEGER
  • pool_async_index_writes_enum: STRING
  • pool_async_read_time: INTEGER
  • pool_async_read_time_enum: STRING
  • pool_async_write_time: INTEGER
  • pool_async_write_time_enum: STRING
(Continued on the next page.)
ITM_KUDDBASEGROUP00
(Continued)
  • pool_async_data_read_reqs: INTEGER
  • pool_async_data_read_reqs_enum: STRING
  • pool_lsn_gap_clns: INTEGER
  • pool_lsn_gap_clns_enum: STRING
  • pool_drty_pg_steal_clns: INTEGER
  • pool_drty_pg_steal_clns_enum: STRING
  • pool_drty_pg_thrsh_clns: INTEGER
  • pool_drty_pg_thrsh_clns_enum: STRING
  • pool_total_reads: INTEGER
  • pool_total_reads_enum: STRING
  • pool_hit_ratio: INTEGER
  • pool_hit_ratio_enum: STRING
  • avg_pool_read_time: INTEGER
  • avg_pool_read_time_enum: STRING
  • pool_total_writes: INTEGER
  • pool_total_writes_enum: STRING
  • avg_pool_write_time: INTEGER
  • avg_pool_write_time_enum: STRING
  • pool_sync_data_reads: INTEGER
  • pool_sync_data_reads_enum: STRING
  • pool_sync_index_reads: INTEGER
  • pool_sync_index_reads_enum: STRING
  • pool_sync_read: INTEGER
  • pool_sync_read_enum: STRING
  • pool_sync_data_writes: INTEGER
  • pool_sync_data_writes_enum: STRING
  • pool_sync_index_writes: INTEGER
  • pool_sync_index_writes_enum: STRING
  • pool_sync_write: INTEGER
  • pool_sync_write_enum: STRING
  • pool_sync_read_time: INTEGER
  • pool_sync_read_time_enum: STRING
  • avg_sync_read_time: INTEGER
  • avg_sync_read_time_enum: STRING
  • pool_sync_write_time: INTEGER
  • pool_sync_write_time_enum: STRING
  • avg_sync_write_time: INTEGER
  • avg_sync_write_time_enum: STRING
  • avg_data_page_read_per_async_req: INTEGER
  • avg_data_page_read_per_async_req_enum: STRING
  • direct_reads: INTEGER
  • direct_reads_enum: STRING
  • direct_writes: INTEGER
  • direct_writes_enum: STRING
  • direct_read_reqs: INTEGER
  • direct_read_reqs_enum: STRING
  • direct_write_reqs: INTEGER
  • direct_write_reqs_enum: STRING
  • direct_read_time: INTEGER
  • direct_read_time_enum: STRING
  • direct_write_time: INTEGER
  • direct_write_time_enum: STRING
(Continued on the next page.)
ITM_KUDDBASEGROUP00
(Continued)
  • commit_sql_stmts: INTEGER
  • commit_sql_stmts_enum: STRING
  • dynamic_sql_stmts: INTEGER
  • dynamic_sql_stmts_enum: STRING
  • static_sql_stmts: INTEGER
  • static_sql_stmts_enum: STRING
  • select_sql_stmts: INTEGER
  • select_sql_stmts_enum: STRING
  • ddl_sql_stmts: INTEGER
  • ddl_sql_stmts_enum: STRING
  • uid_sql_stmts: INTEGER
  • uid_sql_stmts_enum: STRING
  • total_sql_stmts: INTEGER
  • total_sql_stmts_enum: STRING
  • sql_stmts_failed_pct: INTEGER
  • sql_stmts_failed_pct_enum: STRING
  • sql_stmts_rollback_pct: INTEGER
  • sql_stmts_rollback_pct_enum: STRING
  • appl_section_lookups: INTEGER
  • appl_section_lookups_enum: STRING
  • appl_section_inserts: INTEGER
  • appl_section_inserts_enum: STRING
  • binds_precompiles: INTEGER
  • binds_precompiles_enum: STRING
  • total_hash_joins: INTEGER
  • total_hash_joins_enum: STRING
  • total_hash_loops: INTEGER
  • total_hash_loops_enum: STRING
  • hash_join_overflows: INTEGER
  • hash_join_overflows_enum: STRING
  • hash_join_small_overflows: INTEGER
  • hash_join_small_overflows_enum: STRING
  • rows_deleted: INTEGER
  • rows_deleted_enum: STRING
  • rows_inserted: INTEGER
  • rows_inserted_enum: STRING
  • rows_updated: INTEGER
  • rows_updated_enum: STRING
  • rows_selected: INTEGER
  • rows_selected_enum: STRING
  • total_sec_cons: INTEGER
  • total_sec_cons_enum: STRING
  • num_assoc_agents: INTEGER
  • num_assoc_agents_enum: STRING
  • catalog_node_name: STRING
  • catalog_node_name_enum: STRING
  • sec_log_used_top: INTEGER
  • sec_log_used_top_enum: STRING
  • tot_log_used_top: INTEGER
  • tot_log_used_top_enum: STRING
  • sec_logs_allocated: INTEGER
  • sec_logs_allocated_enum: STRING
  • log_reads: INTEGER
  • log_reads_enum: STRING
(Continued on next page.)
ITM_KUDDBASEGROUP00
(Continued)
  • log_writes: INTEGER
  • log_writes_enum: STRING
  • pkg_cache_lookups: INTEGER
  • pkg_cache_lookups_enum: STRING
  • pkg_cache_inserts: INTEGER
  • pkg_cache_inserts_enum: STRING
  • pkg_cache_hit_ratio: INTEGER
  • pkg_cache_hit_ratio_enum: STRING
  • cat_cache_lookups: INTEGER
  • cat_cache_lookups_enum: STRING
  • cat_cache_inserts: INTEGER
  • cat_cache_inserts_enum: STRING
  • cat_cache_overflows: INTEGER
  • cat_cache_overflows_enum: STRING
  • cat_cache_hit_ratio: INTEGER
  • cat_cache_hit_ratio_enum: STRING
  • cat_cache_heap_full: INTEGER
  • cat_cache_heap_full_enum: STRING
  • db_name_u: STRING
  • input_db_alias_u: STRING
  • db_path_u: STRING
  • db_partition: STRING
  • db_partition_enum: STRING
  • instance_name_u: STRING
ITM_KUDDBASEGROUP00
(Continued)
KUDDB2APPLGROUP00 attribute group
  • node_name: STRING
  • agent_id: INTEGER
  • appl_id: STRING
  • appl_status: STRING
  • appl_status_enum: STRING
  • snapshot_time: STRING
  • appl_name: STRING
  • auth_id: STRING
  • client_prdid: STRING
  • db_name: STRING
  • execution_id: STRING
  • corr_token: STRING
  • client_platform: STRING
  • client_platform_enum: STRING
  • client_protocol: STRING
  • client_protocol_enum: STRING
  • locks_held: INTEGER
  • locks_held_enum: STRING
  • lock_waits: INTEGER
  • lock_waits_enum: STRING
  • lock_wait_time: INTEGER
  • lock_wait_time_enum: STRING
  • lock_escals: INTEGER
  • lock_escals_enum: STRING
  • x_lock_escals: INTEGER
  • x_lock_escals_enum: STRING
  • deadlocks: INTEGER
  • deadlocks_enum: STRING
  • uow_lock_wait_time: INTEGER
  • uow_lock_wait_time_enum: STRING
  • lock_timeouts: INTEGER
  • lock_timeouts_enum: STRING
  • avg_lock_waittime: INTEGER
  • avg_lock_waittime_enum: STRING
  • agent_id_holding_lk: INTEGER
  • agent_id_holding_lk_enum: STRING
  • appl_id_holding_lk: STRING
  • appl_id_holding_lk_enum: STRING
  • lock_mode: STRING
  • lock_mode_enum: STRING
  • lock_object_type: STRING
  • lock_object_type_enum: STRING
  • lock_wait_start_time: STRING
  • table_name: STRING
  • table_schema: STRING
  • tablespace_name: STRING
  • pool_data_l_reads: INTEGER
  • pool_data_l_reads_enum: STRING
  • pool_data_p_reads: INTEGER
  • pool_data_p_reads_enum: STRING
  • pool_data_writes: INTEGER
  • pool_data_writes_enum: STRING
  • pool_index_l_reads: INTEGER
  • pool_index_l_reads_enum: STRING
(Continued on next page.)
ITM_KUDDB2APPLGROUP00
(deprecated)
  • pool_index_p_reads: INTEGER
  • pool_index_p_reads_enum: STRING
  • pool_index_writes: INTEGER
  • pool_index_writes_enum: STRING
  • pool_read_time: INTEGER
  • pool_read_time_enum: STRING
  • pool_write_time: INTEGER
  • pool_write_time_enum: STRING
  • pool_data_to_estore: INTEGER
  • pool_data_to_estore_enum: STRING
  • pool_index_to_estore: INTEGER
  • pool_index_to_estore_enum: STRING
  • pool_index_from_estore: INTEGER
  • pool_index_from_estore_enum: STRING
  • pool_data_from_estore: INTEGER
  • pool_data_from_estore_enum: STRING
  • pool_total_reads: INTEGER
  • pool_total_reads_enum: INTEGER
  • pool_hit_ratio: INTEGER
  • pool_hit_ratio_enum: STRING
  • avg_pool_read_time: INTEGER
  • avg_pool_read_time_enum: STRING
  • pool_total_writes: INTEGER
  • pool_total_writes_enum: STRING
  • avg_pool_write_time: INTEGER
  • avg_pool_write_time_enum: STRING
  • appl_idle_time: INTEGER
  • appl_idle_time_enum: STRING
  • agent_usr_cpu_time: STRING
  • agent_sys_cpu_time: STRING
  • appl_con_time: STRING
  • conn_complete_time: STRING
  • prefetch_wait_time: INTEGER
  • prefetch_wait_time_enum: STRING
  • direct_reads: INTEGER
  • direct_reads_enum: STRING
  • direct_writes: INTEGER
  • direct_writes_enum: STRING
  • direct_read_reqs: INTEGER
  • direct_read_reqs_enum: STRING
  • direct_write_reqs: INTEGER
  • direct_write_reqs_enum: STRING
  • direct_read_time: INTEGER
  • direct_read_time_enum: STRING
  • direct_write_time: INTEGER
  • direct_write_time_enum: STRING
  • stmt_type: STRING
  • stmt_type_enum: STRING
  • stmt_operation: STRING
  • stmt_operation_enum: STRING
  • cursor_name: STRING
  • creator: STRING
  • package_name: STRING
  • total_sql_stmt: INTEGER
  • total_sql_stmt_enum: STRING
(Continued on the next page)
ITM_KUDDB2APPLGROUP00
(deprecated)
(Continued)
  • failed_sql_stmts: INTEGER
  • failed_sql_stmts_enum: STRING
  • int_rollbacks: INTEGER
  • int_rollbacks_enum: STRING
  • int_deadlock_rollbacks: INTEGER
  • int_deadlock_rollbacks_enum: STRING
  • rollback_sql_stmts: INTEGER
  • rollback_sql_stmts_enum: STRING
  • failed_sql_stmts_pct: INTEGER
  • failed_sql_stmts_pct_enum: STRING
  • total_sorts: INTEGER
  • total_sorts_enum: STRING
  • total_sort_time: INTEGER
  • total_sort_time_enum: STRING
  • sort_overflows: INTEGER
  • sort_overflows_enum: STRING
  • avg_sort_time: INTEGER
  • avg_sort_time_enum: STRING
  • sort_overflows_pct: INTEGER
  • sort_overflows_pct_enum: STRING
  • commit_sql_stmts: INTEGER
  • commit_sql_stmts_enum: STRING
  • dynamic_sql_stmts: INTEGER
  • dynamic_sql_stmts_enum: STRING
  • static_sql_stmts: INTEGER
  • static_sql_stmts_enum: STRING
  • select_sql_stmts: INTEGER
  • select_sql_stmts_enum: STRING
  • ddl_sql_stmts: INTEGER
  • ddl_sql_stmts_enum: STRING
  • uid_sql_stmts: INTEGER
  • uid_sql_stmts_enum: STRING
  • binds_precompiles: INTEGER
  • binds_precompiles_enum: STRING
  • section_number: INTEGER
  • section_number_enum: STRING
  • stmt_start: STRING
  • stmt_stop: STRING
  • uow_log_space_used: INTEGER
  • uow_log_space_used_enum: STRING
  • uow_comp_status: STRING
  • uow_comp_status_enum: STRING
  • prev_uow_stop_time: STRING
  • uow_start_time: STRING
  • uow_stop_time: STRING
  • int_auto_rebinds: INTEGER
  • int_auto_rebinds_enum: STRING
  • int_rows_deleted: INTEGER
  • int_rows_deleted_enum: STRING
  • int_rows_updated: INTEGER
  • int_rows_updated_enum: STRING
  • int_commits: INTEGER
  • int_commits_enum: STRING
  • int_rows_inserted: INTEGER
  • int_rows_inserted_enum: STRING
(Continued on the next page.)
ITM_KUDDB2APPLGROUP00
(deprecated)
(Continued)
  • rows_deleted: INTEGER
  • rows_deleted_enum: STRING
  • rows_inserted: INTEGER
  • rows_inserted_enum: STRING
  • rows_updated: INTEGER
  • rows_updated_enum: STRING
  • rows_selected: INTEGER
  • rows_selected_enum: STRING
  • rows_read: INTEGER
  • rows_read_enum: STRING
  • rows_written: INTEGER
  • rows_written_enum: STRING
  • open_loc_curs: INTEGER
  • open_loc_curs_enum: STRING
  • open_loc_curs_blk: INTEGER
  • open_loc_curs_blk_enum: STRING
  • open_rem_curs: INTEGER
  • open_rem_curs_enum: STRING
  • open_rem_curs_blk: INTEGER
  • open_rem_curs_blk_enum: STRING
  • rej_curs_blk: INTEGER
  • rej_curs_blk_enum: STRING
  • acc_curs_blk: INTEGER
  • acc_curs_blk_enum: STRING
  • client_pid: INTEGER
  • client_pid_enum: STRING
  • country_code: INTEGER
  • country_code_enum: STRING
  • pkg_cache_lookups: INTEGER
  • pkg_cache_lookups_enum: STRING
  • pkg_cache_inserts: INTEGER
  • pkg_cache_inserts_enum: STRING
  • pkg_cache_hit_ratio: INTEGER
  • pkg_cache_hit_ratio_enum: STRING
  • cat_cache_lookups: INTEGER
  • cat_cache_lookups_enum: STRING
  • cat_cache_inserts: INTEGER
  • cat_cache_inserts_enum: STRING
  • cat_cache_overflows: INTEGER
  • cat_cache_overflows_enum: STRING
  • cat_cache_inserts: INTEGER
  • cat_cache_inserts_enum: STRING
  • cat_cache_overflows: INTEGER
  • cat_cache_overflows_enum: STRING
  • cat_cache_heap_full: INTEGER
  • cat_cache_heap_full_enum: STRING
  • cat_cache_hit_ratio: INTEGER
  • cat_cache_hit_ratio_enum: STRING
  • total_hash_joins: INTEGER
  • total_hash_joins_enum: STRING
  • total_hash_loops: INTEGER
  • total_hash_loops_enum: STRING
  • hash_join_overflows: INTEGER
  • hash_join_overflows_enum: STRING
(Continued on the next page.)
ITM_KUDDB2APPLGROUP00
(deprecated)
(Continued)
  • hash_join_small_overflows: INTEGER
  • hash_join_small_overflows_enum: STRING
  • query_cost_estimate: INTEGER
  • query_cost_estimate_enum: STRING
  • query_card_estimate: INTEGER
  • query_card_estimate_enum: STRING
  • degree_parallelism: INTEGER
  • degree_parallelism_enum: STRING
  • stmt_text: STRING
ITM_KUDDB2APPLGROUP00
(deprecated)
(Continued)
KUDLOCKCONFLICT00 attribute group
  • node_name: STRING
  • agent_id: INTEGER
  • agent_id_enum: STRING
  • appl_id: STRING
  • appl_name: STRING
  • appl_status: STRING
  • appl_status_enum: STRING
  • snapshot_time: STRING
  • auth_id: STRING
  • client_db_alias: STRING
  • status_change_time: STRING
  • codepage_id: INTEGER
  • codepage_id_enum: STRING
  • locks_held: INTEGER
  • locks_held_enum: STRING
  • lock_wait_time: INTEGER
  • lock_wait_time_enum: STRING
  • agent_id_holding_lk: INTEGER
  • agent_id_holding_lk_enum: STRING
  • appl_id_holding_lk: STRING
  • table_name: STRING
  • table_schema: STRING
  • tablespace_name: STRING
  • lock_escalation: STRING
  • lock_escalation_enum: STRING
  • lock_wait_start_time: STRING
  • lock_mode: STRING
  • lock_mode_enum: STRING
  • lock_object_type: STRING
  • lock_object_type_enum: STRING
  • appl_id_u: STRING
  • appl_name_u: STRING
  • auth_id_u: STRING
  • client_db_alias_u: STRING
  • appl_id_holding_lk_u: STRING
  • table_name_u: STRING
  • table_schema_u: STRING
  • tablespace_name_u: STRING
  • snapshot_time_timestamp: STRING
  • status_change_time_timestamp: STRING
  • lock_wait_start_time_timestamp: STRING
  • db_partition: STRING
  • db_partition_enum: STRING
  • locks_held_64: REAL
  • locks_held_64_enum: STRING
  • lock_wait_time_64: REAL
  • lock_wait_time_64_enum: STRING
ITM_KUDLOCKCONFLICT00
KUDBUFFERPOOL00 attribute group
  • node_name: STRING
  • bp_id: STRING
  • bp_name: STRING
  • input_db_alias: STRING
  • db_name: STRING
  • db_path: STRING
  • pool_data_l_reads: INTEGER
  • pool_data_l_reads_enum: STRING
  • pool_data_p_reads: INTEGER
  • pool_data_p_reads_enum: STRING
  • pool_data_writes: INTEGER
  • pool_data_writes_enum: STRING
  • pool_index_l_reads: INTEGER
  • pool_index_l_read:_enum: STRING
  • pool_index_p_reads: INTEGER
  • pool_index_p_reads_enum: STRING
  • pool_index_writes: INTEGER
  • pool_index_writes_enum: STRING
  • pool_read_time: INTEGER
  • pool_read_time_enum: STRING
  • pool_write_time: INTEGER
  • pool_write_time_enum: STRING
  • files_closed: INTEGER
  • files_closed_enum: STRING
  • pool_async_index_reads: INTEGER
  • pool_async_index_reads_enum: STRING
  • pool_data_to_estore: INTEGER
  • pool_data_to_estore_enum: STRING
  • pool_index_to_estore: INTEGER
  • pool_index_to_estore_enum: STRING
  • pool_index_from_estore: INTEGER
  • pool_index_from_estore_enum: STRING
  • pool_data_from_estore: INTEGER
  • pool_data_from_estore_enum: STRING
  • pool_async_data_reads: INTEGER
  • pool_async_data_reads_enum: STRING
  • pool_async_data_writes: INTEGER
  • pool_async_data_writes_enum: STRING
  • pool_async_index_writes: INTEGER
  • pool_async_index_writes_enum: STRING
  • pool_async_read_time: INTEGER
  • pool_async_read_time_enum: STRING
  • pool_async_write_time: INTEGER
  • pool_async_write_time_enum: STRING
  • pool_async_data_read_reqs: INTEGER
  • pool_async_data_read_reqs_enum: STRING
  • pool_total_reads: INTEGER
  • pool_total_reads_enum: STRING
  • pool_hit_ratio: INTEGER
  • pool_hit_ratio_enum: STRING
  • avg_pool_read_time: INTEGER
  • avg_pool_read_time_enum: STRING
  • pool_total_writes: INTEGER
  • pool_total_writes_enum: STRING
(Continued on the next page.)
ITM_KUDBUFFERPOOL00
  • avg_pool_write_time: INTEGER
  • avg_pool_write_time_enum: STRING
  • pool_sync_data_reads: INTEGER
  • pool_sync_data_reads_enum: STRING
  • pool_sync_index_reads: INTEGER
  • pool_sync_index_reads_enum: STRING
  • pool_sync_read: INTEGER
  • pool_sync_read_enum: STRING
  • pool_sync_data_writes: INTEGER
  • pool_sync_data_writes_enum: STRING
  • pool_sync_index_writes: INTEGER
  • pool_sync_index_writes_enum: STRING
  • pool_sync_write: INTEGER
  • pool_sync_write_enum: STRING
  • pool_sync_read_time: INTEGER
  • pool_sync_read_time_enum: STRING
  • avg_sync_read_time: INTEGER
  • avg_sync_read_time_enum: STRING
  • pool_sync_write_time: INTEGER
  • pool_sync_write_time_enum: STRING
  • avg_sync_write_time: INTEGER
  • avg_sync_write_time_enum: STRING
  • avg_data_page_read_per_async_req: INTEGER
  • avg_data_page_read_per_async_req_enum: STRING
  • direct_reads: INTEGER
  • direct_reads_enum: STRING
  • pool_total_reads_k: STRING
  • pool_total_reads_k_enum: STRING
  • pool_total_writes_k: STRING
  • pool_total_writes_k_enum: STRING
  • db_partition: STRING
  • db_partition_enum: STRING
  • direct_writes: INTEGER
  • direct_writes_enum: STRING
  • direct_read_reqs: INTEGER
  • direct_read_reqs_enum: STRING
  • direct_write_reqs: INTEGER
  • direct_write_reqs_enum: STRING
  • direct_read_time: INTEGER
  • direct_read_time_enum: STRING
  • direct_write_time: INTEGER
  • direct_write_time_enum: STRING
  • avg_direct_read_time: INTEGER
  • avg_direct_read_time_enum: STRING
  • avg_direct_write_time: INTEGER
  • avg_direct_write_time_enum: STRING
  • bp_name_u: STRING
  • input_db_alias_u: STRING
  • db_name_u: STRING
  • db_path_u: STRING
(Continued on the next page.)
ITM_KUDBUFFERPOOL00
(Continued)
KUDTABSPACE attribute group
  • node_name: STRING
  • db_name: STRING
  • version: INTEGER
  • version_enum: STRING
  • tablespace_name: STRING
  • tablespace_type: STRING
  • extent_size: INTEGER
  • extent_size_enum: STRING
  • page_size: INTEGER
  • page_size_enum: STRING
  • prefetch_size: INTEGER
  • prefetch_size_enum: STRING
  • num_containers: INTEGER
  • num_containers_enum: STRING
  • container_name: STRING
  • object_id: INTEGER
  • object_id_enum: STRING
  • tablespace_id: INTEGER
  • tablespace_id_enum: STRING
  • total_pages: INTEGER
  • total_pages_enum: STRING
  • usable_pages: INTEGER
  • usable_pages_enum: STRING
  • used_pages: INTEGER
  • used_pages_enum: STRING
  • pending_free_pages: INTEGER
  • pending_free_pages_enum: STRING
  • free_pages: INTEGER
  • free_pages_enum: STRING
  • direct_reads: INTEGER
  • direct_reads_enum: STRING
  • direct_writes: INTEGER
  • direct_writes_enum: STRING
  • direct_read_reqs: INTEGER
  • direct_read_reqs_enum: STRING
  • direct_write_reqs: INTEGER
  • direct_write_reqs_enum: STRING
  • pool_data_writes: INTEGER
  • pool_data_writes_enum: STRING
  • pool_async_data_reads: INTEGER
  • pool_async_data_reads_enum: STRING
  • pool_async_data_writes: INTEGER
  • pool_async_data_writes_enum: STRING
  • pool_async_index_reads: INTEGER
  • pool_async_index_reads_enum: STRING
  • pool_async_index_writes: INTEGER
  • pool_async_index_writes_enum: STRING
  • pool_async_read_time: INTEGER
  • pool_async_read_time_enum: STRING
  • pool_async_write_time: INTEGER
  • pool_async_write_time_enum: STRING
  • pool_data_l_reads: INTEGER
  • pool_data_l_reads_enum: STRING
  • pool_data_from_estore: INTEGER
  • pool_data_from_estore_enum: STRING
(Continued on the next page.)
ITM_KUDTABSPACE
  • pool_data_to_estore: INTEGER
  • pool_data_to_estore_enum: STRING
  • pool_data_p_reads: INTEGER
  • pool_data_p_reads_enum: STRING
  • pool_index_l_reads: INTEGER
  • pool_index_l_reads_enum: STRING
  • pool_index_from_estore: INTEGER
  • pool_index_from_estore_enum: STRING
  • pool_index_to_estore: INTEGER
  • pool_index_to_estore_enum: STRING
  • pool_index_p_reads: INTEGER
  • pool_index_p_reads_enum: STRING
  • pool_index_writes: INTEGER
  • pool_index_writes_enum: STRING
  • direct_write_time: INTEGER
  • direct_write_time_enum: STRING
  • direct_read_time: INTEGER
  • direct_read_time_enum: STRING
  • files_closed: INTEGER
  • files_closed_enum: STRING
  • pool_read_time: INTEGER
  • pool_read_time_enum: STRING
  • pool_write_time: INTEGER
  • pool_write_time_enum: STRING
  • pool_async_data_read_reqs: INTEGER
  • pool_async_data_read_reqs_enum: STRING
  • pool_data_reads: INTEGER
  • pool_data_reads_enum: STRING
  • pool_sync_idx_writes: INTEGER
  • pool_sync_idx_writes_enum: STRING
  • pool_sync_reads: INTEGER
  • pool_sync_reads_enum: STRING
  • pool_sync_writes: INTEGER
  • pool_sync_writes_enum: STRING
  • avg_sect_read: INTEGER
  • avg_sect_read_enum: STRING
  • avg_sect_written: INTEGER
  • avg_sect_written_enum: STRING
  • avg_direct_read_time: INTEGER
  • avg_direct_read_time_enum: STRING
  • avg_direct_write_time: INTEGER
  • avg_direct_write_time_enum: STRING
  • avg_pool_io_time: INTEGER
  • avg_pool_io_time_enum: STRING
  • avg_pool_read_time: INTEGER
  • avg_pool_read_time_enum: STRING
  • avg_pool_write_time: INTEGER
  • avg_pool_write_time_enum: STRING
  • avg_sync_data_read_time: INTEGER
  • avg_sync_data_read_time_enum: STRING
  • avg_sync_data_write_time: INTEGER
  • avg_sync_data_write_time_enum: STRING
(Continued on the next page.)
ITM_KUDTABSPACE
(Continued)
  • avg_sync_io_time: INTEGER
  • avg_sync_io_time_enum: STRING
  • pool_io_per_sec: INTEGER
  • pool_io_per_sec_enum: STRING
  • estore_rw_ratio: INTEGER
  • estore_rw_ratio_enum: STRING
  • pool_hit_pct: INTEGER
  • pool_hit_pct_enum: STRING
  • pool_idx_hit_pct_for_int: INTEGER
  • pool_idx_hit_pct_for_int_enum: STRING
  • prefetch_pct_for_int: INTEGER
  • prefetch_pct_for_int_enum: STRING
  • total_io_pct: INTEGER
  • total_io_pct_enum: STRING
  • prefetch_reqs_for_int: INTEGER
  • prefetch_reqs_for_int_enum: STRING
  • sync_read_time: INTEGER
  • sync_read_time_enum: STRING
  • sync_write_time: INTEGER
  • sync_write_time_enum: STRING
  • total_direct_io_time: INTEGER
  • total_direct_io_time_enum: STRING
  • total_pool_io_time: INTEGER
  • total_pool_io_time_enum: STRING
  • total_pool_p_read_time: INTEGER
  • total_pool_p_read_time_enum: STRING
  • total_pool_p_write_time: INTEGER
  • total_pool_p_write_time_enum: STRING
  • total_sync_io: INTEGER
  • total_sync_io_enum: STRING
  • total_sync_io_time: INTEGER
  • total_sync_io_time_enum: STRING
  • pool_async_index_read_reqs: INTEGER
  • pool_async_index_read_reqs_enum: STRING
  • space_used_dms_table_pct: INTEGER
  • space_used_dms_table_pct_enum: STRING
  • space_used_sms_table: INTEGER
  • space_used_sms_table_enum: STRING
  • tbsp_status: INTEGER
  • tbsp_status_enum: STRING
  • db_name_u: STRING
  • tablespace_name_u: STRING
  • container_name_u: STRING
  • space_used_sms_table_mb: STRING
  • space_used_sms_table_mb_enum: STRING
  • db_partition: STRING
  • db_partition_enum: STRING
  • pool_hit_ratio_pct_for_int: INTEGER
  • pool_hit_ratio_pct_for_int_enum: STRING
  • instance_name_u: STRING
  • tbsp_state_name: STRING
ITM_KUDTABSPACE
(Continued)
KUDDBASEGROUP01 attribute group
  • db_name: STRING
  • app_ctl_heap_sz: INTEGER
  • applheapsz: INTEGER
  • applheapsz_enum: STRING
  • avg_appls: INTEGER
  • avg_appls_enum: STRING
  • buffpage: INTEGER
  • buffpage_enum: STRING
  • catalogcache_sz: INTEGER
  • catalogcache_sz_enum: STRING
  • chngpgs_thresh: INTEGER
  • chngpgs_thresh_enum: STRING
  • dbheap: INTEGER
  • dbheap_enum: STRING
  • locklist: INTEGER
  • locklist_enum: STRING
  • logbufsz: INTEGER
  • logbufsz_enum: STRING
  • logprimary: INTEGER
  • logprimary_enum: STRING
  • maxappls: INTEGER
  • maxappls_enum: STRING
  • maxlocks: INTEGER
  • maxlocks_enum: STRING
  • mincommit: INTEGER
  • mincommit_enum: STRING
  • newlogpath: STRING
  • num_iocleaners: INTEGER
  • num_iocleaners_enum: STRING
  • pckcachesz: INTEGER
  • pckcachesz_enum: STRING
  • restore_pending: INTEGER
  • restore_pending_enum: STRING
  • seqdetect: INTEGER
  • seqdetect_enum: STRING
  • sortheap: INTEGER
  • sortheap_enum: STRING
  • appls_in_db2: INTEGER
  • appls_in_db2_enum: STRING
  • deadlocks_for_int: INTEGER
  • deadlocks_for_int_enum: STRING
  • int_auto_rebinds: INTEGER
  • int_auto_rebinds_enum: STRING
  • int_commits: INTEGER
  • int_commits_enum: STRING
  • int_rows_deleted: INTEGER
  • int_rows_deleted_enum: STRING
  • int_rows_inserted: INTEGER
  • int_rows_inserted_enum: STRING
  • int_rows_updated: INTEGER
  • int_rows_updated_enum: STRING
  • log_io_for_int: INTEGER
  • log_io_for_int_enum: STRING
  • cur_cons_pct: INTEGER
  • cur_cons_pct_enum: STRING
(Continued on the next page.)
ITM_KUDDBASEGROUP01
  • lock_list_in_use_pct: INTEGER
  • lock_list_in_use_pct_enum: STRING
  • sec_log_used_pct: INTEGER
  • sec_log_used_pct_enum: STRING
  • total_log_used: INTEGER
  • total_log_used_enum: STRING
  • pri_log_used_pct: INTEGER
  • pri_log_used_pct_enum: STRING
  • page_cleans_for_interval: INTEGER
  • page_cleans_for_interval_enum: STRING
  • pages_per_prefetch_for_int: INTEGER
  • pages_per_prefetch_for_int_enum: STRING
  • tot_sync_io: INTEGER
  • tot_sync_io_enum: STRING
  • pool_sync_index_reads: INTEGER
  • pool_sync_index_reads_enum: STRING
  • avg_pool_async_data_reads: INTEGER
  • avg_pool_async_data_reads_enum: STRING
  • avg_pool_async_data_writes: INTEGER
  • avg_pool_async_data_writes_enum: STRING
  • avg_pool_writes_per_read: INTEGER
  • avg_pool_writes_per_read_enum: STRING
  • avg_sect_read_per_direct_read: INTEGER
  • avg_sect_read_per_direct_read_enum: STRING
  • avg_sect_written_per_direct_write: INTEGER
  • avg_sect_written_per_direct_write_enum: STRING
  • avg_direct_read_time: INTEGER
  • avg_direct_read_time_enum: STRING
  • avg_direct_write_time: INTEGER
  • avg_direct_write_time_enum: STRING
  • avg_pool_io_time: INTEGER
  • avg_pool_io_time_enum: STRING
  • avg_sync_io_time: INTEGER
  • avg_sync_io_time_enum: STRING
  • avg_pages_per_cleaner_for_int: INTEGER
  • avg_pages_per_cleaner_for_int_enum: STRING
  • pool_io_per_sec: INTEGER
  • pool_io_per_sec_enum: STRING
  • estore_rw_ratio_for_int: INTEGER
  • estore_rw_ratio_for_int_enum: STRING
  • pool_hit_ratio_pct_for_int: INTEGER
  • pool_hit_ratio_pct_for_int_enum: STRING
  • pool_hit_ratio_index_pct_for_int: INTEGER
  • pool_hit_ratio_index_pct_for_int_enum: STRING
(Continued on the next page)
ITM_KUDDBASEGROUP01
(Continued)
  • tot_direct_io_time: INTEGER
  • tot_direct_io_time_enum: STRING
  • tot_pool_phys_io: INTEGER
  • tot_pool_phys_io_enum: STRING
  • tot_pool_phys_read: INTEGER
  • tot_pool_phys_read_enum: STRING
  • tot_pool_phys_write: INTEGER
  • tot_pool_phys_write_enum: STRING
  • tot_sync_io_time: INTEGER
  • tot_sync_io_time_enum: STRING
  • db_cap_err: INTEGER
  • db_cap_err_enum: STRING
  • db_cap_lag: INTEGER
  • db_cap_lag_enum: STRING
  • db_cap_prun: INTEGER
  • db_cap_prun_enum: STRING
  • avg_locks_held: INTEGER
  • avg_locks_held_enum: STRING
  • lock_waits_for_int: INTEGER
  • lock_waits_for_int_enum: STRING
  • lock_waits_pct: INTEGER
  • lock_waits_pct_enum: STRING
  • int_deadlock_rollbacks_pct_for_int: INTEGER
  • int_deadlock_rollbacks_pct_for_int_enum: STRING
  • db_tablespaces: INTEGER
  • db_tablespaces_enum: STRING
  • event_monitors: INTEGER
  • event_monitors_enum: STRING
  • invalid_triggers: INTEGER
  • invalid_triggers_enum: STRING
  • system_tablespaces: INTEGER
  • system_tablespaces_enum: STRING
  • tables: INTEGER
  • tables_enum: STRING
  • tablespaces: INTEGER
  • tablespaces_enum: STRING
  • tablespaces_long_data: INTEGER
  • tablespaces_long_data_enum: STRING
  • triggers: INTEGER
  • triggers_enum: STRING
  • views: INTEGER
  • views_enum: STRING
  • user_indexes: INTEGER
  • user_indexes_enum: STRING
  • commit_stmts_per_sec: INTEGER
  • commit_stmts_per_sec_enum: STRING
  • ddl_sql_pct_for_int: INTEGER
  • ddl_sql_pct_for_int_enum: STRING
  • select_sql_pct_for_int: INTEGER
  • select_sql_pct_for_int_enum: STRING
  • uid_sql_pct_for_int: INTEGER
  • uid_sql_pct_for_int_enum: STRING
(Continued on the next page)
ITM_KUDDBASEGROUP01
(Continued)
  • invalid_pkgs: INTEGER
  • invalid_pkgs_enum: STRING
  • invalid_sys_pkgs: INTEGER
  • invalid_sys_pkgs_enum: STRING
  • pri_log_used_top: INTEGER
  • pri_log_used_top_enum: STRING
  • int_deadlock_rollbacks_pct: INTEGER
  • int_deadlock_rollbacks_pct_enum: STRING
  • num_ioservers: INTEGER
  • num_ioservers_enum: STRING
  • snapshot_time: STRING
  • node_name: STRING
  • db_name_u: STRING
  • newlogpath_u: STRING
  • snapshot_time_timestamp: STRING
  • db_conn_time_timestamp: STRING
  • last_backup_timestamp: STRING
  • lock_list_in_use_kb: INTEGER
  • lock_list_in_use_kb_enum: STRING
  • pool_total_reads_k: INTEGER
  • pool_total_reads_k_enum: STRING
  • pool_total_writes_k: INTEGER
  • pool_total_writes_k_enum: STRING
  • sec_log_used_top_mb: INTEGER
  • sec_log_used_top_mb_enum: STRING
  • tot_log_used_top_mb: INTEGER
  • tot_log_used_top_mb_enum: STRING
  • total_log_used_mb: INTEGER
  • total_log_used_mb_enum: STRING
  • db_partition: STRING
  • db_partition_enum: STRING
  • instance_name_u: STRING
  • lock_timeouts_for_int: INTEGER
  • lock_timeouts_for_int_enum: STRING
  • rollback_rate_for_int: INTEGER
  • rollback_rate_for_int_enum: STRING
  • sql_stmts_rate_for_int: INTEGER
  • sql_stmts_rate_for_int_enum: STRING
  • days_since_last_backup: INTEGER
  • days_since_last_backup_enum: STRING
  • sort_overflows_pct_for_int: INTEGER
  • sort_overflows_pct_for_int_enum: STRING
  • failed_sql_stmts_pct_for_int: INTEGER
  • failed_sql_stmts_pct_for_int_enum: STRING
  • avg_lock_escal_con_for_int: INTEGER
  • avg_lock_escal_con_for_int_enum: STRING
  • deadlock_rollbacks_pct: INTEGER
  • deadlock_rollbacks_pct_enum: STRING
  • lock_escalation_for_int: INTEGER
  • lock_escalation_for_int_enum: STRING
  • pri_log_used_top_mb: INTEGER;
  • pri_log_used_top_mb_enum: STRING;
ITM_KUDDBASEGROUP01
(Continued)
KUDDB2APPLGROUP01 attribute group
  • snapshot_time: STRING
  • appl_name: STRING
  • db_name: STRING
  • agents_stolen: INTEGER
  • agents_stolen_enum: STRING
  • app_work_load: INTEGER
  • app_work_load_enum: STRING
  • associated_agents_top: INTEGER
  • avg_sect_read_per_direct_read: INTEGER
  • avg_sect_read_per_direct_read_enum: STRING
  • avg_sect_written_per_direct_read: INTEGER
  • avg_sect_written_per_direct_read_enum: STRING
  • pool_index_hit_ratio_pct_for_int: INTEGER
  • pool_index_hit_ratio_pct_for_int_enum: STRING
  • pkg_cache_hit_pct: INTEGER
  • pkg_cache_hit_pct_enum: STRING
  • tot_pool_io_time: INTEGER
  • tot_pool_io_time_enum: STRING
  • lock_escalation_for_int: INTEGER
  • lock_escalation_for_int_enum: STRING
  • deadlocks_for_int: INTEGER
  • deadlocks_for_int_enum: STRING
  • stmts_sorts: INTEGER
  • stmts_sorts_enum: STRING
  • appl_section_inserts: INTEGER
  • appl_section_inserts_enum: STRING
  • binds_precompiles: INTEGER
  • binds_precompiles_enum: STRING
  • ddl_sql_pct_for_int: INTEGER
  • ddl_sql_pct_for_int_enum: STRING
  • uid_sql_pct_for_int: INTEGER
  • uid_sql_pct_for_int_enum: STRING
  • sql_reqs_since_commit: INTEGER
  • sql_reqs_since_commit_enum: STRING
  • node_name: STRING
  • appl_name_u: STRING
  • db_name_u: STRING
  • snapshot_time_timestamp: STRING
  • lock_wait_start_time_timestamp: STRING
  • appl_con_time_timestamp: STRING
  • conn_complete_time_timestamp: STRING
  • stmt_start_timestamp: STRING
  • stmt_stop_timestamp: STRING
  • prev_uow_stop_time_timestamp: STRING
  • uow_start_time_timestamp: STRING
  • uow_stop_time_timestamp: STRING
  • pool_total_reads_k: INTEGER
  • pool_total_reads_k_enum: STRING
(Continued on the next page)
ITM_KUDDB2APPLGROUP01
  • pool_total_writes_k: INTEGER
  • pool_total_writes_k_enum: STRING
  • uow_log_space_used_mb: INTEGER
  • uow_log_space_used_mb_enum: STRING
  • appl_id_u: STRING
  • db_partition: STRING
  • db_partition_enum: STRING
  • instance_name_u: STRING
  • appl_section_lookups: INTEGER
  • appl_section_lookups_enum: STRING
  • agent_usr_cpu_time: REAL
  • agent_usr_cpu_time_enum: STRING
  • agent_sys_cpu_time: REAL
  • agent_sys_cpu_time_enum: STRING
  • lock_list_in_use_pct: INTEGER
  • lock_list_in_use_pct_enum: STRING
  • lock_wait_time_for_int: INTEGER
  • lock_wait_time_for_int_enum: STRING
  • open_curs: INTEGER
  • open_curs_enum: STRING
  • open_curs_blk: INTEGER
  • open_curs_blk_enum: STRING
  • pool_hit_ratio_pct_for_int: INTEGER
  • pool_hit_ratio_pct_for_int_enum: STRING
  • total_sorts_for_int: INTEGER
  • total_sorts_for_int_enum: STRING
ITM_KUDDB2APPLGROUP01
(Continued)
KUDDB2APPLGROUP00_U attribute group
  • node_name: STRING
  • agent_id: INTEGER
  • agent_id_enum: STRING
  • appl_id: STRING
  • appl_status: STRING
  • appl_status_enum: STRING
  • snapshot_time: STRING
  • appl_name_u: STRING
  • auth_id_u: STRING
  • client_prdid: STRING
  • db_name_u: STRING
  • execution_id_u: STRING
  • corr_token_u: STRING
  • client_platform: STRING
  • client_platform_enum: STRING
  • client_protocol: STRING
  • client_protocol_enum: STRING
  • locks_held: INTEGER
  • locks_held_enum: STRING
  • lock_waits: INTEGER
  • lock_waits_enum: STRING
  • lock_wait_time: INTEGER
  • lock_wait_time_enum: STRING
  • lock_escals: INTEGER
  • lock_escals_enum: STRING
  • x_lock_escals: INTEGER
  • x_lock_escals_enum: STRING
  • deadlocks: INTEGER
  • deadlocks_enum: STRING
  • uow_lock_wait_time: INTEGER
  • uow_lock_wait_time_enum: STRING
  • lock_timeouts: INTEGER
  • lock_timeouts_enum: STRING
  • avg_lock_waittime: INTEGER
  • avg_lock_waittime_enum: STRING
  • agent_id_holding_lk: INTEGER
  • agent_id_holding_lk_enum: STRING
  • appl_id_holding_lk_u: STRING
  • lock_mode: STRING
  • lock_mode_enum: STRING
  • lock_object_type: STRING
  • lock_object_type_enum: STRING
  • lock_wait_start_time: STRING
  • table_name_u: STRING
  • table_schema_u: STRING
  • tablespace_name_u: STRING
  • pool_data_l_reads: INTEGER
  • pool_data_l_reads_enum: STRING
  • pool_data_p_reads: INTEGER
  • pool_data_p_reads_enum: STRING
  • pool_data_writes: INTEGER
  • pool_data_writes_enum: STRING
  • pool_index_l_reads: INTEGER
  • pool_index_l_reads_enum: STRING
(Continued on the next page.)
ITM_KUDDB2APPLGROUP00_U
  • pool_index_p_reads: INTEGER
  • pool_index_p_reads_enum: STRING
  • pool_index_writes: INTEGER
  • pool_index_writes_enum: STRING
  • pool_read_time: INTEGER
  • pool_read_time_enum: STRING
  • pool_write_time: INTEGER
  • pool_write_time_enum: STRING
  • pool_data_to_estore: INTEGER
  • pool_data_to_estore_enum: STRING
  • pool_index_to_estore: INTEGER
  • pool_index_to_estore_enum: STRING
  • pool_index_from_estore: INTEGER
  • pool_index_from_estore_enum: STRING
  • pool_data_from_estore: INTEGER
  • pool_data_from_estore_enum: STRING
  • pool_total_reads: INTEGER
  • pool_total_reads_enum: STRING
  • pool_hit_ratio: INTEGER
  • pool_hit_ratio_enum: STRING
  • avg_pool_read_time: INTEGER
  • avg_pool_read_time_enum: STRING
  • pool_total_writes: INTEGER
  • pool_total_writes_enum: STRING
  • avg_pool_write_time: INTEGER
  • avg_pool_write_time_enum: STRING
  • appl_idle_time: INTEGER
  • appl_idle_time_enum: STRING
  • agent_usr_cpu_time: STRING
  • agent_sys_cpu_time: STRING
  • appl_con_time: STRING
  • conn_complete_time: STRING
  • prefetch_wait_time: INTEGER
  • prefetch_wait_time_enum: STRING
  • direct_reads: INTEGER
  • direct_reads_enum: STRING
  • direct_writes: INTEGER
  • direct_writes_enum: STRING
  • direct_read_reqs: INTEGER
  • direct_read_reqs_enum: STRING
  • direct_write_reqs: INTEGER
  • direct_write_reqs_enum: STRING
  • direct_read_time: INTEGER
  • direct_read_time_enum: STRING
  • direct_write_time: INTEGER
  • direct_write_time_enum: STRING
  • stmt_type: STRING
  • stmt_type_enum: STRING
  • stmt_operation: STRING
  • stmt_operation_enum: STRING
  • cursor_name_u: STRING
  • creator_u: STRING
  • package_name_u: STRING
  • total_sql_stmt: INTEGER
  • total_sql_stmt_enum: STRING
(Continued on the next page.)
ITM_KUDDB2APPLGROUP00_U
(Continued)
  • failed_sql_stmts: INTEGER
  • failed_sql_stmts_enum: STRING
  • int_rollbacks: INTEGER
  • int_rollbacks_enum: STRING
  • int_deadlock_rollbacks: INTEGER
  • int_deadlock_rollbacks_enum: STRING
  • rollback_sql_stmts: INTEGER
  • rollback_sql_stmts_enum: STRING
  • failed_sql_stmts_pct: INTEGER
  • failed_sql_stmts_pct_enum: STRING
  • total_sorts: INTEGER
  • total_sorts_enum: STRING
  • total_sort_time: INTEGER
  • total_sort_time_enum: STRING
  • sort_overflows: INTEGER
  • sort_overflows_enum: STRING
  • avg_sort_time: INTEGER
  • avg_sort_time_enum: STRING
  • sort_overflows_pct: INTEGER
  • sort_overflows_pct_enum: STRING
  • commit_sql_stmts: INTEGER
  • commit_sql_stmts_enum: STRING
  • dynamic_sql_stmts: INTEGER
  • dynamic_sql_stmts_enum: STRING
  • static_sql_stmts: INTEGER
  • static_sql_stmts_enum: STRING
  • select_sql_stmts: INTEGER
  • select_sql_stmts_enum: STRING
  • ddl_sql_stmts: INTEGER
  • ddl_sql_stmts_enum: STRING
  • uid_sql_stmts: INTEGER
  • uid_sql_stmts_enum: STRING
  • binds_precompiles: INTEGER
  • binds_precompiles_enum: STRING
  • section_number: INTEGER
  • section_number_enum: STRING
  • stmt_start: STRING
  • stmt_stop: STRING
  • uow_log_space_used: INTEGER
  • uow_log_space_used_enum: STRING
  • uow_comp_status: STRING
  • uow_comp_status_enum: STRING
  • prev_uow_stop_time: STRING
  • uow_start_time: STRING
  • uow_stop_time: STRING
  • int_auto_rebinds: INTEGER
  • int_auto_rebinds_enum: STRING
  • int_rows_deleted: INTEGER
  • int_rows_deleted_enum: STRING
  • int_rows_updated: INTEGER
  • int_rows_updated_enum: STRING
  • int_commits: INTEGER
  • int_commits_enum: STRING
  • int_rows_inserted: INTEGER
  • int_rows_inserted_enum: STRING
(Continued on the next page.)
ITM_KUDDB2APPLGROUP00_U
(Continued)
  • rows_deleted: INTEGER
  • rows_deleted_enum: STRING
  • rows_inserted: INTEGER
  • rows_inserted_enum: STRING
  • rows_updated: INTEGER
  • rows_updated_enum: STRING
  • rows_selected: INTEGER
  • rows_selected_enum: STRING
  • rows_read: INTEGER
  • rows_read_enum: STRING
  • rows_written: INTEGER
  • rows_written_enum: STRING
  • open_loc_curs: INTEGER
  • open_loc_curs_enum: STRING
  • open_loc_curs_blk: INTEGER
  • open_loc_curs_blk_enum: STRING
  • open_rem_curs: INTEGER
  • open_rem_curs_enum: STRING
  • open_rem_curs_blk: INTEGER
  • open_rem_curs_blk_enum: STRING
  • rej_curs_blk: INTEGER
  • rej_curs_blk_enum: STRING
  • acc_curs_blk: INTEGER
  • acc_curs_blk_enum: STRING
  • client_pid: INTEGER
  • client_pid_enum: STRING
  • country_code: INTEGER
  • country_code_enum: STRING
  • pkg_cache_lookups: INTEGER
  • pkg_cache_lookups_enum: STRING
  • pkg_cache_inserts: INTEGER
  • pkg_cache_inserts_enum: STRING
  • pkg_cache_hit_ratio: INTEGER
  • pkg_cache_hit_ratio_enum: STRING
  • cat_cache_lookups: INTEGER
  • cat_cache_lookups_enum: STRING
  • cat_cache_inserts: INTEGER
  • cat_cache_inserts_enum: STRING
  • cat_cache_overflows: INTEGER
  • cat_cache_overflows_enum: STRING
  • cat_cache_heap_full: INTEGER
  • cat_cache_heap_full_enum: STRING
  • cat_cache_hit_ratio: INTEGER
  • cat_cache_hit_ratio_enum: STRING
  • total_hash_joins: INTEGER
  • total_hash_joins_enum: STRING
  • total_hash_loops: INTEGER
  • total_hash_loops_enum: STRING
  • hash_join_overflows: INTEGER
  • hash_join_overflows_enum: STRING
  • hash_join_small_overflows: INTEGER
  • hash_join_small_overflows_enum: STRING
  • query_cost_estimate: INTEGER
  • query_cost_estimate_enum: STRING
(Continued on the next page.)
ITM_KUDDB2APPLGROUP00_U
(Continued)
  • query_card_estimate: INTEGER
  • query_card_estimate_enum: STRING
  • degree_parallelism: INTEGER
  • degree_parallelism_enum: STRING
  • stmt_text_u: STRING
  • db_partition: STRING
  • db_partition_ENUM: STRING
ITM_KUDDB2APPLGROUP00_U
(Continued)
KUD_DB2_Apply_Program attribute group
  • node_name: STRING
  • instance_name_u: STRING
  • db_name_u: STRING
  • apply_qualifier: STRING
  • apply_id: STRING
  • apply_status: INTEGER
  • apply_status_enum: STRING
  • tot_apply_sub_fail: INTEGER
  • tot_apply_sub_fail_enum: STRING
  • tot_apply_sub_lag: INTEGER
  • tot_apply_sub_lag_enum: STRING
  • snapshot_time_timestamp: STRING
  • tot_apply_sub_fail_64: REAL
  • tot_apply_sub_fail_64_enum: STRING
  • tot_apply_sub_lag_64: REAL
  • tot_apply_sub_lag_64_enum: STRING
KUD_DB2_Apply_Program
KUD_DB2_Table attribute group
  • node_name: STRING
  • instance_name_u: STRING
  • db_name_u: STRING
  • db_partition: STRING
  • db_partition_enum: STRING
  • table_name_u: STRING
  • table_schema_u: STRING
  • reorg_needed: STRING
  • reorg_needed_enum: STRING
  • rows_read_rate_for_int: INTEGER
  • rows_read_rate_for_int_enum: STRING
  • rows_write_rate_for_int: INTEGER
  • rows_write_rate_for_int_enum: STRING
  • snapshot_time_timestamp: STRING
KUD_DB2_Table
KUD_DB2_DCS_Database attribute group
  • node_name: STRING
  • instance_name_u: STRING
  • db_name_u: STRING
  • db_partition: STRING
  • db_partition_enum: STRING
  • gw_cur_cons: INTEGER
  • gw_cur_cons_enum: STRING
  • gw_cons_wait_host: INTEGER
  • gw_cons_wait_host_enum: STRING
  • gw_comm_errors_for_int: INTEGER
  • gw_comm_errors_for_int_enum: STRING
  • recent_con_rsp_time: REAL
  • recent_con_rsp_time_enum: STRING
  • network_time_per_stmt: INTEGER
  • network_time_per_stmt_enum: STRING
  • host_throughput_for_int: INTEGER
  • host_throughput_for_int_enum: STRING
  • host_time_per_stmt_for_int: INTEGER
  • host_time_per_stmt_for_int_enum: STRING
  • time_per_stmt: INTEGER
  • time_per_stmt_enum: STRING
  • snapshot_time_timestamp: STRING
  • gw_cur_cons_64: REAL
  • gw_cur_cons_64_enum: STRING
  • gw_cons_wait_host_64: REAL
  • gw_cons_wait_host_64_enum: STRING
  • gw_comm_errors_for_int_64: REAL
  • gw_comm_errors_for_int_64_enum: STRING
  • recent_con_rsp_time_64: REAL
  • recent_con_rsp_time_64_enum: STRING
  • network_time_per_stmt_64: REAL
  • network_time_per_stmt_64_enum: STRING
  • host_throughput_for_int_64: REAL
  • host_throughput_for_int_64_enum: STRING
  • host_time_per_stmt_for_int_64: REAL
  • host_time_per_stmt_for_int_64_enum: STRING
  • time_per_stmt_64: REAL
  • time_per_stmt_64_enum: STRING
KUD_DB2_DCS_Database
KUD_DB2_Apply_Subscription attribute group
  • node_name: STRING
  • instance_name_u: STRING
  • db_name_target: STRING
  • target_table: STRING
  • target_owner: STRING
  • apply_num_reqs_refresh: INTEGER
  • apply_num_reqs_refresh_enum: STRING
  • apply_sub_lag_time: INTEGER
  • apply_sub_lag_time_enum: STRING
  • apply_sub_status: INTEGER
  • apply_sub_status_enum: STRING
  • apply_id: STRING
  • snapshot_time_timestamp: STRING
  • apply_num_reqs_refresh_64: REAL
  • apply_num_reqs_refresh_64_enum: STRING
  • apply_sub_lag_time_64: REAL
  • apply_sub_lag_time_64_enum: STRING
KUD_DB2_Apply_Subscription
KUD_DB2_Diagnostic_Messages attribute group
  • node_name: STRING
  • msgid: STRING
  • msgtext: STRING
  • timestamp: STRING
  • timezone: INTEGER
  • dbname: STRING
ITM_KUD_DB2_Diagnostic_Messages
KUD_DB2_System_Resources attribute group
  • node_name: STRING
  • host_name: STRING
  • os_name: STRING
  • os_version: STRING
  • total_physical_mem: INTEGER
  • total_physical_mem_enum: STRING
  • free_physical_mem: INTEGER
  • free_physical_mem_enum: STRING
  • used_physical_mem_pct: INTEGER
  • used_physical_mem_pct_enum: STRING
  • total_swap_mem: INTEGER
  • total_swap_mem_enum: STRING
  • free_swap_mem: INTEGER
  • free_swap_mem_enum: STRING
  • used_swap_mem_pct: INTEGER
  • used_swap_mem_pct_enum: STRING
  • total_virtual_mem: INTEGER
  • total_virtual_mem_enum: STRING
  • free_virtual_mem: INTEGER
  • free_physical_mem_enum: STRING
  • free_virtual_mem_enum: STRING
  • used_virtual_mem_pct: INTEGER
  • used_virtual_mem_pct_enum: STRING
  • cpu_usage_pct: INTEGER
  • cpu_usage_pct_enum: STRING
  • total_physical_mem_64: REAL
  • total_physical_mem_64_enum: STRING
  • free_physical_mem_64: REAL
  • free_physical_mem_64_enum: STRING
  • total_swap_mem_64: REAL
  • total_swap_mem_64_enum: STRING
  • free_swap_mem_64: REAL
  • free_swap_mem_64_enum: STRING
  • total_virtual_mem_64: REAL
  • total_virtual_mem_64_enum: STRING
  • free_virtual_mem_64: REAL
  • free_virtual_mem_64_enum: STRING
  • used_physical_mem_percent: REAL
  • used_physical_mem_percent_enum: STRING
  • used_swap_mem_percent: REAL
  • used_swap_mem_percent_enum: STRING
  • used_virtual_mem_percent: REAL
  • used_virtual_mem_percent_enum: STRING
ITM_KUD_DB2_System_Resources
KUD_DB2_IPADDR_TABLE attribute group
  • node_name: STRING
  • server_name: STRING
  • ip_address: STRING
  • ip_type: INTEGER
  • ip_type_enum: STRING
  • listener_port: INTEGER
  • listener_port_enum: STRING
  • db_partition: STRING
  • db_partition_enum: STRING
ITM_KUD_DB2_IPADDR_TABLE
KUD_DB2_System_Overview attribute group
  • node_name: STRING
  • db2_status: STRING
  • db2_status_enum: STRING
  • last_reset: STRING
  • snapshot_time: STRING
  • prdid: STRING
  • instance_name: STRING
  • instance_name_enum: STRING
  • version: STRING
  • version_enum: STRING
  • server_db2_type: STRING
  • server_db2_type_enum: STRING
  • sort_heap_allocated: REAL
  • sort_heap_allocated_enum: STRING
  • post_threshold_sorts: REAL
  • post_threshold_sorts_enum: STRING
  • piped_sorts_requested: REAL
  • piped_sorts_requested_enum: STRING
  • piped_sorts_accepted: REAL
  • piped_sorts_accepted_enum: STRING
  • piped_sorts_accepted_pct: REAL
  • piped_sorts_accepted_pct_enum: STRING
  • rem_cons_in: REAL
  • rem_cons_in_enum: STRING
  • rem_cons_in_exec: REAL
  • rem_cons_in_exec_enum: STRING
  • local_cons: REAL
  • local_cons_enum: STRING
  • local_cons_in_exec: REAL
  • local_cons_in_exec_enum: STRING
  • con_local_dbases: REAL
  • con_local_dbases_enum: STRING
  • agents_registered: REAL
  • agents_registered_enum: STRING
  • agents_waiting_on_token: REAL
  • agents_waiting_on_token_enum: STRING
  • agents_waiting_on_token_pct: REAL
  • agents_waiting_on_token_pct_enum: STRING
  • agents_from_pool: REAL
  • agents_from_pool_enum: STRING
  • agents_created_empty_pool: REAL
  • agents_created_empty_pool_enum: STRING
  • agents_created_empty_pool_ratio: REAL
  • agents_created_empty_pool_ratio_enum: STRING
  • coord_agents_top: REAL
  • coord_agents_top_enum: STRING
  • max_agent_overflows: REAL
  • max_agent_overflows_enum: STRING
  • agents_stolen: REAL
  • agents_stolen_enum: STRING
(Continued on the next page.)
ITM_KUD_DB2_System_Overview
  • agents_registered_top: REAL
  • agents_registered_top_enum: STRING
  • agents_waiting_top: REAL
  • agents_waiting_top_enum: STRING
  • comm_private_mem: REAL
  • comm_private_mem_enum: STRING
  • idle_agents: REAL
  • idle_agents_enum: STRING
  • gw_total_cons: REAL
  • gw_total_cons_enum: STRING
  • gw_cur_cons: REAL
  • gw_cur_cons_enum: STRING
  • gw_cons_wait_host: REAL
  • gw_cons_wait_host_enum: STRING
  • gw_cons_wait_client: REAL
  • gw_cons_wait_client_enum: STRING
  • post_threshold_hash_joins: REAL
  • post_threshold_hash_joins_enum: STRING
  • piped_sort_hit_ratio_pct_for_int: REAL
  • piped_sort_hit_ratio_pct_for_int_enum: STRING
  • agentpri: INTEGER
  • agentpri_enum: STRING
  • aslheapsz: REAL
  • aslheapsz_enum: STRING
  • fcm_num_anchors: REAL
  • fcm_num_anchors_enum: STRING
  • fcm_num_buffers: REAL
  • fcm_num_buffers_enum: STRING
  • fcm_num_connect: REAL
  • fcm_num_connect_enum: STRING
  • fcm_num_rqb: REAL
  • fcm_num_rqb_enum: STRING
  • maxagents: REAL
  • maxagents_enum: STRING
  • max_coordagents: INTEGER
  • max_coordagents_enum: STRING
  • maxcagents: INTEGER
  • maxcagents_enum: STRING
  • mon_heap_sz: INTEGER
  • mon_heap_sz_enum: STRING
  • query_heap_sz: INTEGER
  • query_heap_sz_enum: STRING
  • rqrioblk: INTEGER
  • rqrioblk_enum: STRING
  • piped_sorts_rejected_pct_for_int: REAL
  • piped_sorts_rejected_pct_for_int_enum: STRING
  • sheapthres: REAL
  • sheapthres_enum: STRING
(Continued on the next page.)
ITM_KUD_DB2_System_Overview
(Continued)
  • connection_status: INTEGER
  • connection_status_enum: STRING
  • buff_free: REAL
  • buff_free_enum: STRING
  • ce_free: REAL
  • ce_free_enum: STRING
  • rb_free: REAL
  • rb_free_enum: STRING
  • buff_free_bottom: REAL
  • buff_free_bottom_enum: STRING
  • ce_free_bottom: REAL
  • ce_free_bottom_enum: STRING
  • ma_free_bottom: REAL
  • ma_free_bottom_enum: STRING
  • rb_free_bottom: REAL
  • rb_free_bottom_enum: STRING
  • buf_used_pct: REAL
  • buf_used_pct_enum: STRING
  • rb_used_pct: REAL
  • rb_used_pct_enum: STRING
  • ce_used_pct: REAL
  • ce_used_pct_enum: STRING
  • buff_max_used_pct: REAL
  • buff_max_used_pct_enum: STRING
  • ce_max_used_pct: REAL
  • ce_max_used_pct_enum: STRING
  • ma_max_used_pct: REAL
  • ma_max_used_pct_enum: STRING
  • rb_max_used_pct: REAL
  • rb_max_used_pct_enum: STRING
  • total_buffers_rcvd: REAL
  • total_buffers_rcvd_enum: STRING
  • total_buffers_sent: REAL
  • total_buffers_sent_enum: STRING
  • piped_sorts_rejected_for_int: REAL
  • piped_sorts_rejected_for_int_enum: STRING
  • dbpg_node_status: STRING
  • db2_avail: REAL
  • db2_avail_enum: STRING
  • cons_in_exec_pct: REAL
  • cons_in_exec_pct_enum: STRING
  • db_partition: STRING
  • db_partition_enum: STRING
  • sort_heap_used_pct: REAL
  • sort_heap_used_pct_enum: STRING
  • post_threshold_olap_funcs: REAL
  • post_threshold_olap_funcs_enum: STRING
ITM_KUD_DB2_System_Overview
(Continued)
KUD_DB2_Application00 attribute group
  • node_name: STRING
  • agent_id: INTEGER
  • agent_id_enum: STRING
  • appl_id: STRING
  • appl_status: STRING
  • appl_status_enum: STRING
  • snapshot_time: STRING
  • appl_name: STRING
  • auth_id: STRING
  • client_prdid: STRING
  • db_name: STRING
  • execution_id: STRING
  • corr_token: STRING
  • client_platform: STRING
  • client_platform_enum: STRING
  • client_protocol: STRING
  • client_protocol_enum: STRING
  • locks_held: REAL
  • locks_held_enum: STRING
  • lock_waits: REAL
  • lock_waits_enum: STRING
  • lock_wait_time: REAL
  • lock_wait_time_enum: STRING
  • lock_escals: REAL
  • lock_escals_enum: STRING
  • x_lock_escals: REAL
  • x_lock_escals_enum: STRING
  • deadlocks: REAL
  • deadlocks_enum: STRING
  • uow_lock_wait_time: REAL
  • uow_lock_wait_time_enum: STRING
  • lock_timeouts: REAL
  • lock_timeouts_enum: STRING
  • avg_lock_waittime: REAL
  • avg_lock_waittime_enum: STRING
  • agent_id_holding_lk: INTEGER
  • agent_id_holding_lk_enum: STRING
  • appl_id_holding_lk: STRING
  • lock_mode: STRING
  • lock_mode_enum: STRING
  • lock_object_type: STRING
  • lock_object_type_enum: STRING
  • lock_wait_start_time: STRING
  • table_name: STRING
  • table_schema: STRING
  • tablespace_name: STRING
  • pool_data_l_reads: REAL
  • pool_data_l_reads_enum: STRING
  • pool_data_p_reads: REAL
  • pool_data_p_reads_enum: STRING
  • pool_data_writes: REAL
  • pool_data_writes_enum: STRING
  • pool_index_l_reads: REAL
  • pool_index_l_reads_enum: STRING
(Continued on the next page.)
ITM_KUD_DB2_Application00
  • pool_index_p_reads: REAL
  • pool_index_p_reads_enum: STRING
  • pool_index_writes: REAL
  • pool_index_writes_enum: STRING
  • pool_read_time: REAL
  • pool_read_time_enum: STRING
  • pool_write_time: REAL
  • pool_write_time_enum: STRING
  • pool_data_to_estore: REAL
  • pool_data_to_estore_enum: STRING
  • pool_index_to_estore: REAL
  • pool_index_to_estore_enum: STRING
  • pool_index_from_estore: REAL
  • pool_index_from_estore_enum: STRING
  • pool_data_from_estore: REAL
  • pool_data_from_estore_enum: STRING
  • pool_total_reads: REAL
  • pool_total_reads_enum: STRING
  • pool_hit_ratio: REAL
  • pool_hit_ratio_enum: STRING
  • avg_pool_read_time: REAL
  • avg_pool_read_time_enum: STRING
  • pool_total_writes: REAL
  • pool_total_writes_enum: STRING
  • avg_pool_write_time: REAL
  • avg_pool_write_time_enum: STRING
  • appl_idle_time: REAL
  • appl_idle_time_enum: STRING
  • appl_con_time: STRING
  • conn_complete_time: STRING
  • direct_reads: REAL
  • direct_reads_enum: STRING
  • direct_writes: REAL
  • direct_writes_enum: STRING
  • direct_read_reqs: REAL
  • direct_read_reqs_enum: STRING
  • direct_write_reqs: REAL
  • direct_write_reqs_enum: STRING
  • direct_read_time: REAL
  • direct_read_time_enum: STRING
  • direct_write_time: REAL
  • direct_write_time_enum: STRING
  • stmt_type: STRING
  • stmt_type_enum: STRING
  • stmt_operation: STRING
  • stmt_operation_enum: STRING
  • cursor_name: STRING
  • creator: STRING
  • package_name: STRING
  • total_sql_stmt: REAL
  • total_sql_stmt_enum: STRING
  • failed_sql_stmts: REAL
  • failed_sql_stmts_enum: STRING
  • int_rollbacks: REAL
  • int_rollbacks_enum: STRING
(Continued on the next page.)
ITM_KUD_DB2_Application00
(Continued)
  • int_deadlock_rollbacks: REAL
  • int_deadlock_rollbacks_enum: STRING
  • rollback_sql_stmts: REAL
  • rollback_sql_stmts_enum: STRING
  • failed_sql_stmts_pct: REAL
  • failed_sql_stmts_pct_enum: STRING
  • total_sorts: REAL
  • total_sorts_enum: STRING
  • total_sort_time: REAL
  • total_sort_time_enum: STRING
  • sort_overflows: REAL
  • sort_overflows_enum: STRING
  • avg_sort_time: REAL
  • avg_sort_time_enum: STRING
  • sort_overflows_pct: REAL
  • sort_overflows_pct_enum: STRING
  • commit_sql_stmts: REAL
  • commit_sql_stmts_enum: STRING
  • dynamic_sql_stmts: REAL
  • dynamic_sql_stmts_enum: STRING
  • static_sql_stmts: REAL
  • static_sql_stmts_enum: STRING
  • select_sql_stmts: REAL
  • select_sql_stmts_enum: STRING
  • ddl_sql_stmts: REAL
  • ddl_sql_stmts_enum: STRING
  • uid_sql_stmts: REAL
  • uid_sql_stmts_enum: STRING
  • binds_precompiles: REAL
  • binds_precompiles_enum: STRING
  • int_auto_rebinds: REAL
  • int_auto_rebinds_enum: STRING
  • int_rows_deleted: REAL
  • int_rows_deleted_enum: STRING
  • int_rows_updated: REAL
  • int_rows_updated_enum: STRING
  • int_commits: REAL
  • int_commits_enum: STRING
  • int_rows_inserted: REAL
  • int_rows_inserted_enum: STRING
  • rows_deleted: REAL
  • rows_deleted_enum: STRING
  • rows_inserted: REAL
  • rows_inserted_enum: STRING
  • rows_updated: REAL
  • rows_updated_enum: STRING
  • rows_selected: REAL
  • rows_selected_enum: STRING
  • rows_read: REAL
  • rows_read_enum: STRING
  • rows_written: REAL
  • rows_written_enum: STRING
  • open_loc_curs: REAL
  • open_loc_curs_enum: STRING
(Continued on the next page.)
ITM_KUD_DB2_Application00
(Continued)
  • open_loc_curs_blk: REAL
  • open_loc_curs_blk_enum: STRING
  • open_rem_curs: REAL
  • open_rem_curs_enum: STRING
  • open_rem_curs_blk: REAL
  • open_rem_curs_blk_enum: STRING
  • rej_curs_blk: REAL
  • rej_curs_blk_enum: STRING
  • acc_curs_blk: REAL
  • acc_curs_blk_enum: STRING
  • client_pid: INTEGER
  • client_pid_enum: STRING
  • country_code: INTEGER
  • country_code_enum: STRING
  • pkg_cache_lookups: REAL
  • pkg_cache_lookups_enum: STRING
  • pkg_cache_inserts: REAL
  • pkg_cache_inserts_enum: STRING
  • pkg_cache_hit_ratio: REAL
  • pkg_cache_hit_ratio_enum: STRING
  • cat_cache_lookups: REAL
  • cat_cache_lookups_enum: STRING
  • cat_cache_inserts: REAL
  • cat_cache_inserts_enum: STRING
  • cat_cache_overflows: REAL
  • cat_cache_overflows_enum: STRING
  • cat_cache_heap_full: REAL
  • cat_cache_heap_full_enum: STRING
  • cat_cache_hit_ratio: REAL
  • cat_cache_hit_ratio_enum: STRING
  • total_hash_joins: REAL
  • total_hash_joins_enum: STRING
  • total_hash_loops: REAL
  • total_hash_loops_enum: STRING
  • hash_join_overflows: REAL
  • hash_join_overflows_enum: STRING
  • hash_join_small_overflows: REAL
  • hash_join_small_overflows_enum: STRING
  • query_cost_estimate: REAL
  • query_cost_estimate_enum: STRING
  • query_card_estimate: REAL
  • query_card_estimate_enum: STRING
  • degree_parallelism: REAL
  • degree_parallelism_enum: STRING
  • stmt_text: STRING
  • db_partition: STRING
  • db_partition_enum: STRING
ITM_KUD_DB2_Application00
(Continued)
KUD_DB2_Application01 attribute group
  • snapshot_time: STRING
  • appl_name: STRING
  • db_name: STRING
  • agents_stolen: REAL
  • agents_stolen_enum: STRING
  • app_work_load: REAL
  • app_work_load_enum: STRING
  • associated_agents_top: REAL
  • associated_agents_top_enum: STRING
  • avg_sect_read_per_direct_read: REAL
  • avg_sect_read_per_direct_read_enum: STRING
  • avg_sect_written_per_direct_write: REAL
  • avg_sect_written_per_direct_write_enum: STRING
  • pool_index_hit_ratio_pct_for_int: REAL
  • pool_index_hit_ratio_pct_for_int_enum: STRING
  • pkg_cache_hit_pct: REAL
  • pkg_cache_hit_pct_enum: STRING
  • tot_pool_io_time: REAL
  • tot_pool_io_time_enum: STRING
  • lock_escalation_for_int: REAL
  • lock_escalation_for_int_enum: STRING
  • deadlocks_for_int: REAL
  • deadlocks_for_int_enum: STRING
  • stmts_sorts: REAL
  • stmts_sorts_enum: STRING
  • appl_section_inserts: REAL
  • appl_section_inserts_enum: STRING
  • ddl_sql_pct_for_int: REAL
  • ddl_sql_pct_for_int_enum: STRING
  • uid_sql_pct_for_int: REAL
  • uid_sql_pct_for_int_enum: STRING
  • sql_reqs_since_commit: REAL
  • sql_reqs_since_commit_enum: STRING
  • node_name: STRING
  • appl_id: STRING
  • db_partition: STRING
  • db_partition_enum: STRING
  • instance_name: STRING
  • appl_section_lookups: REAL
  • appl_section_lookups_enum: STRING
  • agent_usr_cpu_time: REAL
  • agent_usr_cpu_time_enum: STRING
  • agent_sys_cpu_time: REAL
  • agent_sys_cpu_time_enum: STRING
  • lock_list_in_use_pct: REAL
  • lock_list_in_use_pct_enum: STRING
  • lock_wait_time_for_int: REAL
  • lock_wait_time_for_int_enum: STRING
(Continued on the next page.)
ITM_KUD_DB2_Application01
  • open_curs: REAL
  • open_curs_enum: STRING
  • open_curs_blk: REAL
  • open_curs_blk_enum: STRING
  • pool_hit_ratio_pct_for_int: REAL
  • pool_hit_ratio_pct_for_int_enum: STRING
  • total_sorts_for_int: REAL
  • total_sorts_for_int_enum: STRING
  • prefetch_wait_time: REAL
  • prefetch_wait_time_enum: STRING
  • prev_uow_stop_time: STRING
  • section_number: REAL
  • section_number_enum: STRING
  • stmt_start: STRING
  • stmt_stop: STRING
  • uow_comp_status: STRING
  • uow_comp_status_enum: STRING
  • uow_log_space_used: REAL
  • uow_log_space_used_enum: STRING
  • uow_start_time: STRING
  • uow_stop_time: STRING
ITM_KUD_DB2_Application01
(Continued)
KUD_DB2_Buffer_Pool attribute group
  • node_name: STRING
  • bp_id: STRING
  • bp_name: STRING
  • input_db_alias: STRING
  • db_name: STRING
  • db_path: STRING
  • pool_data_l_reads: REAL
  • pool_data_l_reads_enum: STRING
  • pool_data_p_reads: REAL
  • pool_data_p_reads_enum: STRING
  • pool_data_writes: REAL
  • pool_data_writes_enum: STRING
  • files_closed: REAL
  • files_closed_enum: STRING
  • pool_async_index_reads: REAL
  • pool_async_index_reads_enum: STRING
  • pool_data_to_estore: REAL
  • pool_data_to_estore_enum: STRING
  • pool_index_to_estore: REAL
  • pool_index_to_estore_enum: STRING
  • pool_index_from_estore: REAL
  • pool_write_time_enum: STRING
  • pool_index_from_estore_enum: STRING
  • pool_data_from_estore: REAL
  • pool_data_from_estore_enum: STRING
  • pool_async_data_reads: REAL
  • pool_async_data_writes: REAL
  • pool_async_data_writes_enum: STRING
  • pool_async_index_writes: REAL
  • pool_async_index_writes_enum: STRING
  • pool_async_read_time: REAL
  • pool_async_read_time_enum: STRING
  • pool_async_write_time: REAL
  • pool_async_write_time_enum: STRING
  • pool_async_data_read_reqs: REAL
  • pool_async_data_read_reqs_enum: STRING
  • pool_total_reads: REAL
  • pool_total_reads_enum: STRING
  • pool_hit_ratio: REAL
  • pool_hit_ratio_enum: STRING
  • avg_pool_read_time: REAL
  • avg_pool_read_time_enum: STRING
  • pool_total_writes: REAL
  • pool_total_writes_enum: STRING
  • avg_pool_write_time: REAL
  • avg_pool_write_time_enum: STRING
  • pool_sync_data_reads: REAL
  • pool_sync_data_reads_enum: STRING
  • pool_sync_index_reads: REAL
  • pool_sync_index_reads_enum: STRING
  • pool_sync_read: REAL
  • pool_sync_read_enum: STRING
  • pool_sync_data_writes: REAL
  • pool_sync_data_writes_enum: STRING
(Continued on the next page.)
ITM_KUD_DB2_Buffer_Pool
  • pool_sync_index_writes: REAL
  • pool_sync_index_writes_enum: STRING
  • pool_sync_write: REAL
  • pool_sync_write_enum: STRING
  • pool_sync_read_time: REAL
  • pool_sync_read_time_enum: STRING
  • avg_sync_read_time: REAL
  • avg_sync_read_time_enum: STRING
  • pool_sync_write_time: REAL
  • pool_sync_write_time_enum: STRING
  • avg_sync_write_time: REAL
  • avg_sync_write_time_enum: STRING
  • avg_data_page_read_per_async_req: REAL
  • avg_data_page_read_per_async_req_enum: STRING
  • direct_reads: REAL
  • direct_reads_enum: STRING
  • direct_writes: REAL
  • direct_writes_enum: STRING
  • direct_read_reqs: REAL
  • direct_read_reqs_enum: STRING
  • direct_write_reqs: REAL
  • direct_write_reqs_enum: STRING
  • direct_read_time: REAL
  • direct_read_time_enum: STRING
  • direct_write_time: REAL
  • direct_write_time_enum: STRING
  • avg_direct_read_time: REAL
  • avg_direct_read_time_enum: STRING
  • avg_direct_write_time: REAL
  • avg_direct_write_time_enum: STRING
  • db_partition: STRING
  • db_partition_enum: STRING
  • snapshot_time: STRING
ITM_KUD_DB2_Buffer_Pool
(Continued)
KUD_DB2_Database00 attribute group
  • node_name: STRING
  • instance_name: STRING
  • db_name: STRING
  • input_db_alias: STRING
  • db_path: STRING
  • dbase_status: STRING
  • dbase_status_enum: STRING
  • db_conn_time: STRING
  • last_backup: STRING
  • total_cons: REAL
  • total_cons_enum: STRING
  • appls_cur_cons: REAL
  • appls_cur_cons_enum: STRING
  • snapshot_time: STRING
  • int_rollbacks: REAL
  • int_rollbacks_enum: STRING
  • int_deadlock_rollbacks: REAL
  • int_deadlock_rollbacks_enum: STRING
  • rollback_sql_stmts: REAL
  • rollback_sql_stmts_enum: STRING
  • failed_sql_stmts: REAL
  • failed_sql_stmts_enum: STRING
  • agents_top: REAL
  • agents_top_enum: STRING
  • coord_agents_top: REAL
  • coord_agents_top_enum: STRING
  • db_location: STRING
  • db_location_enum: STRING
  • server_platform: STRING
  • connections_top: REAL
  • connections_top_enum: STRING
  • locks_held: REAL
  • locks_held_enum: STRING
  • lock_waits: REAL
  • lock_waits_enum: STRING
  • lock_wait_time: REAL
  • lock_wait_time_enum: STRING
  • lock_list_in_use: REAL
  • lock_list_in_use_enum: STRING
  • deadlocks: REAL
  • deadlocks_enum: STRING
  • lock_escals: REAL
  • lock_escals_enum: STRING
  • x_lock_escals: REAL
  • x_lock_escals_enum: STRING
  • locks_waiting: REAL
  • locks_waiting_enum: STRING
  • lock_timeouts: REAL
  • lock_timeouts_enum: STRING
  • avg_lock_wait_time: REAL
  • avg_lock_wait_time_enum: STRING
  • sort_heap_allocated: REAL
  • sort_heap_allocated_enum: STRING
  • total_sorts: REAL
  • total_sorts_enum: STRING
(Continued on the next page.)
ITM_KUD_DB2_Database00
  • total_sort_time: REAL
  • total_sort_time_enum: STRING
  • sort_overflows: REAL
  • sort_overflows_enum: STRING
  • active_sorts: REAL
  • active_sorts_enum: STRING
  • avg_sort_time: REAL
  • avg_sort_time_enum: STRING
  • sort_overflows_pct: REAL
  • sort_overflows_pct_enum: STRING
  • pool_data_l_reads: REAL
  • pool_data_l_reads_enum: STRING
  • pool_data_p_reads: REAL
  • pool_data_p_reads_enum: STRING
  • pool_data_writes: REAL
  • pool_data_writes_enum: STRING
  • pool_index_l_reads: REAL
  • pool_index_l_reads_enum: STRING
  • pool_index_p_reads: REAL
  • pool_index_p_reads_enum: STRING
  • pool_index_writes: REAL
  • pool_index_writes_enum: STRING
  • pool_read_time: REAL
  • pool_read_time_enum: STRING
  • pool_write_time: REAL
  • pool_write_time_enum: STRING
  • files_closed: REAL
  • files_closed_enum: STRING
  • pool_async_index_reads: REAL
  • pool_async_index_reads_enum: STRING
  • pool_data_to_estore: REAL
  • pool_data_to_estore_enum: STRING
  • pool_index_to_estore: REAL
  • pool_index_to_estore_enum: STRING
  • pool_index_from_estore: REAL
  • pool_index_from_estore_enum: STRING
  • pool_data_from_estore: REAL
  • pool_data_from_estore_enum: STRING
  • pool_async_data_reads: REAL
  • pool_async_data_reads_enum: STRING
  • pool_async_data_writes: REAL
  • pool_async_data_writes_enum: STRING
  • pool_async_index_writes: REAL
  • pool_async_index_writes_enum: STRING
  • pool_async_read_time: REAL
  • pool_async_read_time_enum: STRING
  • pool_async_write_time: REAL
  • pool_async_write_time_enum: STRING
  • pool_async_data_read_reqs: REAL
  • pool_async_data_read_reqs_enum: STRING
  • pool_lsn_gap_clns: REAL
  • pool_lsn_gap_clns_enum: STRING
  • pool_drty_pg_steal_clns: REAL
  • pool_drty_pg_steal_clns_enum: STRING
  • pool_drty_pg_thrsh_clns: REAL
  • pool_drty_pg_thrsh_clns_enum: STRING
ITM_KUD_DB2_Database00
(Continued
  • pool_total_reads: REAL
  • pool_total_reads_enum: STRING
  • pool_hit_ratio: REAL
  • pool_hit_ratio_enum: STRING
  • avg_pool_read_time: REAL
  • avg_pool_read_time_enum: STRING
  • pool_total_writes: REAL
  • pool_total_writes_enum: STRING
  • avg_pool_write_time: REAL
  • avg_pool_write_time_enum: STRING
  • pool_sync_data_reads: REAL
  • pool_sync_data_reads_enum: STRING
  • pool_sync_index_reads: REAL
  • pool_sync_index_reads_enum: STRING
  • direct_reads: REAL
  • direct_reads_enum: STRING
  • direct_writes: REAL
  • direct_writes_enum: STRING
  • direct_read_reqs: REAL
  • direct_read_reqs_enum: STRING
  • direct_write_reqs: REAL
  • direct_write_reqs_enum: STRING
  • direct_read_time: REAL
  • direct_read_time_enum: STRING
  • direct_write_time: REAL
  • direct_write_time_enum: STRING
  • commit_sql_stmts: REAL
  • commit_sql_stmts_enum: STRING
  • dynamic_sql_stmts: REAL
  • dynamic_sql_stmts_enum: STRING
  • static_sql_stmts: REAL
  • static_sql_stmts_enum: STRING
  • select_sql_stmts: REAL
  • select_sql_stmts_enum: STRING
  • ddl_sql_stmts: REAL
  • ddl_sql_stmts_enum: STRING
  • uid_sql_stmts: REAL
  • uid_sql_stmts_enum: STRING
  • total_sql_stmts: REAL
  • total_sql_stmts_enum: STRING
  • sql_stmts_failed_pct: REAL
  • sql_stmts_failed_pct_enum: STRING
  • sql_stmts_rollback_pct: REAL
  • sql_stmts_rollback_pct_enum: STRING
  • total_hash_joins: REAL
  • total_hash_joins_enum: STRING
  • total_hash_loops: REAL
  • total_hash_loops_enum: STRING
  • hash_join_overflows: REAL
  • hash_join_overflows_enum: STRING
  • hash_join_small_overflows: REAL
  • hash_join_small_overflows_enum: STRING
  • rows_deleted: REAL
  • rows_deleted_enum: STRING
ITM_KUD_DB2_Database00
(Continued)
  • rows_inserted: REAL
  • rows_inserted_enum: STRING
  • rows_updated: REAL
  • rows_updated_enum: STRING
  • rows_selected: REAL
  • rows_selected_enum: STRING
  • total_sec_cons: REAL
  • total_sec_cons_enum: STRING
  • num_assoc_agents: REAL
  • num_assoc_agents_enum: STRING
  • catalog_node_name: STRING
  • sec_log_used_top: REAL
  • sec_log_used_top_enum: STRING
  • tot_log_used_top: REAL
  • tot_log_used_top_enum: STRING
  • sec_logs_allocated: REAL
  • sec_logs_allocated_enum: STRING
  • log_reads: REAL
  • log_reads_enum: STRING
  • log_writes: REAL
  • log_writes_enum: STRING
  • pkg_cache_lookups: REAL
  • pkg_cache_lookups_enum: STRING
  • pkg_cache_inserts: REAL
  • pkg_cache_inserts_enum: STRING
  • pkg_cache_hit_ratio: REAL
  • pkg_cache_hit_ratio_enum: STRING
  • cat_cache_lookups: REAL
  • cat_cache_lookups_enum: STRING
  • cat_cache_inserts: REAL
  • cat_cache_inserts_enum: STRING
  • cat_cache_overflows: REAL
  • cat_cache_overflows_enum: STRING
  • cat_cache_hit_ratio: REAL
  • cat_cache_hit_ratio_enum: STRING
  • cat_cache_heap_full: REAL
  • cat_cache_heap_full_enum: STRING
  • db_partition: STRING
  • db_partition_enum: STRING
ITM_KUD_DB2_Database00
(Continued)
KUD_DB2_Database01 attribute group
  • db_name: STRING
  • app_ctl_heap_sz: INTEGER
  • app_ctl_heap_sz_enum: STRING
  • applheapsz_enum: STRING
  • avg_appls: INTEGER
  • avg_appls_enum: STRING
  • buffpage: REAL
  • buffpage_enum: STRING
  • catalogcache_sz: INTEGER
  • catalogcache_sz_enum: STRING
  • chngpgs_thresh: INTEGER
  • chngpgs_thresh_enum: STRING
  • dbheap: REAL
  • dbheap_enum: STRING
  • locklist: REAL
  • locklist_enum: STRING
  • logbufsz: INTEGER
  • logbufsz_enum: STRING
  • logprimary: INTEGER
  • logprimary_enum: STRING
  • maxappls: INTEGER
  • maxappls_enum: STRING
  • maxlocks: INTEGER
  • maxlocks_enum: STRING
  • mincommit: INTEGER
  • mincommit_enum: STRING
  • newlogpath: STRING
  • num_iocleaners: INTEGER
  • num_iocleaners_enum: STRING
  • pckcachesz: REAL
  • pckcachesz_enum: STRING
  • restore_pending: INTEGER
  • restore_pending_enum: STRING
  • seqdetect: INTEGER
  • seqdetect_enum: STRING
  • sortheap: REAL
  • sortheap_enum: STRING
  • appls_in_db2: REAL
  • appls_in_db2_enum: STRING
  • deadlocks_for_int: REAL
  • deadlocks_for_int_enum: STRING
  • int_auto_rebinds: REAL
  • int_auto_rebinds_enum: STRING
  • int_commits: REAL
  • int_commits_enum: STRING
  • int_rows_deleted: REAL
  • int_rows_deleted_enum: STRING
  • int_rows_inserted: REAL
  • int_rows_inserted_enum: STRING
  • int_rows_updated: REAL
  • int_rows_updated_enum: STRING
  • log_io_for_int: REAL
  • log_io_for_int_enum: STRING
  • cur_cons_pct: REAL
  • cur_cons_pct_enum: STRING
(Continued on the next page.)
ITM_KUD_DB2_Database01
  • tot_pool_phys_io: REAL
  • tot_pool_phys_io_enum: STRING
  • tot_pool_phys_read: REAL
  • tot_pool_phys_read_enum: STRING
  • tot_pool_phys_write: REAL
  • tot_pool_phys_write_enum: STRING
  • tot_sync_io_time: REAL
  • tot_sync_io_time_enum: STRING
  • db_cap_err: REAL
  • db_cap_err_enum: STRING
  • db_cap_lag: REAL
  • db_cap_lag_enum: STRING
  • db_cap_prun: REAL
  • db_cap_prun_enum: STRING
  • avg_locks_held: REAL
  • avg_locks_held_enum: STRING
  • lock_waits_for_int: REAL
  • lock_waits_for_int_enum: STRING
  • lock_waits_pct: REAL
  • lock_waits_pct_enum: STRING
  • int_deadlock_rollbacks_pct_for_int: REAL
  • int_deadlock_rollbacks_pct_for_int_enum: STRING
  • db_tablespaces: REAL
  • db_tablespaces_enum: STRING
  • event_monitors: REAL
  • event_monitors_enum: STRING
  • invalid_triggers: REAL
  • invalid_triggers_enum: STRING
  • system_tablespaces: REAL
  • system_tablespaces_enum: STRING
  • tables: REAL
  • tables_enum: STRING
  • tablespaces: REAL
  • tablespaces_enum: STRING
  • tablespaces_long_data: REAL
  • tablespaces_long_data_enum: STRING
  • triggers: REAL
  • triggers_enum: STRING
  • views: REAL
  • views_enum: STRING
  • user_indexes: REAL
  • user_indexes_enum: STRING
  • commit_stmts_per_sec: REAL
  • commit_stmts_per_sec_enum: STRING
  • ddl_sql_pct_for_int: REAL
  • ddl_sql_pct_for_int_enum: STRING
  • select_sql_pct_for_int: REAL
  • select_sql_pct_for_int_enum: STRING
  • uid_sql_pct_for_int: REAL
  • uid_sql_pct_for_int_enum: STRING
  • invalid_pkgs: REAL
  • invalid_pkgs_enum: STRING
(Continued on the next page.)
ITM_KUD_DB2_Database01
(Continued)
  • invalid_sys_pkgs: REAL
  • invalid_sys_pkgs_enum: STRING
  • pri_log_used_top: REAL
  • pri_log_used_top_enum: STRING
  • int_deadlock_rollbacks_pct: INTEGER
  • int_deadlock_rollbacks_pct_enum: STRING
  • num_ioservers: INTEGER
  • num_ioservers_enum: STRING
  • snapshot_time: STRING
  • node_name: STRING
  • db_partition: STRING
  • db_partition_enum: STRING
  • instance_name: STRING
  • lock_timeouts_for_int: REAL
  • lock_timeouts_for_int_enum: STRING
  • rollback_rate_for_int: REAL
  • rollback_rate_for_int_enum: STRING
  • sql_stmts_rate_for_int: REAL
  • sql_stmts_rate_for_int_enum: STRING
  • days_since_last_backup: REAL
  • days_since_last_backup_enum: STRING
  • sort_overflows_pct_for_int: REAL
  • sort_overflows_pct_for_int_enum: STRING
  • failed_sql_stmts_pct_for_int: REAL
  • failed_sql_stmts_pct_for_int_enum: STRING
  • avg_lock_escal_con_for_int: REAL
  • avg_lock_escal_con_for_int_enum: STRING
  • deadlock_rollbacks_pct: REAL
  • deadlock_rollbacks_pct_enum: STRING
  • lock_escalation_for_int: REAL
  • lock_escalation_for_int_enum: STRING
  • curr_pri_log_used_pct: REAL
  • curr_pri_log_used_pct_enum: STRING
  • curr_sec_log_used_pct: REAL
  • curr_sec_log_used_pct_enum: STRING
  • prefetch_wait_time: REAL
  • db_heap_top: REAL
  • db_heap_top_enum: STRING
  • pool_sync_read: REAL
  • pool_sync_read_enum: STRING
  • pool_sync_data_writes: REAL
  • pool_sync_data_writes_enum: STRING
  • pool_sync_index_writes: REAL
  • pool_sync_index_writes_enum: STRING
  • pool_sync_write: REAL
  • pool_sync_write_enum: STRING
  • pool_sync_read_time: REAL
  • pool_sync_read_time_enum: STRING
  • avg_sync_read_time: REAL
  • avg_sync_read_time_enum: STRING
(Continued on the next page.)
ITM_KUD_DB2_Database01
(Continued)
  • pool_sync_write_time: REAL
  • pool_sync_write_time_enum: STRING
  • avg_sync_write_time: REAL
  • avg_sync_write_time_enum: STRING
  • avg_data_page_read_per_async_req: REAL
  • avg_data_page_read_per_async_req_enum: STRING
  • appl_section_lookups: REAL
  • appl_section_lookups_enum: STRING
  • appl_section_inserts: REAL
  • appl_section_inserts_enum: STRING
  • binds_precompiles: REAL
  • binds_precompiles_enum: STRING
ITM_KUD_DB2_Database01
(Continued)
KUD_DB2_Tablespace attribute group
  • node_name: STRING
  • db_name: STRING
  • tablespace_name: STRING
  • tablespace_type: STRING
  • tablespace_type_enum: STRING
  • extent_size: REAL
  • extent_size_enum: STRING
  • page_size: REAL
  • page_size_enum: STRING
  • prefetch_size: REAL
  • prefetch_size_enum: STRING
  • num_containers: REAL
  • num_containers_enum: STRING
  • container_name: STRING
  • object_id: INTEGER
  • object_id_enum: STRING
  • tablespace_id: REAL
  • tablespace_id_enum: STRING
  • total_pages: REAL
  • total_pages_enum: STRING
  • usable_pages: REAL
  • usable_pages_enum: STRING
  • used_pages: REAL
  • used_pages_enum: STRING
  • pending_free_pages: REAL
  • pending_free_pages_enum: STRING
  • free_pages: REAL
  • free_pages_enum: STRING
  • direct_reads: REAL
  • direct_reads_enum: STRING
  • direct_writes: REAL
  • direct_writes_enum: STRING
  • direct_read_reqs: REAL
  • direct_read_reqs_enum: STRING
  • direct_write_reqs: REAL
  • direct_write_reqs_enum: STRING
  • pool_data_writes: REAL
  • pool_data_writes_enum: STRING
  • pool_async_data_reads: REAL
  • pool_async_data_reads_enum: STRING
  • pool_async_data_writes: REAL
  • pool_async_data_writes_enum: STRING
  • pool_async_index_reads: REAL
  • pool_async_index_reads_enum: STRING
  • pool_async_index_writes: REAL
  • pool_async_index_writes_enum: STRING
  • pool_async_read_time: REAL
  • pool_async_read_time_enum: STRING
  • pool_async_write_time: REAL
  • pool_async_write_time_enum: STRING
  • pool_data_l_reads: REAL
  • pool_data_l_reads_enum: STRING
  • pool_data_from_estore: REAL
  • pool_data_from_estore_enum: STRING
(Continued on the next page.)
ITM_KUD_DB2_Tablespace
  • pool_data_to_estore: REAL
  • pool_data_to_estore_enum: STRING
  • pool_data_p_reads: REAL
  • pool_data_p_reads_enum: STRING
  • pool_index_l_reads: REAL
  • pool_index_l_reads_enum: STRING
  • pool_index_from_estore: REAL
  • pool_index_from_estore_enum: STRING
  • pool_index_to_estore: REAL
  • pool_index_to_estore_enum: STRING
  • pool_index_p_reads: REAL
  • pool_index_p_reads_enum: STRING
  • pool_index_writes: REAL
  • pool_index_writes_enum: STRING
  • direct_write_time: REAL
  • direct_write_time_enum: STRING
  • direct_read_time: REAL
  • direct_read_time_enum: STRING
  • files_closed: REAL
  • files_closed_enum: STRING
  • pool_read_time: REAL
  • pool_read_time_enum: STRING
  • pool_write_time: REAL
  • pool_write_time_enum: STRING
  • pool_async_data_read_reqs: REAL
  • pool_async_data_read_reqs_enum: STRING
  • pool_data_reads: REAL
  • pool_data_reads_enum: STRING
  • pool_sync_idx_reads: REAL
  • pool_sync_idx_reads_enum: STRING
  • pool_sync_idx_writes: REAL
  • pool_sync_idx_writes_enum: STRING
  • pool_sync_data_reads: REAL
  • pool_sync_data_reads_enum: STRING
  • pool_sync_data_writes: REAL
  • pool_sync_data_writes_enum: STRING
  • avg_sect_read: REAL
  • avg_sect_read_enum: STRING
  • avg_sect_written: REAL
  • avg_sect_written_enum: STRING
  • avg_direct_read_time: REAL
  • avg_direct_read_time_enum: STRING
  • avg_direct_write_time: REAL
  • avg_direct_write_time_enum: STRING
  • avg_pool_io_time: REAL
  • avg_pool_io_time_enum: STRING
  • avg_pool_read_time: REAL
  • avg_pool_read_time_enum: STRING
(Continued on the next page.)
ITM_KUD_DB2_Tablespace
(Continued)
  • avg_pool_write_time: REAL
  • avg_pool_write_time_enum: STRING
  • avg_sync_data_read_time: REAL
  • avg_sync_data_read_time_enum: STRING
  • avg_sync_data_write_time: REAL
  • avg_sync_data_write_time_enum: STRING
  • avg_sync_io_time: REAL
  • avg_sync_io_time_enum: STRING
  • pool_io_per_sec: REAL
  • pool_io_per_sec_enum: STRING
  • estore_rw_ratio_enum: STRING
  • estore_rw_ratio_enum: STRING
  • pool_hit_pct: REAL
  • pool_hit_pct_enum: STRING
  • pool_idx_hit_pct_for_int: REAL
  • pool_idx_hit_pct_for_int_enum: STRING
  • prefetch_pct_for_int: REAL
  • prefetch_pct_for_int_enum: STRING
  • total_io_pct: REAL
  • total_io_pct_enum: STRING
  • prefetch_reqs_for_int: REAL
  • prefetch_reqs_for_int_enum: STRING
  • sync_read_time: REAL
  • sync_read_time_enum: STRING
  • sync_write_time: REAL
  • sync_write_time_enum: STRING
  • total_direct_io_time: REAL
  • total_direct_io_time_enum: STRING
  • total_pool_io_time: REAL
  • total_pool_io_time_enum: STRING
  • total_pool_p_read_time: REAL
  • total_pool_p_read_time_enum: STRING
  • total_pool_p_write_time: REAL
  • total_pool_p_write_time_enum: STRING
  • total_sync_io: REAL
  • total_sync_io_enum: STRING
  • total_sync_io_time: REAL
  • total_sync_io_time_enum: STRING
  • pool_async_index_read_reqs: REAL
  • pool_async_index_read_reqs_enum: STRING
  • space_used_dms_table_pct: REAL
  • space_used_dms_table_pct_enum: STRING
  • space_used_sms_table: REAL
  • space_used_sms_table_enum: STRING
  • tbsp_status: REAL
  • tbsp_status_enum: STRING
  • db_partition: STRING
  • db_partition_enum: STRING
  • pool_hit_ratio_pct_for_int: REAL
  • pool_hit_ratio_pct_for_int_enum: STRING
  • instance_name: STRING
  • tbsp_state_name: STRING
ITM_KUD_DB2_Tablespace
(Continued)
KUD_DB2_Database02 attribute group
  • node_name: STRING
  • instance_name: STRING
  • db_name: STRING
  • snapshot_time: STRING
  • db_partition: STRING
  • db_partition_enum: STRING
  • log_held_by_dirty_pages: REAL
  • log_held_by_dirty_pages_enum: STRING
  • log_to_redo_for_recovery: REAL
  • log_to_redo_for_recovery_enum: STRING
  • num_log_buffer_full: REAL
  • num_log_buffer_full_enum: STRING
  • num_log_data_found_in_buffer: REAL
  • num_log_data_found_in_buffer_enum: STRING
  • num_log_part_page_io: REAL
  • num_log_part_page_io_enum: STRING
  • num_log_read_io: REAL
  • num_log_read_io_enum: STRING
  • num_log_write_io: REAL
  • num_log_write_io_enum: STRING
  • total_log_available: REAL
  • total_log_available_enum: STRING
  • appl_id_oldest_xact: REAL
  • appl_id_oldest_xact_enum: STRING
  • log_read_time_ns: REAL
  • log_read_time_ns_enum: STRING
  • log_read_time_s: REAL
  • log_read_time_s_enum: STRING
  • log_write_time_ns: REAL
  • log_write_time_ns_enum: STRING
  • log_write_time_s: REAL
  • log_write_time_s_enum: STRING
  • pool_no_victim_buffer: REAL
  • pool_no_victim_buffer_enum: STRING
  • num_db_storage_paths: REAL
  • num_db_storage_paths_enum: STRING
  • num_indoubt_trans: REAL
  • num_indoubt_trans_enum: STRING
  • cat_cache_size_top: REAL
  • cat_cache_size_top_enum: STRING
  • unread_prefetch_pages: REAL
  • unread_prefetch_pages_enum: STRING
  • pool_temp_data_l_reads: REAL
  • pool_temp_data_l_reads_enum: STRING
  • pool_temp_data_p_reads: REAL
  • pool_temp_data_p_reads_enum: STRING
  • pool_temp_index_l_reads: REAL
  • pool_temp_index_l_reads_enum: STRING
  • pool_temp_index_p_reads: REAL
  • pool_temp_index_p_reads_enum: STRING
  • smallest_log_avail_node: REAL
  • smallest_log_avail_node_enum: STRING
(Continued on the next page.)
ITM_KUD_DB2_Database02
  • shr_workspace_size_top: REAL
  • shr_workspace_size_top_enum: STRING
  • shr_workspace_num_overflows: REAL
  • shr_workspace_num_overflows_enum: STRING
  • shr_workspace_section_lookups: REAL
  • shr_workspace_section_lookups_enum: STRING
  • shr_workspace_section_inserts: REAL
  • shr_workspace_section_inserts_enum: STRING
  • priv_workspace_size_top: REAL
  • priv_workspace_size_top_enum: STRING
  • priv_workspace_num_overflows: REAL
  • priv_workspace_num_overflows_enum: STRING
  • priv_workspace_section_lookups: REAL
  • priv_workspace_section_lookups_enum: STRING
  • priv_workspace_section_inserts: REAL
  • priv_workspace_section_inserts_enum: STRING
  • pool_temp_hit_ratio: REAL
  • pool_temp_hit_ratio_enum: STRING
  • data_temp_pool_hit_ratio: REAL
  • data_temp_pool_hit_ratio_enum: STRING
  • min_catalog_cache_size: REAL
  • min_catalog_cache_size_enum: STRING
  • catalog_partition: INTEGER
  • catalog_partition_enum: STRING
  • catalog_partition_name: STRING
  • elapsed_exec_time_ms: REAL
  • elapsed_exec_time_ms_enum: STRING
  • elapsed_exec_time_s: REAL
  • elapsed_exec_time_s_enum: STRING
  • last_reset: STRING
  • pkg_cache_num_overflows: REAL
  • pkg_cache_num_overflows_enum: STRING
  • pkg_cache_size_top: REAL
  • pkg_cache_size_top_enum: STRING
  • min_pkg_cache_size: REAL
  • min_pkg_cache_size_enum: STRING
  • rows_read: REAL
  • rows_read_enum: STRING
  • sort_shrheap_allocated: REAL
  • sort_shrheap_allocated_enum: STRING
  • sort_shrheap_top: REAL
  • sort_shrheap_top_enum: STRING
  • active_hash_joins: REAL
  • active_hash_joins_enum: STRING
(Continued on the next page.)
ITM_KUD_DB2_Database02
(Continued)
  • post_shrthreshold_hash_joins: REAL
  • post_shrthreshold_hash_joins_enum: STRING
  • post_shrthreshold_sorts: REAL
  • post_shrthreshold_sorts_enum: STRING
  • pool_temp_xda_l_reads: REAL
  • pool_temp_xda_l_reads_enum: STRING
  • pool_temp_xda_p_reads: REAL
  • pool_temp_xda_p_reads_enum: STRING
  • pool_xda_l_reads: REAL
  • pool_xda_l_reads_enum: STRING
  • pool_xda_p_reads: REAL
  • pool_xda_p_reads_enum: STRING
  • pool_xda_writes: REAL
  • pool_xda_writes_enum: STRING
  • num_threshold_violations: REAL
  • num_threshold_violations_enum: STRING
  • active_olap_funcs: REAL
  • active_olap_funcs_enum: STRING
  • olap_func_overflows: REAL
  • olap_func_overflows_enum: STRING
  • total_olap_funcs: REAL
  • total_olap_funcs_enum: STRING
  • async_runstats: REAL
  • async_runstats_enum: STRING
  • stats_cache_size: REAL
  • stats_cache_size_enum: STRING
  • stats_fabricate_time: REAL
  • stats_fabricate_time_enum: STRING
  • stats_fabrications: REAL
  • stats_fabrications_enum: STRING
  • sync_runstats: REAL
  • sync_runstats_enum: STRING
  • sync_runstats_time: REAL
  • sync_runstats_time_enum: STRING
  • blocks_pending_cleanup: REAL
  • blocks_pending_cleanup_enum: STRING
  • total_log_used_pct: REAL
  • total_log_used_pct_enum: STRING
ITM_KUD_DB2_Database02
(Continued)
KUD_DB2_LOG attribute group
  • node_name: STRING
  • instance_name: STRING
  • db_name: STRING
  • db_alias: STRING
  • snapshot_time: STRING
  • db_partition: STRING
  • db_partition_enum: STRING
  • backup_pending: INTEGER
  • backup_pending_enum: STRING
  • database_is_consistent: INTEGER
  • database_is_consistent_enum: STRING
  • rollforward_pending: INTEGER
  • rollforward_pending_enum: STRING
  • restore_pending: INTEGER
  • restore_pending_enum: STRING
  • logbufsz: INTEGER
  • logbufsz_enum: STRING
  • logfilsiz: REAL
  • logfilsiz_enum: STRING
  • logprimary: INTEGER
  • logprimary_enum: STRING
  • logsecond: INTEGER
  • logsecond_enum: STRING
  • newlogpath: STRING
  • newlogpath_size: REAL
  • newlogpath_size_enum: STRING
  • newlogpath_freesize: REAL
  • newlogpath_freesize_enum: STRING
  • logpath: STRING
  • logpath_size: REAL
  • logpath_size_enum: STRING
  • logpath_freesize: REAL
  • logpath_freesize_enum: STRING
  • overflowlogpath: STRING
  • overflow_log_path_size: REAL
  • overflow_log_path_size_enum: STRING
  • overflow_log_path_freesize: REAL
  • overflow_log_path_freesize_enum: STRING
  • mirror_log_path: STRING
  • mirror_log_path_size: REAL
  • mirror_log_path_size_enum: STRING
  • mirror_log_path_freesize: REAL
  • mirror_log_path_freesize_enum: STRING
  • logretain: INTEGER
  • logretain_enum: STRING
  • userexit: INTEGER
  • userexit_enum: STRING
  • logarchmeth1: STRING
  • logarchmeth1_size: REAL
  • logarchmeth1_size_enum: STRING
  • logarchmeth1_freesize: REAL
  • logarchmeth1_freesize_enum: STRING
(Continued on the next page.)
ITM_KUD_DB2_LOG
  • logarchmeth2: STRING
  • logarchmeth2_size: REAL
  • logarchmeth2_size_enum: STRING
  • logarchmeth2_freesize: REAL
  • logarchmeth2_freesize_enum: STRING
  • failarchpath: STRING
  • failarchpath_size: REAL
  • failarchpath_size_enum: STRING
  • failarchpath_freesize: REAL
  • failarchpath_freesize_enum: STRING
  • numarchretry: INTEGER
  • numarchretry_enum: STRING
  • archretrydelay: INTEGER
  • archretrydelay_enum: STRING
  • sec_log_used_top: REAL
  • sec_log_used_top_enum: STRING
  • tot_log_used_top: REAL
  • tot_log_used_top_enum: STRING
  • sec_logs_allocated: REAL
  • sec_logs_allocated_enum: STRING
  • log_reads: REAL
  • log_reads_enum: STRING
  • log_writes: REAL
  • log_writes_enum: STRING
  • uow_log_space_used: REAL
  • uow_log_space_used_enum: STRING
  • total_log_used: REAL
  • total_log_used_enum: STRING
  • total_log_available: REAL
  • total_log_available_enum: STRING
  • log_held_by_dirty_pages: REAL
  • log_held_by_dirty_pages_enum: STRING
  • log_to_redo_for_recovery: REAL
  • log_to_redo_for_recovery_enum: STRING
  • log_write_time: REAL
  • log_write_time_enum: STRING
  • log_read_time: REAL
  • log_read_time_enum: STRING
  • num_log_write_io: REAL
  • num_log_write_io_enum: STRING
  • num_log_read_io: REAL
  • num_log_read_io_enum: STRING
  • num_log_part_page_io: REAL
  • num_log_part_page_io_enum: STRING
  • num_log_buffer_full: REAL
  • num_log_buffer_full_enum: STRING
  • num_log_data_found_in_buffer: REAL
  • num_log_data_found_in_buffer_enum: STRING
  • sec_log_used_pct: REAL
  • sec_log_used_pct_enum: STRING
  • total_log_used_pct: REAL
  • total_log_used_pct_enum: STRING
  • pri_log_used_pct: REAL
  • pri_log_used_pct_enum: STRING
(Continued on the next page.)
ITM_KUD_DB2_LOG
(Continued)
  • curr_pri_log_used_pct: REAL
  • curr_pri_log_used_pct_enum: STRING
  • curr_sec_log_used_pct: REAL
  • curr_sec_log_used_pct_enum: STRING
  • first_active_log: REAL
  • first_active_log_enum: STRING
  • last_active_log: REAL
  • last_active_log_enum: STRING
  • current_active_log: REAL
  • current_active_log_enum: STRING
  • current_archive_log: REAL
  • current_archive_log_enum: STRING
ITM_KUD_DB2_LOG
(Continued)
KUD_DB2_LOG_RECORD attribute group
  • node_name: STRING
  • instance_name: STRING
  • db_name: STRING
  • db_alias: STRING
  • db_partition: STRING
  • db_partition_enum: STRING
  • snapshot_time: STRING
  • eid: REAL
  • eid_enum: STRING
  • seqnum: REAL
  • seqnum_enum: STRING
  • start_time: STRING
  • end_time: STRING
  • first_log: STRING
  • last_log: STRING
  • backup_id: STRING
  • operation: STRING
  • operation_enum: STRING
  • operation_type: STRING
  • operation_type_enum: STRING
  • object_type: STRING
  • object_type_enum: STRING
  • location: STRING
  • device_type: STRING
  • device_type_enum: STRING
  • entry_status: STRING
  • entry_status_enum: STRING
ITM_KUD_DB2_LOG_RECORD
KUD_DB2_Diagnostic_Log attribute group
  • node_name: STRING
  • instance_name: STRING
  • db_name: STRING
  • db_partition: STRING
  • db_partition_enum: STRING
  • facility: STRING
  • rectype: STRING
  • rectype_enum: STRING
  • timestamp: STRING
  • timezone: INTEGER
  • timezone_enum: STRING
  • impact: STRING
  • pid: REAL
  • pid_enum: STRING
  • process_name: STRING
  • tid: REAL
  • tid_enum: STRING
  • funcation_string: STRING
  • component_name: STRING
  • funcation_name: STRING
  • msgid: STRING
  • message_type: STRING
  • message_number: REAL
  • message_number_enum: STRING
  • level: STRING
  • message: STRING
ITM_KUD_DB2_Diagnostic_Log