Skip to main content

IBM DB2 11 for z/OS Buffer Pool Monitoring and Tuning

An IBM Redpaper publication

thumbnail 

Published on 10 July 2014, updated 31 July 2014

  1. .EPUB (0.3 MB)
  2. .PDF (1.5 MB)

Apple BooksGoogle Play Books

Share this page:   

ISBN-10: 0738453749
ISBN-13: 9780738453743
IBM Form #: REDP-5092-00


Authors: Jeff Berger

    menu icon

    Abstract

    IBM® DB2® buffer pools are still a key resource for ensuring good performance. This has become increasingly important as the difference between processor speed and disk response time for a random access I/O widens in each new generation of processor. An IBM System z® processor can be configured with large amounts of storage, which if used wisely, can help compensate by using storage to avoid synchronous I/O. Several changes in buffer pool management have been provided by DB2 10 and DB2 11.

    The purpose of this IBM Redpaper™ is to cover the following topics:

    • Describe the functions of the DB2 11 buffer pools
    • Introduce a number of matrixes for read and write performance of a buffer pool
    • Provide information about how to set up and monitor the DB2 buffer pools

    The paper is intended to be read by DB2 system administrators, but it might be of interest to any IBM z/OS® performance specialist. It is assumed that the reader is familiar with DB2 and performance tuning.

    In this paper, we also assume that you are familiar with DB2 11 for z/OS performance. See DB2 11 for z/OS Technical Overview, SG24-8180; and DB2 11 for z/OS Performance Topics, SG24-8222, for more information about DB2 11 functions and their performance.

    Table of Contents

    Chapter 1. Introduction

    Chapter 2. Prefetch and RID pool

    Chapter 3. Buffer pool writes

    Chapter 4. Data sharing

    Chapter 5. Workfiles

    Chapter 6. Assigning page sets to buffer pools

    Chapter 7. Improving CPU performance

    Chapter 8. Index and data organization

     

    Others who read this also read