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 available in db2?

Answer Posted / manisha shukla

A buffer pool is main storage that is reserved to satisfy
the buffering requirements for one or more tablespaces or
indexes, and is made up of either 4K or 32K pages.

There are four buffer pools: BP0, BP1, BP2, and BP32.

Is This Answer Correct ?    2 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Define sqlca.

1117


What is table space in db2?

1020


Comment whether the cursor is closed during commit or not.

1107


How to access db2 tables in mainframe?

1055


What are catalog tables in db2?

1051


What is a collection in db2?

1036


Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?

3157


What is the maximum No of rows per page?

1070


Is db2 a programming language?

1051


How do I delete a table in db2?

1075


What is db2?

1185


What does sqlcabc has?

1058


How connect db2 database to datastage?

1245


What does db2 plan contain?

1023


What is dbrm? What it contains? When it will be created?

1051