Aborting Teradata Database Transactions - Advanced SQL Engine - Teradata Database

Database Utilities

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
Published
June 2020
Language
English (United States)
Last Update
2020-06-15
dita:mapPath
boh1556732696163.ditamap
dita:ditavalPath
lze1555437562152.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.