Shell Script

[Sanjiv Sharma_1]

Hi,

I am writing a shell script which will give me the database free space information and alert. I am getting the following output :

ds1dbs
5000000
991156

tmpdbs
1000000
999944

c3dbs
2000000
932508

s2dbs
5000000
1860968

rootdbs
512000
8815

testdbs
4000000
1087746

My requirement is that the script will calculate the percentage for all the above database like for testdbs:
1087746/4000000*100=27.19%.

If this percentage is more then 80% then it should send a mail to me?

Can anyone help me to get started?

Thanks,
Raje.

[Rodney Hills]

Raje,

You could use perl for the whole thing.

while(<>) {
chomp;
if (/^\d+$/) {
chomp($n2=<>);
$pct=100*$n2/$_;
push(@db,sprintf "%3d %s",$pct,$db) if $pct > 80;
} else {
$db=$_;
}
}
if (scalar @db) {
open(OUT,"|mailx -s 'Some databases are over 80%' youremail\@yourhome.com'");
print OUT $_,"\n" foreach @db;
close(OUT);
}

HTH

-- Rod Hills

[Jean-Louis Phelix]

Once again, just in case ...

Hello,

using shell ... cat your input to this script :

#!/usr/bin/sh

while read DBS
do
read BLOCKS
read USED
read
PERC=$(($USED \* 100 / $BLOCKS))
[ "$PERC" -gt 80 ] &&
{
echo "\n$DBS has ${PERC}% blocks used\n" | mailx -s "Free space in $DBS" phelix
}
done

And you will receive :

Date: Thu, 17 Oct 2002 09:16:30 +0200 (METDST)
From: Jean-Louis Phelix
To: phelix
Subject: Free space in tmpdbs

tmpdbs has 99% blocks used