Consultor Eletrônico



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.