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 |
What is a system catalog table in db2?
What is a PLAN table? How will you use it? Give the various fields of PLAN table?
What is schema in db2?
db2 maintains information about the data... a.in tables. b.in a set of tables known as db2 catalog. c.in db2 database. d.none of the above.
What is host variable?
Which one allows duplicate values Union or Union All ?
What is sqlcode -922 ?
What is precompiler in db2?
How to fetch the uncommited data from table ?
What are the three types of page locks that can be held?
What is sqlcode -811?
7 Answers Accenture, CTS, TCS,
What is filter factor?