Apply configuration file changes - 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 again, changes made to the Agent Configuration (.cab) file are not effective until they are applied. For example, let us imagine that the new Oracle tables will be rolled out next weekend:

If changes were effective immediately or automatically at the next start, then these changes could not be performed until the production capture is stopped for the migration during the weekend. Otherwise, the risk exists that the capture agent may go down for unrelated production issues, and the new change would be activated prematurely.

Forcing a distinct and explicit apply step, insures that such changes can be planned and prepared in advance, without putting the current production replication in jeopardy. This allows capture agent maintenance to be done outside of the critical upgrade path.

In order to apply changes, the agent must first be stopped. This operation in effect pauses the agent task and permits the additions and/or modifications to the configuration to be applied. Once the agent is restarted, the updated configuration will be active.
$ sqdconf stop /<SQDATA_VAR_DIR>/oracdc1/oracdc1.cab
$ sqdconf apply /<SQDATA_VAR_DIR>/oracdc1/oracdc1.cab
$ sqdconf start /<SQDATA_VAR_DIR>/oracdc1/oracdc1.cab