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

The DB2Night Show #205: Deep Dive Db2 LUW Locks, Logs, and pureScale

May 18, 2018, 4:01 pm
Posted by Scott in DB2 LUW
Mohan and Kent
Follow @mohankumarsp
Follow @rcollins963

Special Guests: Mohan Saraswatipura and Kent Collins, Authors

DEEP DIVE on Db2 LUW Locks, Logs, and pureScale

100% of our audience learned something! Mohan took us into the bowels of Db2 pureScale locking and logging, complete with sample SQL, monitoring commands, configuration considerations, important stuff you need to know for Db2 V11.1 Certification Testing, and much more! Get the PDF for reference AND watch our replay so that you don't miss Mohan's brilliant explanations! Continue...

Show Host Scott Hayes Commentary

Seriously - I'm pretty sure Mohan's life revolves around Db2! He authors books with Kent Collins and gives fantastic presentations at IDUG and on our show! The man is brilliant, talented, and very knowledgeable! Don't miss a word of the replay, and be sure to try out many of the useful SQLs he provided in today's show!

Get the new Db2 V11.1 Certification Book

When we asked Mohan what he was doing this weekend, he said that he would be finishing up their new Db2 V11.1 Certification Book (most of us regular folks will be going on picnics). You can pre-order the new book on by clicking HERE!

Upcoming Shows

  • 8th June - A Crash Course on Db2 pureScale and Advantages! (Mohan and Kent return)
  • 15th June - DB2 Security Best Practices Volume II with Dave Beulke!
  • 22nd June - Db2 LUW on AWS Cloud - SAP Experiences - A Customer Success Story  

A message from our sponsor:
DBI Software

Today's commercial was super quick! We demonstrated a customer favorite feature - trend chart with drill down to the statements executing during the charted timeframe! We also showcased DBI's Explain, Design Analysis, and Predictive Index Impact Analysis. Like it? Contact DBI Now (just 2 clicks).

Magic Hat Money Working with DBI is like making money magically appear!

Typical customers enjoy 30-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. 7 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 88MB

To download a recorded replay of Episode #205 in WMV format, right click on the link below and choose "Save As..."
Episode #205, 18 May 2018, Deep Dive on Db2 V11.1 pureScale Locks and Logging with Mohan Saraswatipura and Kent Collins

MP4 Format - big screen TV resolution - 193MB

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

PDF Handout!

Our guests have been very generous to permit us to share a PDF of their slides. If you promise to watch the video replay, you can CLICK HERE for the PDF.

Did you learn something from this show?

Share a great show with your friends and followers!

Printer friendly