DB2 Version 10.1 for Linux, UNIX, and Windows

FP1: New logical data groups added to the statistics event monitor

Starting with Version 10 Fix Pack 1, two new logical data groups are available for the statistics event monitor. These logical data groups include metrics monitor elements that were formerly returned only in XML documents.

Prior to Fix Pack 1, metrics information collected by the statistics event monitor was stored in the details_xml monitor element as an XML document. The XML document contains other monitor elements that report system metrics information. The details_xml monitor element is included in the EVENT_SCSTATS and EVENT_WLSTATS logical data groups. With the new logical data groups EVENT_SCMETRICS and EVENT_WLMETRICS, you can now directly view any metric that previously required post-processing or parsing of an XML document. You can use the EVMON_UPGRADE_TABLES procedure to modify any existing statistics event monitors to add the new logical data groups.

The new logical data groups are included by default in the output of the statistics event monitor. These new logical data groups are only available for statistics event monitor that write to tables.

Important: The metrics recorded in the details_xml monitor element XML document are accumulated values that start at database activation and increase until database deactivation. While the monitor elements reported in the EVENT_SCMETRICS and EVENT_WLMETRICS logical data groups show the change in value for the metric since the last time statistics were collected. The metrics recorded in the XML document associated with the new metrics monitor element mirror those metrics reported in the new EVENT_SCMETRICS and EVENT_WLMETRICS logical data groups. For more information, see FP1: New XML document stores metrics collected by statistics event monitor.

Starting with Version 10.1 Fix Pack 1, the details_xml monitor element is deprecated for the statistics event monitor and might be removed in a future release. If you use the metrics data returned in details_xml monitor element XML document, you might consider using the metrics XML document instead. For more information, see FP1: Reporting of metrics in details_xml by the statistics event monitor has been deprecated.