Kbase P19535: How to monitor the BI file usage?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
7/28/2009 |
|
Status: Verified
GOAL:
How to monitor the BI file usage?
GOAL:
Number of active BI clusters since Database Broker started
GOAL:
How much of the BI file is in use?
FACT(s) (Environment):
All Supported Operating Systems
Progress 8.x
Progress 9.x
OpenEdge 10.x
FIX:
Within the Virtual System Table _ActBILog, the field _BiLog-ClstrClose gives the Number of BI clusters filled and closed in preparation for reuse since the DataServer broker started; it is a accumulative field.
Within the Virtual System Table _ActSummary, the field _Summary-Chkpts gives the Number of Checkpoints, i.e. the number of BI clusters filled since the Database Broker started.
BI clusters have been reused when _ActBILog._BiLog-ClstrClose, or _ActSummary._Summary-Chkpts, are higher than the total number of clusters within the BI file.
The total number of clusters within the BI file can be calculated with information from 2 fields of _DbStatus:
_DBStatus-BiSize which gives the logical size of the BI file
_DbStatus-BiClSize which gives the size of the BI cluster.
It can be seen that clusters have been reused when you do have when:
_ActBILog._BiLog-ClstrClose > (_DbStatus._DBStatus-BiSize / _DbStatus._DbStatus-BiClSize)
Starting with V9, using the Virtual System Table _AreaStatus you can monitor if additional clusters are formatted within a BI as the following value will increase:
_AreaStatus-Hiwater where _AreaStatus-Areaname = "Primary Recovery Area".