I installed the product below and tested the connection to the Informix database.
IBM InfoSphere Data Replication v10.2.1 Change Data Capture for Informix for Windows x86 Multilingual (CIIV0ML)
Connection Manager settings are as follows. There are two Connection Manager processes on the same host.
<cm1>
[informix@db1 etc]$ cat cm1.cfg
NAME cm1
LOGFILE ${INFORMIXDIR}/tmp/cm1.log
DEBUG 0
CLUSTER db_98c
{
INFORMIXSERVER db_98,db_97
SLA sla_primary_1 DBSERVERS=primary
FOC ORDER=ENABLED PRIORITY=1
CMALARMPROGRAM ${INFORMIXDIR}/etc/cmalarmprogram.sh
}
[informix@db1 etc]$ cat sqlhosts
g_primary group - - c=1,e=sla_primary_2
sla_primary_1 onsoctcp xxx.xx.xx.14 53311 g=g_primary
sla_primary_2 onsoctcp xxx.xx.xx.14 53312 g=g_primary
db_98 onsoctcp xxx.xx.xx.15 53331
db_97 onsoctcp xxx.xx.xx.15 53332
<cm2>
[informix@db1 etc]$ cat cm2.cfg
NAME cm2
LOGFILE ${INFORMIXDIR}/tmp/cm2.log
CLUSTER db_98c
{
INFORMIXSERVER db_98,db_97
SLA sla_primary_2 DBSERVERS=primary
FOC ORDER=ENABLED PRIORITY=2
CMALARMPROGRAM ${INFORMIXDIR}/etc/cmalarmprogram.sh
}
The sqlhosts file refers to the same file as cm1.
It works well with the SLA name and port.
I hope my test helps.------------------------------
SangGyu Jeong
Software Engineer
Infrasoft
Seoul Korea, Republic of
------------------------------
Original Message:
Sent: Mon April 06, 2020 05:43 AM
From: Neville Monteiro
Subject: Informix Change Data Capture v.10.2 and Informix Connection Manager
Dear all,
Trying to configure Informix CDC which will connect to the Informix Connection Manager and then the Informix Connection Manager will redirect this clients connection request to the "AVAILABLE" PRIMARY Informix Database Server.
For this, just wanted to know if Informix CDC v.10.2 supports Informix Connection Manager or not ?
------------------------------
Neville Monteiro
------------------------------
#DataIntegration
#DataReplication