Re: HDR issues?

Assuming you're doing all of this in a single transaction, it wouldn't work. Because the secondary won't get fully updated until you've done COMMIT WORK. If you're doing this without transactions, then I'm not sure I can explain the behavior. Once we've got HDR on-line here (we're currently implementing it), I'll see if I can replicate this. abipri@my-dejanews.com wrote in message <72g2d2$eu$1@nnrp1.dejanews.com>... > > >I had not given the correct scenario in my earlier post. Here >goes the correct one. > >In article <72fjjg$jj0$1@nnrp1.dejanews.com>, > abipri@my-dejanews.com wrote: >> >> >> I would greatly appreciate if you someone could help me with >> the following: >> >> I have an HDR setup and the primary and secondary databases are >> configured to be in sync: >> The Data Replication variables are: >> >> DRAUTO 2 >> DRINTERVAL -1 >> DRTIMEOUT 90>> CDR_LOGBUFFERS 2048 >> >> I have a multi threaded program and each thread does the following: >> >> Create a table in primary >> In a loop { >> 1. Write 5 rows into the primary >> 2. Read back the row from the secondary >> 3. Delete all the rows in primary >> } >> >> I notice that when I read back the the rows from the secondary, informix >> says that there's no rows in the primary. My client program is >> informix esql: $ FETCH :cursor_name USING DESCRIPTOR descriptor . >> Basically SQLSTATE says: 02 (in secondary database). > >Sorry about the typo here: This should read: > SQL CODE: 100 > SQLSTATE: 02000 > > >> >> Please let me know if I need to change my onconfig file or >> my esql program or if there's a bug in Informix. >> >> Thanks much for your response. >> >> -Abi >> abi@healtheon.cm >> >> -----------== Posted via Deja News, The Discussion Network ==---------- >> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own >> > >-----------== Posted via Deja News, The Discussion Network ==---------- >http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own