What is buffrpool? Where we use it ?
Answers were Sorted based on User's Feedback
Answer / s
Bufferpools are areas of virtual storage where DB2
temporarily stores the pages of tablespaces and indexes.
Is This Answer Correct ? | 12 Yes | 0 No |
Answer / 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 |
what is the difference between normal select query and currosor
What are foreign keys in db2?
What is the use of with ur in db2?
Highlight all the advantages that are attached to a package.
List out the buffer pools in db2
When Can you be sure that a query will return only one row?
In cobol+DB2program if the code of cobol program has changed than i have to do precompilation once again?
How can the firstname and the lastname from the emp table be concatenated to generate complete names?
Write a query to extract first 5 characters of a name in the column Stud_Name?
in column y record abc.v abc.s xyz.j abc.h i wan only abc columns how to retrieve thi records
What is UNION,UNION ALL?
What is the role of the data page in the db2 database?