The JOURNAL keyword without NO or DUAL implies single copy journaling.
The JOURNAL keyword without BEFORE implies both types (BEFORE and AFTER) of images.
Journal options are not supported for tables with row sizes greater than 64KB.
- BEFORE
- A before change image is maintained.
- DUAL
- Number of before change images to be maintained by default for each data table created in the new database.
- NO
- No journaling.