Enterprise replication replicating instance on sam
User on IDS 11.50.FC6 wanted Enterprise Replication (update-anywhere) from one instance to a second instance on the same physical box, in addition to an existing cross-server replicate. Attempts to 'cdr define server' failed because the server was already defined, and adding the participant to a replicate gave "undefined server (37)". Madison explained that 'cdr define server' only builds the ER domain/topology while 'cdr define/change replicate' sets the endpoints, suggesting templates or 'cdr change replicate --add' plus 'cdr start replicate'. The real cause turned out to be that the two instances belonged to two separate ER domains, and Madison confirmed there is no way to merge distinct domains, so the goal was not achieved.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
hello folks IBM Informix Dynamic Server Version 11.50.FC6 Using enterprise replication update anywhere conflict resolution Looking for some advice on the following. I have two servers running replication fine replicating between phyical servers wuast130 and auast120. on server wuast130 I want to be able to replicate two instances. So in effect I want to replicate to instance on auast120 and instance on wuast130 as well from one instance on wuast130. Can this be done ? What i use to define the two servers is below ## physical server names Wuast130 auast120 cdr define server -I -S res_uat_rep_wlg -A $ATSDIR -R $ATSDIR res_uat_rep_akl works fine on wuast130 I tried to add server instance as below cdr define server -I -S mafdata_uat_wlg -A $ATSDIR -R $ATSDIR res_uat_rep_wlg does not work because res_uat_rep_wlg already exists Hoping someone can help please
Don't confuse routing and topology with replication. When you define a server, you are defining the topology - that is how two servers communicate with each other. When you define replication you are defining the end points of replication. The define server describes the domain. Define replicate defines the endpoints of replication. You can simply add the new server to the existing ER domain. See below.... From: "KARL OLIVER" <karl.oliver@maf.govt.nz> To: ids@iiug.org Date: 03/16/2011 03:33 PM Subject: Enterprise replication replicating instance on sam [23120] Sent by: ids-bounces@iiug.org hello folks IBM Informix Dynamic Server Version 11.50.FC6 Using enterprise replication update anywhere conflict resolution Looking for some advice on the following. I have two servers running replication fine replicating between phyical servers wuast130 and auast120. on server wuast130 I want to be able to replicate two instances. So in effect I want to replicate to instance on auast120 and instance on wuast130 as well from one instance on wuast130. Can this be done ? What i use to define the two servers is below ## physical server names Wuast130 auast120 cdr define server -I -S res_uat_rep_wlg -A $ATSDIR -R $ATSDIR res_uat_rep_akl MP says --- OK, this is adding res_uat_rep_ak1 to an existing domain. It is not defining any thing to be replicated, however. You simply added another root server to an existing domain. This is routing and topology stuff. Noting more. </MP> works fine on wuast130 I tried to add server instance as below cdr define server -I -S mafdata_uat_wlg -A $ATSDIR -R $ATSDIR res_uat_rep_wlg does not work because res_uat_rep_wlg already exists MP says -- because it is already part of the domain. So now you need to define what is to be replicated to res_uat_rep_ak1. If you are using templates, then you can simply run cdr realize template ..... res_uat_rep_ak1 If you are not using templates, then you can add res_uat_rep_ak1 to an existing replicate by running "cdr change repl --add " followed by "cdr start repl xyz res_uat_rep_ak1.... </MP> Hoping someone can help please ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.
thanks for that information. I have tried this but does not work cdr change replicate --add accept_commodity \\\\ "res_accept@res_uat_rep_wlg:paqis.res_accept_commodity" "select * from commodity" cdr start replicate accept_commodity res_uat_rep_wlg >> cha_errs 2>&1 echo ending I get this participant res_accept@res_uat_rep_wlg:paqis.res_accept_commodity 'select * from commodity' command failed -- undefined server (37) The server is defined so I dont know what I am missing ERVER ID STATE STATUS QUEUE CONNECTION CHANGED ----------------------------------------------------------------------- res_uat_rep_akl 19 Active Connected 0 Mar 16 11:43:45 res_uat_rep_wlg 18 Active Local SERVER ID STATE STATUS QUEUE CONNECTION CHANGED ----------------------------------------------------------------------- mafdata_uat_akl 11 Active Connected 0 Mar 16 13:18:41 mafdata_uat_wlg 12 Active Local 0 I am tried to replicate from mafdata_uat_wlg to res_uat_rep_wlg
Try placing the replicate in front of --add. From: "KARL OLIVER" <karl.oliver@maf.govt.nz> To: ids@iiug.org Date: 03/16/2011 04:38 PM Subject: Re: Enterprise replication replicating instance on [23125] Sent by: ids-bounces@iiug.org thanks for that information. I have tried this but does not work cdr change replicate --add accept_commodity \\\\ "res_accept@res_uat_rep_wlg:paqis.res_accept_commodity" "select * from commodity" cdr start replicate accept_commodity res_uat_rep_wlg >> cha_errs 2>&1 echo ending I get this participant res_accept@res_uat_rep_wlg:paqis.res_accept_commodity 'select * from commodity' command failed -- undefined server (37) The server is defined so I dont know what I am missing ERVER ID STATE STATUS QUEUE CONNECTION CHANGED ----------------------------------------------------------------------- res_uat_rep_akl 19 Active Connected 0 Mar 16 11:43:45 res_uat_rep_wlg 18 Active Local SERVER ID STATE STATUS QUEUE CONNECTION CHANGED ----------------------------------------------------------------------- mafdata_uat_akl 11 Active Connected 0 Mar 16 13:18:41 mafdata_uat_wlg 12 Active Local 0 I am tried to replicate from mafdata_uat_wlg to res_uat_rep_wlg ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.
afraid that has not worked. The format I used has worked before on host to host replicates
More info I have deleted the existing replicate and tried creating a new repliacte for instance to instance on the same machine still does not work Can you actually do this ? I get the same error replicate: accept_commodity command failed -- undefined server (37) participant res_accept@res_uat_rep_wlg:paqis.commodity 'select * from commodity'
what is the output of "cdr list serv" ? From: "KARL OLIVER" <karl.oliver@maf.govt.nz> To: ids@iiug.org Date: 03/16/2011 07:28 PM Subject: Re: Enterprise replication replicating instance on [23131] Sent by: ids-bounces@iiug.org More info I have deleted the existing replicate and tried creating a new repliacte for instance to instance on the same machine still does not work Can you actually do this ? I get the same error replicate: accept_commodity command failed -- undefined server (37) participant res_accept@res_uat_rep_wlg:paqis.commodity 'select * from commodity' ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.
yes they are two distinct domains . Note some messages have been put under the wrong thread-Audit IDS 11.50 Sessions & SQL jobs
We currently do not have the ability to merge two distinct domains into a single domain. From: "KARL OLIVER" <karl.oliver@maf.govt.nz> To: ids@iiug.org Date: 03/17/2011 01:10 PM Subject: Re: Enterprise replication replicating instance on [23151] Sent by: ids-bounces@iiug.org yes they are two distinct domains . Note some messages have been put under the wrong thread-Audit IDS 11.50 Sessions & SQL jobs ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.