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 do I create a view in db2?
What is host variable?
What is the physical storage length of the data types: date, time, timestamp in the db2 database?
define clustering index.
Is db2 free?
What is the maximum number of columns in a db2 table?
What is check constraint. Explain with example.
How can you count the number of rows from a table tab?
List down the types of triggers in the db2 database?
B37 abend during spufi?
What are the different types of base tables?
Explain packages.
What is the clustering index in the db2 database?
Mention the definition of cobol in varchar field.
Define sqlca.