Kbase P7790: High water mark versus total database blocks in promon
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/15/2008 |
|
Status: Verified
GOAL:
High water mark versus total database blocks in promon
GOAL:
Why is there a difference between the High water mark versus total database blocks in promon?
FACT(s) (Environment):
Progress 8.x
FIX:
There is some confusion surrounding the meaning of the values give for the Total number of database blocks, and Database blocks high water mark in the promon "Database Status" option screen".
The "Total number of database blocks" is equal to the physical database size. This number is reported in blocks, and requires you to multiply the number by the database block size to determine the physical database size in bytes.
The "Database blocks high water mark" is equal to the largest number of database blocks that contained data since the creation of the database. It is the pointer between the data/index information in the database and the free chain which is a list of empty blocks waiting to be allocated as index or data information.
In other words, the Total number of database blocks will always be equal to or higher than the high water mark.