Script to monitor tablespace and filesytem growth and alert DBAs of pending "Filesystem Full" scenarios. Any such script to share?

Hello all,

I have a need to deploy a DB2 tablespace, diagnostic log files and especially the filesystem monitoring for potential "Log full", and/or  "Filesystem Full" situation. I am hoping to "borrow and modify for my own use" a very decent Linux/AIX script from one of our esteemed DBAs any such script that they use in their production environment for monitoring these objects. The script should monitor the current used space for tablespace, db2diag log files, filesystem size and alert DBAs when a threshold is reached (85%) of total space as Yellow and (90%) of space used as RED.

I will be very grateful for any assistance with in finding the kind of script that I am looking for.

Thanks
EnachiokenAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Dan CraciunIT ConsultantCommented:
For older versions of DB2, this Nagios plugins worked fine:
https://exchange.nagios.org/directory/Plugins/Databases/DB2/check_db2_health/details

Of course, this assumes you already have a Nagios server. If not, it may be overkill to monitor a single instance.

HTH,
Dan

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Alex [***Alex140181***]Software DeveloperCommented:
You may also want to take a look at Zabbix ;-)
http://www.zabbix.com/

It's open-source, so it's free and it's quite handy...
EnachiokenAuthor Commented:
I am really looking written shell script(s) for this. I do not want any third-party tool/plug-in type of tools.
Your Guide to Achieving IT Business Success

The IT Service Excellence Tool Kit has best practices to keep your clients happy and business booming. Inside, you’ll find everything you need to increase client satisfaction and retention, become more competitive, and increase your overall success.

Dan CraciunIT ConsultantCommented:
OK.
But if you don't have a monitoring infrastructure in place (Nagios/Icinga, PRTG, Zabbix, Spiceworks, etc, etc), you should consider it.
EnachiokenAuthor Commented:
I am still hoping for some assistance on using scripts/cron to solve this issue. Can I find a hero on this site?

With humility, I thank everyone.

E.
EnachiokenAuthor Commented:
Thank you guys...
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
DB2

From novice to tech pro — start learning today.