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 do I create a view in db2?

982


What is host variable?

1027


What is the physical storage length of the data types: date, time, timestamp in the db2 database?

1124


define clustering index.

989


Is db2 free?

1047


What is the maximum number of columns in a db2 table?

1235


What is check constraint. Explain with example.

1060


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

1058


List down the types of triggers in the db2 database?

984


B37 abend during spufi?

1421


What are the different types of base tables?

1048


Explain packages.

1068


What is the clustering index in the db2 database?

968


Mention the definition of cobol in varchar field.

1203


Define sqlca.

1074