The DB2Night Show #87: DB2 LUW Reducing CPU and I/O Consumption


Posted by Scott on June 29, 2012, 4:01 pm
in DB2 LUW ( The DB2Night Show)






Andrew Endicott

Special Guest: Andrew Endicott, DBA Manager, Cardinal Health



DB2 LUW Performance Tuning: Reducing CPU and I/O, Achieving Performance Gains, while lowering IT Infrastructure Costs



In our Season #3 finale, Scott Hayes was joined by Andrew Endicott, DBA Manager at Cardinal Health, for a lively discussion about DB2 LUW Performance Tuning. Andrew described how he has helped his organization avoid costly hardware and license upgrades while improving quality of service for his user community. Remarkably, all of this has been achieved while doubling the size of his SAP footprint and without adding any head count. How did Andrew achieve all this? Watch and learn...







Andrew Endicott

Special Guest: Andrew Endicott, DBA Manager, Cardinal Health



DB2 LUW Performance Tuning: Reducing CPU and I/O, Achieving Performance Gains, while lowering IT Infrastructure Costs



In our Season #3 finale, Scott Hayes was joined by Andrew Endicott, DBA Manager at Cardinal Health, for a lively discussion about DB2 LUW Performance Tuning. Andrew described how he has helped his organization avoid costly hardware and license upgrades while improving quality of service for his user community. Remarkably, all of this has been achieved while doubling the size of his SAP footprint and without adding any head count. How did Andrew achieve all this? Watch and learn...





Show Host Scott Hayes Commentary



Andrew and I covered a lot of ground during this show. Index structures, access paths, leaf scans, SQL workload analysis, tuning SAP, reducing CPUs, reducing and eliminating I/O, sample SQL analysis commands, solid state disk, table I/O analysis, when to REORG a table (without using REORGCHK), Index Design, Indexes to Drop, Clustering Indexes, Response Time and Time Spent analysis, SQL commands to find table and index scans, and more. Several case studies of the methods and techniques where shown. In just 75 minutes, this show is a complete primer on DB2 LUW tuning best practices!


Join The DB2Night Show™ LinkedIn Group


The DB2Night Show™ has a LinkedIn Group. The
"closed" group is open to any LinkedIn member. Join to receive LinkedIn group updates including
future shows and replay information, and, if you like, start some discussions about the show! href="http://www.linkedin.com/groupRegistration?gid=2761037" target="NEW" title="New Window: Join The DB2Night Show LinkedIn Group">Join The DB2Night Show LinkedIn Group!





The Corporate Sponsor of The DB2Night Show:

DBI Software



During DBI's quick sponsor commercial break, DBI demonstrated the performance methodology used by Cardinal Health, and other DBI customers, to achieve breakthrough performance improvements in minutes.


DBI is offering a free Webinar "How to Improve Performance in Minutes!" on 7 September 2012 at 1pm CDT. Visit DBI Events for details and the registration link.


On 23 May 2012, DBI Announced new competitive performance tool pricing incentives. If you have IBM OPM or other performance tools, DBI invites you to trade-in, trade-up, and swap-out those tools while enjoying special license savings. Inquire with your DBI representative for qualifications and details.



DBI is Your Trusted Partner

for Breakthrough DB2 Performance Solutions

that Deliver Invaluable Results

for Organizations having the most Demanding Requirements

and Discriminating Preferences


Our #1 Job is helping you look great!

Our #2 Job is giving you the documentation to prove it!



Contact DBI and find out how our DB2 LUW Performance Solutions can truly help you optimize performance and lower IT costs.



Get the Download Replays


WMV Format


To download a recorded replay of Episode #87 in WMV format, right click on
the link below and choose "Save As..."


Episode #87, 29 June 2012,
DB2 LUW Reducing CPU and I/O Consumption with Performance Gains


MP4 Format



Have an iLife, iDevice, iPod, iPad, or iPhone? Right click and download the MP4 ( M4V ) format!




Did you learn something from this show?


See that "Mail this" link below? Click it and do a friend a favor - share this blog post and show with one of your friends or peers. THANKS!


Share a great show with your friends and followers:


Post from : http://www.dbisoftware.com/blog/db2nightshow.php
Printed from : http://www.dbisoftware.com/blog/db2nightshow.php?id=382