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

Front Cover
IBM Redbooks, Jul 31, 2014 - Computers - 64 pages
0 Reviews
Reviews aren't verified, but Google checks for and removes fake content when it's identified

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 RedpaperTM 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.

 

What people are saying - Write a review

We haven't found any reviews in the usual places.

Selected pages

Contents

Common terms and phrases

allocated avoid buffer hit ratio Buffer Manager cached CFRM Chapter checkpoint interval cluster ratio conditional getpages coupling facility DASD Data Manager data set data sharing DB1A DB2 optimizer DB2 utilities DB211 for z/OS DGTT dirty pages DSNZPARM DWQT dynamic prefetch FICON files Flash Express format writes free space GBP write-around GBPCACHE I/O bound IBM recommends IBM Redbooks IFCID Index Manager indirect references International Business Machines KB pages KB to less LOB table spaces number of buffers number of pages page-sequential pages written parallel PCTFREE PGFIX(NO PGFIX(YES prefetch engine prefetch quantity query random getpage Read I/O reduce the number result set RID list scan RID pool rows scheduled secondary index sequential buffers sequential detection sequential inserts sequential prefetch SLRU chain sorted RID list sparse index specify storage synchronous I/O total number trigger a prefetch unclustered updated pages VARCHAR VDWQT virtual pool VPSEQT VPSIZE workfile write I/O zIIP

Bibliographic information

QR code for IBM DB2 11 for z/OS Buffer Pool Monitoring and Tuning
TitleIBM DB2 11 for z/OS Buffer Pool Monitoring and Tuning
AuthorsJeff Berger, IBM Redbooks
PublisherIBM Redbooks, 2014
ISBN0738453749, 9780738453743
Length64 pages
Subjects › 

Computers / Database Administration & Management
  
Export CitationBiBTeX EndNote RefMan