What is a buffer pool?

Answers were Sorted based on User's Feedback



What is a buffer pool?..

Answer / s

Buffer pool are areas of virtual storage that temporarily
stores tablespace pages and index pages.

Is This Answer Correct ?    2 Yes 0 No

What is a buffer pool?..

Answer / raja

yes what is said above is right. the reason for maintaining
a buffer pool is to minimise the time required for a page
to be accessed for IDMS. the buffer pool is the place which
is searched first by the IDMS for a page.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More DB2 Interview Questions

What is database manager in db2?

0 Answers  


What is DB2 (IBM Database 2)?

3 Answers  


What are packages in db2?

0 Answers  


How to define the a field which accepts value till 99999.99 in db2

3 Answers  


What are the disadvantages of using VARCHAR?

3 Answers  






Which one allows duplicate values Union or Union All ?

3 Answers  


When do you specify the isolation level? How?

1 Answers  


List out the three types of page locks that can be held.

0 Answers  


What's The Percentage Free Space ?

0 Answers   IBM,


How to resolve -407 sql code in DB2?

9 Answers   Cap Gemini,


insert into tablename a column1, column2 select column1, column2 from tablename b i am getting abend -104..can any one help?

3 Answers   Syntel,


what is the process of precompiler?

2 Answers  


Categories