Re: HDR issues?

Hi Thomas, Thanks for your response. Yes I do perform these operations in a transaction: The loop is: { Begin Transaction to primary Perform write on Primary Commit Transaction Begin Transaction to Secondary Perform Select of the same rows in Secondary Commit Transaction } Thanks! -Abi In article <364c5dfd.0@news.one.net>, "Thomas J. Girsch" <tgirsch@iname.com> wrote: > 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 > > -----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own