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

How can you split a table in to exactly half?

7 Answers   HSBC,


How to resolve -917 sql code in DB2?

3 Answers   Cap Gemini,


What are the benefits of using the db2 database?

0 Answers  


How to see the structure of db2 table??

4 Answers   IBM,


What are host variables in db2?

0 Answers  


What is database manager in db2?

0 Answers  


How do I create a table MANAGER (EMP-NO, MANAGER) where MANAGER is a foreign key which references to EMP-NO in the same table? Give the exact DDL.

3 Answers  


What is an EXPLAIN in DB2. How and what is the steps followed in EXPLAIN command. Can all the queries be used in EXPLAIN command to check the performance.

3 Answers   IBM,


What are the rules for db2 programming?

0 Answers  


What is load utility in db2?

0 Answers  


What is image copy in db2?

0 Answers  


in column y record abc.v abc.s xyz.j abc.h i wan only abc columns how to retrieve thi records

2 Answers   IBM,


Categories