trying to create shell script to monitor logfile size and email an alert message

cat555 · 11-11-2008, 04:19 PM

I am trying to create a shell script that will do a df -h on datafiles, if they are more then 80% full, I want it to send me an email alert message. I have a script that will check my mount points and send me a report once a day, but I need to be more proactive because these will fill really quickly when some jobs are running and they can lock up the database before you know what is going on.
Thanks for any suggestions and help

chrism01 · 11-11-2008, 05:29 PM

You've got various options:
1. use cron more frequently eg every 5 mins.
2. Get the controlling job to spawn off a checking script when it starts
3. get the output job to do its own data checking

etc. It depends on the lang and exactly how your app works.

cat555 · 11-12-2008, 11:16 AM

What I was looking to do was to create the script, have it cron'd to run every 5 minutes and only send me an alert when one of the mount points was filling up, so just when one of the datafiles was getting over 80%. One of the problems I am running into is that the servers have multiple files and I get into a loop. What I have so far is

df -h | grep oradata | awk '{ print $4 " " $5 }' output
if output $4 >= 80
then
mail -s "Alert: File filling up" $me
else
fi
As you can tell I have forgotten a lot ...
Another problem to this is that I need the alert message to identify which file and which host.
any help is greatly appreciated
thanks

chrism01 · 11-13-2008, 01:59 AM

You need something like this

Code:

for pcent in `df -h | grep oradata | awk '{ print $5 }' |cut -d'%' -f1`
do
    if [[ $pcent -ge 80 ]]
    then
        host=`hostname`
        mail -s "Alert: partition $pcent full on $host"  you@domain-name.com
    fi
done

note that df tells you how full a disk (actually a partition) is. You can't use it on a file.