Follow Our FB Page << >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

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

In BIND, isolation level parameter specifies the duration of page lock and ACQUIRE, RELEASE also do almost the same thing. What is the exact difference between the two? Do they work in conjunction while executing SQL queries and obtaining locks?

8 Answers   Syntel,

What is a PLAN table? How will you use it? Give the various fields of PLAN table?

1 Answers   Accenture,

Why use RUNSTAT Utility?

3 Answers   Merrill Lynch,

what are bind concepts in db2 cobol?

0 Answers  

How will fetch last 5 rows from table in db2

6 Answers  

What are the isolation levels possible ?

3 Answers  

how can u retrieve the data from null values using applicaion program.

3 Answers   TCS,

What is a db2 cursor?

0 Answers  

How to run db2 command in windows?

0 Answers  

db2 query I have one table with the following details. SNO SNAME DOJ ------ -------------------- ---------- 10 KRISH 2007-03-19 20 REDDY 2007-05-19 30 RRRRR 2007-05-19 40 BBBBB 2008-05-19 50 CCCCC 2009-05-19 60 JJJJJ 2009-05-19 70 JJJJJ 2004-05-19 i want the output in the following format:( no of students joined in each year(no nedd to consider about month and date) year count --------- ---------- 2004 1 2007 3 2008 1 2009 2

9 Answers   TCS,

What is a db2 tablespace?

0 Answers  

How do I import data from excel to db2?

0 Answers