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 to find last record before record through SQLRPGLE?
What is filter factor?
What are the functions in DB2?
What are the different types of base tables?
How we create a tables in DB2 ?Previously client has using 7 letters for user id,now he wants to increase the letters from 7 to 12 for user id.How we can do it?
What information is contained in a SYSCOPY entry?
Define data page.
What is the difference between db2 and oracle?
What is data manager?
Can a unique index have more than one null value? If not, what error code is given if an attempt is made to insert more than one null value?
What is the FREE command?
What is the size of a data page?