Session priority

You can define the default and maximum priority values for a user, a group, or as the system default. The system determines the value to use when the user connects to the host and executes SQL commands.

The possible priorities are critical, high, normal, low, or none.

The default priority for users, groups, and the system is none. If you do not set any priorities, user sessions run at normal priority.

• The syntax to set system the default and maximum priority is:

  SET SYSTEM DEFAULT [DEFPRIORITY | MAXPRIORITY ] to    [CRITICAL | 
  HIGH | NORMAL | LOW | NONE]

• The syntax to create a group and set the default priority is:

  CREATE GROUP group_name WITH DEFPRIORITY TO HIGH;