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 maximum No of rows per page?

0 Answers   IBM,

Suppose if I need to update a column, how you do that using cursor?

2 Answers   Verizon,

How do you eliminate duplicate values in db2?

0 Answers  

A Table feild is declared as Decimal(7,2). I want to insert the decimal in to this column thru cobol-db2 program. How should I declare my local input file variable or any suggestion?

7 Answers   IBM,

What do you mean by storage group (stogroup)?

0 Answers  

What is query for your birthday date should be in hours,minute and seconds format?

1 Answers   Fidelity,

when does the SQL statement gets executed when you use cursor in the application programming ?

3 Answers   IBM,

what types of copies can be made with the COPY Utility ?

1 Answers  

What are the 4 environments which can access DB2 ?

2 Answers  

What does db2 plan contain?

0 Answers  

How do you run JCL in cobol program

1 Answers   IBM, Syntel,

What is filter factor?

2 Answers