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 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
premdb=# alter wlm resource pool bobr_pool (profile bobr_profile);
ALTER WLM RESOURCE POOL
premdb=# alter wlm resource pool bobr_pool (slots 5, queue_size 10);
ALTER WLM RESOURCE POOL
premdb=# alter wlm resource pool longpool rename to longest_pool;
ALTER WLM RESOURCE POOL