Purpose
Determines the amount of time that elapses between WAL checkpoints.
Field Group
File System
Valid Range
1 through 240 seconds
Default
60 seconds
Changes Take Effect
After the DBS Control Record has been written.
Usage Notes
A WAL checkpoint is used to indicate the oldest part of the WAL log that must be scanned when recovering from a system crash. It differentiates the WAL log records that have been written to disk from the records that must be applied during system recovery. The checkpoint is used as the starting point for the Redo forward scan of the WAL log during recovery.