How to create a DB2 bufferpool with pagesize 4096?

DB2DatabaseBig Data Analytics

Bufferpool is the unit of the main memory which is used to cache the data in the DB2 table. The data is stored in the cache once the database manager reads the data from the disk to the main memory. The bufferpool can be defined by giving the pagesize.

The page is the smallest unit of Input/Output that a DB2 database manager can handle. We can create a DB2 bufferpool using the below command−

CREATE BUFFERPOOL BP3
PAGESIZE 4096;

The CREATE and BUFFERPOOL reserved words are followed by the bufferpool name which we want to create. Finally we will use PAGESIZE parameter to give the size of the page which has to be used in bufferpool.

raja
Updated on 11-Sep-2020 14:04:29

Advertisements