To disable a work action set, use the DISABLE keyword of
the CREATE WORK ACTION SET statement or the ALTER WORK ACTION SET
statement.
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.