The Yellow Brick Road to Performance
Joel Goldstein
Tel. (732) 972-1261
Buffer Pool Tool™ for DB2 The only product that can Predict the effect of changes to the buffer pools.
Coupling Facility Sizing Module Sizes the CF structures based on statistical data from your ‘operating’ DB2 system(s).
DB2 Buffer Pool Tuning and Sizing – The Yellow Brick Road to Performance
The Past…..
The Present…..
The Present…..
Large VP vs VP/HP Configuration
Performance Impacts
Some Limits We Must Remember…..
HiperPools…..
Using the Adjustable Thresholds
Buffer Pool Hit Ratio
Additional Hit Ratios to Track…..
BufferPool Hit Ratio – VP & HP
System BufferPool Data…..1
System BufferPool Data…..2
Application BufferPool Data
I/O Performance Relationships…..
Application Effects of BufferPool Tuning
MVS Paging vs VP Buffers
Response Time vs MVS Paging vs VP Buffers
MVS Paging vs HP Buffers
Response Time vs HP Buffers
BufferPool Performance Analysis Beyond the Basic Hit Ratio…..
BufferPool Performance Analysis Beyond the Basic Hit Ratio…..
BufferPool Performance Analysis Beyond the Basic Hit Ratio…..
BufferPool Performance Analysis Beyond the Basic Hit Ratio…..
BufferPool Performance Analysis Beyond the Basic Hit Ratio…..
BufferPool Performance Analysis Beyond the Basic Hit Ratio…..
BufferPool Statistical Analysis
BufferPool Statistical Analysis
BufferPool Statistical Analysis
Object Statistical Analysis
Object Statistical Analysis
Object Statistical Analysis
Analyze the Statistical Data
Simulate Performance Gains with Larger Pool Sizes
Base Simulation…..BufferPool Level
Base Simulation…..Object Level
Base Simulation…..Object Level
Additional Data Analysis…
Client Case Study…..1
Client Case Study…..Tune the Pools The Standard Shotgun Approach
Client Case Study…..Tune the Pools
Client Case Study…..Tune the Pools
System Results of BufferPool Tuning
Client Case Study…..2
Client Case Study…..2
Client Case Study…..2
Client Case Study…..3
Client Case Study…..3
Yearly I/O Reduction Cost Saving
Yearly Productivity Cost SavingsReducing Avg. Transaction Elapsed .1 Secs
Pool Usage Suggestions
Pool Usage Suggestions
Summary…..
The Future…..
PP Presentation
Contact Info
281 Highway 79,
Morganville, NJ 07751 USA
Office: (732) 972-1261,