DBA Workload Management Tasks
The DBA can manage workload at the session level using the ALTER WLM statement to do the following:
• Force a waiting session to wake up and become active. For example: ALTER WLM SESSION 0000000139936055473344 set active
• Reassign a session to a different queue and/or queue wait list priority. The reassignment can be made permanent for the session or for the current query only. For example: ALTER WLM SET SESSION ‘0x7f4188abd700’ QUEUE=escalations, PRIORITY=LOW
• Reset a session back to default queue configuration settings. For example: ALTER WLM SET SESSION ‘0x7f4188abd700’ DEFAULT
The DBA can also use the ALTER WLM statement to authorize users, groups, and roles to use a queue. A queue authorization consists of the following:
• A queue that the user, group, or role can use. All users in a group have the same priority.
Note: Granting authorization to a queue automatically grants authorization to all configurations that use that queue.
• Priority-low, medium, high, or critical. The priority of a user determines where they wait in the queue’s wait list if their query needs to wait for execution. Queries of higher priority users will become active sooner than lower priority users.
For more information on using the ALTER WLM statement, see the SQL Language Guide.
Last modified date: 08/29/2024