16.20 - Specifying Data Protection - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Data Definition Language Detailed Topics

Teradata Database
Teradata Vantage NewSQL Engine
Release Number
March 2019
Content Type
Programming Reference
Publication ID
English (United States)

Specific protection for the data in a table is provided by the FALLBACK, JOURNAL, and CHECKSUM options.

FALLBACK causes a duplicate, or fallback, copy to be maintained by Teradata Database. The fallback copy is used if the primary copy becomes unavailable.

JOURNAL provides data protection through system-generated BEFORE- and AFTER-journals that contain the before and after images of data that changes as a result of any INSERT, UPDATE, or DELETE operations.

These journals are used by Teradata Database either to restore a table or to roll back the changes that were made to a table.

The CHECKSUM option provides disk I/O integrity checking of primary table data rows, fallback table data rows, and secondary index subtable rows.