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

Explain the contents that are a part of dclgen.

1137


What is check constraint. Explain with example.

1159


What is the maximum size of a char data type in db2?

1050


For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.

1156


Explain about mirror activator disk mirroring?

1061


What is the difference between drop table and delete table?

1285


What's The Error Code For Unique Index Voilation?

1299


What is a bind card?

1278


What is package in db2 mainframe?

1033


What is the information associated with sysibm.syslinks table?

1168


What are the contents of a dclmgen?

1176


What is load utility in db2?

1229


I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.

3263


What is the reason behind not using select * in embedded sql programs?

1166


What does sqlcabc has?

1098