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 on DB2 Connectâ„¢ applications. Including information on DCS applications
running at the gateway, SQL statements being executed, and database
connections.
- Information on 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.
- 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 on how you can use the information
collected by the
monitor element when monitoring your database system.