How to delete Enterprise Replication

Hi everybody! A client, LONG time ago, configured Enterprise Replication from a main server to a test server. After they finished their tests, they stopped the replication and did nothing else. Now, years later, I have to alter a replicated table, I get 19989: Enterprise Replication is not in active state The replication can not be started, due to the fact that the test server doesn't even exist. I tried several cdr commands (cdr remove, cdr delete server, cdr delete replicateset) , but I only get command failed -- Enterprise Replication not active (62) How can I drop the replication for good? Thanks in advance!

Drop the syscdr database on both ends -----Original Message----- From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org] On Behalf Of MADS Sent: Friday, 23 October 2009 7:11 a.m. To: informix-list@iiug.org Subject: How to delete Enterprise Replication Hi everybody! A client, LONG time ago, configured Enterprise Replication from a main server to a test server. After they finished their tests, they stopped the replication and did nothing else. Now, years later, I have to alter a replicated table, I get 19989: Enterprise Replication is not in active state The replication can not be started, due to the fact that the test server doesn't even exist. I tried several cdr commands (cdr remove, cdr delete server, cdr delete replicateset) , but I only get command failed -- Enterprise Replication not active (62) How can I drop the replication for good? Thanks in advance! _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list DISCLAIMER: This email contains confidential information and may be legally privileged. If you are not the intended recipient or have received this email in error, please notify the sender immediately and destroy this email. You may not use, disclose or copy this email or its attachments in any way. Any opinions expressed in this email are those of the author and are not necessarily those of the Fonterra Co-operative Group. http://www.fonterra.com/

On Oct 22, 11:10 am, MADS <mdapo...@gmail.com> wrote: > Hi everybody! > > A client, LONG time ago, configured Enterprise Replication from a main > server to a test server. After they finished their tests, they stopped > the replication and did nothing else. > > Now, years later, I have to alter a replicated table, I get > >  19989: Enterprise Replication is not in active state> > The replication can not be started, due to the fact that the test > server doesn't even exist. I tried several cdr commands (cdr remove, > cdr delete server, cdr delete replicateset) , but I only get > > command failed -- Enterprise Replication not active  (62) > > How can I drop the replication for good? > > Thanks in advance! cdr delete server --force <server_name> cdr remove (if using 9.4). If you just drop syscdr, then you are not going to get the automatic cleanup of all of the internal tables. M.P.

Thanks to all for your advice. I'll ask the client to schedule a downtime this Sunday and will test your advices... On Oct 22, 2:10 pm, MADS <mdapo...@gmail.com> wrote: > Hi everybody! > > A client, LONG time ago, configured Enterprise Replication from a main > server to a test server. After they finished their tests, they stopped > the replication and did nothing else. > > Now, years later, I have to alter a replicated table, I get > >  19989: Enterprise Replication is not in active state> > The replication can not be started, due to the fact that the test > server doesn't even exist. I tried several cdr commands (cdr remove, > cdr delete server, cdr delete replicateset) , but I only get > > command failed -- Enterprise Replication not active  (62) > > How can I drop the replication for good? > > Thanks in advance!