DB2 10.5 for Linux, UNIX, and Windows

Dropping a work class

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

Before you begin

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

See Workload management DDL statements for additional prerequisites.

Procedure

To drop a work class:

  1. Use the DROP keyword of the ALTER WORK CLASS SET statement. You cannot drop a work class if any work action in any work action set associated with this work class set has a dependency on the work class you want to drop. In this situation, you must first drop all dependent work actions before dropping the work class.
  2. Commit your changes. When you commit your changes, the work class is removed from the SYSCAT.WORKCLASSES view.