Dropping a work action set

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:

  1. Use the DROP WORK ACTION SET statement.
  2. 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.