Once Linux, UNIX and Windows source and target systems and datastores have been identified, the configuration of the Capture Agents, Apply Engines and their Controller Daemon's can begin. That will require the creation of directories and files for variable portions of the configuration. At this point, we assume the base Connect CDC SQData product has already been installed according to the instructions. The recommended location and Environment Variable values for this static data were:
/opt/sqdata or
/home/<sqdata_user>/sqdataIf an Environment Variable will be used to reference the installation location, the recommended value is:
<SQDATA_DIR>
Controller Daemons, Capture Agents and Engines require the creation of directories and files for variable portions of their configurations. Just as the location of the base product installation can be modified, the location of variable directories can be adjusted conform to the operating system and to accommodate areas of responsibility, including the associated "application" and "environments" such as Test and Production. This document will refer to the location most commonly used on Linux, AIX and Windows:
/var/opt/sqdata[/<application>[/<environment>]] or
/home/<sqdata_user>[/<application>[/<environment>]] or simply
/home/sqdata[/<application>[/<environment>]]If an Environment Variable will be used to reference the location of variable portions of the configuration, the recommended value is:
<SQDATA_VAR_DIR>
While only the base variable directory is required and the location of the daemon directory is optional, we recommend the structure described below:
<SQDATA_VAR_DIR>/daemon- The working directory used by the Daemon that also contains two sub directories.<SQDATA_VAR_DIR>/daemon/cfg- A configuration directory that contains two configuration files.<SQDATA_VAR_DIR>/daemon/logs- A logs directory, though not required, is suggested to store log files used by the controller daemon. Its suggested location below must match the file locations specified in the Global section of the sqdagents.cfg file created in the section "Setup Controller Daemon" later in this document.
Additional directories should be created for each Capture agent running on the system. Precisely recommend the structures described below:
<SQDATA_VAR_DIR>/<type>cdc- The working directory of each capture agent where type might be ORA (Oracle), UDB (Db2/LUW).<SQDATA_VAR_DIR>/<type>cdc/data- A data directory is also required by each Capture agents. Files will be allocated in this directory as needed by the CDCStore Storage Agent when transient data exceeds allocated in-memory storage. The suggested location below must match the "data_path" specified in the Storage agent configuration (.cab file) described in the Capture References. A dedicated File System is required in production with this directory as the "mount point".
Example:
The following commands will create the directories described above:
$ mkdir -p <SQDATA_VAR_DIR>/daemon --mode=775
$ mkdir -p <SQDATA_VAR_DIR>/daemon/cfg --mode=775
$ mkdir -p <SQDATA_VAR_DIR>/daemon/log --mode=775
$ mkdir -p <SQDATA_VAR_DIR>/<type>cdc --mode=775
$ mkdir -p <SQDATA_VAR_DIR>/<type>cdc/data --mode=775Note: The User-ID(s) under which the Capture and Engine agents and the Controller Daemon will run must be authorized for Read/Write access to these directories.