Sunday, September 12, 2010

How to setup an alert for GoldenGate LAG / Stopped / Abended process?

#!/usr/bin/ksh

GG_HOME=/oracleGG
if [ -d $GG_HOME ]
then

   rm -Rf showtrans_detail.txt
   cd $GG_HOME
   $GG_HOME/ggsci << *eof* > showtrans_detail.txt
   info all
   *eof*

   sqlplus "/ as sysdba" << *eof* >> showtrans_detail.txt
   alter session set NLS_DATE_FORMAT='DD.MM.YYYY HH24:MI:SS';
   select GROUP_NAME,GROUP_KEY,LAST_UPDATE_TS from GG_STDB3.CHKPTAB order by 3 ;
   *eof*

   LAG=`cat showtrans_detail.txt | grep -i replicat | awk '{print $4}' | cut -c 1,2,4,5,7,8 | sort -rn |  head -1`
   ABNDST=`cat showtrans_detail.txt | grep -E 'STOPPED|ABENDED' | wc -l`

 if [ $ABNDST -gt 0 ]
 then
  echo "GoldenGate ABENDED or STOPPED"
  echo "please send an email..."
 fi

 if [ $LAG -gt 3000 ]
 then
   echo "Lag $LAG in Golden Gate..."
   echo "please send an email..."
 fi
fi

No comments:

Post a Comment