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 and CREATE TABLE … AS.
- If journaling is specified, a DUAL journal is maintained for data tables with FALLBACK protection.
- 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.
- The default is no journaling.