Product Documentation

Appearance

ALTER WLM RESOURCE POOL ​

Alter the name, the profile, or other options for a WLM resource pool.

ALTER WLM RESOURCE POOL 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 resource pools.

PROFILE name ​

You can alter the profile that is associated with this pool 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 RESOURCE POOL. 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.

RENAME TO name ​

You can rename a resource pool.

Examples ​

For example, alter a resource pool and attach it to a profile:

premdb=# alter wlm resource pool bobr_pool (profile bobr_profile);
ALTER WLM RESOURCE POOL

For example, alter two settings for a resource pool:

premdb=# alter wlm resource pool bobr_pool (slots 5, queue_size 10);
ALTER WLM RESOURCE POOL

For example, rename a resource pool:

premdb=# alter wlm resource pool longpool rename to longest_pool;
ALTER WLM RESOURCE POOL

Parent topic:SQL Commands