Kbase 19769: Promon Empty Problem in Progress Version 9.x
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
09/10/2008 |
|
Status: Unverified
FACT(s) (Environment):
Progress 8.x
Progress 9.x
SYMPTOM(s):
Viewing the number of "Empty blocks:" using the R&D option of the
PROMON utility resulting in an inordinate percentage of empty blocks.
CAUSE:
The example below shows that the database is comprised of 20% empty space while the variable extents continue to grow:
Database was started at: 05/06/00 06:47
It has been up for: 58:10:50
Database state: Open (1)
Database damaged flags: None
Integrity flags: None
Most recent database open: 02/19/00 11:43
Previous database open: 05/06/00 06:47
Local cache file time stamp: 03/25/00 06:58
Database block size: 4096 bytes
Number of blocks allocated: 5161998 (20647964 kb)
Empty blocks: 1048216 (20 %)
Free blocks: 0 (0 %)
RM blocks with free space: 327 (0 %)
Last transaction id: 466122521
Highest table number defined: 159
Database version number: 91
Shared memory version number: 9045
RETURN - show remaining, U - continue uninterrupted, Q - quit:
FIX:
There are multiple high water marks with Storage Areas and PROMON has not matured enough to know about them. In the meantime, use the _AreaStatus VST to look at the high water marks of all the individual areas. The following code should show the required information:
FOR EACH _Areastatus:
DISPLAY _Areastatus WITH 1 COLUMN.
END.
Also, the following information may be seen when running the PROMON utility in Progress 9.x that is different than in Version 8.x:
Block alloc empty blocks Free Blocks
512841 512841 0
The information shown in Progress 8.x is correct.