This is a discussion on RE: informix 9.4 configuration - DRAUTO within the Informix forums, part of the Database Server Software category; --> If DRINTERVAL in your onconfig is set to -1, then it's synchronous; otherwise it's async. Current setting is also ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| If DRINTERVAL in your onconfig is set to -1, then it's synchronous; otherwise it's async. Current setting is also displayed in 'onstat -g dri'. For performance reasons, we use async mode. We have never had any problem with lost data, nor with big lag times. Replication almost always occurs within a second or two, with one server in Sacramento and the other in Minneapolis. Suggest that you RTFineM, if you haven't already -- Admin Guide, ch. 19-20. If you don't have the hard copies, try http://www-3.ibm.com/software/data/i...ry/ids_94.html -or- http://publibfi.boulder.ibm.com/epubs/pdf/ct1ucna.pdf HTH, Paul Mosser -----Original Message----- From: owner-informix-list@iiug.org [mailto Sent: Thursday, October 30, 2003 12:51 PM To: informix-list@iiug.org Subject: Re: informix 9.4 configuration - DRAUTO thanks, Paul. Can you tell me if there is a way for me to find out if the replication is currently in synchronous or asynchronous transfer mode....? Thanks, Tom mosserp@wellsfargo.com wrote in message news:<bnpl38$oa2$1@terabinaries.xmission.com>... > DRAUTO was disabled in version 9.2x. My understanding is that it caused > more problems than it fixed for most customers (i.e., possible in some cases > for *both* servers to think that they are primary, and both start accepting > update txns), so Informix removed it. We depend upon HDR for some critical > applications here at the bank, and we have always used manual failover > (DRAUTO=0), even prior to 9.2x. > > HTH, > Paul Mosser > sending to informix-list |