catch.saravana
Member
Hi All,
We are planning to migrate our application from version 9.1E to 11.6. I am currently working on modifying the ST file from Type I to Type II storage area. We are good with the data area (applied the rough calculation provided by Tom & Adam).
On Index Area, I see 1 RPB, 64 RPB and 256 RPB for different Index Areas. From the guidelines provided by progress on the below article it says its better to give '8 blocks per cluster for index areas with 1 record per block' or 'Increase the index cluster size to 64 from 8, still 1 record per block' for fast growing tables.
What should be my RPB and cluster size in Type II for the index area that has currently 64 RPB and 256 RPB on Type I?
Only thing I noticed is these indexes have 5 to 8 components on each of them. Does this make a difference in RPB of Index Area?
Regards,
Saravanakumar B
We are planning to migrate our application from version 9.1E to 11.6. I am currently working on modifying the ST file from Type I to Type II storage area. We are good with the data area (applied the rough calculation provided by Tom & Adam).
On Index Area, I see 1 RPB, 64 RPB and 256 RPB for different Index Areas. From the guidelines provided by progress on the below article it says its better to give '8 blocks per cluster for index areas with 1 record per block' or 'Increase the index cluster size to 64 from 8, still 1 record per block' for fast growing tables.
What should be my RPB and cluster size in Type II for the index area that has currently 64 RPB and 256 RPB on Type I?
Only thing I noticed is these indexes have 5 to 8 components on each of them. Does this make a difference in RPB of Index Area?
Regards,
Saravanakumar B