Bharath's Tech Blog

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