What is buffrpool? Where we use it ?

Question Posted / guest

2 Answers
9614 Views
Tesco, I also Faced
E-Mail Answers

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?