Setting the DB2 buffer pool size

The database server is equipped with 8 GB memory. This allows a larger buffer pool than the initial default buffer pool size.

The buffer pool size is set to 4 GB for the System Under Test (SUT). The value is in 4 KB pages.

Sample command: change DB2 default buffer pool size

db2 -v “alter bufferpool ibmdefaultbp size 1048576 
Note: If the profile variable DB2_PINNED_BP is set, it is important to understand that the database server memory must not be overcommitted. This will result in poor performance, because the Linux memory management is capped when it runs out of memory.