DB2 Version 9.7 for Linux, UNIX, and Windows
DB2 Version 9.7 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.
This parameter specifies if the 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 completes.
If the parameter is set to BASE, information about all units of work executed on the data server will be sent to the active unit of work event monitors when the units of work complete. If the parameter is set to NONE, information will only be sent to the unit of work event monitors for those units of work that are executed under a DB2 workload whose COLLECT UNIT OF WORK DATA clause is set to BASE.
If the parameter is set to PKGLIST, information about all units of work executed on the data server, including the package list, will be sent to the active unit of work event monitors when the units of work complete. The size of the package list that is collected is controlled by the value of the mon_pkglist_sz database configuration parameter. If this value is 0, then a package list is not collected, even if this option is specified. In a partitioned database environment, the package list is available for only the coordinator member. The BASE level will be collected on remote members.
If the parameter is set to BASE, and a particular workload has PKGLIST set for the COLLECT UNIT OF WORK DATA clause for the ALTER or CREATE WORKLOAD statements, then the package list will be collected for only that workload, and BASE for all other workloads.
The default setting is NONE. Note that the information gathered at the end of a unit of work includes the system level request metrics for that unit of work, for example, amount of CPU used during the unit of work. The collection of these request metrics is controlled independently from the collection of the unit of work data using either the COLLECT REQUEST METRICS clause on a DB2 service superclass or the mon_req_metrics database configuration parameter. If request metrics collection is not enabled, the value of all the request metrics gathered as part of the unit of work data is zero.