Javatpoint Logo
Javatpoint Logo

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"

Verify a Bufferpool

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:

Verify a Bufferpool

Alter a fixed Bufferpool size

Syntax:

Example:

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

Output:

Verify a Bufferpool




Please Share

facebook twitter google plus pinterest

Learn Latest Tutorials


Preparation


Trending Technologies


B.Tech / MCA