SPACE check of sybase directories

 

SPCAE check of sybase directories :

Note : you may need to change some prams as per your env

#!/bin/sh

##

## space_check

##

##      Usage: space_check server_name dir_name threshold

##             server_name - the name of the ASE server

##             dir_name - name of directory to check. ex. /sybase

##             threshold - a number that indicates the percent above which to

##                          notify you. ex. 75

##      example: space_check p4nmb /sybase_sa 85

##          When the /sybase_sa directory is more than 85% full, notification

##          will be sent.

##

## Version 1.0

##

## =================================================================

## Change History

##

## Date         Programmer      Revisions

## -----------------------------------------------------------------

## 21/1/2012 Bhupendra bagde

##

## ==================================================================

##

## Input Parameters for script

SRVNAME=`echo $1 | tr '[a-z]' '[A-Z]'`

DIR_NAME=$2

THRESHOLD=$3

ENV_DIR=/sybase_sa

ENVFILE="$ENV_DIR/.$SRVNAME.env"

##

## Check for correct number of parameters

if [ $# -lt 3 ]

then

    echo "Usage: $0 <SQL Srvr Name> <dir name> <threshold>"

    exit 1

fi

if [ ! -d $DIR_NAME ]

then

   echo "space_check.csh: ** ERROR ** $DIR_NAME is not a valid directory name"

   exit

fi

EXECUTE_ENV()

{

 ##

 ## Check for existence of ASE file

 if [ ! -s $ENVFILE ]

 then

    echo "$ENVFILE files does not exist for ASE Server ($SRVNAME) .."

    echo "Script exiting ..."

    exit 1

 fi

 ##

 ## Source environment (ASE) file

 . $ENVFILE

}

SET_VARIABLES()

{

 TMP_FILE=$SYB_TMP/TMP_FILE.$$

 LNEW=`date +%Y%m%d"-"%R`

 rm -f $TMP_FILE 2>/dev/null

}

CHECK_DISKSPACE()

{

 ##

 ## extract the directory space used and name.

 ##

 XDATA=`df -k $DIR_NAME | grep "$DIR_NAME" | awk '{line=$0;line=substr(line,index(line,"%")-3,50);print line;}'`

 DIRSIZE=`echo $XDATA | cut -d"%" -f1`

 DIRNAME=`echo $XDATA | cut -d"%" -f2`

 ##

 ## Check to see if current size exceeds threshold.

 ##

 if [ $DIRSIZE -gt $THRESHOLD ]

 then

    SERVER=`/usr/ucb/hostname | awk -F"." '{print $1}' | tr '[a-z]' '[A-Z]'`

    MESSAGE="** WARNING ** On server ($SERVER) directory $DIR_NAME has exceeded threshold of $THRESHOLD% it is at $DIRSIZE%."

    echo "** WARNING ** On server ($SERVER) directory $DIR_NAME has exceeded threshold of $THRESHOLD% it is at $DIRSIZE%." > $TMP_FILE

    $SYB_BIN/send_messages $SRVNAME "$TMP_FILE" "$MESSAGE" BOTH ALL

 fi

}

##

## MAIN SECTION

EXECUTE_ENV

SET_VARIABLES

CHECK_DISKSPACE

rm -f $TMP_FILE 2>/dev/null

exit