Feedback
Did this article resolve your question/issue?

   

Article

How to calculate the number of bi clusters existing in the before-image log based off of the number of clusters shown in VST?

Information

 
TitleHow to calculate the number of bi clusters existing in the before-image log based off of the number of clusters shown in VST?
URL NameP182270
Article Number000137235
EnvironmentProduct: Progress
Version: 9.x
Product: OpenEdge
Version: 10.x, 11.x
OS: All supported platforms
Other: VST
Question/Problem Description
How to calculate the number of clusters existing in the before-image log based off of the number of clusters shown in VST?
How to calculate the number of clusters existing in the before-image log?
How many clusters exist in the bi log?
How to calculate clusters in the before-image log?
How to calculate current before-image log size at any given point using VST?
How to calculate current before-image log size at any given point?
How much data is in the BI file?
How to calculate the amount of free space in the BI file ?
Steps to Reproduce
Clarifying Information
Error Message
Defect/Enhancement Number
Cause
Resolution

The following ABL code computes the total number of clusters in the before-image log. 

  • The amount of data in the BI file in kilobytes,
  • There may be unused but allocated space after these clusters, if fixed bi extents are being used.
FIND _areastatus no-lock where _areastatus-areanum = 3.
FIND _dbstatus no-lock.

DISPLAY "Total BI Clusters:" string(_areastatus-hiwater * _dbstatus._dbstatus-biblksize 
               / _dbstatus-biclsize /  1024 ) + " kb".
 

Free space in the BI file(fixed BI Extent) can be calculated using the below formula   

Total size of BI Extent - The Amount of used space 


To calculate the total size of the before-image log, multiply the number of clusters from the above result with the before-image cluster size (_dbstatus._dbstatus-biclsize) which is stored as KB. 

Total before-image log size in KB:

FIND _areastatus no-lock where _areastatus-areanum = 3.
FIND _dbstatus no-lock.
    DISPLAY 
             (_areastatus-hiwater *
              _dbstatus._dbstatus-biblksize /
              _dbstatus-biclsize /
                1024) *  
              _dbstatus-biclsize.
Workaround
Notes
Last Modified Date11/20/2020 7:36 AM
Attachment 
Files
Disclaimer The origins of the information on this site may be internal or external to Progress Software Corporation (“Progress”). Progress Software Corporation makes all reasonable efforts to verify this information. However, the information provided is for your information only. Progress Software Corporation makes no explicit or implied claims to the validity of this information.

Any sample code provided on this site is not supported under any Progress support program or service. The sample code is provided on an "AS IS" basis. Progress makes no warranties, express or implied, and disclaims all implied warranties including, without limitation, the implied warranties of merchantability or of fitness for a particular purpose. The entire risk arising out of the use or performance of the sample code is borne by the user. In no event shall Progress, its employees, or anyone else involved in the creation, production, or delivery of the code be liable for any damages whatsoever (including, without limitation, damages for loss of business profits, business interruption, loss of business information, or other pecuniary loss) arising out of the use of or inability to use the sample code, even if Progress has been advised of the possibility of such damages.