How to delete Enterprise Replication

[MADS]

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!

[Jarrod Teale]

Drop the syscdr database on both ends

Hi everybody!

Thanks in advance!
_______________________________________________
Informix-list mailing list
Inform...@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/

[Plugge, Joe R.]

You may have to bring down the engine and then bring it back up using oninit -D, which prevents the replication treads from starting, then you should be able to drop the syscdr database. Then depending on how tangled up it was, you may have to grind through each database and make sure that there are no cdr_deltab_xxxxx tables, if there are, drop them.

You can then bounce the engine again, restarting normally.

-----Original Message-----
From: informix-l...@iiug.org [mailto:informix-l...@iiug.org] On Behalf Of Jarrod Teale
Sent: Thursday, October 22, 2009 3:10 PM
To: MADS; inform...@iiug.org
Subject: RE: How to delete Enterprise Replication

Drop the syscdr database on both ends

-----Original Message-----
From: informix-l...@iiug.org
[mailto:informix-l...@iiug.org] On Behalf Of MADS
Sent: Friday, 23 October 2009 7:11 a.m.
To: inform...@iiug.org
Subject: How to delete Enterprise Replication

Hi everybody!

Thanks in advance!

[dba....@gmail.com]

you can also do
cdr delete server

[mpruet]

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.

[Habichtsberg, Reinhard]

"cdr start [-c prodserver]" on the production server? Should start without
any replication partner active. Afterwards the other commands should work.

HTH, Reinhard.

[MADS]

Thanks to all for your advice.

I'll ask the client to schedule a downtime this Sunday and will test
your advices...