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

Could anyone clearly explain the diference between sub query and correlated sub query?

3 Answers  


What does db2 blu stand for?

0 Answers  


what is consistency token

3 Answers  


i want to maintain uniqueness on pdf without make lf??????????

0 Answers  


What is a collection in db2?

0 Answers  






wt is view ? wht r the restrictions for view ?

3 Answers   Verizon,


in db2, already 10 columns arie der, and i want to insert 11th column. what parameters u wil consider for insertion and how will u insert

1 Answers   TCS,


What does a deadlock mean in DB2?

0 Answers  


What is the picture clause of the null indicator variable?

6 Answers  


What is performance tuning db2?

0 Answers  


What is the function of the Data Manager?

2 Answers  


Explain what a plan is?

3 Answers   CTS,


Categories