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

Enachioken
Enachioken used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Commented:
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
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...

Author

Commented:
I am really looking written shell script(s) for this. I do not want any third-party tool/plug-in type of tools.
Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Commented:
OK.
But if you don't have a monitoring infrastructure in place (Nagios/Icinga, PRTG, Zabbix, Spiceworks, etc, etc), you should consider it.

Author

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.

Author

Commented:
Thank you guys...

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial