informix 9.4 configuration - DRAUTO

[tomL]

hello all!
we are upgrading to 9.4 (on 11i) from 9.21 on HP-UX 11. We are running
HDR and I noticed that our current config file does not have an entry
for DRAUTO. The config parameters listed in the 9.4 manual (Admin
Reference) does not list DRAUTO. Can someone enlighten me on what our
current situation is not having the param in the file and about 9.4.?
Thanks in advance
Tom

[mos...@wellsfargo.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

[tomL]

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

mos...@wellsfargo.com wrote in message news:<bnpl38$oa2$1...@terabinaries.xmission.com>...

[mos...@wellsfargo.com]

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/informix/pubs/library/ids_94.html
-or-
http://publibfi.boulder.ibm.com/epubs/pdf/ct1ucna.pdf

HTH,
Paul Mosser

-----Original Message-----
From: owner-inf...@iiug.org
[mailto:owner-inf...@iiug.org]On Behalf Of tom...@yahoo.com

sending to informix-list