Answer Posted / pavan grandhi
Buffer pool is a process of caching currently retrieved or
probable pages for retrieval from secondary storage (hard
disks, drums etc.), on to the primary storage.
It is for faster read/write cycles.
Used in OS/RDBMS, DB2 too.
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
How to create db2 table in mainframe?
What is rct?
What is the maximum No of rows per page?
can all users have the privilage to use the sql statement select * (dml)?
What is the difference between cursor stability and repeatable read isolation levels?
Can there be more than one cursor open for any program?
Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference
What is innodb buffer pool?
What are the various data types available in db2?
Explain in detail about buffer manager and its functionalities?
How connect db2 database to datastage?
What is runstats utility in db2?
How do I delete a table in database?
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
What kind of database is db2?