How many buffer pools are available in db2?

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


Please Help Members By Posting Answers For Below Questions

Which isolation level provides maximum concurrency?

668


What does db2 mean?

589


What is the difference between cursor and select statement?

615


What is meant by union and union all?

589


How do you stop a db2 database in linux?

570






What is the difference between dbm cfg and db cfg file in db2 ?

1009


can we view the access paths created by dbrm ? how ? thx

6262


Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.

2324


Why db2 is called db2?

595


Why do chiropractors use drop table?

662


What is check constraint. Explain with example.

650


Can one database have multiple instances?

583


Is ibm db2 open source?

589


What is node in db2?

610


What are the bind parameters ibm db2?

624