DB2 10.5 for Linux, UNIX, and Windows

Dropping a work class set

Use the DROP WORK CLASS SET statement to drop a work class set.

Before you begin

To drop a work class set, you require WLMADM or DBADM authority.

About this task

You can drop a work class set only if no work action sets are associated with it. If you want to drop the work class set, you must first drop its dependent work action sets.

Procedure

To drop a work class set:

Use the DROP WORK CLASS SET statement.
Commit your changes. When you commit your changes the work class set is removed from the SYSCAT.WORKCLASSSETS view. In addition, all work classes that were part of the work class set are removed from the SYSCAT.WORKCLASSES view.