Verify Bufferpools

One bufferpool is automatically created at the time of database creation and one bufferpool we have created above. Now you can check your created bufferpools in current database.

Example:

db2 "select bpname,pagesize,npages from syscat.bufferpools"

Make a bufferpool resize automatically

Use the following command to resize the bufferpool automatically. You must have STMM turned on at the database configuration level for this functionality.

Syntax:

Example:

Let's resize the already created bufferpool "new_bufferpool".

Output:

Alter a fixed Bufferpool size

Syntax:

Example:

Let's alter the size of the bufferpool named "new_bufferpool".

Output: