Checking if an instance is available
This script checks if DB2 instance is up
What | |
---|---|
When |
2010-08-06 17:39
2010-08-06 17:39
2010-08-06 from 17:39 to 17:39 |
Add event to calendar |
vCal iCal |
#!/usr/bin/ksh
##########################################################
# Author: Felipe Alkain de Souza
#
# Script Name: check_instance_up.sh
#
# Functionality: This script checks if DB2 instance is up
#
# Usage: ./check_instance_up.sh
#
##########################################################
. $HOME/sqllib/db2profile
### Nagios RCs Variables
STATE_OK=0
STATE_WARNING=1
STATE_CRITICAL=2
STATE_UNKNOWN=3
SVCNAME=`db2 get dbm cfg |grep SVCENAME |awk -F= '{print $2}'`
PORTNUM=`grep $SVCNAME /etc/services |awk '{print $2}' |awk -F/ '{print $1}'`
PROC=`netstat -na |grep $PORTNUM |wc -l`
if [[ $PROC -eq "0" ]]; then
echo "$STATE_CRITICAL&DB2 - Instance $DB2INSTANCE down on `hostname`"
exit $STATE_CRITICAL
else
echo "$STATE_OK&DB2 - Instance $DB2INSTANCE is up."
exit $STATE_OK
fi