- Trending Categories
- Data Structure
- Networking
- RDBMS
- Operating System
- Java
- MS Excel
- iOS
- HTML
- CSS
- Android
- Python
- C Programming
- C++
- C#
- MongoDB
- MySQL
- Javascript
- PHP
- Physics
- Chemistry
- Biology
- Mathematics
- English
- Economics
- Psychology
- Social Studies
- Fashion Studies
- Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
How to create a DB2 bufferpool with pagesize 4096?
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.
Advertisements