17.10 - Transaction Recovery Sequence - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Database Utilities

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Configuration
Publication ID
B035-1102-171K
Language
English (United States)

The general sequence of a Teradata system recovery is as follows:

  1. The status of each transaction on each online AMP is determined by the Teradata system.

    All of the online AMPs at the time of the restart work together to determine which transactions were complete, and which ones were not completed. Completed transactions are ignored and incomplete ones are backed out. The process of rolling back incomplete transactions might take some time.

    Write and exclusive locks are set against all data modified by incomplete transaction.

  2. All locks needed for the recovery are set, and the Teradata system begins rollback or completion of the transactions.
  3. The Teradata system accepts work and is operational.
    If new transactions reference the inconsistent data of to-be-rolled-back transactions, they are blocked until the recovery process restores the data and releases the lock.
  4. Down AMP recovery begins.