- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
- 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.
Updated on 11-Sep-2020 14:04:29
- Related Questions & Answers
- How to create a DB2 Tablespace in storage group STG1 and bufferpool BP01?
- How to create a DB2 storage group STG1 with volume VOL1.
- How to create a DB2 tablespace TABSPAC1 in the database DBSPAC1?
- How to create a DB2 database DBSET1 in the storage group STG1?
- How to create a DB2 segmented tablespace TABSPAC2 in storage group STOGRP1?
- How to update DB2 table with a duplicate primary key?
- How to create a DB2 table TAB1 with 4 columns, Student ID, Enrollment ID, Name and Age?
- How to create an ALIAS TAB2 for DB2 table TAB1?
- How to precompile a COBOL-DB2 program?
- How to delete a DB2 table TAB1?
- What is STORED PROCEDURE in a DB2? How will you create a new stored procedure?
- How to get the list of all COBOL-DB2 programs using a DB2 table TAB1?
- How to store a NULL value in a particular column of a DB2 table using COBOL-DB2 program?
- How to create a table with a caption?
- How to create a Bibliography with HTML?
Advertisements