The DB2Night Show #201: Favorite Tuning Tips and Tricks for Db2 LUW


Posted by Scott on January 19, 2018, 2:27 pm
in DB2 LUW ( The DB2Night Show)







title="Joe Geller on LinkedIn">
Joe Geller, Db2 Performance Specialist, JP Morgan Chase



Special Guest: Joe Geller, JP Morgan Chase



Favorite Tuning Tips and Tricks for Db2 LUW



100% of our audience learned something! SELECTIVITY, OPTGUIDELINES, Runstats, Indexes, Bufferpool Design, REORGs, monitoring advice, and more!! No wonder Joe won Best User Speaker at IDUG Lisbon 2017! Joe's presentation is full of terrific advice and tips! Watch and learn...








title="Joe Geller on LinkedIn">
Joe Geller, Db2 Performance Specialist, JP Morgan Chase



Special Guest: Joe Geller, JP Morgan Chase



Favorite Tuning Tips and Tricks for Db2 LUW



100% of our audience learned something! SELECTIVITY, OPTGUIDELINES, Runstats, Indexes, Bufferpool Design, REORGs, monitoring advice, and more!! No wonder Joe won Best User Speaker at IDUG Lisbon 2017! Joe's presentation is full of terrific advice and tips! Watch and learn...






Show Host Scott Hayes Commentary



As someone who has spent the last 20 years dedicated to monitoring and tuning Db2, I have to confess that even I learned some things from Joe! That's what makes our Db2 community and IDUG great - people sharing their experiences and knowledge helps us all! Thank you so much Joe! And we'll see you at IDUG Philadelphia April 29-May 3!






A message from our sponsor:

DBI Software



Trend Setting Product Logos


5 Years in a Row! DBI pureFeat™ Performance Management Suite for IBM Db2 has once again been recognized by Database Trends and Applications Magazine as a Top 100 Trend Setting Product for 2018!


During today's quick commercial break, DBI showed how database and SQL performance can be easily compared between two time windows. It's an educational commercial - don't fast forward through it! #Awesome









Magic Hat Money

Working with DBI is like making money magically appear!


Typical customers enjoy 40-60% CPU utilization reductions in the first week, plus measurably faster
transaction and query response times. More importantly, your time savings will be substantial!
Read our newest title="Press Release: DBI and HealthPlan Services celebrate DB2 LUW successes!">SUCCESS STORY with
HealthPlan Services, do your target="NEW" title="Learn about the high cost of 'free' tools and do your due diligence">due diligence,
and speak with as many references as you have time to call.


We saved a health care company $250,000 in one afternoon, solved a performance problem in two hours that two senior
DBAs were unable to solve in six months, and we have helped top brand name retailers achieve top ranked e-Commerce
performance on Black Friday multiple years in a row. 8 of the Top 25 Retailers, plus others, plus top Banks,
State Governments, Manufacturers, Insurers, and more rely on DBI. How can we help you?
target="NEW" title="Let's have a conversation - Contact DBI">Contact DBI






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!




Get the Download Replays



WMV Format - approximately 82MB


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


Episode #201, 19 January 2018,
Favorite Tuning Tips and Tricks for Db2 LUW with Joe Geller, Sr. DB2 Performance Specialist, JP Morgan Chase



MP4 Format - 123MB



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



PDF Handout!


Depending on our guest and their preferences, we can't always do this, but Joe was kind enough to agree to share a PDF of his presentation. Don't just download the PDF - WATCH THE REPLAY so that you can HEAR what Joe says and benefit from our audience questions! CLICK HERE for PDF!



Sharing is Caring!


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=739