HDR issues?
Posted in 1998
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 90CDR_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).
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