Skip to Content
Author's profile photo Gi-sung Jang

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

1. Problem

Unable to increase the value of IQGOVERN_PROIRITY option for an individual user.

>> set option gjang.iqgovern_priority=1

[Error]

Could not execute statement.

Invalid setting for option ‘IQgovern_priority’

SQLCODE=-201, ODBC 3 State=”42000″

Line 1, column 36

The following options are related to setting the query priority.

  • IQGOVERN_PRIORITY ? Assigns a numeric priority (1, 2, or 3, with 1 being the highest) to queries waiting in the processing queue.
  • IQGOVERN_MAX_PRIORITY ? Allows the DBA to set an upper boundary on IQGOVERN_PRIORITY for a user or a group.
  • IQ_GOVERN_PRIORITY_TIME ? Allows high priority users to start if a high priority (priority 1) query has been waiting in the -iqgovern queue for more than a designated amount of time.

2. Cause

IQGOVERN_MAX_PRIORITY limits the allowed IQGOVERN_PRIORITY setting, which affects the order in which a user’s queries are queued for execution.

3. Solutions

IQGOVERN_PRIORITY could be configured for the user after setting IQgovern_max_priority as public.

  • set option public.IQGOVERN_MAX_PRIORITY=1;
  • set option gjang.IQGOVERN_PRIORITY=1;


===

Gi-Sung Jang

Assigned Tags

      Be the first to leave a comment
      You must be Logged on to comment or reply to a post.