멋지게 놀아라

#!/usr/bin/ksh

SHELLHOME=/fsudb/db2inst1/HOME/EXEM/SHELL/ARCDEL

NOW=`date '+%Y%m%d_%H%M'`

# Check Node Number And Make DIRNODE environment Variable 

    case `/usr/ucb/expr length $DB2NODE` in

          1) DIRNODE=`/usr/ucb/expr NODE000$DB2NODE` ;;

          2) DIRNODE=`/usr/ucb/expr NODE00$DB2NODE` ;;

          3) DIRNODE=`/usr/ucb/expr NODE0$DB2NODE` ;;

          4) DIRNODE=`/usr/ucb/expr NODE$DB2NODE`;;

    esac

    #echo $DIRNODE

# Connect to Database 

    db2 connect to $DBNAME >> /dev/null

# Get DB CFG ( archive log directory )

    db2 get db cfg | grep LOGARCHMETH1 > $SHELLHOME/arc.out

# Get Archive log directory from out file

    ARCHOME=`cat $SHELLHOME/arc.out | awk -F: '{print $2}'`

# Check last character from archive log directory 

    TEMP1=`/usr/ucb/expr length $ARCHOME`

    TEMP2=`/usr/ucb/expr substr $ARCHOME $TEMP1 1`

    #echo $TEMP2

# Make Full Archive log directory

   if [ "$TEMP2" = "/" ] ; then 

      #ARCHOME=$ARCHOME$DB2INSTANCE/$DBNAME/$DIRNODE/C0000000

      ARCHOME=$ARCHOME$DB2INSTANCE/$DBNAME/$DIRNODE

   else

      #ARCHOME=$ARCHOME/$DB2INSTANCE/$DBNAME/$DIRNODE/C0000000

      ARCHOME=$ARCHOME/$DB2INSTANCE/$DBNAME/$DIRNODE

   fi

   #echo $ARCHOME

#  Count archive log files

   CNT=`find $ARCHOME -type f  | wc -l`
   DELCNT=`expr $CNT - 150`

   if [ $CNT -gt 150 ]  

      then

          echo "Removing Files...." > $SHELLHOME/$NOW.out
          find $ARCHOME -type f | xargs ls -t | grep -v dr >> $SHELLHOME/$NOW.out
          sed -e '1,/150/d'  $SHELLHOME/$NOW.out >> $SHELLHOME/$NOW_del.out
          cat  $SHELLHOME/$NOW_del.out  | xargs /bin/rm 
          db2 terminate  >> /dev/null
          exit    
  fi  

 

# Exit Shell

exit