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 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.