What is buffrpool? Where we use it ?
- 2 Answers
- 14210 Views
- Tesco, I also Faced
- E-Mail Answers
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 cobol db2?
What are PACKAGES ?
What is referential integrity?
How does one bind 2 versions of a CICS transaction with the same module name in two different CICS regions that share the same DB2 subsystem?
Can we delete records from view?
can any one expalin check point with an example?
How to resolve -504 sql code in DB2?
How can the duplicate values be eliminated from db2 select?
What is cascading rollback?
What is dclgen (declaration generator)?
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
what is plan? is plan executable or package?
COBOL 
