Add existing server to replication ~ Answered: amber (solid confidence) — Madison Pruet gives the correct cdr commands (cdr define server + cdr change replicate) to add an existing server to an ER replicate, but there is no follow-up confirming success.

Advisory only.

I started replication between g_trf05sl and g_trf10rf and now I realize I need to merge data from g_psprod10rf. Is there a way to add existing g_psprod10rf to g_trf05sl and g_trf10rf? $uname -a Linux psdb05spr.state.ut.us 2.6.32-431.23.3.el6.x86_64 #1 SMP Wed Jul 16 06:12:23 EDT 2014 x86_64 x86_64 x86_64 GNU/Linux $onstat - IBM Informix Dynamic Server Version 12.10.FC4 -- On-Line -- Up 1 days 05:48:41 -- 2520368 Kbytes [trf05sl]$cdr list serverSERVER ID STATE STATUS QUEUE CONNECTION CHANGED ----------------------------------------------------------------------- g_trf05sl 55 Active Local 0 g_trf10rf 105 Active Connected 0 Jan 26 11:19:12 [trf10rf]$cdr list server SERVER ID STATE STATUS QUEUE CONNECTION CHANGED ----------------------------------------------------------------------- g_trf05sl 55 Active Connected 0 Jan 26 11:19:11 g_trf10rf 105 Active Local 0 [psprod10r]$cdr list server SERVER ID STATE STATUS QUEUE CONNECTION CHANGED ----------------------------------------------------------------------- g_bci05sl 51 Active Connected 0 Jan 25 02:23:57 g_bci10rf 3 Active Connected 0 Jan 25 02:42:05 g_bci10rfe 101 Active Connected 0 Jan 25 06:17:30 g_dld05sl 52 Active Connected 0 Jan 25 01:35:54 g_dld10rf 102 Active Connected 0 Jan 25 01:36:33 g_dps01sl 13 Active Connected 0 Jan 26 07:08:55 g_dps05sl 53 Active Connected 0 Jan 25 01:33:59 g_dps10rf 103 Active Connected 0 Jan 25 01:34:32 g_psprod10rf 10 Active Local 0 g_psprod5sl 5 Active Connected 0 Jan 25 10:10:07

cdr change replicate This can be used to add or drop a participant to an existing replicate definition. cdr define server This can be used to add a node to the replication domain, but you will= still need to execute "cdr change replicate" to change the participants= of a given replication strategy. From: "BEVIS KENNEDY" <bkennedy@utah.gov> To: ids@iiug.org Date: 01/26/2015 01:05 PM Subject: Add existing server to replication [34521] Sent by: ids-bounces@iiug.org I started replication between g_trf05sl and g_trf10rf and now I realize= I need to merge data from g_psprod10rf. Is there a way to add existing g_psprod10rf to g_trf05sl and g_trf10rf? $uname -a Linux psdb05spr.state.ut.us 2.6.32-431.23.3.el6.x86_64 #1 SMP Wed Jul 1= 6 06:12:23 EDT 2014 x86_64 x86_64 x86_64 GNU/Linux $onstat - IBM Informix Dynamic Server Version 12.10.FC4 -- On-Line -- Up 1 days 05:48:41 -- 2520368 Kbytes [trf05sl]$cdr list serverSERVER ID STATE STATUS QUEUE CONNECTION CHANGED -----------------------------------------------------------------------= g_trf05sl 55 Active Local 0 g_trf10rf 105 Active Connected 0 Jan 26 11:19:12 [trf10rf]$cdr list server SERVER ID STATE STATUS QUEUE CONNECTION CHANGED -----------------------------------------------------------------------= g_trf05sl 55 Active Connected 0 Jan 26 11:19:11 g_trf10rf 105 Active Local 0 [psprod10r]$cdr list server SERVER ID STATE STATUS QUEUE CONNECTION CHANGED -----------------------------------------------------------------------= g_bci05sl 51 Active Connected 0 Jan 25 02:23:57 g_bci10rf 3 Active Connected 0 Jan 25 02:42:05 g_bci10rfe 101 Active Connected 0 Jan 25 06:17:30 g_dld05sl 52 Active Connected 0 Jan 25 01:35:54 g_dld10rf 102 Active Connected 0 Jan 25 01:36:33 g_dps01sl 13 Active Connected 0 Jan 26 07:08:55 g_dps05sl 53 Active Connected 0 Jan 25 01:33:59 g_dps10rf 103 Active Connected 0 Jan 25 01:34:32 g_psprod10rf 10 Active Local 0 g_psprod5sl 5 Active Connected 0 Jan 25 10:10:07 ***********************************************************************= ******** Forum Note: Use "Reply" to post a response in the discussion forum. =