Kbase P25852: How many records are fragmented in a given table?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
6/29/2009 |
|
Status: Verified
GOAL:
How many records are fragmented in a given table?
GOAL:
How to verify if the records per block calculation was accurate after loading a table?
FACT(s) (Environment):
All Supported Operating Systems
Progress/OpenEdge Product Family
OpenEdge Category: Database
FIX:
Run dbanalys, then take a look at the output and subtract the number of records by the fragments count for the table of interest.
For example:
The output of the command:
$ proutil db_name -C dbanalys > recount.txt
Shows that no more than 7 (= 1638 - 1631) records are fragmented on this table.
-Record Size (B)- ---Fragments--- Scatter
Table Records Size Min Max Mean Count Factor Factor
TABLE_NAME 1631 183.2K 87 153 115 1638 1.0 6.7