DB2 Version 9.7 for Linux, UNIX, and Windows
DB2 Version 9.7 for Linux, UNIX, and Windows
The activity event monitor contains the details_xml monitor element in the event_activity logical data groups. Use this monitor element to capture information about activities.
The monitor element details_xml returns an XML document containing all the activity monitor elements reported by the MON_GET_ACTIVITY_DETAILS table function. Activity monitor elements are a subset of the activity details document reported in the DETAILS column of the MON_GET_ACTIVITY_DETAILS table function.
Activity monitor elements are controlled through the COLLECT ACTIVITY METRICS clause on workloads, or the mon_act_metrics database configuration parameter at the database level. Monitor elements are collected if the connection that submits the activity is associated with a workload or database for which activity monitor element collection is enabled. If activity monitor element are not collected for an activity, DETAILS_XML contains an empty document.
The schema for the XML document that is returned in the DETAILS_XML column is available in the file sqllib/misc/DB2MonCommon.xsd. The top level element is activity_metrics.