How to Restore a Database After a Failed ABORT Request | Basic Teradata Query - 17.00 - Restoring a Database After a Failed ABORT Request - Basic Teradata Query

Basic Teradata® Query Reference

prodname
Basic Teradata Query
vrm_release
17.00
created_date
June 2020
category
Programming Reference
featnum
B035-2414-220K
If the request did not affect the database, or if the affect was not damaging, then the impact of a failed abort request is minimal. If the request damaged the database, then correct the damage using one of the following options:
  • If the request was embedded in a transaction, abort the transaction by submitting an SQL ABORT statement as a normal SQL request, which backs out the effect of the damaging request.
  • If the request was not embedded in a transaction, submit a second request that has the opposite effect of the first, thus returning the database to its state before the damaging request.