15.00 - 15.10 - Journaling - Teradata Database

Teradata Database Introduction to Teradata

Product
Teradata Database
Release Number
15.00
15.10
Content Type
User Guide
Publication ID
B035-1091-151K
Language
English (United States)
Last Update
2018-09-25

Teradata Database supports tables that are devoted to journaling. A journal is a record of some kind of activity. Teradata Database supports several kinds of journaling. The system does some journaling on its own, while you can specify whether to perform other journaling.

The following table explains the capabilities of the different Teradata Database journals.

 

This type of journal…

Does the following…

And Occurs …

Down AMP recovery

  • Is active during an AMP failure only
  • Journals fallback tables only
  • Is used to recover the AMP after the AMP is repaired, then is discarded
  • always.

    Transient

  • Logs BEFORE images for transactions
  • Is used by system to roll back failed transactions aborted either by the user or by the system
  • Captures:
  • Begin/End Transaction indicators
  • Before row images for UPDATE and DELETE statements
  • Row IDs for INSERT statements
  • Control records for CREATE, DROP, DELETE, and ALTER statements
  • Keeps each image on the same AMP as the row it describes
  • Discards images when the transaction or rollback completes
  • always.

    Permanent

  • Is available for tables or databases
  • Can contain before images, which permit rollback, or after images, which permit rollforward, or both before and after images
  • Provides rollforward recovery
  • Provides rollback recovery
  • Provides full recovery of nonfallback tables
  • Reduces need for frequent, full-table archives
  • as specified by the user.