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

• Episode #194: Interviewing the Db2 LUW Optimizer ( Explains Explained in English! )
  
• Episode #164: 8 High-Impact Performance Tuning Tips for DB2 LUW
  
• Episode #133, Why Low Cardinality Indexes (STINK)
  
• Episode #143, HADR and TSAMP Advanced Topics
  
• Episode #66, Top 10 Tips for E-Commerce Databases
  
  

---

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.

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!


Tweet

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