Documentation

Database Administrator's Guide

Previous Topic

Next Topic

CHKPDFC_LOG_LIMIT

CHKPDFC_LOG_LIMIT <max logs w/o checkpoint>

Ordinarily, several checkpoints are expected within each FairCom DB Server transaction log file and the FairCom DB Server would terminate with error CHKP_ERR (529) when two consecutive log files without these checkpoints were encountered. The FairCom DB Server has been modified with respect to this absence of checkpoints. This keyword permits additional log files to be written without checkpoints. A short wait is introduced for each non-checkpoint log write, allowing a checkpoint to occur and resolving any possible race conditions.

CHKPDFC_LOG_LIMIT specifies how many consecutive logs may be processed without a checkpoint until the FairCom DB Server terminates. The default number of transaction logs is five log files and this may be lowered to as few as four log files or raised to any reasonable limit.

Once the checkpoint deficiency reaches two logs, the first write of each transaction commit to the transaction logs is slightly deferred. This improves the chances that the FairCom DB Server checkpoint thread is allotted a slice of time. Once the checkpoint is eventually written, this write log defer is removed.

TOCIndex