Re: Data Replication

Juan R. Guzman wrote: > As for problems, I've only encountered two. We do a dbexport every night on the > secondary machine and once in a while Informix corrupts a date on a record. I > know this because the dbexport complains about the date format and then we have > to reinitalize DR. This isn't really a pain since an archive only takes 40 > minutes to do, but it shouldn't happen. Are you doing any work on the primary when the dbexport is occuring? If so, then maybe the data isn't really corrupted. Dbexport wants to lock a database in exclusive mode when it does it's unloads, but when being taken on the secondary this database lock does not prohibit the threads that apply the changes coming from the primary to change things. So it could be possible that the dbexport hit a page as a thread was changing it...also if you have referential integrity it may be violated as dbexport unloads a table, you modify it, it then unloads a table with a key to that previous table. This shouldn't be a problem if no work is being done on the primary at the time, but if there is work being done then I wouldn't count on your dbexport being completely valid. -- ******************************************************************** * Jacques P. Renaut "I'd dazzle you with brilliance * * Informix Advanced Support if I only had the knack..." * * email: jrenaut@informix.com #include <disclamier.h> * ********************************************************************