IQGOVERN_PRIORITY option

Function

Assigns a priority to each query waiting in the -iqgovern queue.

Allowed values

1 – 3

Default

2

Scope

DBA permissions are not required to set this option. Can be set temporary, for an individual connection, or for the PUBLIC group. Takes effect immediately.

Description

Assigns a value that determines the order in which a user’s queries are queued for execution. In the range of allowed values, 1 indicates high priority, 2 (the default) medium priority, and 3 low priority. This switch can be set temporary, per user, or public by any user. Queries with a lower priority will not run until all higher priority queries have executed.

This option is limited by the per user or per group value of the option IQGOVERN_MAX_PRIORITY.