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:
      kmq:
        enabled: true
        tables:
          lh_smds:
            enabled: true
            fields:
              - mq_manager_name
              - cf_structure_name
              - sample_date_and_time
              - structure_number
              - message_count
              - total_blocks
              - data_block_used_percent
              - no_space
              - buffer_size
              - total_buffers
              - buffers_in_use
              - buffers_in_use_percent
              - waiting_request_queue_for_free_buffer
              - waiting_request_queue_for_busy_buffer
              - no_buffer_available
              - control_interval_size
              - control_area_size
              - write_requests
          qmch_lh:
            enabled: true
            fields:
              - mq_manager_name
              - channel_name
              - connection_name
              - sample_date_and_time
              - host_name
              - channel_type
              - channel_status
              - in_doubt_status
              - message_count
              - transmit_kilobytes_per_second
              - batches_complete
              - start_date_and_time
              - last_message_date_and_time
              - remote_qmgr_name
              - long_term_exit_time
              - long_term_net_time
              - long_term_transmit_queue_time
              - current_action_state
              - bytes_sent_64bit
              - bytes_received_64bit
              - maximum_message_length
              - non_persistent_message_speed
              - completed_retry_time
          qmchanin:
            enabled: true
            fields:
              - mq_manager_name
              - host_name
              - adapters_started
              - adapters_requested
              - dispatchers_started
              - dispatchers_requested
              - chan_conn_current
              - chan_conn_active
              - chan_conn_retrying
              - port_number
              - chan_init_active
              - tcp_ip_listener_active
              - lu62_listener_active
              - tcp_ip_group_port
              - ssl_server_subtasks_started
              - ssl_server_subtasks_requested
              - number_of_queue_manager_tcpip_listeners
              - number_of_group_tcpip_listeners
              - number_of_queue_manager_tcpip_listeners_retrying
              - sample_date_and_time
          qmcurstat:
            enabled: true
            fields:
              - mq_manager_name
              - host_name
              - mq_manager_status
              - channel_initiator_status
              - command_server_status
              - connection_count
              - current_channel_connections
              - active_channel_connections
              - maximum_channels
              - maximum_active_channels
              - percent_maximum_channels
              - percent_maximum_active_channels
              - active_log_copy_2_dataset_name
              - in_doubt_channel_connections
              - server_connections
              - dlq_depth
              - open_queue_count
              - high_depth_queue_count
              - put_inhibited_queue_count
              - get_inhibited_queue_count
              - total_messages
              - total_transmission_queue_messages
              - current_channel_connections_not_running
              - current_mqevents
              - queue_manager_health
              - queue_health
              - channel_health
              - start_date
              - not_being_read_queue_count
              - sysplex_name
              - qsg_name
              - version
          qmlhbm:
            enabled: true
            fields:
              - mq_manager_name
              - buffer_pool_id
              - sample_date_and_time
              - host_name
              - number_of_buffers
              - available_buffers
              - lowest_available_buffers
              - unavailable_buffers_count
              - percent_available_buffers
              - synchronous_writes
              - getpage_io_percent
              - percent_getpages_outside_pool
              - percent_updated_pages_written
              - dasd_page_reads_per_second
              - dasd_page_writes_per_second
              - asynchronous_writes
              - synchronous_write_percent
              - page_sets_assigned
              - queues_assigned
          qmlhlm:
            enabled: true
            fields:
              - mq_manager_name
              - sample_date_and_time
              - host_name
              - unavailable_log_buffer_waits
              - archive_read_log_percent
              - percent_read_logs_delayed
              - read_logs_per_minute
              - logging_suspended
              - archive_log_quiesce_active
              - current_active_log_percent_full
              - active_log_dataset_name
              - offload_task_status
              - full_logs_to_offload
              - active_logs_available
              - checkpoints
              - log_write_requests_per_minute
              - compression_requests_per_minute
              - compression_failures_per_minute
              - uncompressed_kilobytes_before_compression
              - compressed_kilobytes_after_compression
              - decompression_requests_per_minute
              - decompression_failures_per_minute
              - current_active_log_copy_2_percent_full
              - active_log_copy_2_dataset_name
          qmlhmm:
            enabled: true
            fields:
              - mq_manager_name
              - sample_date_and_time
              - host_name
              - mqgets_per_second
              - mqputs_per_second
              - mqput1s_per_second
              - mqopens_per_second
              - mqcloses_per_second
              - mqinqs_per_second
              - mqsets_per_second
              - close_handles_per_second
              - mqsubs_per_second
              - mqsubrqs_per_second
              - mqcbs_per_second
              - mqstats_per_second
              - publication_puts_per_second
          qmlhtm:
            enabled: true
            fields:
              - mq_manager_name
              - host_name
              - subscriptions_per_second
              - durable_subscriptions_per_second
              - expired_subscriptions
              - messages_on_subscriber_queue_per_second
              - api_publications_per_second
              - admin_publications_per_second
              - proxy_publications_per_second
              - no_subscriber_publish_count
              - sample_date_and_time
          qmps_lh:
            enabled: true
            fields:
              - mq_manager_name
              - page_set_id
              - sample_date_and_time
              - host_name
              - status
              - allocated_data_pages
              - percent_pages_in_use
              - persistent_pages
              - non_persistent_pages
              - total_extents
              - extents_since_restart
              - buffers_in_use
              - percent_buffer_pool_in_use
              - queues_assigned
              - queue_messages
          qmq_lh:
            enabled: true
            fields:
              - mq_manager_name
              - queue_name
              - sample_date_and_time
              - host_name
              - put_status
              - get_status
              - output_opens
              - input_opens
              - highest_depth
              - percent_full
              - messages_put
              - messages_read
              - messages_read_per_second
              - messages_put_per_second
              - last_put_date_and_time
              - queue_usage
              - definition_type
              - storage_class
              - page_set_id
              - buffer_pool_id
              - queue_type
              - qsg_name
              - cf_structure_name
              - qsg_disposition
          qmq_qu_st:
            enabled: true
            fields:
              - mq_manager_name
              - host_name
              - queue_name
              - input_opens
              - output_opens
              - qsg_disposition
              - oldest_message_age
              - short_term_queue_time
              - long_term_queue_time
              - last_get_date_and_time
              - last_put_date_and_time
          qmq_st_smf:
            enabled: true
            fields:
              - mq_manager_name
              - host_name
              - queue_name
              - uncommitted_changes
              - page_set_id
              - buffer_pool_id
              - qsg_name
              - cf_structure_name
              - output_opens
              - input_opens
              - oldest_message_age
              - short_term_queue_time
              - long_term_queue_time
              - last_put_date_and_time
              - last_get_date_and_time
              - highest_depth
              - lowest_depth
              - put_count
              - put1_count
              - non_persistent_put_count
              - persistent_put_count
              - non_persistent_put1_count
              - persistent_put1_count
              - put_bytes
              - put1_bytes
              - non_persistent_put_bytes
              - persistent_put_bytes
              - non_persistent_put1_bytes
              - persistent_put1_bytes
              - put_fail_count
              - put1_fail_count
              - average_message_size
              - destructive_get_count
              - non_persistent_destructive_get_count
              - persistent_destructive_get_count
              - destructive_get_bytes
              - non_persistent_destructive_get_bytes
              - persistent_destructive_get_bytes
              - browse_get_count
              - non_persistent_browse_get_count
              - persistent_browse_get_count
              - browse_get_bytes
              - non_persistent_browse_get_bytes
              - persistent_browse_get_bytes
              - destructive_get_fail_count
              - destructive_get_fail_no_message_count
              - destructive_get_fail_truncated_message_count
              - browse_get_fail_count
              - browse_get_fail_no_message_count
              - browse_get_fail_truncated_message_count
              - destructive_get_wait_no_message_count
              - destructive_get_wait_retry_count
              - browse_get_wait_no_message_count
              - browse_get_wait_retry_count
              - destructive_get_signal_request_count
              - browse_get_signal_request_count
              - highest_simultaneous_open_input_count
              - lowest_simultaneous_open_input_count
              - highest_simultaneous_open_output_count
              - lowest_simultaneous_open_output_count
              - open_request_count
              - close_request_count
              - expired_message_count
              - put_roll_back_count
              - sample_date_and_time
          qsg_cfstr:
            enabled: true
            fields:
              - qsg_name
              - cf_structure_name
              - structure_level
              - recovery_supported
              - cf_structure_type
              - structure_status
              - maximum_kilobytes_storage
              - percent_storage_used
              - maximum_list_entries
              - percent_list_entries_used
              - description
              - offload_usage
              - expand_dataset
              - automatic_recovery
              - connection_loss_action
          qsg_qmgr:
            enabled: true
            fields:
              - qsg_name
              - mq_manager_name
              - queue_manager_status
              - mqseries_release
              - db2_subsystem_name
              - db2_connection_status
              - number_of_db2_servers
              - data_sharing_group_name
              - host_name
      kqi:
        enabled: true
        tables:
          kqitacmf:
            enabled: true
            fields:
              - start_date_and_time
              - node
              - integration_server
              - application
              - message_flow
              - total_elapsed_microseconds
              - maximum_elapsed_microseconds
              - minimum_elapsed_microseconds
              - total_cpu_microseconds
              - maximum_cpu_microseconds
              - minimum_cpu_microseconds
              - input_message_wait_cpu_microseconds
              - input_message_wait_elapsed_microseconds
              - total_input_message_size
              - maximum_input_message_size
              - minimum_input_message_size
              - average_elapsed_microseconds
              - average_cpu_microseconds
              - average_input_message_size
              - total_input_messages
              - number_of_threads_in_pool
              - times_maximum_number_of_threads_reached
              - total_number_of_mq_errors
              - total_number_of_messages_with_errors
              - total_number_of_aggregate_reply_wait_timeouts
              - total_number_of_commits
              - total_number_of_backouts
              - input_message_rate
              - input_byte_rate
          kqitapps:
            enabled: true
            fields:
              - node
              - integration_server
              - application
              - status
              - total_message_flows
              - started_message_flows
              - stopped_message_flows
              - type
              - java_isolation
              - last_modified_date_and_time
              - identifier
              - start_mode
              - monitoring
              - start_date_and_time
          kqitbrks:
            enabled: true
            fields:
              - node
              - status
              - integration_servers
              - queue_manager
              - queue_manager_connection_status
              - trusted_queue_manager
              - process_identifier
              - release
              - system_name
              - platform
              - platform_version
              - jobname_taskname
              - start_date_and_time
              - address_space_identifier
              - component_type
              - statistics_archive_interval
              - configuration_timeout
              - configuration_delay_timeout
              - http_listener_port
              - http_listener_trace_level
              - http_listener_trace_size
              - total_message_flows
              - started_message_flows
              - stopped_message_flows
          kqitbsev:
            enabled: true
            fields:
              - node
              - event_date_and_time
              - event_type
              - event
              - event_qualifier_1
              - qualifier_1_description
          kqitegrs:
            enabled: true
            fields:
              - node
              - integration_server
              - status
              - total_message_flows
              - started_message_flows
              - trace_level
              - user_trace_level
              - trace_log_file_size
              - trace_log_file_mode
              - user_trace_log_file_size
              - user_trace_log_file_mode
              - event_log_file_size
              - event_log_file_mode
              - stopped_message_flows
              - process_identifier
              - exception_logging
              - trace_node_level
              - server_host
              - rest_administration_port
              - last_message_date_and_time
              - monitoring
              - start_date_and_time
              - build_level
              - platform_architecture
              - platform_name
              - platform_version
              - version
              - trusted_queue_manager
              - force_server_https
              - started_applications
              - total_applications
              - stopped_applications
          kqitmfls:
            enabled: true
            fields:
              - node
              - integration_server
              - application
              - message_flow
              - status
              - processing_nodes
              - additional_instances
              - trace_level
              - user_trace_level
              - deploy_date_and_time
              - modify_date_and_time
              - version 

After editing the configuration file, restart OMEGAMON Data Connect.