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

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

Publisher Description

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.

GENRE
Computing & Internet
RELEASED
2014
31 July
LANGUAGE
EN
English
LENGTH
64
Pages
PUBLISHER
IBM Redbooks
SIZE
295.5
KB

More Books by IBM Redbooks

TCP/IP Tutorial and Technical Overview TCP/IP Tutorial and Technical Overview
2006
Cloud Computing Patterns of Expertise Cloud Computing Patterns of Expertise
2014
IT Service Management Best Practices Using IBM SmartCloud Control Desk IT Service Management Best Practices Using IBM SmartCloud Control Desk
2013
Understanding LDAP - Design and Implementation Understanding LDAP - Design and Implementation
2004
Introduction to the New Mainframe: z/OS Basics Introduction to the New Mainframe: z/OS Basics
2011
Using WebSphere Message Broker V8 in Mid-Market Environments Using WebSphere Message Broker V8 in Mid-Market Environments
2012