To add, alter, or drop a work action from a work action
set, or to enable or disable the work action set, use the ALTER WORK
ACTION SET statement.
Before you begin
To alter a work action set, you require
SQLADM, WLMADM, or DBADM authority. To specify any clause other than
a COLLECT clause, the authorization id must include WLMADM or DBADM
authority.
For additional prerequisites, see the following
topics:
When you create a work action set to work with a specific
work class set, you cannot change it to work with a different work
class set because the work actions in the work action set have a dependency
on the work classes in the work class set. If you want to change the
work class set this work action set is to be applied to, you must
drop and recreate the work action set.
You
cannot change which object the work action set applies to because
the type of work actions in the work action set depends on which object
(database, workload, or service superclass) the work action set is
defined for. If you want to change which object the work action set
is associated with, you must drop and recreate the work action set.
Procedure
To alter a work action set:
- If you want to add a new work action to the work action
set, use the ADD keyword.
For information about the parameters
that you can specify when adding a work action to a work action set,
see
Creating a work action
- If you want to alter an existing work action, use the ALTER
keyword.
- If you want to drop a work action, use the DROP keyword.
- You can enable a work action set that is not currently enabled,
and the reverse.
If you disable an enabled work action
set, the data server ignores it after you commit your changes. For
more information, see
Disabling a work action set. If you enable
the work action set, after you commit your changes, the work action
set is applied to the next applicable activity that enters the database.
Note: Disabling
a work action set does not disable the work actions within the work
action set, but the work action set will no longer affect any work. If
you want to drop a work action set that contains a concurrency work
action threshold, you must first disable the concurrency work action
before the work action set can be dropped, because concurrency thresholds
must be disabled before they can be dropped.
- Commit your changes.
When you commit your
changes, the work action set is updated in the SYSCAT.WORKACTIONSETS
view. The SYSCAT.WORKACTIONS view is updated for any added, altered,
or dropped work actions.