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 plan and package in db2?
what is the certification that has a good value for a practioner in mainframes but not habving much knowledge on db2 related stuff?
How to resolve -504 sql code in DB2?
How do I delete a column in db2?
What is buffer pool?
What is the function of logging in the db2 database?
select * from orders where odate between '2010-01-01'and '2010-03-31' How do u fetch this into cursor?
Define buffer pool.
What is image copy?
What is alias in db2?
What are the full forms of spufi and dclgen and why are they used?
What is buffer pool and list some of them?