[db2]_hadr_monitoring_connection

#!/usr/bin/ksh
#
# Purpose: DB2 HADR connection status check
# Installed on host which can monitor both DB2 nodes, witness
# Author: Hendrawan
#
# global variable
_dbname="DB2INSTANCE_NAME"
_output_dir="$HOME/scripts"
_output_file="hadr_status.txt"
_subject="HADR Status"
_rcpt="db2.basis@example.com"
_now="$(date +"%Y-%m-%d-%T")"
# Check the status
db2 get snapshot for database on $_dbname | awk '/HADR Status/,/^$/ { print $0}'> $_output_dir/$_output_file
READ=`cat $_output_dir/$_output_file |grep "Connection status"| awk '{print $4}'| awk -F "," '{print $1}'`

if [ "$READ" == "Connected" ]; then
        echo "$_now >> [Connection status : $READ]"
                elif [ "$READ" == "Congested" ]; then
                echo "$_now >> [Connection status : $READ]"
        else
        echo "$_now >> [Connection status : $READ]"
        cat $_output_dir/$_output_file | mailx -s "$_subject" $_rcpt
fi
# EOF