Re: HDR issues?
Posted in 1998
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