DB2 Version 9.7 for Linux, UNIX, and Windows

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

Starting with Version 9.7 Fix Pack 6, the XML document details_xml, which is included in two of logical data groups for the statistics event monitor has been deprecated. This document might be removed from the output of this event monitor in a future release.

Details

When the logical data groups event_scstats and event_wlstats are included in the output of the statistics event monitor, the XML document details_xml, which contains monitor elements that report metrics information is included in the output of the event monitor. The elements that appear in this document are included in the XML document metrics, which is now included in these two logical data groups. In addition, two new logical data groups, event_scmetrics and event_wlmetrics have been added to the event monitor. These logical data groups include the metrics reported in the metrics document. See FP6: XML document metrics stores system metrics collected by statistics event monitor for more information.

Resolution

If you use the XML metrics data returned in the details_xml document, start using the metrics document instead. Alternatively, if you include the logical data groups event_scmetrics and event_wlmetrics in the information collected by the event monitor, you can access the metrics monitor elements directly. For example, if you create a statistics event monitor that writes to tables that includes these two logical data groups, you can access the metrics monitor elements from the new tables associated with each of these groups. See FP6: New logical data groups added to the statistics event monitor for more information.