What is a buffer pool?
Answers were Sorted based on User's Feedback
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 |
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 |
How can you split a table in to exactly half?
How to resolve -917 sql code in DB2?
What are the benefits of using the db2 database?
How to see the structure of db2 table??
What are host variables in db2?
What is database manager in db2?
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.
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.
What are the rules for db2 programming?
What is load utility in db2?
What is image copy in db2?
in column y record abc.v abc.s xyz.j abc.h i wan only abc columns how to retrieve thi records