CREATE WLM PROFILE
Create a workload management (WLM) profile.
CREATE WLM PROFILE name [ ( DEFAULT_POOL name ) ]Only superusers and users who have been granted CONTROL WLM ON SYSTEM can
create, alter, and drop WLM profiles. You can use Yellowbrick Manager to create and manage
WLM profiles, resource pools, and rules.
Use any valid SQL identifier as the profile name. Names longer than 128 characters are allowed but truncated. See also SQL Identifiers.
For example:
premdb=# create wlm profile shortquerybias;
CREATE WLM PROFILEThis example creates a profile with a default pool. The default pool does not have to exist
when this command is run.
premdb=# create wlm profile sqb (default_pool sqbpool);
CREATE WLM PROFILEUse the ALTER WLM PROFILE
command to make a profile the active profile or change its default pool. Query the
sys.wlm_active_profile view to see the current profiles in the system
and which profile is active. Alternatively, use the ybsql \dwp command to
return a list of profiles.