Kbase 20849: How to Interpret Option 7 in the Progress PROMON utility
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
2/7/2011 |
|
Status: Verified
GOAL:
How to interpret what Option 7 in the Progress PROMON utility indicates.
GOAL:
What is the information in promon Option 7 (Database Status, Record blocks with free space) telling me?
FACT(s) (Environment):
Progress 9.x
OpenEdge 10.x
FIX:
The "record blocks with free space" does not indicate the amount of space that can be reclaimed if a dump and load is performed. The option refers to the total number of record blocks that have (some) free space.
These blocks might contain one or more records and have enough free space that they are worth considering when space is allocated for a new record (or record fragment). In theory, there could be 200 bytes of free space in each block. These blocks are kept on a linked list called the "RM chain".
The space in these blocks can be reused.
To find out how much space is actually being used, and for what, use PROUTIL, tabanalysis and idxanalysis.