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.