SQL and Access Paths › Access Paths › Virtual Buffer Pools

Virtual Buffer Pools

You can have up to 80 virtual buffer pools. This feature allows up to any one of the following buffer pool sizes:

• Fifty 4-KB page buffer pools BP0 - BP49
• Ten 32-KB page buffer pools BP32K - BP32K9
• Ten 8-KB page buffer pools
• Ten 16-KB page buffer pools

The physical memory available on your system limits the size of the buffer pools, with a maximum size for all buffer pools of 1 TB. It does not use additional resources to search a large pool versus a small pool. If you exceed the available memory in the system, the system begins swapping pages from physical memory to disk. This swapping can severely affect performance.