Interview Questions   Tutorials   Discussions   Programs   

DB2 - How many buffer pools are there in DB2?

asked mar September 2, 2014 12:42 PM  

How many buffer pools are there in DB2?


1 Answers

answered By Mswami   0  
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.

Note: Latest versions of DB2 could have more than this.
   add comment

Your answer

Join with account you already have



 Write A Tutorials
Online-Classroom Classes

  1 person following this question

  1 person following this tag

  Question tags

Asked 1 year and 1 month ago ago
Number of Views -287
Number of Answers -1
Last updated
2 years and 1 month ago ago

Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!