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 resolve the -305 error code in DB2? And also please let me know, how to resolve the db2 error codes.
What is a db2 collection?
What is temporal table in db2?
what is REORG? what is the use?
What is copy book?
What are the various locking levels available?
What is db2 purescale?
What is db2 optimizer?
What is the difference between spufi and qmf?
Generally if I want to select the names starting with c I need to use c% But how could I code to select the data which contains % as a part of data.
What is a page in db2?
what is the use of commit ? and what is the syntax?