16.10 - Online Transaction Recovery - Teradata Database

Teradata Database Utilities

Product
Teradata Database
Release Number
16.10
Published
June 2017
Language
English (United States)
Last Update
2018-04-26
dita:mapPath
zll1480972831047.ditamap
dita:ditavalPath
changebar_rev_16_10_exclude_audience_ie.ditaval

Online transaction recovery is automatically invoked by a Teradata Database system restart and includes the following processes:

  • Rolling back transactions that were not completed at the time of the crash or restart
  • Completing transactions that were committed

Changes made to underlying data by transactions are recorded in the Transient Journal (TJ). AMPs keep track of transactions in progress using the TJ which is stored on each AMP’s disk.

IF... THEN...
all the modification operations successfully complete on all the AMPs working on behalf of the transaction that transaction is successful and there is no further concern for recovery of that transaction.
a transaction does not complete due to a Teradata Database system crash or forced restart those transactions are backed out as part of the Teradata Database system recovery process when the Teradata Database system restarts.