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...

  1. Categories >> Software >> MainFrame >> IBM MainFrame >> DB2
  2. Suggest New Category

How many buffer pools are there in DB2?

Question Posted / guest

Answers were Sorted based on User's Feedback



How many buffer pools are there in DB2?..

Answer / sabahat khan

50 4K size Buffer Pool BP01 to BP49
10 8K size Buffer Pool 8KBP0 to 8KBP9
10 16K size Buffer Pool 16KBP0 to 16KBP9
10 32K size Buffer Pool 32KBP0 to 32KBP9

Is This Answer Correct ?    15 Yes 0 No

How many buffer pools are there in DB2?..

Answer / sunil1405

4 Buffer pools. BP0,BP1,BP2

Is This Answer Correct ?    5 Yes 9 No

Post New Answer

More DB2 Interview Questions

What are column-name qualifiers used?

1 Answers  

Give some example of statistics collected during RUNSTATS?

1 Answers  

What is a collection?

3 Answers  

Why might full image copies be faster to implement than an incremental image copy?

4 Answers  

Explain about dbrm.

0 Answers  

What is buffrpool? Where we use it ?

2 Answers   Tesco,

How does one bind 2 versions of a CICS transaction with the same module name in two different CICS regions that share the same DB2 subsystem?

2 Answers  

How can you quickly find out the number of rows updated after an update statement?

1 Answers   CSI, CTS,

How does DB2 determine what lock-size to use?

2 Answers  

What is runstats db2?

0 Answers  

how will you retrieve first record in table

1 Answers   UST,

What are leaf pages?

3 Answers  

For more DB2 Interview Questions Click Here
Categories