Determine if informix is online?

Posted in 2008

BART GROOT — Mon, 21 Jul 2008 10:56:04 — source: IIUG Forums & Mailing Lists

Hi All, I was just wondering; are there any other tools to determine the informix engine status besides onstat -? I would like to use a script to monitor our databases. We are using the alarmprogram.sh, but I would like to check if the database server is up and running. Are there any database ping utilities? Or should I use a dummy query; e.g. select * from sysusers on sysmaster? Thanks, Regards, Bart

↪ replying to BART GROOT

Obnoxio The Clown — Mon, 21 Jul 2008 11:01:52 — source: IIUG Forums & Mailing Lists

BART GROOT said: > Hi All, > > I was just wondering; are there any other tools to determine the informix > engine status besides onstat -? I would like to use a script to monitor > our > databases. We are using the alarmprogram.sh, but I would like to check if > the > database server is up and running. Are there any database ping utilities? > Or > should I use a dummy query; e.g. select * from sysusers on sysmaster? I'd stick with onstat - IIRC, the select from a table could hang for a long time if the engine is not up. -- Bye now, Obnoxio http://obotheclown.blogspot.com/

↪ replying to Obnoxio The Clown

Fernando Nunes — Mon, 21 Jul 2008 11:22:16 — source: IIUG Forums & Mailing Lists

Not necessarily... Just set INFORMIXCONRETRY and INFORMIXCONTIME to fair values... onstat - will not work remotely... (unless you use ssh to connect to the dbserver of course :) ) Regards. On Mon, Jul 21, 2008 at 12:01 PM, Obnoxio The Clown <obnoxio@serendipita.com> wrote: > BART GROOT said: > > Hi All, > > > > I was just wondering; are there any other tools to determine the informix > > engine status besides onstat -? I would like to use a script to monitor > > our > > databases. We are using the alarmprogram.sh, but I would like to check if > > the > > database server is up and running. Are there any database ping utilities? > > Or > > should I use a dummy query; e.g. select * from sysusers on sysmaster? > > I'd stick with onstat - > > IIRC, the select from a table could hang for a long time if the engine is > not up. > > -- > Bye now, > Obnoxio > > http://obotheclown.blogspot.com/ > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > >

↪ replying to Fernando Nunes

Obnoxio The Clown — Mon, 21 Jul 2008 11:28:05 — source: IIUG Forums & Mailing Lists

Fernando Nunes said: > Not necessarily... > Just set INFORMIXCONRETRY and INFORMIXCONTIME to fair values... Are you implying that the default values might not be good enough? :oD > onstat - will not work remotely... (unless you use ssh to connect to the > dbserver of course :) ) Make it OAT's problem. ;o) -- Bye now, Obnoxio http://obotheclown.blogspot.com/

↪ replying to Obnoxio The Clown

Fernando Nunes — Mon, 21 Jul 2008 11:42:25 — source: IIUG Forums & Mailing Lists

Not at all!!!! They make sure that any network glitch won't prevent you to connect to our beloved engine! :P Regards. On Mon, Jul 21, 2008 at 12:28 PM, Obnoxio The Clown <obnoxio@serendipita.com> wrote: > Fernando Nunes said: > > Not necessarily... > > Just set INFORMIXCONRETRY and INFORMIXCONTIME to fair values... > > Are you implying that the default values might not be good enough? :oD > > > onstat - will not work remotely... (unless you use ssh to connect to the > > dbserver of course :) ) > > Make it OAT's problem. ;o) > > -- > Bye now, > Obnoxio > > http://obotheclown.blogspot.com/ > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > >

Glossary

onstat