Create variable directories - connect_cdc_sqdata - Latest

Connect CDC (SQData) Change Data Capture
Product type
Software
Portfolio
Integrate
Product family
Connect
Product
Connect > Connect CDC (SQData)
Version
Latest
Language
English
Product name
Connect CDC (SQData)
Title
Connect CDC (SQData) Change Data Capture
Copyright
2024
First publish date
2000
Last edition
2024-09-13
Last publish date
2024-09-13T19:10:49.846957
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. The recommended location and environment variable values for this static data were:
/opt/sqdata or 
/home/<sqdata_user>/sqdata

If 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:

Directories Description
<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.

Additional directories should be created for each Capture agent running on the system. Precisely recommend the structures described below:

Directories Description
<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=775
Note: 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.