DB2 10.5 for Linux, UNIX, and Windows

mon_act_metrics - Monitoring activity metrics configuration parameter

This parameter controls the collection of activity metrics on the entire database and affects activities submitted by connections associated with any DB2® workload definitions.

Configuration type

Database

Parameter type

Configurable online

Note: If you modify the mon_act_metrics parameter online, only the new activities use the updated value. The existing activities are not affected.

Default [range]

BASE [NONE, BASE, EXTENDED]

Upgrade Note

On databases created before V9.7 and then upgraded to V9.7 or higher, the mon_act_metrics parameter is set to NONE by default.
If you are upgrading from a DB2 Version 9.8 Fix Pack 4 pureScale environment or earlier, the value of mon_req_metrics is set to the value on member 0.

If you set this configuration parameter to BASE, activity metrics are collected for all activities executed on the data server regardless of the DB2 workload the connection that submitted the activity is associated with.

If you set this configuration parameter to EXTENDED, the same metrics are collected as under the BASE setting. In addition, the values reported for the following monitor elements are determined with more granularity:

total_section_time
total_section_proc_time
total_routine_user_code_time
total_routine_user_code_proc_time
total_routine_time

For information about how the EXTENDED setting affects these monitor elements, see the detailed monitor element descriptions.

If you set this configuration parameter to NONE, activity metrics are collected only for the subset of activities submitted by a connection that is associated with a DB2 workload whose COLLECT ACTIVITY METRICS clause has been set to BASE

The following monitor interfaces report activity metrics:

MON_GET_PKG_CACHE_STMT_DETAILS
MON_GET_ACTIVITY
MON_GET_ACTIVITY_DETAILS
MON_GET_PKG_CACHE_STMT
WLM_GET_WORKLOAD_OCCURRENCE_ACTIVITIES
Package cache event monitor
Activity event monitor

If you use these interfaces, consider setting mon_act_metrics to a value other than NONE. Each interface topic contains a list of the monitor elements that are reported and the details on whether a monitor element is controlled by the mon_act_metrics database configuration parameter.