For Teradata Aster systems, you can abort a non-idle process that is blocking other processes or consuming too many resources.
-
From the Viewpoint Dashboard, do any of the following:
The query details view appears.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.
- Click any state in the Queries state filter bar.
-
Do one of the following:
Option Description Abort a single process - Click
to the right of the session number and select Abort Process. - Click Next.
Abort multiple processes - From the Table Actions menu, select Abort Process.
Check boxes appear next to the session ID.
-
Do one of the following:
- Select the first check box located in the column heading to select all processes.
- Select the check boxes for specific processes.
- Click
- Click Next.
- Log in to Teradata Aster, if prompted.
- Click Next to confirm you want to abort the processes. A confirmation appears indicating the abort process was successfully submitted.
- Click OK.