Re: DR cause error -710, help!

This can happen when DR mode is changed. This fact is documented in documentation update notes starting with 7.11 ($INFORMIXDIR/release/ONLINEDOC_7.1) as follows: L. Effect of DR mode change on prepared statements and open cursors. Whenever Online server switches DR mode from one type to another, it marks all data dictionary entries in shared memory as modified and dirty for consistency reasons. This may result in -710 for prepared statements or opened cursors that were prepared/opened before mode change. Application will have to prepare statement again or open cursor again in that case. I think with 7.20 onwards it is part of Online admin guide. Darshan ccliu wrote: > > Hi, > I have a wired error when doing DR. At the time when the online.log > shows a "DR: Receive error", My stored procedure shows an error number 710. > and some message like "Table (%) has been dropped, alter or rename.". > > My guess, because the primary is temperory down, my stroed procedures can't > find the tables that it wants, and presumes the tables are dropped. > > Can someone tell me how to avoid this problem. > > BTW, our system is running 24 hrs a day, so when doing DR, it's not > a good idea to stop any operation. > > Jack