Data Replication

Expand all | Collapse all

Informix Change Data Capture v.10.2 and Informix Connection Manager

  • 1.  Informix Change Data Capture v.10.2 and Informix Connection Manager

    Posted Mon April 06, 2020 05:44 AM
    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
    ------------------------------


  • 2.  RE: Informix Change Data Capture v.10.2 and Informix Connection Manager

    Posted Wed April 08, 2020 11:27 AM
    IBM Data Replication (IDR) Change Data Capture (CDC) for Informix is documented here:
    https://www.ibm.com/support/knowledgecenter/en/SSTRGZ_11.3.3/com.ibm.cdcdoc.cdcforinformix.doc/concepts/understandinghowcdcinteractswithyourdatabase.html

    IDR CDC is a product which replicates from many different databases (Db2, Informix, Oracle, SQL Server, PostgreSQL, MySQL, ...) to target systems like Kafka or databases or Hadoop or other systems.
    https://www.ibm.com/analytics/data-replication

    However, it appears you may be asking about the Informix database CDC interface:
    https://www.ibm.com/support/knowledgecenter/SSGU8G_14.1.0/com.ibm.cdc.doc/ids_cdc_057.htm

    If so, the Informix forum is here:
    https://community.ibm.com/community/user/hybriddatamanagement/communities/community-home/digestviewer?communitykey=cf5a1f39-c21f-4bc4-9ec2-7ca108f0a365&tab=digestviewer

    If not, please do advise and the IBM CDC team will help.

    ------------------------------
    Glenn Steffler
    ------------------------------



  • 3.  RE: Informix Change Data Capture v.10.2 and Informix Connection Manager

    Posted Tue April 14, 2020 03:32 AM
    Hi Neville,
    Since the Connection Manager serves to route the client's connection path, the CDC can of course be accessed as Informix through the Connection Manager.
    In addition, the version of Informix supported by the CDC API may require verification.

    ------------------------------
    SangGyu Jeong
    Software Engineer
    Infrasoft
    Seoul Korea, Republic of
    ------------------------------



  • 4.  RE: Informix Change Data Capture v.10.2 and Informix Connection Manager

    Posted Wed April 15, 2020 10:19 PM
    Edited by SangGyu Jeong Wed April 15, 2020 10:24 PM
    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.


    However, since the port must be entered, the garbage value was entered in the port, and the SQLH_FILE and SQLH_TYPE jdbc properties were added in the advanced settings, but the connection also failed.
    https://www.ibm.com/support/pages/how-configure-informix-jdbc-connection-string-connect-group

    I don't know any other way to connect as a group.
    And according to the manual, the 'Informix Server' column tells you to use the DBSERVERNAME setting. Even if you ignore and connect with SLA, metadata has been created in informix schema.
    https://www.ibm.com/support/knowledgecenter/en/SSTRGZ_10.2.1/com.ibm.cdcdoc.cdcforinformix.doc/tasks/addanewinstance_windows.html


    I hope my test helps.


    ------------------------------
    SangGyu Jeong
    Software Engineer
    Infrasoft
    Seoul Korea, Republic of
    ------------------------------



  • 5.  RE: Informix Change Data Capture v.10.2 and Informix Connection Manager

    Posted Thu April 16, 2020 10:04 AM
    Hi Neville and SangGyu,

    Support for Informix High Availability that uses a connection manager was added to version 11.3.3, therefore I don't think that you will be able to connect using version 10.2. In version 11.3.3 the instance configuration menu has been changed to allow you to use the connection manager group name and SQL hosts file.

    Hope this helps.
    Edvin

    ------------------------------
    EDVIN VITO
    ------------------------------



  • 6.  RE: Informix Change Data Capture v.10.2 and Informix Connection Manager

    Posted Thu April 16, 2020 11:10 AM
    @EDVIN VITO
    Thank you for the information. From version 11.3.3, CM Group Name can be assigned!
    https://www.ibm.com/support/knowledgecenter/en/SSTRGZ_11.3.3/com.ibm.cdcdoc.cdcforinformix.doc/tasks/addanewinstance_windows.html

    ------------------------------
    SangGyu Jeong
    Software Engineer
    Infrasoft
    Seoul Korea, Republic of
    ------------------------------