Kbase P11041: How to check how much data is in database?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
28/10/2008 |
|
Status: Verified
GOAL:
How to check how much data is in database?
GOAL:
How to use VST table to check how much data is in database?
GOAL:
How to check how many database blocks are really in use for a database with fixed-length extents.
FACT(s) (Environment):
Progress 9.1x
FIX:
The following method is using Area Status File to determine what is the highest block used.
FOR EACH _areaStatus NO-LOCK:
DISPLAY _areaStatus-Areanum
_areaStatus-AreaName
_areaStatus-Totblocks
_areaStatus-HiWater
.
END.
In order to estimate what is the level of data in each extent/ of the database
you need to know the database block size and each extent size.