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

The DB2Night Show #194: Interviewing the DB2 LUW Optimizer w/ Ember Crooks

June 11, 2017, 7:32 pm
Posted by Scott in DB2 LUW
Ember Crooks, IBM DB2 GOLD Consultant

@ember_crooks

Special Guest: Ember Crooks
Director, Xtivia
IBM DB2 GOLD Consultant

Interviewing the DB2 LUW Optimizer

100% of our audience learned something! Ember took us on a deep dive journey through DB2 LUW Explain information including how to get it, how to interpret it, how to make the most of it, and much more. You will learn about db2exfmt, DB2 Explain from Actuals, IBM DSM, dsmtop, db2top, other tools, and just what the heck all those numbers actually mean! Watch and learn...


Show Host Scott Hayes Commentary

It was an honor and a pleasure to have Ember Crooks as our special guest. She's got a real gift for teaching that includes making complex topics seem understandable. And yes, I squirmed in my chair a little bit while she talked about IBM Data Server Manager (DSM). But, as you'll see, there are other and better tools available. icon_wink

Season #8 Grand Finale Show
"Breaking News from IBM"
23rd June 10am CDT

Don't miss our last show for Season #8 - IBM is making many important announcements during June 2017 and we'll have special guests from IBM to guide us through all the amazing and exciting news. REGISTER HERE

More shows Featuring Ember Crooks

Check out these replays of past shows:


A message from our sponsor:
DBI Software

During today's quick 3 minute commercial, DBI demonstrated the DB2 LUW Explain capabilities featured in its flagship product Brother-Panther®. Please enjoy this short commercial so that you can make informed decisions about the best tools to use within your organization.

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 94MB

To download a recorded replay of Episode #194 in WMV format, right click on the link below and choose "Save As..."
Episode #194, 9 June 2017, Interviewing the DB2 LUW Optimizer with Ember Crooks!

MP4 Format - standard resolution - 115MB

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

PDF Handout!

Ember has been very generous to permit us to share a PDF of her slides. If you promise to watch the video replay, you can CLICK HERE for the PDF.

Sharing is Caring!

Share a great show with your friends and followers!

Printer friendly