Need script that monitors for archive directory filling up

I've been bit one time too many by the archive directory filling up in unix.

I am looking for a korn shell script that will log into the database and find out what mount point the archives log files are being stored on. Then I'd like the script to do something like a df -k and see if the mount point has crossed a threshold for percentage full (something like 85% full). If that mount point is more than 85% full, I'd like the script to send me an email.

Anybody have such a script they'd be willing to send me? I think I can code the SQL part but I'm not that great with the unix part.

Eternal gratitude in advance,

Cherie Machler
Gelco Information Network Received on Wed Dec 13 2000 - 13:11:38 CST