DB2 Version 9.7 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.

About this task

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.