Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.


  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • DownloadDownload
  • PrintPrint
Share this Page URL
Help

Chapter 5. DB2 Buffer Pools > Configuring the block-based area

Configuring the block-based area

Buffer pools are defined as having a large number of pages by default, so when DB2 issues a prefetch, the pages read from the disk may not be stored contiguously in the buffer pool.

The block-based area enhances prefetching performance by allowing a contiguous area of the buffer pool for this eventuality, named the block area, or block-based area. Each set of contiguous pages is called a block; the number of pages in a block is referred to as the blocksize.


  

You are currently reading a PREVIEW of this book.

                                                                                        

Get instant access to over
$1 million worth of books and videos.

  

Start a Free Trial