Kbase P27397: How much space do I have left for my database to grow?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
12/06/2009 |
|
Status: Verified
GOAL:
How much space do I have left in an extent?
GOAL:
How to know the amount of data within a last fixed extent?
GOAL:
What is the overall high water mark of my database?
GOAL:
Do I have enough disk space remaining to accommodate my database expansion?
GOAL:
How to use VST's to aid in database space utilization planning?
GOAL:
When will I need to add a new extent?
FACT(s) (Environment):
Progress 9.x
All Supported Operating Systems
OpenEdge 10.x
OpenEdge Category: Database
FIX:
With the introduction of Storage Areas in Progress Version 9, the high-water mark for each area must be monitored to ensure that sufficient space is available to extend the database on a per area basis. Disregard for the high-water mark on a per area basis could result in abnormal shutdown of the database due to inability to extend within an area.
The formula to determine the overall Database high-water mark would be:
Overall High-water Mark = SUM(highwater marks for each storage area excluding 1 and 3)
FOR EACH _Areastatus
WHERE _AREASTATUS-AREANUM >= 6 NO-LOCK:
DISPLAY _AREASTATUS._AREASTATUS-AREANAME
_AREASTATUS._AREASTATUS-HIWATER (SUM).
END.
To calculate how much physical space is remaining on disk:
the difference between Total Database blocks and the Overall High-water Mark, is then Total Empty Blocks.
Total Empty Blocks * Database Block Size (bytes) = physical space remaining (bytes)
Comparing this to the O/S size of your database (by conversion of each to the same byte, order of magnitude) and the remaining space left on your system aides forecast planning exercises and prevents databases terminating abnormally.