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
-
Note: If you modify mon_act_metrics online,
only new connections use the updated value. Existing connections 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 set this configuration parameter
to
BASE, all metrics
reported through the following interfaces will be collected for all
activities executed on the data server, regardless of the DB2 workload the connection that
submitted the activity is associated with:
- MON_GET_PKG_CACHE_STMT_DETAILS
- MON_GET_ACTIVITY_DETAILS
- MON_GET_PKG_CACHE_STMT
- Package cache event monitor
- Activity event monitor
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, refer to the detailed monitor element descriptions.
If
you set this configuration parameter to NONE, the
metrics reported through the previously listed interfaces 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.