Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2005
    Posts
    36

    Unanswered: DB2 server monitor

    Hi,

    We have DB2 8.2 installed on Linux Redhat server. What's the easy way to monitor the linux server to check the database availability? since we want to be notified when the server is down.

    Thanks!
    Lan

  2. #2
    Join Date
    Oct 2004
    Location
    DELHI INDIA
    Posts
    338
    Write a cron job which includes the following:

    1> latest entry of the db2diag.log to a flat file.1
    2> latest entry of the db2.nfy to the same file.1
    3> cpu usage by the db2 processes to the file.
    4> Tablespace usage incase u are using DMS TS.
    5> check the disk space usage by the db2 home and write that to file.1

    Check the file.1 periodically and you will be able to know the latest status of the server. We have implemented the above in our project and have found it is very helpful in monitoring the server.

    Thx,
    Jay

  3. #3
    Join Date
    Jan 2004
    Posts
    49

    Thumbs up Third party tool for monitoring

    Quote Originally Posted by Lxw176
    Hi,

    We have DB2 8.2 installed on Linux Redhat server. What's the easy way to monitor the linux server to check the database availability? since we want to be notified when the server is down.

    Thanks!
    Lan

    You can use sitescope for monitoring kind of job. Download the evaluation version of sitescope from mercury site and try to use it. Enable login counter on that.

    With Regards

    Balakrishnan Ethiraju

Posting Permissions

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