Caché License Key monitoring
One of our Caché database servers stopped working last week. Because, the License key got expired. There was an oversight in checking the License key expiration date.
To avoid any such issues in future, I coded a shell script that runs everyday on Caché database servers and does the following:
1. Compare License key expiration date with future date (current date + 1 week)
2. Trigger an email to DBA if the License key expiration date is less than the future date
I'm sure that the Date handling (in the script) could be done in a better way. Still working on improving my scripting skills.
The script as below.
#!/bin/ksh
#coder: Bharath Nunepalli
LICKEY_EXP=/home//lickey_exp
LICKEY_EXP1=/home/lickey_exp1
LICKEY_EXP2=/home/lickey_exp2
LICKEY_EXP3=/home/lickey_exp3
LICKEY_EXP_DATE=/home/lickey_date
timezone=$(date +%Z)
NEXT_WEEK=$(TZ=$timezone-168 date +"%Y%m%d")
csession cache "^CKEY" | grep -i ExpirationDate > $LICKEY_EXP
cat $LICKEY_EXP | read LINE
LIC_EXP_DT=$(echo $LINE | awk '{print $3}')
echo $LIC_EXP_DT|awk -F'/' '{ print $1 }' > $LICKEY_EXP1
cat $LICKEY_EXP1 | read LINE
LIC_EXP_DT1=$(echo $LINE | awk '{print $1}')
if (( $LIC_EXP_DT1 < 10 )) then
LIC_EXP_MON=$(echo "0"$LIC_EXP_DT1)
fi
echo $LIC_EXP_DT|awk -F'/' '{ print $2 }' > $LICKEY_EXP2
cat $LICKEY_EXP2 | read LINE
LIC_EXP_DT2=$(echo $LINE | awk '{print $1}')
if (( $LIC_EXP_DT2 < 10 )) then
LIC_EXP_DAY=$(echo "0"$LIC_EXP_DT2)
fi
echo $LIC_EXP_DT|awk -F'/' '{ print $3 }' > $LICKEY_EXP3
cat $LICKEY_EXP3 | read LINE
LIC_EXP_DT3=$(echo $LINE | awk '{print $1}')
echo $LIC_EXP_DT3$LIC_EXP_MON$LIC_EXP_DAY > $LICKEY_EXP_DATE
cat $LICKEY_EXP_DATE | read LINE
LIC_EXP_DATE=$(echo $LINE | awk '{print $1}')
if (( $LIC_EXP_DATE < $NEXT_WEEK )) then
mail -s "LICENSE KEY ABOUT TO EXPIRE ON $HOSTNAME " <email ID>
fi
else exit
exit
The above script can be coded as below.
#!/bin/ksh
#Coder: Bharath Nunepalli
DB_STATUS=/home/db_status
ccontrol list | grep -i running > $DB_STATUS
if [[ -s $DB_STATUS ]] then
#collect expiration date from cache
EXPR_DATE=$(csession cache "^CKEY"|grep -i ExpirationDate|awk '{print $3}'|awk -F'/' '{printf("%d%02d%02d\n",$3,$2,$1)}')
#get future date
NEXT_WEEK=$(TZ="$(date +%Z)-168" date "+%Y%m%d")
# compare date
if [[ $EXPR_DATE -lt $NEXT_WEEK ]] then
echo mail -s "LICENSE KEY ABOUT TO EXPIRE ON $HOSTNAME " <email ID>
exit 0
else exit 0
fi
else exit 0
fi
#!/bin/ksh
#Coder: Bharath Nunepalli
DB_STATUS=/home/db_status
ccontrol list | grep -i running > $DB_STATUS
if [[ -s $DB_STATUS ]] then
#collect expiration date from cache
EXPR_DATE=$(csession cache "^CKEY"|grep -i ExpirationDate|awk '{print $3}'|awk -F'/' '{printf("%d%02d%02d\n",$3,$2,$1)}')
#get future date
NEXT_WEEK=$(TZ="$(date +%Z)-168" date "+%Y%m%d")
# compare date
if [[ $EXPR_DATE -lt $NEXT_WEEK ]] then
echo mail -s "LICENSE KEY ABOUT TO EXPIRE ON $HOSTNAME " <email ID>
exit 0
else exit 0
fi
else exit 0
fi
