DB2 Version 10.1 for Linux, UNIX, and Windows

FP1: Reporting of metrics in details_xml by the statistics event monitor has been deprecated

Starting with V10.1 Fix Pack 1, the details_xml monitor element has been deprecated. This monitor element might be removed from the output of the system event monitor in a future release.

Details

When the EVENT_SCSTATS and EVENT_WLSTATS logical data groups are included in the output of the statistics event monitor, the details_xml monitor element is included as part of the output. This monitor element is an XML document that contains other monitor elements that report system metrics information. The elements that appear in this XML document are also included in an XML document associated with the new metrics monitor element. The metrics element is included in the same two logical data groups (EVENT_SCSTATS and EVENT_WLSTATS). However, unlike the metrics collected 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. For more information, see FP1: New XML document stores metrics collected by statistics event monitor.

In addition, two new logical data groups, EVENT_SCMETRICS and EVENT_WLMETRICS are added to the statistics event monitor. With these new logical data groups, you can now view the information contained in the metrics monitor element as individual elements without the need to parse an XML document. For more information, see FP1: New logical data groups added to the statistics event monitor.

Resolution

If you use the XML metrics data returned in the details_xml monitor element, start using the metrics monitor element instead. Alternatively, if you include the logical data groups EVENT_SCMETRICS and EVENT_WLMETRICS in the information collected by the event monitor, then you can access the metrics monitor elements directly. For example, if you create a statistics event monitor that writes to tables, include these two logical data groups, then you can access the metrics monitor elements from the new tables associated with each of these groups.