mon_uow_data - Monitoring unit of work events configuration parameter
This parameter specifies whether information about a unit of work, also referred to as a transaction, is sent to the active unit of work event monitors when the unit of work is completed. It is a parent parameter to the mon_uow_execlist and mon_uow_pkglist configuration parameters.
- Configuration type
- Applies to
- Database server with local and remote clients
- Database server with local clients
- Partitioned database server with local and remote clients
- Parameter type
- Configurable online
- Propagation class
- Next unit of work
- Default [range]
- NONE [NONE, BASE]
- Upgrade Note
- If you are upgrading from a Db2® Version 9.8 Fix Pack 4 pureScale environment or earlier, the value of mon_uow_data is set to the value on member 0.
If you disable this parameter, all of its child parameters are also disabled, but their settings, as recorded in the database configuration file, do not change. If you enable this parent parameter, recorded values for its child parameters take effect. This means that data collection can be enabled or disabled globally.
If the parameter is set to BASE, basic data collection for a UOW event monitor is enabled. 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, all data collection for a UOW event monitor is disabled. 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 for the mon_uow_data configuration parameter 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 with a Db2 service superclass or by 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.