Question Calculating storage area size and wasted space based on RPB setting?

[doemichael687]

Hello,

I'm currently working on a database analysis report and dealing with two tables situated within a type 2 storage area. The storage area has a block size of 8K and is operating under OE 12.8.

Here are the specifics:

• mytable1 contains 188573993 records, each averaging 464 bytes.
• mytable2 contains 309841941 records, averaging 106 bytes each.

I referred to Progress Knowlege Base KBP7561 as a guide for calculating records per block.

Based on this, the estimated records per block (RPB) are:

• mytable1 = 16 or 32
• mytable2 = 64 or 128

I am leaning towards selecting the lower RPB values as the records do not significantly expand post-insertion. However, I'm encountering issues when calculating the minimum storage area size; particularly, I get negative numbers for the storage area size of Table 1 when applying an RPB of 32, as per the examples in the Progress KB.

Could someone assist by providing a working example or method to accurately calculate the minimum storage area size, the amount of wasted space, and the impact on row IDs? I would like to apply this example calculation across all my tables.

Thank you in advance for your guidance.