Presentations, PowerPoint Slides and Adobe .PDFs
New
Presentations:
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.
Paper:
DB2 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)
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.
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.
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
DB2 System Performance Metrics – DB2 System Performance Metrics – presented by Joel Goldstein at CMG 1996, IDUG 1997