Database Administrator's Guide

PREIMAGE_DUMP

PREIMAGE_DUMP <YES | NO>

When enabled, all PREIMG files, even those not in a dynamic dump, are temporarily changed to TRNLOG files to be compatible with the upgraded transactions, and all transactions are automatically changed from PREIMG mode to TRNLOG mode during the dump. PREIMG files opened or created in the middle of the dump are also temporarily promoted from PREIMG files to TRNLOG files. All promoted files are restored to their PREIMG status at the conclusion of the dynamic dump.

The dynamic dump script file accepts a !DELAY parameter whose argument is the number of seconds to wait for a transaction to complete before aborting it in order to permit the start of a dynamic dump. When the PREIMAGE_DUMP facility is used, the !DELAY parameter is effectively ignored if a long PREIMG transaction begins prior to the dynamic dump. This means the dump will not begin until all current transactions complete. See Dynamic Dump and Advanced - Faster Auto-Recovery for additional information.

Default: NO