16.10 - Working with Transaction Rollbacks - Teradata Database

Teradata Database Administration

Product
Teradata Database
Release Number
16.10
Release Date
April 2018
Content Type
Administration
Publication ID
B035-1093-161K
Language
English (United States)

A rollback is a reversal of an incomplete database transaction due to problems. A transaction may fail to complete and be aborted due to:

  • A deadlocked query
  • A database restart
  • An ABORT SESSION command

The rollback removes any partially completed database updates from the affected user tables. The system uses the TJ (dbc.transientjournal), which contains data about incomplete transactions, including a “before image” of each modified table row, to maintain data integrity.

Also see the rollback topics in Archiving, Restoring, and Recovering Data: Operational DBAs.