Product Documentation

Appearance

ALTER WLM RULE ​

Alter either the name or the options set for a WLM rule.

ALTER WLM RULE name
(PROFILE name [ options ]) |
RENAME TO name

Only superusers and users who have been granted CONTROL WLM ON SYSTEM can create, alter, and drop WLM rules.

PROFILE name ​

You can alter the profile that is associated with this rule by naming an existing profile. The profile cannot be set to null. A single set of parentheses is required around the profile name and the subsequent list of options (if any).

options ​

For details about the available options you can change, see CREATE WLM RULE. The profile name, if specified, and subsequent options must be enclosed in parentheses.

ALTER commands only change the options you specify; other options remain as they were previously defined. To remove a value for an option that accepts null, use null as the new value in the ALTER command.

Examples ​

For example, set the profile for a rule:

premdb=# alter wlm rule fastlane (profile bobr_profile);
ALTER WLM RULE

For example, rename a rule:

premdb=# alter wlm rule fastlane rename to freeway;
ALTER WLM RULE

Parent topic:SQL Commands