Re: Informix 9.3 replication

On Wed, 30 Apr 2003 06:12:15 -0400, MATHUR,SHASHANK (HP-India,ex2) wrote: PLEASE DO NOT POST MIME, it triples the bandwidth usage of a posting! Get my dbexport/dbimport replacement utility, myexport, which will export a dbimport compatible dataset without locking the database. Myschema is available for download from the IIUG Software Repository and also requires the download of Jonathan Leffler's sqlcmd package. Art S. Kagel > Hi All, > > I have started the replication between two informix 9.3 instances. Now > if I want to do a dbexport of one of the database, I will not be able to > do it because the replication is ON. If I stop replication & do it, then > I will loose the data which is updated during that time. So is there any > way, I can suspend the replication till I complete the dbexport & > restart the replication.. What I am expecting here is I should get the > data which got updated / inserted on to the active database once I > restart the replication. > > In 7.3, I used to setup an environment variable CDRBLOCKOUT to 1 for > suspending the replication & to 0 for restarting it. > > Here in 9.3 I tried > cdr suspend server <server name> > But doing this will not allow dbexport to run. will not allow > > -425 - Database is currently opened by another user. -107 - ISAM error: > record is locked. > > Thanks > Shashank MG > IRDI (ITRC Team) > Phone # 205 1990 > TN # 847 1990