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

Teradata® Viewpoint User Guide

Product
Teradata Viewpoint
Teradata Workload Management
Release Number
16.50
16.20
Published
July 2021
Language
English (United States)
Last Update
2021-07-27
dita:mapPath
yqb1520516846011.ditamap
dita:ditavalPath
yqb1520516846011.ditaval
dita:id
B035-2206
lifecycle
previous
Product Category
Analytical Ecosystem
For Teradata Database systems, you can change the workload of a query or session to allow higher priority workloads to run or to balance workload resources.

This option is only available when workloads are 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 whose workload you want to change.
  3. Tap Actions and select Change Workload.
  4. Log in to Teradata Database, if prompted.
  5. Tap Next.
  6. Select a new workload from the list, and tap the check box to use this as the default workload for this session.
  7. Tap Next.
  8. Tap Next to confirm your selection, and tap OK.