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
|