How to check if an informix server is Up

Posted in 2003

Topics: Connectivity: ESQL/C, 4GL & Embedded SQL, Clustering, Grid & MACH11

Ortiz Manuel — Wed, 5 Nov 2003 09:34:32 -0500 — source: Usenet: comp.databases.informix

This is a multi-part message in MIME format. ------_=_NextPart_001_01C3A3A9.ED851AB8 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable 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_01C3A3A9.ED851AB8 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable <html xmlns:o=3D"urn:schemas-microsoft-com:office:office" = xmlns:w=3D"urn:schemas-microsoft-com:office:word" = xmlns=3D"http://www.w3.org/TR/REC-html40">; <head> <meta http-equiv=3DContent-Type content=3D"text/html; = charset=3Dus-ascii"> <meta name=3DProgId content=3DWord.Document> <meta name=3DGenerator content=3D"Microsoft Word 10"> <meta name=3DOriginator content=3D"Microsoft Word 10"> <link rel=3DFile-List href=3D"cid:filelist.xml@01C3A380.0493C3C0">  <style>  </style>  </head> <body lang=3DES link=3Dblue vlink=3Dpurple = style=3D'tab-interval:35.4pt'> <div class=3DSection1> In a 4GL program I = need to do an insert in three distinct servers:<o:p></o:p> <o:p> </o:p></span= > …<o:p></o:p></spa= n> INSERT INTO = db@olserver1.table VALUES (…)<o:p></o:p> INSERT INTO = db@olserver2.table VALUES (…)<o:p></o:p> INSERT INTO = db@olserver3.table VALUES (…)<o:p></o:p> …..<o:p></o:p></s= pan> <o:p> </o:p></span= > When one of this = servers is down, the 4GL program wait several minutes before I got an error = message.<o:p></o:p> <o:p> </o:p></span= > How I can check if the = server is Up before to do the = insert.<o:p></o:p> <o:p> </o:p></span= > It is possible to trap = the error setting the timeout shorter.<o:p></o:p> <o:p> </o:p></span= > <span lang=3DEN-US = style=3D'font-size: 10.0pt;font-family:Arial;mso-ansi-langua

↪ replying to Ortiz Manuel

Art S. Kagel — Wed, 05 Nov 2003 12:39:19 -0500 — source: Usenet: comp.databases.informix

On Wed, 05 Nov 2003 09:34:32 -0500, Ortiz Manuel wrote: This kind of delay happens when the target server's machine is online but the Informix engine is not. Try setting and exporting the following in the program's environment: INFORMIXCONTIME=5 INFORMIXCONRETRY=2 The 4GL library will try to connect twice within 5 seconds and return an error if it fails. These variables enable a local alarm mechanism which is more responsive than waiting for the remote machine's TCP stack to timeout. Art S. Kagel > This is a multi-part message in MIME format. > > ------_=_NextPart_001_01C3A3A9.ED851AB8 > Content-Type: text/plain; > charset="us-ascii" > Content-Transfer-Encoding: quoted-printable > > 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_01C3A3A9.ED851AB8 > Content-Type: text/html; > charset="us-ascii" > Content-Transfer-Encoding: quoted-printable > > <html xmlns:o=3D"urn:schemas-microsoft-com:office:office" = > xmlns:w=3D"urn:schemas-microsoft-com:office:word" = > xmlns=3D"http://www.w3.org/TR/REC-html40">; > > <head> > <meta http-equiv=3DContent-Type content=3D"text/html; = charset=3Dus-ascii"> > <meta name=3DProgId content=3DWord.Document> <meta name=3DGenerator > content=3D"Microsoft Word 10"> <meta name=3DOriginator content=3D"Microsoft > Word 10"> <link rel=3DFile-List href=3D"cid:filelist.xml@01C3A380.0493C3C0"> >  > <style> >  > </style> >  > </head> > > <body lang=3DES link=3Dblue vlink=3Dpurple = style=3D'tab-interval:35.4pt'> > > <div class=3DSection1> > > style=3D'font-size: > 10.0pt;font-family:Arial;mso-ansi-language:EN-US'>In a 4GL program I = need to > do > an insert in three distinct servers:<o:p></o:p> > > style=3D'font-size: > 10.0pt;font-family:Arial;mso-ansi-language:EN-US'><o:p> </o:p></span= >> > > style=3D'font-size: > 10.0pt;font-family:Arial;mso-ansi-language:EN-US'>…<o:p></o:p></spa= > n> > > style=3D'font-size: > 10.0pt;font-family:Arial;mso-ansi-language:EN-US'>INSERT INTO = > db@olserver1.table > VALUES (…)<o:p></o:p> > > style=3D'font-size: > 10.0pt;font-family:Arial;mso-ansi-language:EN-US'>INSERT INTO = > db@olserver2.table > VALUES (…)<o:p></o:p> > > style=3D'font-size: > 10.0pt;font-family:Arial;mso-ansi-language:EN-US'>INSERT INTO = > db@olserver3.table > VALUES (…)<o:p></o:p> > > style=3D'font-size: > 10.0pt;font-family:Arial;mso-ansi-language:EN-US'>…..<o:p></o:p></s= > pan> > > style=3D'font-size: > 10.0pt;font-family:Arial;mso-ansi-language:EN-US'><o:p> </o:p></span= >> > > style=3D'font-size: > 10.0pt;font-family:Arial;mso-ansi-language:EN-US'>When one of this = servers > is > down, the 4GL program wait several minutes before I got an error = > message.<o:p></o:p> > > style=3D'font-size: > 10.0pt;font-family:Arial;mso-ansi-language:EN-US'><o:p> </o:p></span= >> > > style=3D'font-size: > 10.0pt;font-family:Arial;mso-ansi-language:EN-US'>How I can check if the = > server > is Up before to do the =@@NL@

Glossary

4GL (Informix-4GL)