#!/bin/sh

DBName='master MBFEWKDB MBFEHISDB DIRWAYSDB DISWAYSDB'

logdir=/sybase/dumpdb
tbslog=btmbfe_tbs.log
tbslog2=btmbfe_tbs2.log
fslog=btmbfe_fs.log

wkd=`date +"%w%H"` # 每周日中午12点收集空间大小

cd $logdir

cat /dev/null > $tbslog

#-- 数据库监控 --#
for db in $DBName
do
i_spool=$logdir/$db.spool

su - sybase -c "isql -Usa -PBtsa1@ < $i_spool
use $db
go
sp_spaceused
go
!"

if [ $wkd = "012" ]
then
    echo "\n--------------------------------------------------------" >> $tbslog2
    nowtime=`date +"%Y%m%d %H:%M:%S"`
    echo "--> $nowtime " >> $tbslog2
    cat $db.spool >> $tbslog2
    echo "--------------------------------------------------------\n" >> $tbslog2
fi

    i_total=`cat $i_spool | grep -E "[0-9]" | grep -v return | grep $db | awk 'BEGIN{OFS=" "}{print $2 }' `
    i_total=`echo $i_total|cut -d "." -f1`
    i_total=`expr $i_total \* 1024 `
    i_use=`cat $i_spool | grep -E "[0-9]" | grep -v return | grep KB| awk 'BEGIN{OFS=" "}{print $3 }' `
    #i_use=`expr $i_use / 1024 `
    i_percent=`expr $i_use \* 100 / $i_total `

    echo "$db:$i_total:$i_use:$i_percent%" >> $tbslog

    rm $i_spool

done

#--文件系统监控 --#
dfspace | grep -v "Total Disk Space" | tr -s "[\n]" | \
awk 'BEGIN{FS=":";OFS=":"}{print $1,$3 }'          | \
sed 's/[\)]//' | sed 's/[\(]//'                   | \
awk 'BEGIN{OFS=":"}{print $1,$6,$6-$3,100-$9 }' | \
sed 's/$/%/' > $fslog

ftp -i -n 30.23.1.66 <
user test test123
lcd $logdir
bin
prom
put $tbslog
put $fslog
by
!

ITPub博客

Sybase空间监控脚本 btmbfe_sybase_space_use.sh

最新文章