Add engine controller daemon - 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 updated
2024-11-25
Published on
2024-11-25T15:05:48.570404

The Controller Daemon, SQDaemon plays a key role in the authentication process by being the first point of contact for any agent requesting communication with any other agent in both single and multi-platform environments. Controller Daemons are accessed via a TCP/IP interface to an assigned Port on the platform where they are running. Their symbolic name is often synonymous with a specific Host (platform or Environment on which they are running).

The primary difference between an Engine Controller Daemon and a Daemon on Capture platforms is that the Authorized Key File of the Engine Controller Daemon need only contain the Public keys of SQDmon utility users on both the local and remote platforms.

Setup and configuration of the Engine Controller Daemon, SQDaemon, includes:

# Task Utility
  Configure Engine Daemon
1 Reserve TCP/IP port for Engine Daemon N/A
2 Generate Engine public / private keys SQDUTIL
3 Add the public key generated in step #2 to the Authorized Key List files on the Source system and target system N/A
4 Create the Access Control List Configuration N/A
5 Create the Agent Configuration File N/A
6 Prepare the Controller Daemon JCL, shell or batch script N/A
  Engine Environment Preparation Complete

Example

A sample sqdagent.cfg file for a Controller Daemon containing the Engine ORATOSQL follows. Changes are not known to the daemon until the configuration file is reloaded, using SQDMON, or the sqdaemon process is stopped and started.
acl=<SQDATA_VAR_DIR>/daemon/cfg/acl.cfg
authorized_keys=<SQDATA_VAR_DIR>/daemon/nacl_auth_keys
identity=<SQDATA_VAR_DIR>/id_nacl
message_file=../logs/daemon.log
service=2626
[ORATOSQL]
type=engine
program=SQDATA
args=ORATOSQL.prc
working_directory=<SQDATA_VAR_DIR>
message=<SQDATA_VAR_DIR>
stderr_file=<SQDATA_VAR_DIR>/ORATOSQL.rpt
stdout_file=<SQDATA_VAR_DIR>/ORATOSQL.rpt
auto_start=yes