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


Posted by scott on September 22, 2017, 3:05 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



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...








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

















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