Once the CDCStore configuration (.cab) file has been created, SQDCONF utility is used to Mount, Apply and Start the Log Reader Capture Agent process.
Example
$ sqdconf mount <SQDATA_VAR_DIR>/udbcdc/udbcdc.cab
$ sqdconf apply <SQDATA_VAR_DIR>/udbcdc/udbcdc.cab
$ sqdconf start <SQDATA_VAR_DIR>/udbcdc/udbcdc.cab Note:
- A shell script is commonly created containing commands for this purpose.
- The sqdconf utility is used to create the Capture Agent configuration and perform most of the other management and control tasks associated with Agents including the function of the MOUNT command.
- The first time this command script is run you may choose to include both the sqdconf apply and sqdconf start commands in the shell script. After the initial creation, apply should not be used in this script, unless all changes made since the agent was last Stopped are intended to take effect immediately upon the Start. The purpose of apply is to make it possible to add/modify the configuration while preparing for an implementation of changes without affecting the current configuration. Apply and start can and frequently will be separated into different SQDCONF shell scripts.
- The Controller Daemon uses a Public / Private key mechanism to ensure component communications are valid and secure. While it is critical to use unique key pairs when communicating between platforms, it is common to use the same key pair for components running together on the same platform. Consequently, the key pair used by a Log Reader Capture agent may be the same pair used by its Controller Daemon.
- It may be desirable to substitute the following mount statement for the standard one above to separate RDBMS error message from other output from the capture:
sqdconfmount <SQDATA_VAR_DIR>/udbcdc/udbcdc.cab --log-level=2 >> sqdudbc.output 2>&1