Resolution:
Data accessed from a DB2 table is first read from DASD and then moved into a bufferpool. Data in the bufferpool can remain resident in memory and thus avoiding the expense of I/O. DB2 provides bufferpool with sizes of 4K and 32K. BP0 thru BP49 are designated for 4K bufferpools while BP32K thru BP32K9 are for 32K bufferpools. We allow user to distribute the indexes (two for each publishing table) among bufferpools according to their DBA strategy.