Informix

Informix

Connect with Db2, Informix, Netezza, open source, and other data experts to gain value from your data, share insights, and solve problems.

 View Only
  • 1.  Setting up enterprise replication for a test

    Posted Tue January 14, 2025 11:33 AM

    I am trying to set up enterprise replication between a source machine named ezri and a destination machine named tpol. When I run the "cdr list server" command tpol, this is what I see:

    SERVER ID STATE STATUS QUEUE CONNECTION CHANGED
    -----------------------------------------------------------------------
    g_ezri 1 Active Disconnect 0 Jan 5 09:56:38
    g_tpol 2 Active Local 0


    These two databases are supposed to have different ID numbers (e.g., 1 and 2), correct?

    When I run the "cdr list server" command ezri, this is what I see:

    -> cdr list server
    SERVER ID STATE STATUS QUEUE CONNECTION CHANGED
    -----------------------------------------------------------------------
    g_ezri 1 Active Local 0


    So, in other words, I'm not seeing a line for "g_tpol" when I run this command on ezri.

    This is the command I ran on ezri initially :

    cdr define server -A /workspace/informix/ats -R /workspace/informix/ris -I g_ezri

    This is the command I ran on tpol:

    cdr define server -A /workspace/informix/ats -R /workspace/informix/ris -I g_ezri -S g_tpol

    I'm wondering if I should have run this command on tpol instead:

    cdr define server -A /workspace/informix/ats -R /workspace/informix/ris -I g_tpol -S g_ezri

     

    According to the documentation, the –I is for Adds server_group to the replication domain" and the –S is for "Adds a server to the existing domain of which the sync_server is a member. Uses the global catalog on sync_server as the template for the global catalog on the new replication server, server_group. For Hierarchical Routing topologies, Enterprise Replication also uses the sync_server as the parent of the new server in the current topology."

    I'm wondering if I need to run a "cdr disconnect server" or "cdr delete server" command or do something else to fix the problem if the command I used on the tpol machine was incorrect. I am also wondering if the command I ran on the ezri machine was correct.

     

    image001.png@01DA3FB5.4B40F670

    John Dargan

    Database Administrator III

    LAURA E. ROTH, Clerk of the Circuit Court

    Seventh Circuit, Volusia County, Florida

    Phone: 386-785-9106

     

     



  • 2.  RE: Setting up enterprise replication for a test

    Posted Tue January 14, 2025 11:43 AM

    Hi John,

    you're wondering correctly.

    To throw everything over again:

    • on ezri:   cdr del ser g_ezri
    • on tpol:  cdr del ser g_tpol

    Then, to redifine properly:

    • on ezri:  cdr def ser g_ezri -I
    • on tpol:  cdr def ser g_tpol -I -S g_ezri

    (I omitted -A and -R options for clarity, readd them for your environment.)



    ------------------------------
    Andreas Legner
    Informix Dev
    HCL Software
    ------------------------------



  • 3.  RE: Setting up enterprise replication for a test

    Posted Tue January 14, 2025 12:13 PM

    Thank you, Andreas!