Optional: Filter fields
By default, the OMEGAMON Data Connect component of ODP forwards all data that it receives.
Optionally, you can specify a filter in the OMEGAMON Data Connect configuration file to forward only specific fields.
Filters are useful for reducing data volume if you have limited storage capacity.
However, filters restrict the fields that are available for analysis.
If you decide that you want to limit the forwarded data to just the fields used by the starter dashboards, add the following filter to the OMEGAMON Data Connect configuration file:
Warning
This filter corresponds to the current starter dashboards. You might want to create dashboards that use other fields, or extend the samples with other fields. Future samples might require fields that this filter excludes. It is your decision whether to introduce a filter, and how to manage it.
connect:
filter:
enabled: true
products:
kd5:
enabled: true
tables:
statedmp:
enabled: true
fields:
- originnode
- timestamp
- mvs_system
- db2_subsystem
- data_sharing_group
- member_name
- db2_version
- fieldname
- value
- delta
- rate
- sequence
opersys:
enabled: true
fields:
- originnode
- mvs_system
- db2_subsystem
- db2_version
- cpu_utilization_lpar
- cpu_utilization_db2
- cpu_utilization_db2_mstr
- cpu_utilization_db2_dbm1
- real_storage_on_lpar
- used_real_storage_db2
- virtual_storage_lpar
- used_virtual_storage_db2
dp_sy_exc:
enabled: true
fields:
- originnode
- time
- edm_utilization
- db_wait_percent
- thread_wait_limit
- edm_current_pages
- mvs_system
- db2_subsystem
- status
- idname
- ridpool_fail_no_storage
- db2_version
- number_of_active_dbats
- rid_pool_size
- edm_pool_full
- rid_pool_size_too_small
- global_cache_hit_ratio
- nonstealable_pages
- indoubt_urs
- transactions_per_second
- resync_attempted
- sort_error_bp_shortage
- merge_error_bp_shortage
- sort_degraded_bp_small
- deadlocks
- timeouts
- lock_escalations
- dm_critical_thresh
- checkpoint_freq
- output_buffer_size
- dsc_active
- allowed_locks_per_ts
- resource_timeout
- bytes_written_to_log
- pages_read_from_bps
- pages_read_from_dasd
- pages_castout
- avg_thread_footprint
statlokc:
enabled: true
fields:
- originnode
- timestamp
- mvs_system
- db2_subsystem
- data_sharing_group
- member_name
- db2_version
- fieldname
- value
- delta
- rate
- sequence
statlogs:
enabled: true
fields:
- originnode
- timestamp
- mvs_system
- db2_subsystem
- data_sharing_group
- member_name
- db2_version
- fieldname
- value
- delta
- rate
- sequence
real254:
enabled: true
fields:
- originnode
- mvs_system
- db2_subsystem
- db2_version
- data_sharing_group
- member_name
- read_hit
- global_buffer_pool_name
- read_hit_percent
edmpool:
enabled: true
fields:
- originnode
- db2_subsystem
- db2_version
- dynamic_sql_cache_loads
- dynamic_sql_cache_requests
- available_pages
real2252:
enabled: true
fields:
- originnode
- mvs_system
- db2_subsystem
- db2_version
- data_sharing_group
- member_name
- agent_local_storage
- total_agent_sys_stg
- active_threads
- extended_csa_size
- rid_pool_storage
- total_alloc_shr_dyn_sql
- total_alloc_shr_stat_sql
- total_agt_non_sys_stg
- log_wrt_buffer_real
- log_wrt_ctl_real
- log_wrt_ctl_aux
- total_array_var_stg
real225:
enabled: true
fields:
- originnode
- mvs_system
- db2_subsystem
- db2_version
- data_sharing_group
- member_name
- addr_space_name
- cur_priv_highaddr_31_bit
- fixed_storage_above
- fixed_storage
- getmained_storage_above
- getmained_storage
- getmained_stack_storage
- mvs_usage_storage_mb
- stg_mgr_ctl_blocks_above
- stack_storage_in_use
- cur_priv_highaddr_24_bit
- variable_storage_above
- variable_storage
- aux_stor_inuse_64_bit
- aux_in_use_mb_31bit
- aux_stor_inuse
- castout_buffers
- total_storage_mb
- total_storage_below_mb
- max_num_of_threads
- real_stor_inuse_31
- real_stor_4k_frame_inuse
- avg_thd_footprint
- aux_used_shr_stor_64
- total_31bit_inuse_pct
- db2_31bit_inuse_pct
realsqlc:
enabled: true
fields:
- originnode
- timestamp
- mvs_system
- db2_subsystem
- description
- delta
- rate
- total
realqbst:
enabled: true
fields:
- originnode
- mvs_system
- db2_subsystem
- db2_version
- data_sharing_group
- member_name
- buffer_pool_id
- bp_pages_in_use_percent
- bp_hit_ratio
- sync_reads_random2
- seq_hit_ratio
- rand_hit_ratio
- rand_failed_cond_req2
- random_getpages2
- getpage_per_sync_random2
- get_page
- sync_read_io
- defer_write_thld_reached
- getpage_fail_vpool_full
- expand_fail_sos
- update_intents
- pages_written_system
- async_write_io
- current_active_buffers
- page_ins_read_io
- page_ins_write_io
- datasets_opened
- immediate_writes
- sequential_prefetch
- pages_seq_prefetch
- seq_pref_disabled_buf
- seq_pref_disabled_rd_eng
- dm_buff_crit_thld_reach
- migrated_datasets
- recall_timeouts
- async_read_seq_prefetch
- seq_pref_not_sch_quant
- current_alloc_workf_exc
- max_workfiles_merge
- pages_destruct_read
- pages_removedt_ds_deffer
- sort_merges
- work_sort_merges
- work_reject_sort_merges
- no_sort_merge_buff_spc
- list_prefetch_reads
- dyn_prefetches
- expand_contract_alter
- buffers_allocated
- async_reads_dyn_pre
- async_reads_list_pre
- async_reads_io_dyn_pre
- async_reads_io_list_pre
- getpage_seq_access
- read_io_seq_access
- parall_getpage_unavail
- prefetch_io_concurr_hwm
- pref_io_str_reduced_buf
- bp_name
- sync_read_io_nons_over
- sync_read_io_seq_over
gstqxst:
enabled: true
fields:
- originnode
- timestamp
- mvs_system
- db2_subsystem
- data_sharing_group
- member_name
- db2_version
- fieldname
- value
- delta
- rate
- sequence
real230:
enabled: true
fields:
- originnode
- mvs_system
- db2_subsystem
- db2_version
- data_sharing_group
- member_name
- group_buffer_pool_id
- hit_ratio
- sync_read_xi_no_data_ret
- castout_class_threshold
- gb_castout_threshold
- pages_castout
- group_buffer_pool
- sync_read_xi_data_ret
statqxst:
enabled: true
fields:
- originnode
- timestamp
- mvs_system
- db2_subsystem
- data_sharing_group
- member_name
- db2_version
- fieldname
- value
- delta
- rate
- sequence
db2msg:
enabled: true
fields:
- originnode
- mvs_system
- db2_subsystem
- db2_version
- message_text
dp_srm_log:
enabled: true
fields:
- originnode
- time
- log_recording_mode
- archive_recording_mode
- logs_defined
- logs_available
- checkpoint_frequency
- next_checkpoint
- input_buffer_size
- output_buffer_size
- write_threshold
- dataset_size
- dataset_utilization
- primary_dataset_name
- secondary_dataset_name
- percent_logs_avail
- current_rba
- begin_rba
- end_rba
- mvs_system
- db2_subsystem
dp_srm_sub:
enabled: true
fields:
- originnode
- time
- max_threads_allowed
- foreground_limit
- background_limit
- current_threads
- current_foreground
- current_background
- thread_utilization
- foreground_utilization
- background_utilization
- total_identify
- total_signon
- total_create_threads
- total_create_thread_wait
- create_thread_wait_rate
- total_terminate_thread
- total_single_phase_commits
- total_read_only_commits
- total_phase1_commits
- total_phase2_commits
- total_aborts
- abort_rate
- total_commits
- commit_rate
- total_indoubt
- total_indoubt_resolve
- total_abends_eom
- total_abends_eot
- maxdbat
- current_dbat
- dbat_utilization
- maxdbat_hwm
- condbat
- dbat_connection
- dbat_conn_utilization
- dbat_conn_hwm
- mvs_system
- db2_subsystem
After editing the configuration file, restart OMEGAMON Data Connect.