OpenEdge 10.1c Solaris SPARC 64Bit Enterprise Database license.
I am trying to set up a before image monitor which should detect when the before image is in danger of getting filled up. I figured out how to fetch the hiwater from the _AreaStatus VST - but as the clusters get re-used and the hiwater mark stays the same, how can I determine the actual utilization?
Thanks in Advance and Best Regards,
This code will tell you how many clusters have been allocated:
find _areastatus where _areastatus-areanum = 3.
display _areastatus-hiwater * _dbstatus._dbstatus-biblksize / _dbstatus-biclsize / 1024 .
to find the number of clusters in use, subtract the oldest in use cluster number from the newest in use cluster number.
_trans._trans-counter has the starting cluster number for a transaction.
The smallest value tells you the oldest cluster that is in use.
To find the newest, start a transaction and update something. get the _trans-counter value. then undo your transaction. Or use the largest value in _trans as an estimate.
thank you very much - that really helps me a lot!
Thanks and Best Regards,