How many buffer pools are there in DB2?

Question Posted / guest

2 Answers
7384 Views
I also Faced
E-Mail Answers

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

Define check constraint.

0 Answers

How to retrieve rows from a db2 table in embedded sql?

0 Answers

Is ibm db2 open source?

0 Answers

I have 3 cursors declared. Cursor1 retieves some data. Based on this curso2 will also fetches some data. In cursor3 (using for some updation) I'm using the data retrieved by the above 2 cursor. My question is, while working with cursor3, periodically if I give commit, will all the three crsors will be closed or only cursor3 will be closed?

4 Answers

What is a collection?

3 Answers

Can we declare DB2 HOST variable in COBOL COPY book?

2 Answers

What is the use of reorg in db2?

0 Answers

While creating a table, by mistake you have given size of one field as 10. But as per requirement size should be 8. What is your next step?

4 Answers CTS, IBM,

Which components manage deadlocks in db2?

0 Answers

How do you filter out the rows retrieved from a Db2 table ?