IQGOVERN_MAX_PRIORITY option

Function

Limits the allowed IQGOVERN_PRIORITY setting.

Allowed values

1 – 3

Default

2

Scope

Can be set temporary, per user, or PUBLIC. Requires DBA permissions to set. Takes effect immediately.

Description

Limits the allowed IQGOVERN_PRIORITY setting, which affects 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. Sybase IQ returns an error if a user sets IQGOVERN_PRIORITY higher than IQGOVERN_MAX_PRIORITY.