Hi Gurus,

I am looking for a script to monitor the informix dataase on unix which can alert(email/pager) the DBA incase the database goes to any other mode other than 'online' mode i.e if the database goes down for normal users or goes down completely.

Thanks

IDS is able to send SNMP traps.
check Informix SNMP Subagent Guide, Version 8.3/9.3 (G251-0497-00)
at
http://www-3.ibm.com/software/data/i...ry/ids_93.html

Or, just write a shell script that checks for "On-Line" in onstat - command.
Put this script in the crontab and use the mail command.

You can use Informix's shell script ALARMPROG name is log_full.sh as default name this script can action as you want . It's event-base action , In my site I use it with my monitoring shell script with crontab togather

If you do that, you should make your logfiles not too big.
This shell script is fired when the LOG Full event is enabled.
It can take a while when you don't do a lot of updates in your database.