The
mechanisms that enable the collection of package list information
by the unit of work event monitor have changed.
Details
You can enable the collection of
package list information by using one of the following two mechanisms:
- Enable collection at the database level by setting the mon_uow_data and mon_uow_pkglist database
configuration parameters. In Version 10.1,
the mon_uow_data database configuration parameter
has two values: NONE and BASE. In
previous releases, this parameter had three possible values: NONE, BASE,
and PKGLIST. The mon_uow_data parameter
is the parent parameter of the new mon_uow_pkglist and mon_uow_execlist database
configuration parameters. You can use these two parameters, collectively,
to collect package list information, executable ID information, or
both.
- Enable collection for a specific workload by using the COLLECT
UNIT OF WORK DATA clause of the CREATE WORKLOAD or ALTER WORKLOAD
statement. The syntax of the clause has changed to specify the collection
of package list information, executable ID information, or both. For
details, see "ALTER WORKLOAD and CREATE WORKLOAD statements have
changed".
Resolution
If you have scripts or applications
that set the
mon_uow_data database configuration
parameter to
PKGLIST, set the
mon_uow_data database
configuration parameter to
BASE and the
mon_uow_pkglist database
configuration parameter to
ON as shown in the following
example:
UPDATE DB CFG FOR SAMPLE USING mon_uow_data BASE
UPDATE DB CFG FOR SAMPLE USING mon_uow_pkglist ON
If you upgrade a database that has the mon_uow_data database
configuration parameter set to PKGLIST, the mon_uow_data database
configuration parameter is set to BASE and the mon_uow_pkglist database
configuration parameter is set to ON during the database
upgrade.
If you specify the COLLECT UNIT OF WORK DATA clause
for the CREATE WORKLOAD or ALTER WORKLOAD statement, start using the
new syntax for this clause.
DB2 Version 10.1 for Linux, UNIX, and Windows