Product Documentation

Database Administrator's Guide

Previous Topic

Next Topic

Configuration Flexibility with Environment Variables

FairCom DB allows many of its configuration options to include an environment variable name that will be substituted with its value when the configuration file is read. For example, on Windows an administrator might want to set the FairCom DB data directory based on the PROGRAMDATA environment variable:

LOCAL_DIRECTORY %PROGRAMDATA%\FairCom\V*\bin\ace\sql\data

In this example, %PROGRAMDATA% is replaced with the value of the PROGRAMDATA environment variable (according to the environment variables that are defined in the logon session in which FairCom DB is running).

If you want to specify a literal % sign that is not treated as part of an environment variable name, use %%. For example, if you want to specify a value of ABC%DEF, specify it as ABC%%DEF. A literal % sign cannot be used in an environment variable name; it always signifies the end of the environment variable name. For example, %MY%%VAR% is treated as two environment variables, MY and VAR, rather than one variable named MY%VAR.

The following configuration options support this feature:

  • ADMIN_MIRROR
  • BROADCAST_DATA
  • CTSRVR_CFG
  • DISK_FULL_ACTION
  • DISK_FULL_VOLUME
  • DYNAMIC_DUMP
  • KEY_EXCHANGE_PARAMS
  • LOCAL_DIRECTORY
  • LOG_EVEN
  • LOG_EVEN_MIRROR
  • LOG_ODD
  • LOG_ODD_MIRROR
  • MASTER_KEY_FILE
  • MIRROR_DIRECTORY
  • NULL_STRING
  • PREIMAGE_FILE
  • SERVER_DIRECTORY (deprecated)
  • SHMEM_DIRECTORY
  • SIGNAL_DOWN
  • SIGNAL_MIRROR_EVENT
  • SIGNAL_READY
  • SIGNAL_USER_DOWN
  • SIGNAL_USER_READY
  • SQL_LOGFILE
  • START_EVEN
  • START_EVEN_MIRROR
  • START_ODD
  • START_ODD_MIRROR
  • TMPNAME_PATH

TOCIndex