Use the DROP WORK ACTION SET statement to drop a work action
set.
Before you begin
To drop a work action set, you require WLMADM
or DBADM authority.
About this task
Dropping a work action set drops the work action set and
all work actions in it.
If the work action set contains a CONCURRENTDBCOORDACTIVITIES
threshold work action, that work action must first be disabled before
the work action set can be dropped.
Procedure
To drop a work action set:
- Use the DROP WORK ACTION SET statement.
- Commit your changes. When you commit your
changes the work action set is removed from the SYSCAT.WORKACTIONSETS
view. In addition, all work actions that were part of the work action
set are removed from the SYSCAT.WORKACTIONS view. If the work action
set contains threshold work actions, the thresholds are removed from
the SYSCAT.THRESHOLDS view.