I'm using DBI to write a monitoring program for our informix
servers. Problem I am running into is that if the database server
(to which I am always connecting via a tcp connection) is down
completely, the connect() takes a very long time before it returns.
The same server in quiescent mode returns quite quickly, as
expected. My question: Is there a parameter or other setting that
can be used to have the connect return more quickly, i.e. some
sort of timeout value? I tried using an alarm(), but the connect
appear to ignore the alarm.
Thanks,
Dave
Jonathan Leffler - 31 Aug 2004 05:44 GMT
> I'm using DBI to write a monitoring program for our informix
> servers. Problem I am running into is that if the database server
[quoted text clipped - 5 lines]
> sort of timeout value? I tried using an alarm(), but the connect
> appear to ignore the alarm.
INFORMIXCONTIMEOUT and INFORMIXCONRETRY?
See Informix Guide to SQL: Reference, ct1spna.pdf, chapter 3.

Signature
Jonathan Leffler #include <disclaimer.h>
Email: jleffler@earthlink.net, jleffler@us.ibm.com
Guardian of DBD::Informix v2003.04 -- http://dbi.perl.org/
superboer - 31 Aug 2004 06:33 GMT
am not into dbi sorry; however
you could try setting
INFORMIXCONRETRY
INFORMIXCONTIME
env vars; afaik the default for
INFORMIXCONRETRY is 3
and for
INFORMIXCONTIME is 60 secs...
hope it helps
Superboer.
> I'm using DBI to write a monitoring program for our informix
> servers. Problem I am running into is that if the database server
[quoted text clipped - 8 lines]
> Thanks,
> Dave