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
Why do chiropractors use drop table?
Which isolation level provides highest data integrity?
Explain about rct in db2?
What is the connection string to connect to the DB2 Database ?
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
How does db2 sample database connect?
Where do you specify them?
What is the difference between db2 and oracle?
What is the role of schema in the db2 database?
Define buffer pool.
what is utility for parm lib
What is the function of logging in the db2 database?
What is the result of open cursor statement?
What are catalog tables in db2?
What is the maximum size of a char data type in db2?
