Changing the Priority of a Query or Session - Teradata Viewpoint - Teradata Workload Management

Teradata® Viewpoint User Guide - 24.04

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Teradata Viewpoint
Teradata Workload Management
Release Number
24.04
Published
April 2024
Language
English (United States)
Last Update
2024-04-29
dita:mapPath
xwb1711972215358.ditamap
dita:ditavalPath
tky1501004671670.ditaval
dita:id
xvu1467243446040
Product Category
Analytical Ecosystem
For Teradata systems, you can change the priority of a query or session to allow higher priority queries to run or balance session resources.

This option is only available when workloads are not enabled and the system being monitored supports this feature.

  1. Click the row of the query you want to change.
  2. Click "" to the right of the session number and select Change Priority.
    If JWT integration with Vantage is enabled (versions 16.50.05.00 and later), you will not be prompted to log in. A Disconnect option is available, which will allow the user to login using different credentials.

    Note that once disconnected, the user will continue to be prompted to enter credentials. This setting is saved per portlet instance; a new portlet instance will bypass the login dialog.

  3. Log in to Analytics Database, if prompted.
  4. Click Next.
  5. Do one of the following to change the priority of sessions:
    • Select an account string from the list of accounts that have been assigned to the user.
    • Type an account string.
  6. [Optional] Select the check box to use the account string as the default for the selected session.
    The priority will be changed for the selected query and all subsequent queries in the current session.
  7. Click Next.
  8. Click Next to confirm your selection.