hi all,

I want to calculate DB2 heap size (DBHEAP). In version IBM give the formulas:
In bytes:
(logbufsz * 4K)
+ 10K per table space
+ 4K per table
+ ( 1K + 4*extents used ) per range clustered table (RCT)

However I do not know how to calculate the value ( 1K + 4*extents used ) per range clustered table (RCT)

Anyone can guide me how to get the information to calculate this values. Plz give me an example if it is possible.

Thx much

which version is this calculation for?

it is version 8.1 fixpak 7

I have not seen that calculation. Assuming your logbufsz is 256 or less (which it should normally be), the almost every database can use 2048 for dbheap with plenty to spare. In version 7, dbheap depended on the size of the bufferpools, but this is no longer true.

You really should upgrade to the latest fixpack because FP7 is the first release of 8.2 and it has a lot of bugs. There have been more than 1500 APARs fixed in the fixpacks after FP7.

We just upgraded to fixpak 9 yesterday.

The formulas is from IBM for fixpak 4 and newer:

http://www-1.ibm.com/support/docview...id=swg21141490