Product Documentation

FairCom DB Configuration OptionsTransaction ProcessingCHECK_SYSTEM_FILEID

Database Administrator's Guide

Previous Topic

Next Topic

CHECK_SYSTEM_FILEID

CHECK_SYSTEM_FILEID <YES/NO>

CHECK_SYSTEM_FILEID YES is intended to distinguish different filesystem-level copies of files and prevent transaction recovery from applying corrections to an incorrect copy of a data or index file following a crash. Operation sequences are as follows:

  1. update A.dat
  2. close A.dat
  3. Filesystem level copy A.dat to B.dat
  4. update B.dat

These sequences are vulnerable to recovery errors if CHECK_SYSTEM_FILEID NO is disabled.
Some distributed file systems or containerized environments do not provide a stable device or inode id and will result in additional CTSTATUS.FCS messages like "reassigning file ID (sysid changed)..." when opening a file, even if the file has not been copied.

Default: Yes

TOCIndex