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 the 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.
