DB2 Version 10.1 for Linux, UNIX, and Windows

FP1: New XML document stores metrics collected by statistics event monitor

Starting with Version 10 Fix Pack 1, the new metrics monitor element stores delta system metrics information in an XML document.

Prior to Fix Pack 1, system metrics were captured by the statistics event monitor as an XML document in the details_xml monitor element. This XML document was generated for both the EVENT_SCSTATS and EVENT_WLSTATS logical data groups. The new metrics monitor element is an XML document that contains the same system metrics as those metrics in details_xml. However, unlike the metrics contained in the details_xml document which are accumulated values that start at database activation and increase until database deactivation, the metrics in the metrics XML document show the change in value for a metric since the last time statistics were collected. The metrics monitor element is also generated for both the EVENT_SCSTATS and EVENT_WLSTATS logical data groups. You can use the EVMON_UPGRADE_TABLES procedure to modify any existing statistics event monitors to add new metrics monitor element to the EVENT_SCSTATS and EVENT_WLSTATS logical data groups.

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 logical data groups added to the statistics event monitor.

Note: 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 XML metrics returned in details_xml, 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.