RE: How to remove ER ?

Posted in 2003

Colin Bull — Wed, 24 Dec 2003 08:46:12 -0000 — source: Usenet: comp.databases.informix

Ph. Chantry wrote > > We use ER to replicate databases. > Our replication scheme involves 3 servers: 1 master 9.40.uc2, 1 slave > 9.40.uc2, 1 slave 9.30.fc3. > > ER works very bad (server crashes, and so on), so that we > stop replication > ("cdr stop") on the 3 servers. > Now I want to rebuild replication servers from scratch. > > ER beeing not active, how to remove it ? > Just drop database syscdr on the 3 servers, or something else to do ? You should also check in your databases for ER tables that are called cdr_deltabxxxx. These are created to keep a tab on records that use timed resolution conflict I believe. If you do not delete these, when you try and recreate the rule, you get an error that is difficult to trace. Colin Bull c.bull@videonetworks.com sending to informix-list