Changing the Priority of a Query or Session - Teradata Viewpoint

Teradata Viewpoint User Guide

Product
Teradata Viewpoint
Release Number
16.00
Published
October 2016
Language
English (United States)
Last Update
2018-03-29
dita:mapPath
fey1467302953244.ditamap
dita:ditavalPath
2206_User_vp_1600_NEW.ditaval.ditaval
dita:id
B035-2206
lifecycle
previous
Product Category
Analytical Ecosystem
For Teradata Database systems, you can change the priority of a query or session to allow higher priority queries to run or balance session resources.

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

  1. From the Queries section of System Overview, do one of the following:
    • Tap View total number of queries and then use the query state selection list or column filters to narrow the list.
    • Tap Active, Block, or Delay to display the queries in those states.
  2. Tap the row of the query you want to abort.
  3. Tap Actions and select Change Priority.
  4. Log in to Teradata Database, if prompted.
  5. Tap Next.
  6. 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.
  7. [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.
  8. Tap Next.
  9. Tap Next to confirm your selection, and tap OK.