A new default for duplicate copy protection of each data table subsequently created in the database. The current fallback setting for existing data tables remains unchanged.
- PROTECTION
- Optional keyword that you can specify with FALLBACK. The FALLBACK keyword used alone implies PROTECTION.
- NO
- Sets the default to not provide duplicate copy protection for data tables created in the database.You cannot use the NO FALLBACK option and the NO FALLBACK default on platforms optimized for fallback.
Example: Change fallback protection and space allocation options
Change fallback protection and space allocation options on the finance database as follows.
MODIFY DATABASE finance AS PERM = 75000000, SPOOL = 150000000, NO FALLBACK, DROP DEFAULT JOURNAL TABLE = finance.journals;