DB2 10.5 for Linux, UNIX, and Windows

Altering a work action set

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:

  1. 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
  2. If you want to alter an existing work action, use the ALTER keyword. For information about altering a work action, see Altering a work action.
  3. If you want to drop a work action, use the DROP keyword. For information about dropping a work action from a work action set, see Dropping a work action.
  4. 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.
  5. 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.