The syntax for the ALTER WORKLOAD and CREATE WORKLOAD statements
has changed to support new functionality such as enabling application
intrapartition parallelism, limiting the maximum runtime degree for
an application, and collecting information.
Details
- Enabling application intrapartition parallelism and limiting the
maximum runtime degree for an application
- When you create or modify workloads, you can use the new MAXIMUM
DEGREE clause for the following purposes:
- To enable or disable intrapartition parallelism for applications
that you assign to the workload
- To limit the system resource that an application can consume
- Collecting information
- You can now specify two new values for the BASE option of the
COLLECT UNIT OF WORK DATA clause: INCLUDE PACKAGE LIST and INCLUDE
EXECUTABLE LIST. You can use these new values to indicate whether
you want to collect information about the executable ID list, package
list, or both for transactions that are associated with the workload.
This information is sent to the unit of work event monitors. In previous
releases, you could collect only package list information for transactions that
were associated with a workload, by using the PACKAGE LIST option
for the COLLECT UNIT OF WORK DATA clause.
Resolution
- Enabling application intrapartition parallelism and limiting the
maximum runtime degree for an application
Start using the new MAXIMUM DEGREE clause to enable or disable
intrapartition parallelism for applications that you assign to a workload
or limit the maximum runtime degree of an application.
- Collecting information
Modify scripts and applications that use the COLLECT UNIT OF
WORK DATA PACKAGE LIST clause. Use the new syntax to collect package
list information, as shown in the following example:
ALTER WORKLOAD REPORTS COLLECT UNIT OF WORK DATA BASE
INCLUDE PACKAGE LIST
If you want to collect
information about the executable ID list, use the new syntax that
is shown in the following example:
ALTER WORKLOAD REPORTS COLLECT UNIT OF WORK DATA BASE
INCLUDE PACKAGE LIST, EXECUTABLE LIST
Although
the COLLECT UNIT OF WORK DATA PACKAGE LIST clause is still supported
for compatibility with previous releases, this syntax is nonstandard,
and you should not use it.
DB2 Version 10.1 for Linux, UNIX, and Windows