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 copy book?
Can we declare cursor in Procudere division or open the cursor in the Working storage section. Is there any particular rules in the usage of cursors lifecycle
How to resolve deadlock issue
how to resolve -805 . how to see dbrm and package not found
How do I optimize a query in db2?
What is blu acceleration in db2?
What are PACKAGES ?
What does DML stand for and what are some examples of it?
What is sqlca?
When one binds a PACKAGE ( of a plan ) what package information is stored and where it is stored?
How to create a table using embedded sql?
Which one allows duplicate values Union or Union All ?