lonegroover
New Member
Hi there.
I'm a Unix sysadmin and have recently taken over responsibilities for a number of boxes running Progress databases following the departure of a colleague. I have some notes on clearing out full extents, and I've been able to do that successfully. But apart from that, unfortunately I know next to nothing about Progress.
Sorry about that.
Anyway Nagios flagged up a warning at the weekend for a production server, complaining that a data area had crossed a threshold. Having spent a few minutes googling, and following a brief chat with our database developer, I still don't know how to fix it. Here's the pertinent bit of the log file:
.. Data Area 2 is the one Nagios complained about, having crossed the 85% mark.
Two questions then.
Firstly - is there likely to be an impact on reliability or performance as the data areas grow closer to 100%?
And secondly, how to fix this?
I appreciate that these probably seem naive questions, but I'm grateful for any help or advice.
Thanks,
James
I'm a Unix sysadmin and have recently taken over responsibilities for a number of boxes running Progress databases following the departure of a colleague. I have some notes on clearing out full extents, and I've been able to do that successfully. But apart from that, unfortunately I know next to nothing about Progress.
Sorry about that.
Anyway Nagios flagged up a warning at the weekend for a production server, complaining that a data area had crossed a threshold. Having spent a few minutes googling, and following a brief chat with our database developer, I still don't know how to fix it. Here's the pertinent bit of the log file:
Code:
[16/01/12 10:00:01 Area Status Check for DB: /db/production/production.db
OpenEdge 10
Storage Areas violating capacity thresholds ( 20%/ 70%):
Area Name %Used Suggest %Projected
------------------------- -------- ------------- ----------
Schema Area 78% 2,496 50%
Data Area 1 73% 1,523,760 50%
Data Area 2 86% 15,536,176 50%
Data Area 3 81% 1,703,984 50%
Index Area 1 83% 5,083,952 50%
.. Data Area 2 is the one Nagios complained about, having crossed the 85% mark.
Two questions then.
Firstly - is there likely to be an impact on reliability or performance as the data areas grow closer to 100%?
And secondly, how to fix this?
I appreciate that these probably seem naive questions, but I'm grateful for any help or advice.
Thanks,
James