What is buffrpool? Where we use it ?

Answers were Sorted based on User's Feedback

What is buffrpool? Where we use it ?..

Answer / s

Bufferpools are areas of virtual storage where DB2
temporarily stores the pages of tablespaces and indexes.

Is This Answer Correct ?    12 Yes 0 No

What is buffrpool? Where we use it ?..

Answer / pavan grandhi

Buffer pool is a process of caching currently retrieved or
probable pages for retrieval from secondary storage (hard
disks, drums etc.), on to the primary storage.

It is for faster read/write cycles.

Used in OS/RDBMS, DB2 too.

Is This Answer Correct ?    2 Yes 2 No

Post New Answer

More DB2 Interview Questions

What is concurrency?

0 Answers  

Lot of updates have been done on a table due to which indexes have gone haywire. What do you do?

2 Answers  

Can DASD types assigned to storage groups be intermixed (i.e., 3350s and 3380s)?

1 Answers  

What is cursor stability?

1 Answers  

When do you specify the isolation level?

0 Answers  

What are leaf pages?

3 Answers  

Q4. How will you get the count of record without using COUNT verb in query?

2 Answers   IBM,

what is Runstats? Whem will u choose to runatats?

1 Answers   Danske,

Can you use a select query in a loop to fetch multiple rows? If so what is the advantage of using a cursor?

2 Answers   L&T, UST,

i have one file having 100 of records? i want to display it like 20 records in one column and 20 records in another column total 40 records per page ? how ?

2 Answers   EDS,

How is a typical DB2 batch program executed ?

1 Answers  

max number of columns in a db2 table?

6 Answers