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 is a base table?

2 Answers  


what are stage one indexable predicates?

1 Answers  


What are the Isolation levels possible ?

5 Answers  


What is normalization and what are the five normal forms?

1 Answers  


What are the benefits of using the db2 database?

0 Answers  


How to insert more than one record using insert?

7 Answers   Atos Origin, IBM,


What are the different types of base tables?

0 Answers  


wht is d/f b/w inner join and outer join ? d/f group by and order by having by ?

2 Answers  


What is the FREE command?

1 Answers  


What is meant by repeatable read?

4 Answers  


i hav created a program and moved to production but failed to create the table which is been used in the program. the program shows error as soon as it is moved or installed in production or shows error during its runtime. what is the sqlcode for this error

3 Answers   UST,


What is the COBOL picture clause for a DB2 column defined as DECIMAL(11,2)?

5 Answers   Emsang,


Categories