Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


How many Buffer pools are there in DB2 and what are they?



How many Buffer pools are there in DB2 and what are they?..

Answer / s

Depends on how many Buffer pools you would like to define
to the system. You can use upto 50 4KB and 10 8KB, 10 16KB
and 10 32KB bufferpools

The minimum buffer pool storage that DB2 allocates
4KB 2000 pages
8KB 1000 pages
16KB 500 pages
32KB 250 pages

Is This Answer Correct ?    9 Yes 2 No

Post New Answer

More DB2 Interview Questions

What is dbrm? When it will be created?

0 Answers  


what are the copybook changes generally we done?can anyone tell me......... Thanks in advance........

1 Answers  


Is db2 a programming language?

0 Answers  


What is commit in db2?

0 Answers  


What is the syntax for seeing the columns and data types of a table in the db2 database?

0 Answers  


What is a LIKE table and how is it created?

2 Answers  


What is the cobol picture clause of the db2 data types date, time, timestamp?

0 Answers  


What are the three DB2 date and time data types and their associated functions?

1 Answers  


What's the maximum number of characters that a tablename can have?

3 Answers  


how we will do null data selection in cobol-db2 program

2 Answers   Wipro,


What are the three lock types?

2 Answers  


What is db2 bind process?

0 Answers  


Categories