The Db2Night Show™ Sponsored by DBI Software

Educate | Inform | Entertain

The Db2Night Show has the simple mission of building a fun, interactive community around Db2. Each episode will include fun stuff, information, tips, and special guests who are industry experts.
SEASON #14 : FOURTEEN YEARS of FREE Db2 Education!

Unless otherwise noted, all shows start at 11 am Eastern time. Adjust accordingly for Daylight Savings and International locations.

The DB2Night Show #196: Db2 LUW Transaction Log Expedition w/ Ember Crooks

Posted on 9/22/2017
Ember Crooks, IBM DB2 GOLD Consultant

@ember_crooks

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

SQL Infusion: A Db2 LUW Transaction Log Expedition!

96% of our audience learned something! Ember took us on an educational journey that covered just about everything related to Db2 transaction logs, active logs, archive logs, configuration settings, recommendations, and sample SQL for examining your systems. As for the 4% that didn't learn something --- they were IBM Canada Lab staff! Watch and learn...


Show Host Scott Hayes Commentary

Again, 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. She offered great advice and recommendations for Db2 logging during this session. I'll be watching this replay myself and checking configuration settings on some of my favorite databases.

More shows Featuring Ember Crooks

Check out these replays of past shows:


A message from our sponsor:
DBI Software

During today's quick 1 minute commercial, DBI demonstrated the Brother-Thoroughbred® component of the DBI pureFeat Performance Management Suite for IBM Db2. Brother-Thoroughbred shows average transaction response times, how much time is spent inside Db2 and out, and, within Db2 time, where that time is spent so you can quickly see if a performance issue belongs to Db2 or not, and, if so, where the bottleneck is within Db2.

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 includingfuture 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 90MB

To download a recorded replay of Episode #196 in WMV format, right click on the link below and choose "Save As... "
Episode #196, 22 September 2017, SQL Infusion - A transaction log expedition with Ember Crooks!

MP4 Format - standard resolution - 113MB

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

PDF Handout!

Ember presented this session at IDUG Anaheim 2017, and will be presenting it again at IDUG Lisbon 2017. A PDF is available to IDUG attendees. Or, try emailing Ember to request a PDF.

Sharing is Caring!

Share a great show with your friends and followers!