Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2002
    Location
    Bellevue,WA
    Posts
    20

    Unanswered: database monitoring script

    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

  2. #2
    Join Date
    Aug 2002
    Location
    Belgium
    Posts
    534
    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.
    rws

  3. #3
    Join Date
    Mar 2002
    Posts
    112

    re

    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

  4. #4
    Join Date
    Aug 2002
    Location
    Belgium
    Posts
    534

    Re: re

    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.
    rws

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •