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


Posted by scott on June 11, 2017, 7:32 pm
in DB2 LUW ( The DB2Night Show)







title="Ember Crooks on LinkedIn">
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...








title="Ember Crooks on LinkedIn">
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 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 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!
















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