Kbase 20012: How to monitor database growth using VST's?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
6/17/2008 |
|
Status: Verified
GOAL:
How to monitor database growth using VST's?
GOAL:
Monitoring Database growth with VST's?
GOAL:
How to know the growth of a Database using the Virtual System Tables?
GOAL:
How Virtual System Tables can show how much a database is growing?
FACT(s) (Environment):
Progress 9.x
OpenEdge 10
FIX:
An alternative to using Progress utility prostrct statistics to monitor database growth is to use the Virtual System Tables (VSTs).
The following is a small 4GL program that will give you the Area Name, Total Blocks in that area, and the High Watermark for that area:
FOR EACH _AreaStatus:
DISPLAY _AreaStatus-AreaName LABEL "Area Name"
_AreaStatus-TotBlocks LABEL "Total Blocks"
_AreaStatus-Hiwater LABEL "High Watermark"
_AreaStatus-TotBlocks - _AreaStatus-Hiwater LABEL "Free" (SUM).
END.
Of course, you can customize this program, for example by adding a WHERE clause to the FOR EACH on fields like _AreaStatus-Areanum or _AreaStatus-Areaname.