Monitor element reference

A description of the data collected by the monitor element.

The monitor elements returned by the system monitor fall into the following categories:
  • Identification for the database manager, an application, or a database connection being monitored.
  • Data primarily intended to help you to configure the system.
  • Database activity at various levels including database, application, table, or statement. This information can be used for activity monitoring, problem determination, and performance analysis. It can also be used for configuration.
  • information about DB2 Connect applications. Including information about DCS applications running at the gateway, SQL statements being executed, and database connections.
  • information about Federated Database Systems. This includes information about the total access to a data source by applications running in a DB2® federated system and information about access to a data source by a given application running in a federated server instance.
Monitor elements are described in a standard format as follows:
Element identifier
The name of the element. If parsing the data stream directly, the element identifier is uppercase and prefixed with SQLM_ELM_.
Element type
The type of information the monitor element returns. For example, the db2start_time monitor element returns a timestamp.
Table function monitoring information
If a monitor element is returned by a table function, a table with the following fields is shown.
  • Table Function: The name of the table function that returns the monitor element.
  • Monitor Element Collection Level: For more information about monitor element collection levels, see Monitor element collection levels.
Snapshot monitoring information
If a monitor element returns snapshot monitoring information, a table with the following fields is shown.
  • Snapshot level: The level of information that can be captured by the snapshot monitor. For example, the appl_status monitor element returns information at the Application level and at the Lock level.
  • Logical data grouping: The logical data group where captured snapshot information is returned. If parsing the data stream directly, the logical data group identifier is uppercase and prefixed with SQLM_ELM_. For example, the appl_status monitor element returns information for the appl_id_info grouping and for the appl_lock_list grouping.
  • Monitor switch: The system monitor switch that must be set to obtain this information. If the switch is Basic, data will always be collected for the monitor element.
Event monitoring information
If a monitor element is collected by event monitors, a table with the following fields is shown.
  • Event type: The level of information that can be collected by the event monitor. The event monitor must be created with this event type to collect this information. For example, the appl_status monitor element is collected for CONNECTIONS event monitors.
  • Logical data grouping: The logical data group where captured event information is returned. If parsing the data stream directly, the logical data group identifier is uppercase and prefixed with SQLM_ELM_. For example, the appl_status monitor element returns information for the event_conn grouping.
  • Monitor switch: The system monitor switch that must be set to obtain this information. For event monitors, the TIMESTAMP switch is the only monitor switch that can restrict the collection of event data. If there is a dash shown for this field, data will always be collected for the monitor element.
Usage
information about how you can use the information collected by the monitor element when monitoring your database system.