Kbase P23833: How to find out the BI usage
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
9/21/2010 |
|
Status: Verified
GOAL:
How to find out the BI usage
GOAL:
What is the real size of my bi file?
GOAL:
How to tell the current bi file high watermark.
GOAL:
What is the current size of my bi file?
FIX:
The code below will first look for Areanum = 3 which is the bi are. Next we find the total block allocated by multiplying the total number of blocks in a area (_AreaStatus-Totblocks) by the BI block size (_Logging-BiBlkSize). Followed by multiplying the highest block used (_AreaStatus-Hiwater ) by the BI block size will give us the information we are looking for, ?the total BI file usage?.
After that some useful information is displayed:
BI Block Size
BI Cluster Size
Total cluster in use
FIND FIRST _AreaStatus WHERE _AreaStatus-Areanum = 3.
FIND FIRST _Logging.
DISPLAY _AreaStatus-Totblocks * _Logging-BiBlkSize FORMAT
">>,>>>,>>>,>>9" LABEL "Total Block Allocated"
_AreaStatus-Hiwater * _Logging-BiBlkSize FORMAT ">>,>>>,>>>,>>9"
LABEL "Total Used"
_Logging-BiBlkSize FORMAT ">>,>>>,>>>,>>9" LABEL "BI Block Size"
_Logging-BiClSize FORMAT ">>,>>>,>>>,>>9" LABEL "BI Cluster
Size"
_AreaStatus-Hiwater * _Logging-BiBlkSize / _Logging-BiClSize
LABEL "Clusters in Use"
WITH 1 COLUMN.