For DB2: What is a BufferPool? Why does ADB prompt for it?
Article ID: KB0085425
Updated On:
| Products | Versions |
|---|---|
| TIBCO ActiveMatrix BusinessWorks Plug-in for Database | - |
| Not Applicable | - |
Description
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.
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.
Issue/Introduction
For DB2: What is a BufferPool? Why does ADB prompt for it?
Feedback
Yes
No
Powered by
