Kbase P44730: How many clusters are there in the bi file?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
28/07/2009 |
|
Status: Verified
GOAL:
Is there a tool for calculating the number of clusters in a bi file?
GOAL:
How many clusters are there in a bi file?
FACT(s) (Environment):
All Supported Operating Systems
Progress 8.x
Progress 9.x
OpenEdge 10.0A
CAUSE:
Bug# OE00089542
FIX:
Upgrade to 10.0B or later.
Prior to OpenEdge 10.0B, the methods below reported ambiguous sizes. These discrepancies are listed accordingly.
OFFLINE:
$ proutil dbname -C biscan
is an offline utility which will output a listing of each bi cluster created at that moment to the database log file.
NOTE: At the time this solution was written, the "Cluster size" reported, is actually the number of bi blocks per cluster:
(Before-image cluster size)/(Before-image block size)
Similarly, the "Before Image File Size" reported, is actually the number of bi blocks in the bi file:
(Before-image log size)/(Before-image block size)
ONLINE:
$ promon dbname -> (type in) "R&D" (without the quotes -> [enter] -> 1. Status Displays -> 9. Bi Log
The Before-image log size (KB) reported, will be out by 1 x "Before-image block size", furthermore, it should be compared with the OS filesize, but this cannot always be truly relied on in some OS.
For a rough calculation, it fits the ballpark figure.
((Before-image log size KB) + (Before-image block size))/
(Before-image cluster size) = "Number of BI clusters"