Team with the best
Db2® LUW Performance Tools
company in the World

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

January 19, 2018, 2:27 pm
Posted by Scott in DB2 LUW
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 SUCCESS STORY with HealthPlan Services, do your 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? 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! 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!

Printer friendly