db2 server monitor

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Lan W - 26 Jan 2006 20:21 GMT

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 our first
goal is just want to be notified that everything's up and
Working, alerted when the server is down, or something unexpected happened.
Our future goal may include to health of the database, etc.

Are there any options besides installing a third party product on the
servers.
I would really appreciate any comments or suggestions.

Thanks!
Lan

Reply to this Message

Knut Stolze - 26 Jan 2006 21:31 GMT

> Hi,
>
[quoted text clipped - 3 lines]
> Working, alerted when the server is down, or something unexpected
> happened. Our future goal may include to health of the database, etc.

Have a look at the health center.

Signature

Knut Stolze
DB2 Information Integration Development
IBM Germany

Reply to this Message

aj - 27 Jan 2006 13:35 GMT

Or try this little hack:

######################################################################
# check_db2sysc_oltp.sh
# The purpose of this script is to check if the db2sysc instance master
# daemon
# for the oltp instance is up and functioning. If not, call for help..

if [ `ps aux | grep db2sysc | grep oltp | grep -v grep | grep -v
check_db2sysc_oltp | wc -l` -eq 0 ]
then
echo "DB2:oltp instance db2sysc not found" | /bin/mail page_dba
fi

HTH

aj

>> Hi,
>>
[quoted text clipped - 5 lines]
>
> Have a look at the health center.

Reply to this Message