DB2 Version 10.1 for Linux, UNIX, and Windows
DB2 Version 10.1 for Linux, UNIX, and Windows
This parameter controls the generation of unit of work events at the database level for the unit of work event monitor and affects units of work on the data server. It is a parent parameter to the mon_uow_execlist and mon_uow_pkglist configuration parameters.
Valid values for this parameter are as follows:
This parameter specifies whether information about a unit of work, also referred to as a transaction, should be sent to the active unit of work event monitors when the unit of work is completed.
When this parameter is disabled, all of its child parameters are also disabled, but their settings, as recorded in the database configuration file, do not change. When this parent parameter is enabled, recorded values for its child parameters take effect. Thus, data collection can be enabled or disabled globally.
If the parameter is set to BASE, information about all units of work that are executed on the data server are sent to the active unit of work event monitors when the units of work are completed. If the parameter is set to NONE, information is sent to the unit of work event monitors only for those units of work that are executed under a DB2® workload whose COLLECT UNIT OF WORK DATA clause is set to BASE. The default setting is NONE.
The information that is gathered at the end of a unit of work includes the system-level request metrics for that unit of work, for example, the amount of CPU that is used during the unit of work. The collection of these request metrics is controlled independently from the collection of the unit of work data. You collect unit of work data by using either the COLLECT REQUEST METRICS clause on a DB2 service superclass or setting the mon_req_metrics database configuration parameter to the value of BASE. If you do not enable request metrics collection, the value of all the request metrics that are gathered as part of the unit of work data is 0.