RE: How to check if an informix server is Up

Posted in 2003

Everett Mills — Wed, 5 Nov 2003 11:58:08 -0600 — source: Usenet: comp.databases.informix

This is a multi-part message in MIME format. ------_=_NextPart_001_01C3A3C6.5E8673DB Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Manuel- What we do is have a script that runs every few minutes. It runs a 4gl that does nothing but check the health of another server. What it does is update a table on the remote database with the current time and attempts to read it back. We run it as a background process, which we kill if the program locks up. If it succeeds, it stores a value in the local database telling us that the connection is good. If we killed it, we fire an sql script which stores a value telling us that the connection is down. With this running constantly, we almost never have locked up applications, because if the connection is down, we don't try to use it. You may be able to do something similar. =20 -EEM =20 -----Original Message----- From: Ortiz Manuel [mailto:mortiz@gtireecu.com]=20 Sent: Wednesday, November 05, 2003 8:35 AM To: informix-list@iiug.org Subject: How to check if an informix server is Up =20 In a 4GL program I need to do an insert in three distinct servers: =20 ... INSERT INTO db@olserver1.table VALUES (...) INSERT INTO db@olserver2.table VALUES (...) INSERT INTO db@olserver3.table VALUES (...) ..... =20 When one of this servers is down, the 4GL program wait several minutes before I got an error message. =20 How I can check if the server is Up before to do the insert. =20 It is possible to trap the error setting the timeout shorter. =20 Thanks =20 Manuel Ortiz =20 :-) =20 ------_=_NextPart_001_01C3A3C6.5E8673DB Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable <html> <head> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Dus-ascii"> <meta name=3DGenerator content=3D"Microsoft Word 10 (filtered)"> <style>  </style> </head> <body lang=3DEN-US link=3Dblue vlink=3Dpurple> <div class=3DSection1> Manuel-       =       What we do is have a script that runs every few minutes.  It runs a 4gl that does nothing but = check the health of another server.  What it does is update a table on the = remote database with the current time and attempts to read it back.  We = run it as a background process, which we kill if the program locks up.  If it = succeeds, it stores a value in the local database telling us that the connection is = good.  If we killed it, we fire an sql script which stores a value telling us that = the connection is down.  With this running constantly, we almost never = have locked up applications, because if the connection is down, we don’t try = to use it.  You may be able to do something similar.         =             &= nbsp;     -EEM   -----Original = Message----- From: Ortiz Manuel [mailto:mortiz@gtireecu.com] Sent: Wednesday, November 05, 2003 8:35 AM To: = informix-list@iiug.org Subject: How to check if = an informix server is Up   In a 4GL program I need to = do an insert in three distinct servers:   … INSERT INTO = db@olserver1.table VALUES (…) INSERT INTO = db@olserver2.table VALUES (…) INSERT INTO = db@olserver3.table VALUES (…) <p class=3DMsoNormal styl