DB2 10.5 for Linux, UNIX, and Windows

Altering a work class set

You cannot change the work class set attributes after you create a work class set. However, you can add, alter, and drop work classes in the work class set using the ALTER WORK CLASS SET statement.

Before you begin

To alter a work class set, you require WLMADM or DBADM authority.
For additional prerequisites, see the following topics:

Procedure

  1. If you want to add work class to the work class set, use the ADD keyword. For information about the keywords that you can specify when adding a work class, see Creating a work class.
  2. If you want to alter a work class, use the ALTER keyword. For information about altering a work class, see Altering a work class.
  3. If you want to drop a work class, use the DROP keyword. For information about dropping a work class from a work class set, see Dropping a work class. If you want to drop all the work classes from the work class set, you can drop the work class set itself. For more information, see Dropping a work class set.
  4. Commit your changes. When you commit your changes, the SYSCAT.WORKCLASSES view is updated to show any added, altered, or dropped work class.