Kbase P25546: Dbanalys gives contradicting Information about the DB size
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/02/2010 |
|
Status: Verified
SYMPTOM(s):
Dbanalys gives contradicting Information about the database size
The Total Combined size of the dbanalys is much smaller than the total blocks found in the database multiplied by the blocksize
Why do dbanalysis and prostrct statistics show different sizes for the database?
FACT(s) (Environment):
All Supported Operating Systems
Progress/OpenEdge Product Family
FIX:
The information given by dbanalys is correct.
For example if we have the following information from dbanalys (a database with blocksize of 4k):
Total Records size = 1.8 MB (1842.5K)
Total Indexes size = 500.3K
Total Combined size = 2.3MB (2342.8k)
270 empty blocks found in the DB
1546 total blocks found in the DB.
The first data shows the size in bytes (the sum of the size of each record and index) but doesn't take into account the the part of each block that is not used. If for each record we don't use a small part of the block, then when adding all those parts of all those database blocks the amount is not so small.
The second data is more real regarding the physical space in disk since it shows the real space the Database is taking in the disk (including the part of the blocks that are not being used). If you add the size of all the DB data extents, the result will be similar to this size (blocks x database blocksize).
One is the the size of the information saved and the other is the real physical size of the database.