Responsive Systems Company
Home

Papers and Presentations


Presentations, PowerPoint Slides and Adobe .PDFs

--> New <--

 

 Presentations: 
DB2 System Performance Metrics - The Big Picture  -  presented at Tridex Dec 2009

DB2 System Performance - Peeling the Onion,  presented at IDUG Denver,  May 2009

DB2 z/OS Performance - the Basics and a Bit to a Lot More,  Presented at IDUG Dallas, May 2008
 

Buffer Pool Tuning in Large Memory World (pdf - 1.6Mb) - BPT in today's Large Memory World of 64 bit z/OS environments .  Presented at IDUG 2007 in San Diego.
 
Tuning your DB2 System with the Buffer Pool Tool (pdf - 1.1Mb)

This presentation will take you through the steps of analysis and tuning using the industry standard Buffer Pool Tool for DB2 from Responsive Systems, and show you how to analyze and tune your system, and evaluate the payback. Converting I/O savings to elapsed time, dollar savings, and improved productivity.
 

Aside from the elapsed time and cpu savings from I/O elimination, the tuning process often highlights significant application performance problems. See the steps of analysis and tuning using the industry standard Buffer Pool Tool for DB2, how to analyze and tune your system, and evaluate the payback.
 

Converting I/O savings to elapsed time, $ savings, and improved productivity. Buffer Pool Tool is the only product that can predict the I/O rate per second. This is a measurable metric. Unlike Hit Ratios, it can be converted into CPU costs, and elapsed time savings for both online and batch functions.
 

 

PaperDB2 Version 9 Automatic Pool Tuning (pdf - 64K)   - IBM documentation for DB2 V9 has a paragraph about Automatically Managing Buffer Pool Size. We look at their statement, and determine if the average installation will derive a benefit from this approach, and what side-effects may occur (e.g. wasting memory)
 

 
The Buffer Pool Hit Ratio is Dead!!  - (9Mb)
 
Tuning Your DB2 Buffer Pools - How Much Memory Do You Need? - (700K)
 
Using Averages for Performance Prediction
(380K .pdf by Dr. Bernie Domanski)
 

DB2 Buffer Pool Tuning: Statistical Accuracy of Performance Prediction Techniques - (.PDF by Dr. Bernie Domanski - requires the free Adobe Acrobat Reader) Unless you're careful, it's easy to build bias  into performance prediction.  This paper clearly explains  the problem, and points out where bias distorts performance results in other products.
 

Tuning the IMS Database Buffer Pools - A presentation that extends our industry standard  Buffer Pool tuning technology to the IMS database marketplace.  See how it predicts the effect/benefit of pool changes by altering the number of buffers and moving datasets, grouping by access type.
 
Buffer Pool Tuning - The Techniques That Work (.PDF by Joel Goldstein - requires the free Adobe Acrobat Reader) - What to do to reduce elapsed times, save CPU cycles, and to optimize memory usage.
 

DB2 and the Need for Speed (.PDF by Joel Goldstein - requires the free Adobe Acrobat Reader) - Simply stated, DB2 response time is never fast enough unless it's sub-second.  IBM has said that productivity improves by 100% when improving response time from 2 seconds to less than one second.  Joel's presentation reviews what you can do to achieve better response times.
 

Performance Miracles via DASD Activity Tuning (.PDF by Ivan Gelb - requires the free Adobe Acrobat Reader) - The z/OS environment IO activity tuning opportunities can produce results that seem like miracles. Productive capacity of a complex can be greatly increased because IO activity tuning will also improve processor, main storage and virtual storage utilization. This presentation will demonstrate all that is needed for an effective IO activity tuning project along with the benefits achieved by such activities.
 

Buffer Pools and DASD Analysis and Tuning (.PDF by Joel Goldstein - requires the free Adobe Acrobat Reader) - This presentation addresses the architecture and functionality of buffer pools, and the DASD from different vendors. It illustrates proven approaches for pool tuning as well as explaining the thresholds, performance exceptions, and the meaning of vital values and percentages.  There have been many changes in DASD implementations over the last several years. While it’s important to understand the underlying changes, it is just as important to understand the different implementations – to get beyond the salespersons hype, and to understand the approaches that will provide good performance, and those that will fail.

 

DB2 UDB for z/OS Performance - The Basics - Performance is critical for an enterprise. Joel's presentation reviews the what's, where's and why's of DB2 performance.
 

DB2 System Performance Metrics Revisited - DB2 is a complex database management system, that has a major impact upon your overall processing environment.  Installations are constantly looking for ways to measure, analyze, and control its resource  consumption. This presentation assumes that the reader has a basic understanding of DB2, and does not define basic DB2 terminology.  It addresses the origins and data available for analyzing, tuning, and tracking the performance of the DB2 System, and inter-dependencies and relationships between the various data elements.  Many of the system tuning options are explained and trade-offs discussed, since the systems and applications are always somewhat different for each corporation.

DB2 Buffer Pool Tuning: Top Down or Bottom Up? - Joel examines  different approaches for tuning DASD as well as for Buffer Pool tuning.
 


 

Client Server Performance and Capacity Planning - Client Server Performance Management and Capacity Planning - presented by Joel Goldstein at IDUG 1996, Dallas and Amsterdam
 
DB2 Buffer Pool Tuning and Sizing - Buffer Pool Tuning and Sizing - The Yellow Brick Road - presented by Joel Goldstein at IDUG 1995, Berlin 1995, Melbourne 1996 and many user groups throughout the country.
 
DB2 System Performance Metrics - DB2 System Performance Metrics - presented by Joel Goldstein at CMG 1996, IDUG 1997
 

Papers, Full Text

Buffer Pool Tuning and Sizing - Buffer Pool Tuning and Sizing, the Yellow Brick Road presentation by Joel Goldstein at IDUG 1995, Berlin 1995, Melbourne 1996, and many user groups throughout the country.
 
It's Time to Re-Think Your DB2 Buffer Pool Strategy - This paper provides a series of buffer pool tuning ideas and techniques used to reduce the resources used by DB2 for processing I/O.  - A white paper by Martin Hubel
 
Tuning PeopleSoft Applications for DB2 z/OS - Tuning PeopleSoft Applications for  DB2 z/OS Environments - A white paper by Martin Hubel 
 
The Value of Buffer Pool Tuning for DB2 z/OS - The Value of DB2 Buffer Pool Measurement, Analysis, and Modeling.  A white paper by Dr. Bernie Domanski
 
Simulation Vs Analytic Modeling in Large Computing Environments - Simulation Vs Analytic Modeling in Large Computing Environments - A white paper by Dr. Bernie Domanski
 
DB2 System Performance Metrics - DB2 System Performance Metrics - presented by Joel Goldstein at CMG 1996, IDUG 1997
 

 

Buffer Pool Tool™ for DB2
The only product that can predict the effect of  changes to the buffer pools.

 


  eMail Us with Your Questions or Comments 
 
Responsive Systems Company 1997-2012  All Rights Reserved.
281 Highway 79, Morganville, NJ 07751 USA
(732) 972-1261, (800) DB2-EXPErt, (732) 972-9416 FAX

Last modified: May 22, 2012 by Dr Bernie Domanski