Restoring a Teradata Database After a Failed ABORT Request - Basic Teradata Query - 16.20

Basic Teradata Query Reference

Basic Teradata Query
Programming Reference

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 a Teradata SQL ABORT statement as a normal Teradata 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.