17.10 - Aborting a Query or Session - Teradata Viewpoint - Teradata Workload Management

Teradata® Viewpoint User Guide

Teradata Viewpoint
Teradata Workload Management
Release Number
Release Date
October 2021
Content Type
User Guide
Publication ID
English (United States)
For Teradata Database systems, you can abort a query or session that is blocking other queries or consuming too many resources.
  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 session number of the query you want to abort appears in the details view.
  2. Click to the right of the session number and select Abort.
  3. Log in to Teradata Database, if prompted.
  4. Click Next.
  5. Select one of the following:
    • Abort Query to abort the selected query.
    • Abort Session to abort the selected query and log out of the session.
  6. Click Next.
  7. Click Next to confirm your selection.
  8. Click OK.