RealHeavyDude
Well-Known Member
OpenEdge 10.1c Sun Solaris 64Bit ( soon to upgrade to OE 11.3 )
Apparently we've hit a bug in OE 10.1c where the RECIDs in one storage area have grown beyond the 32Bit limit into 64Bit where records which have a 64Bit RECID are not retrieved by mulit-index queries ( OE00197068 ). And this is a real nasty one.
Since the upgrade is scheduled for Q1/2014 I want to proactively monitor my storage areas and asked myself what the best way to determine the largest RECID in a given storage area would be.
For one I could check each table located in the given storage area but that might be damn slow.
But, since I know how many blocks I have and what the records/block setting is, I am able to calculate how many records I could store in that area under ideal conditions ( number of blocks * records/block ). That should give me a hint as to how many RECIDs there are in the area and whether the number is larger than the limit for a 32Bit integer ...
Since we can't upgrade to OE11.3 that fast I need to split storage areas whose RECIDs potentially grow beyond the 32Bit limit as an interim solution.
I would be very pleased if anybody would share her/his thoughts.
Thanks in Advance and Best Regards, RealHeavyDude.
Apparently we've hit a bug in OE 10.1c where the RECIDs in one storage area have grown beyond the 32Bit limit into 64Bit where records which have a 64Bit RECID are not retrieved by mulit-index queries ( OE00197068 ). And this is a real nasty one.
Since the upgrade is scheduled for Q1/2014 I want to proactively monitor my storage areas and asked myself what the best way to determine the largest RECID in a given storage area would be.
For one I could check each table located in the given storage area but that might be damn slow.
But, since I know how many blocks I have and what the records/block setting is, I am able to calculate how many records I could store in that area under ideal conditions ( number of blocks * records/block ). That should give me a hint as to how many RECIDs there are in the area and whether the number is larger than the limit for a 32Bit integer ...
Since we can't upgrade to OE11.3 that fast I need to split storage areas whose RECIDs potentially grow beyond the 32Bit limit as an interim solution.
I would be very pleased if anybody would share her/his thoughts.
Thanks in Advance and Best Regards, RealHeavyDude.