Aborting Teradata Database Transactions - Advanced SQL Engine - Teradata Database

Database Utilities

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
Published
January 2021
Language
English (United States)
Last Update
2021-01-23
dita:mapPath
ynh1604715438919.ditamap
dita:ditavalPath
hoy1596145193032.ditaval
dita:id
B035-1102
lifecycle
previous
Product Category
Teradata Vantageā„¢

To abort all Teradata Database transactions for a particular host, after starting aborthost type the following and press Enter:

ABORT HOST  nnn

where nnn is the identifier of the host that originated the database transactions you want to abort.

For logon and start requests to a host that has been aborted in this manner, the system displays this error message:

Host quiesced by operator

After running Abort Host, the only way to re-establish host communication with the Teradata Database is to restart the appropriate TDP.