16.20 - AFTER JOURNAL - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Data Definition Language Syntax and Examples

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Language
English (United States)
Last Update
2019-05-24
dita:mapPath
wkf1512081455740.ditamap
dita:ditavalPath
TD_DBS_16_20_Update1.ditaval

Type of image to be maintained by default for data tables created in the new database. The JOURNAL keyword without AFTER implies BEFORE and AFTER images.

If only AFTER JOURNAL is specified, then a before change image is not maintained. If both types are specified, the two specifications must not conflict.

You can override this setting for individual tables when the table is created. See CREATE TABLE.

DUAL
If journaling is specified, a DUAL journal is maintained for data tables with FALLBACK protection.
LOCAL
Single after-image journal rows for non-fallback data tables are written on the same virtual AMP as the changed data rows. See the CREATE DATABASE “Local Journaling” topic in Teradata Vantage™ SQL Data Definition Language Detailed Topics , B035-1184 .
NOT LOCAL
Single after-image journal rows for non-fallback data tables are written on another virtual AMP in the cluster than the changed data rows.
NO
The default is no journaling.