Setting up enterprise replication for a test
Posted in 2025
Topics: High Availability & Replication
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.
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 ------------------------------
Thank you, Andreas!