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

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 the SQL Communications Area and what are some of its key fields?

1 Answers  

What do you mean by commit and rollback?

0 Answers  

what is the total syntax for fetch ? can any one please give me all the details of fetch ? thx

2 Answers   IBM,

What is a composite index and how does it differ from a multiple index?

1 Answers  

Define db2 and its databases?

0 Answers  

Mention a credible reason why select* is never given preference in an sql program that has been embedded.

0 Answers  

how to delete perticular row from table for ex. how you will delete 3rd row from table please answer THANKS IN ADVANCE

10 Answers   IBM,

What is temporal table in db2?

0 Answers  

i want to know how the commit option works,how it save the changes? it will update the database or what ? where we can see these saved changes?

4 Answers  

how we will do null data selection in cobol-db2 program

2 Answers   Wipro,

In cursor program perform para varying until 1 by 1 fetch para cursor------close para in the blank what will come for confirming in the database?

1 Answers   HCL,


4 Answers   Accenture,