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 |
how to take the back up of the DB2 table.
In terms of DB2 indexing, what is the root page?
What should be specified along with a cursor in order to continue updating process after commit?
When do you specify the isolation level? How?
How can the duplicate values be eliminated from db2 select?
Is it possible to precompile if db2 goes down?
When would you prefer to use VARCHAR?
List out the buffer pools in db2
what is datacom db?
Mention the definition of cobol in varchar field.
What is lock escalation in db2?
what is consistency token