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 use of value function?
Explain the use of the WHERE clause?
What is the specific need of Plan and..where are the tables in DB2 are physically saved
What is db2 purescale?
what are the SQL codes u freequently got?
How do I connect my db2 database to ibm?
What are the 2 sqlcodes that are returned?
What is bind in db2?
Give the name of some fields form sqlca.
how to resolve -811 sqlcode .give clear explaination
How would you move a tablespace (using STOGROUP) to a different DASD volume allocated to that tablespace?
How to find primary key of a table in db2?