Re: Data Replication

Juan R. Guzman wrote: > > Srinivas Reddy wrote: > > > > Hi, > > > > ... > > As I mentioned in the beginning I am using 7.20 UC2 on HP K400 with HP-UX > > 10.10 I do not have any problems. ( I still have a problem, that is, I can > > not run any commands like 'dbschema', 'dbexport' on secondary while HDR > > is on, talking to Informix about this). > > I have DR under On-line 7.11UC1 and Solaris 2.4 and I can do a dbexport > and dbschema without any problems. What has Informix said? Is it a > bug? I'm thinking of upgrading to 7.21 (when it's available) so I'm > very interested in your reponse. > > thanks, From my knowledge on HDR you shouldn't talk a dbexport on the secondary. For dbexport to execute correctly it puts an exculsive lock on your database. Well, it might place that lock on the secondary but the recovery threads that are applying changes to the database from the primary don't check for those locks. So it would be possible that you end up with either more or less data then you think. As for dbschema, I can't think of any reason why that shouldn't run on the secondary. -- ******************************************************************** * 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> * ********************************************************************