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 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_ACTIVITY_DETAILS
- MON_GET_PKG_CACHE_STMT
- Activity event monitor (DETAILS_XML monitor element in the event_activity
logical data groups)
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 on 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 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.