After-image journal rows are maintained by default for data tables created in the new user.
A user can contain only one journal table.
The default is no journaling.
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.
This setting can be overridden for a particular data table when the table is created (see CREATE TABLE and CREATE TABLE AS).
Specifying the JOURNAL keyword without also specifying either NO or DUAL implies single copy journaling.
If journaling is specified, a DUAL journal is maintained for data tables with FALLBACK protection.
The JOURNAL keyword without AFTER implies both types (BEFORE and AFTER) of images.
- After-image journal rows are not maintained by default for data tables created in the new user.
- Dual after-image journal rows for non-fallback data tables are maintained.
- Single after-image journal rows for non-fallback data tables are written on the same virtual AMP as the changed data rows.
- NOT LOCAL
- Single after-image journal rows for non-fallback data tables are written on another virtual AMP in the cluster.