15.10 - AFTER JOURNAL - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

prodname
Teradata Database
vrm_release
15.10
created_date
December 2015
category
Programming Reference
featnum
B035-1144-151K

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 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.