17.10 - 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
17.10
Release Date
October 2021
Content Type
User Guide
Publication ID
B035-2206-101K
Language
English (United States)
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 Viewpoint Dashboard, do any of the following:
    Option Description
    Queries filtered by state
    1. Click any state in the Queries state filter bar.

      The query results that display are filtered based on what you selected.

    2. Click the row in the table for the session you want to see.
    Top 5 queries
    1. Click any row under Top 5 Queries.
    The query details view appears.
  2. Click to the right of the session number and select Change Workload.
  3. Log in to Teradata Database, if prompted.
  4. Select a different workload from the list and click Next.
  5. Click Next to confirm your selection.
  6. Click OK.