Re: DBI connect timeout question

Posted in 2004

Jonathan Leffler — Tue, 31 Aug 2004 04:44:49 GMT — source: Usenet: comp.databases.informix

Dave Kosenko wrote: > 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. INFORMIXCONTIMEOUT and INFORMIXCONRETRY? See Informix Guide to SQL: Reference, ct1spna.pdf, chapter 3. -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2003.04 -- http://dbi.perl.org/