Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
Database Servers
DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybase
Desktop Databases
FileMakerFoxProMS AccessParadox
General
General DB TopicsDatabase Theory
Related Topics
Java Development.NET DevelopmentVB DevelopmentMore Topics ...

Database Forum / Informix Topics / August 2004

Tip: Looking for answers? Try searching our database.

DBI connect timeout question

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Dave Kosenko - 30 Aug 2004 19:22 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
(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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.