Dropping a work action

If you no longer require a work action, you can drop it from the work action set.

Before you begin

Procedure

To drop a work action:

  1. Use the DROP keyword of the ALTER WORK ACTION SET statement.
    If you want to drop a CONCURRENTDBCOORDACTIVITIES threshold work action, you must disable the work action in one ALTER WORK ACTION SET operation, commit the change, verify that there are no queued activities, and then drop the threshold in a second ALTER WORK ACTION SET operation.
  2. Commit your changes.
    When you commit your changes, the work action is removed from the SYSCAT.WORKACTIONS view. If the work action is a threshold work action, the threshold is also removed from the SYSCAT.THRESHOLDS view.

    An altered work action set and work action only takes effect in the database after it is committed, and does not affect any database activities currently running.