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 / s

You can define:

50 4KB BP0-BP49
10 8KB BP8K0-BP8K9
10 16KB BP16K0-BP16K9
10 32KB BP32K0-BP32K9

The number of buffer pools you define is specific to the
DB2 sysbsystem and depends on the DB2 workload. If you dont
have enough real memory to support your bufferpools,
performance will affected severely because of paging.

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Which are the db2 tools to protect integrity of the database?

1095


What is commit in db2?

1017


How and when does the db2 enforces the unique key?

1061


What is db2 plan table?

1018


What is a bind card?

1178


What is package in db2 mainframe?

945


What is db2 bind?

1040


What is database manager in db2?

992


Explain about rct in db2?

1070


Define db2 and its databases?

1031


Explain how can you do the explain of a dynamic sql statement?

1088


What is the use of reorg in db2?

1058


What db2 400?

1132


What are the benefits of using the db2 database?

1187


What is dbrm?

1069