Answer Posted / manisha shukla
A buffer pool is main storage that is reserved to satisfy
the buffering requirements for one or more tablespaces or
indexes, and is made up of either 4K or 32K pages.
There are four buffer pools: BP0, BP1, BP2, and BP32.
| Is This Answer Correct ? | 2 Yes | 3 No |
Post New Answer View All Answers
How can you count the number of rows from a table tab?
What is the difference between plan and package in db2?
What is the role of union all and union
What is a bind in db2?
How do I optimize a query in db2?
What is cascading rollback?
What is bind in db2?
What is the use of reorg in db2?
Why do chiropractors use drop table?
How can you classify the locks in db2?
what is a corelated subquerry?
How do we specify index to include or not during bind process.
How is the value function used?
What is ibm db2 database?
Explain package in db2 and its advantages?