Start Replicate for huge tables

Posted in 2009

Topics: Migration, Import/Export & Data Conversion

Habichtsberg, Reinhard — Wed, 14 Oct 2009 11:44:58 +0200 — source: Usenet: comp.databases.informix

Hi all, I have to start new ER replicates with tables up to 400 Millions rows. I want to avoid to unload/load the tables because I have problems with piping the data with HPL. Furthermore I had to stop all transactions to ensure that the data the same on both servers before starting the replicate. Is it possible to use the command "cdr start replicate xxx_repl targetServer --syncdatasource=sourceServer" with such a high amount of rows? Remark: Transactions on the sourcetable can't be stopped meanwhile. How would you start a replicate with many rows? Is there a good strategy or a best pratice? TIA, Reinhard.

↪ replying to Habichtsberg, Reinhard

theBP — Wed, 14 Oct 2009 11:13:36 +0100 — source: Usenet: comp.databases.informix

Habichtsberg, Reinhard wrote: > Hi all, > > I have to start new ER replicates with tables up to 400 Millions rows. I > want to avoid to unload/load the tables because I have problems with piping > the data with HPL. Furthermore I had to stop all transactions to ensure that > the data the same on both servers before starting the replicate. > > Is it possible to use the command "cdr start replicate xxx_repl targetServer > --syncdatasource=sourceServer" with such a high amount of rows? Remark: > Transactions on the sourcetable can't be stopped meanwhile. > > How would you start a replicate with many rows? Is there a good strategy or > a best pratice? > > TIA, > Reinhard. What version? Answer is "yes", but you could consider ifx_replcheck : http://publib.boulder.ibm.com/infocenter/idshelp/v115/index.jsp?tab=search&searchWord=ifx_replcheck+