Determine if informix is online?
Bart Groot asked how to check whether the Informix engine is online besides onstat -, such as a ping utility or a dummy query on sysmaster. Obnoxio The Clown preferred onstat - because a query might hang. Fernando Nunes said setting INFORMIXCONRETRY and INFORMIXCONTIME avoids that and that onstat - does not work remotely. No single final answer.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
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
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/
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.
>
>
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/
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.
>
>