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 there in DB2?

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 happens in bind step in a db2 program?

0 Answers  


What is a storage group (stogroup)?

0 Answers  


Q3. How will you fetch duplicate values from a DB2 table?

2 Answers   RBS,


How do you select a row using indexes in db2?

0 Answers  


What keyword does an SQL SELECT statement use for a string search?

2 Answers  


What is dbrm? What it contains?

0 Answers  


On the create tablespace, what does the CLOSE parameter do?

1 Answers  


Mention the location where the output received from explain statement is stored.

0 Answers  


What are the prerogatives?

0 Answers  


What is the specific need of Plan and..where are the tables in DB2 are physically saved

3 Answers   Infosys,


Do we have any optinon to search part of integer in DB2 as we have for character Like,SUBSTR optins?

1 Answers  


Assuming that a site's standard is that pgm name = plan name, what is the easiest way to find out which Will precompile of an DB2-COBOL program bomb, if DB2 is down?

1 Answers  


Categories