The type of permanent journal image to maintain for the table. Any existing images are not affected until the table is updated.
If you specify the JOURNAL keyword without also specifying NO or DUAL, Vantage maintains a single copy of the image unless FALLBACK is in effect or is also specified.
If you specify journaling for a database that uses fallback protection by default, Vantage maintains DUAL images.
You cannot add or modify journal options for an nonpartitioned NoPI table or for a column-partitioned table.
- NO
- After-change images are not maintained for the table.
- DUAL
- Two after-change images are maintained for the table.
- LOCAL
- 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 compute cluster.