Documentation

Database Administrator's Guide

Previous Topic

Next Topic

CHECKPOINT_FLUSH

CHECKPOINT_FLUSH <# of checkpoints>

This keyword sets the maximum number of checkpoints to be written before a buffer (data or index) holding an image for a transaction controlled file will be flushed. The default value is 2. A value of zero causes the buffer to be flushed at least by the occurrence of the first checkpoint written after the buffer update. Reducing the value of this system parameter reduces the amount of buffering, slowing system performance, but decreases the amount of work to be performed during recovery.

Note: Enabling background transaction flush threads disables this checkpoint flush operation.

Default: 17

See Also

CHECKPOINT_INTERVAL

TRAN_DATA_FLUSH_SEC

TRAN_INDEX_FLUSH_SEC

TOCIndex