IBM Support

What are system bufferpools or hidden bufferpools in DB2?

Question & Answer


Question

What are system bufferpools?

Cause

The System bufferpools are created by DB2 itself for emergency situations and used when the regular bufferpools or bufferpool configured for the database could not be allocated.

Answer

To ensure that an appropriate buffer pool is available in all circumstances, DB2 creates small system buffer pools, one with each of the following page sizes: 4 KB, 8 KB, 16 KB, and 32 KB. The size of each buffer pool is 16 pages. These buffer pools are hidden; they are not in the system catalog or in the buffer pool system files. These could not be used or altered directly.

Usually, these hidden system bufferpools are used when the main bufferpools could not be allocated due to insufficient memory or, other similar situations. These are used to avoid failure of functioning of the DB2 database. But, one should not continue to run a database which failed to allocate the main bufferpools and using the system bufferpools temporarily. Instead, fix the main bufferpool allocation failure reason and start using the normal bufferpools as soon as possible.

The name of the system bufferpools for four different page sizes :

IBMSYSTEMBP4K

IBMSYSTEMBP8K

IBMSYSTEMBP16K

IBMSYSTEMBP32K

Internal Use Only

This technote was generated by Technote Kickstart 1.1.0.19 based on Information Management PMR 47133,122,000.
View the associated PMR's text via Wellspring at: http://eclient.lenexa.ibm.com:9082/DocFetcher/source/PMR/47133.122.000%20O13/06/27

[{"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Business Unit":{"code":"BU001","label":"Analytics Private Cloud"},"Component":"Database Objects\/Config - Bufferpools","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"9.8;9.7;9.5;9.1;10.1;10.5","Edition":"Advanced Enterprise Server;Enterprise Server;Express;Workgroup Server"}]

Document Information

Modified date:
16 June 2018

UID

swg21643819