Product Documentation

Database Administrator's Guide

Previous Topic

Next Topic

FairCom DB Server Configuration Recommendations

The following options can be defined in the FairCom DB Server configuration file ctsrvr.cfg and should be taken into consideration for all new and existing FairCom DB customers:

In This Section

SKIP_MISSING_FILES

KEEP_LOGS

FORCE_LOGIDX

Previous Topic

Next Topic

SKIP_MISSING_FILES

Do not operate with SKIP_MISSING_FILES enabled in the ctsrvr.cfg configuration file by default. This configuration may cause files to be inadvertently skipped during recovery, making it difficult to restore the database back to a consistent state. This keyword should only be utilized when confirmed necessary (by reviewing specific error messages in the CTSTATUS.FCS status log file), and then promptly removing it. (Commenting the keyword in the configuration file is suggested, as it is then readily available if absolutely needed.)

Previous Topic

Next Topic

KEEP_LOGS

To take fullest advantage of FairCom DB’s recovery options, it is advisable to keep as many transaction logs as practical — up through the last two backups, if possible. The FairCom DB restore process can start with an existing backup and roll forward through remaining logs if available, restoring data to the latest possible time point.

Previous Topic

Next Topic

FORCE_LOGIDX

FairCom has a feature that reduces the amount of time it takes for automatic recovery to complete, especially in systems with high transaction rates. By adding the keyword FORCE_LOGIDX ON to your ctsrvr.cfg file, FairCom DB will store a few additional bytes of information per index node within the FairCom DB transaction logs, which will greatly reduce the amount of time automatic recovery will take. There is no performance loss with the production system for enabling this feature and you do not need to rebuild indexes to enable this feature.

FORCE_LOGIDX supports these settings:

  • ON forces all indexes to use LOGIDX entries.
  • OFF forces all indexes not to use LOGIDX entries.
  • NO uses existing file modes to control LOGIDX entries.

Note: LOGIDX is ON by default with FairCom DB V9.2 and later.

TOCIndex