Changing the Workload of a Query or Session

Teradata® Viewpoint User Guide

brand
Analytical Ecosystem
prodname
Teradata Viewpoint
Teradata Workload Management
vrm_release
16.20
category
User Guide
featnum
B035-2206-107K
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.