DB2 Create Bufferpool

78

Create a Bufferpool

If you want to create a new bufferpool for database server, you just need two parameters named “bufferpool name” and “size of page”. Use the following query to create a new bufferpool:

Syntax:

Here,’bp_name’ specifies name of the bufferpool and ‘size’ specifies size for page. You need to declare for bufferpools (4K,8K,16K,32K)

Example:

Let’s create a new bufferpool named “new_bufferpool” where pagesize is 8192.

Output: