CREATE WLM PROFILE
Create a workload management (WLM) profile.
CREATE WLM PROFILE name [ ( DEFAULT_POOL name ) ]
Only superusers can create, alter, and drop WLM profiles. Alternatively, you can use the SMC to create and manage profiles.
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 PROFILE
This 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 PROFILE
Use 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.