Disabling a work action set

To disable a work action set, use the DISABLE keyword of the CREATE WORK ACTION SET statement or the ALTER WORK ACTION SET statement.

Before you begin

To disable a work action set, you require WLMADM or DBADM authority.

About this task

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. At runtime, a disabled work action set is treated as if it does not exist.

Note: 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.

For example, assume that you have a work action set called READACTIVITIES that is associated with a work class set called READCLASSES, and that work action set is defined for a service superclass called READSERVICECLASS. The SMALLREAD work action set has a work action in it that remaps all SELECT statements to the service subclass SMALLREADSERVICECLASS. If the READACTIVITIES work action set is disabled, all SELECT statements are treated as though the READACTIVITIES work action set does not exist, and are mapped to the default service subclass.

Procedure

To disable a work action set:

Use one of the following statements, depending on whether you are creating or altering a work action set:
- To create a work action set that is disabled:
```
CREATE WORK ACTION SET work-action-set-name ... DISABLE
```
- To disable an already existing work action set:
```
ALTER WORK ACTION SET work-action-set-name ... DISABLE
```
Commit your changes.
When you commit your changes, the work action set is updated in the SYSCAT.WORKACTIONSETS view.