1000 pages is very small. The total of all bufferpool memory should be about 50-75% of all real memory on the server. DB2 does not like virtual memory, so make sure you have real memory available. Also, make sure you understand that if there are four logical DPF partitions on a server, and 2 databases on a DPF system, and if both databases are configured with the same bufferpool sizes, then there will be eight sets of bufferpools on the server, so take that into consideration when ensuring you don't go over the maximum amount of real memory.
Regarding data bufferpools vs index bufferpools, a starting value for number of pages might be to allocate 3/4 of memory for data and 1/4 for indexes. But it is not clear if you have your system set up with separate bufferpools for data and indexes. Not sure what you mean by "control tables," but there is no benefit to making bufferpools larger than the total amount of data in those tables, since you would be wasting valuable memory.
For block size, a good starting number would be about 3% of total pages for that bufferpool, which would have to be calculated after you figured out all the other numbers.
Last edited by Marcus_A; 09-28-12 at 09:33.
M. A. Feldman
IBM Certified DBA on DB2 for Linux, UNIX, and Windows
IBM Certified DBA on DB2 for z/OS and OS/390