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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
![Avatar of Alex [***Alex140181***]](https://filedb.experts-exchange.com/files/public/2022/11/13/8257e912-ee3c-4a93-9df0-fe9a8a1515cf.jpeg){kind=small}
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
OK.
But if you don't have a monitoring infrastructure in place (Nagios/Icinga, PRTG, Zabbix, Spiceworks, etc, etc), you should consider it.
But if you don't have a monitoring infrastructure in place (Nagios/Icinga, PRTG, Zabbix, Spiceworks, etc, etc), you should consider it.
ASKER
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.
With humility, I thank everyone.
E.
ASKER
Thank you guys...
ASKER