Kbase P96410: When we bigrow clusters, can we monitor online the highest numbered cluster being used
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
28/07/2009 |
|
Status: Verified
GOAL:
When we bigrow clusters, can we monitor online, the highest numbered cluster being used within the grown group of clusters.
GOAL:
How to use VST's to monitor bi cluster use within a cluster group created by the command: proutil <daname> -C bigrow n
FACT(s) (Environment):
All Supported Operating Systems
Progress 9.x
OpenEdge 10.x
FIX:
Yes, we can monitor the bi file for which cluster position is active in the following way:
If you monitor the bi file using the following code, from when the database starts, you will be able to tell the number of closed clusters. The number of closed cluster will give you the last cluster filled, thus the "hi-water mark" within the cluster group, on the first pass through the grown cluster group:
FOR EACH _ActBIlog NO-LOCK:
DISPLAY
_BiLog-ClstrClose COLON 32 LABEL "bi clusters filled and closed"
WITH FRAME biLoggingFrame TITLE "BI cluster status"
SIDE-LABELS THREE-D CENTERED.
END.
If the database is shut down, then the number of closed clusters prior to shutdown plus the new number seen after startup will be the total unless the bi is truncated and re-grown. Then it will be from the beginning cluster. The closed cluster count starts at zero after stopping and restarting the database , but the new closed cluster count starts from the cluster it left off at.
This will work until the closed clusters reach the number of clusters grown.
Once the end of the existing cluster group is reached, it will attempt to re-use clusters from the beginning of the cluster ring, so it may not need more clusters then or ever .The closed cluster count will continue to grow as you re-use clusters within the current cluster ring . Dividing the number of closed clusters by the number of clusters in the current ring will give a remainder that approximates the current active cluster in your cluster ring. A bi file in the re-use cluster phase, the phase after all cluster have been used once, will not grow until a cluster cannot be re-used because of an active transaction or insufficient aging. If that happens, the bi file grows, as additional clusters are added to the ring . Thus the bi file has grown beyond the original group of cluster grown by the bigrow command.