DB2 10.5 for Linux, UNIX, and Windows

mon_req_metrics - Monitoring request metrics configuration parameter

This parameter controls the collection of request metrics on the entire database and affects requests executing in any DB2® service classes.

Configuration type

Database

Parameter type

Configurable online

Default [range]

BASE [NONE, BASE, EXTENDED]

Upgrade Note

On databases created before V9.7 and then upgraded to V9.7 or higher, the mon_req_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, request metrics are collected for all requests executed on the data server, irrespective of the DB2 service class the request runs in.

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, request metrics are collected only for the subset of requests running in a DB2 service class whose service superclass has the COLLECT REQUEST METRICS clause set to BASE.

The following monitor interfaces report request metrics:

MON_GET_UNIT_OF_WORK
MON_GET_UNIT_OF_WORK_DETAILS
MON_GET_CONNECTION
MON_GET_CONNECTION_DETAILS
MON_GET_DATABASE
MON_GET_DATABASE_DETAILS
MON_GET_ROUTINE
MON_GET_ROUTINE_DETAILS
MON_GET_SERVICE_SUBCLASS
MON_GET_SERVICE_SUBCLASS_DETAILS
MON_GET_WORKLOAD
MON_GET_WORKLOAD_DETAILS
Statistics event monitor (DETAILS_XML monitor element in the event_wlstats and event_scstats logical data groups)
Unit of work event monitor

If you use these interfaces, consider setting mon_req_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_req_metrics database configuration parameter.