Consultor Eletrônico



Kbase P113758: _DbStatus-BiClSize returning wrong value
Autor   Progress Software Corporation - Progress
Acesso   Público
Publicação   4/21/2008
Status: Verified

FACT(s) (Environment):

Progress 9.1E
OpenEdge 10.0x
OpenEdge 10.1A
All Supported Operating Systems

SYMPTOM(s):

_DbStatus-BiClSize returning wrong value

VST field _DbStatus-BiClSize shows different values from PROMON

_DbStatus-BiClSize retuns a smaller value than the actual bi cluster size

select _DbStatus-BiClSize from _DbStatus.

CAUSE:

The _DbStatus-BiClSize is returning the actual bi cluster size divided by 16KB. For example, _DbStatus-BiClSize returns 32 for a 512KB bi cluster size.

FIX:

To get the correct Before Image Cluster-size:

0.) Upgrade to OpenEdge 10.1B where this issue has been fixed, or
1.) Parse the database.lg file for the Before-Image Cluster Size: <num>. (4250), or
2.) Start a promon session and choose option 7 (Database Status), or
3.) Refer to Solution P11835, "How to monitor before-image growth with Virtual System Tables" which provides an example using the _Logging VST instead.