RE: Recreating ER replicates query

No - never got an answer. What we are looking for is some way to back up the cdr create commands, so we can re-run then in a dev/test environment (just changing the server names). Also, if for some reason the syscdr database is lost (think really dumb dba not knowing what it is so they drop it) then recreating the replicates would be useful. Templates are okay - but want something outside of the instance that will reproduce the commands. We can and do have procedures about documenting things when a replicate is created, but if that isn't followed there is a risk to looseing the replicate definitions (especially as we have a single central server talking to a heap of non-authoritive leaf nodes, so only one instance has the full catalog). Jarrod -----Original Message----- From: Jonathan Leffler [mailto:jleffler.iiug@gmail.com] Sent: Wednesday, 19 August 2009 11:01 a.m. To: Jarrod Teale Cc: informix-list@iiug.org Subject: Re: Recreating ER replicates query On Wed, Aug 5, 2009 at 14:18, Jarrod Teale<Jarrod.Teale@fonterra.com> wrote: > I was wondering if there is any tidy way of exporting all the > replicates in an ER cloud? Did you get an answer to this? > The idea here would be to issue some command a non-leaf server and get > it to provide the cdr commands to recreate all the replicates. Can you use ER templates to provide this functionality? It is close to what you want, I think. > As part of a recent upgrade exercise of our production environment, we > had to build a contingency plan for ER as moving from 11.10.UC2W2 to > 11.50.UC3 or UC5 caused the cdr threads to consume heaps of memory and > crash. Doing this, we had to work out all the replicates by hand in > case we had to recreate them from scratch. > > Any one got a tool for this? > > We are on RedHat Linux EL4. -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2008.0513 -- http://dbi.perl.org/ "Blessed are we who can laugh at ourselves, for we shall never cease to be amused." NB: Please do not use this email for correspondence. I don't necessarily read it every week, even. Stephen Leacock - "I detest life-insurance agents: they always argue that I shall some day die, which is not so." - http://www.brainyquote.com/quotes/authors/s/stephen_leacock.html