Sybase Monitor config file

 Monitor config file in Sybase

#!/bin/sh

#set -x

##

## This scripts initiates sp_monitorconfig for parameters that have gone over

##

##

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

## Change History

##

## Date         Programmer      Revisions

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

## 03/11/2010   Bhupendra

##

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

##

##

VERSION="monitor_config.sp Version 1.0"

## Input Parameters for script

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

ENV_DIR="/sybase_sa"

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

##

## Check for correct number of parameters

if [ $# -lt 1 ]

then

    echo "Usage: $0 <SQL-Server Name> "

    exit 1

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()

{

 ##

 ## Defining system variables

 SA_PW=`$GET_PW $SRVNAME`

 DATE=`date +%Y%m%d`

 OUTFILE="$SYB_SRV/monitor_config.$SRVNAME.${DATE}"

 touch ${OUTFILE}

}

MONITOR_CONFIG()

{

$ISQL_CMD -Usa -S${SRVNAME}  -w132<< EOF  >> ${OUTFILE}

${SA_PW}

sp_monitorconfig "all"

go

EOF

}

CLEANUP()

{

find $SYB_SRV -mtime +21 -name "monitor_config.$(SRVNAME}*" -exec /bin/rm -f {} \;

}

##

## MAIN SECTION

EXECUTE_ENV

SET_VARIABLES

MONITOR_CONFIG

CLEANUP

exit