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

How can you count the number of rows from a table tab?

1075


What is the difference between plan and package in db2?

1095


What is the role of union all and union

1103


What is a bind in db2?

1020


How do I optimize a query in db2?

1080


What is cascading rollback?

1190


What is bind in db2?

1017


What is the use of reorg in db2?

1068


Why do chiropractors use drop table?

1083


How can you classify the locks in db2?

1077


what is a corelated subquerry?

1105


How do we specify index to include or not during bind process.

2107


How is the value function used?

1135


What is ibm db2 database?

989


Explain package in db2 and its advantages?

1188