For Teradata Database systems, you can abort a query or session that is blocking other queries or consuming too many resources.
-
From the Viewpoint Dashboard, do any of the following:
Option Description Queries filtered by state - Click any state in the Queries state filter bar.
The query results that display are filtered based on what you selected.
- Click the row in the table for the session you want to see.
Top 5 queries - Click any row under Top 5 Queries.
The session number of the query you want to abort appears in the details view. - Click any state in the Queries state filter bar.
-
Click
to the right of the session number and select Abort.
- Log in to Teradata Database, if prompted.
- Click Next.
-
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.
- Click Next.
- Click Next to confirm your selection.
- Click OK.