Aborting 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 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.