To create a work action and a work action set, use the
CREATE WORK ACTION SET statement.
Before you begin
To create a work action set, you require
WLMADM or DBADM authority.
For additional prerequisites, see the
following topics:
When you create a work action set:
- You associate it with a work class set. The work class set must
already exist.
- You also associate it with a database, a workload,
or a service superclass. If you are associating the work action set
with a service superclass, the service class must already exist. You
cannot define the work action set for the default system service class
(SYSDEFAULTSYSTEMCLASS), the default user class (SYSDEFAULTUSERCLASS)
or the default maintenance service class (SYSDEFAULTMAINTENANCECLASS).
If you are associating the work action set with a workload, the workload
must exist in the current server. You cannot associate the work action
set with the default administration workload (SYSDEFAULTADMWORKLOAD).
Procedure
To create a work action set:
- Use the CREATE WORK ACTION SET statement with the following
options:
- Commit your changes. When you commit your
changes the work action set is added to the SYSCAT.WORKACTIONSETS
view.
A new work action set only takes effect in the database after
it is committed, and does not affect any database activities currently
running.