I am creating a new BUFFERPOOL for 32K page tablespaces (DATA32, INDEX32 and TEMPSPACE32). All other tablespaces are at the 4K default.
When I size the new BUFFERPOOL, I was going to take the size of the tables and indexes I plan on moving to 32K and take that as a percent of the total size of all data and indexes.
Use that percent to reduce IBMDEFAULT and convert the freed pages to 32K and use that as the size for BP32.
Is there any other DB or DBM parameters that are affected by adding a new bufferpool.
I also stuck with a 32bit DB2. Application will not support 64bit at this time. I understand there is a limit on all allocated memory of 4GIG.
What are all the parms (and I assume BufferPools) that are added together that will give me the total memory used?
Thanks.....
When I size the new BUFFERPOOL, I was going to take the size of the tables and indexes I plan on moving to 32K and take that as a percent of the total size of all data and indexes.
Use that percent to reduce IBMDEFAULT and convert the freed pages to 32K and use that as the size for BP32.
Is there any other DB or DBM parameters that are affected by adding a new bufferpool.
I also stuck with a 32bit DB2. Application will not support 64bit at this time. I understand there is a limit on all allocated memory of 4GIG.
What are all the parms (and I assume BufferPools) that are added together that will give me the total memory used?
Thanks.....