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

The DB2Night Show #136: Why Wait?!?! DB2 LUW Locking

June 6, 2014, 2:37 pm
Posted by Scott in DB2 LUW
Paul Turpin on LinkedIn

Special Guest: Paul Turpin, Sr. DBA, BB&T Bank

Why Wait? DB2 LUW Locking

100% of our audience learned something! During today's show, Paul shared his excellent IDUG presentation in which he details terrific information about DB2 LUW locking! Learn about maxlocks, mon_lockwaits, mon_lw_thresh, mon_deadlock, mon_locktimeout, locktimeout, monreport, mon_get_pkg_cache_stmt, mon_db_summary, mon_lck_msg_lvl and the secret decoder ring, lock behavior, set current lock timeout, secret DB2 registry variables that impact locking, deadlocks, and much more, plus get MANY great SQL and command examples! Watch our replay for details...

Show Host Scott Hayes Commentary

Paul Turpin has been a friend for many years, and it has been a delight to watch him contribute to the DB2 community through IDUG and his local RUG. Inspired by his daughter, whenever Paul presents he brings along BONGO to be part of his audience!

Consider volunteering for IDUG in any capacity, or submit presentations to become a speaker - and get a free badge if accepted! This presentation on DB2 LUW locking is EXCELLENT!.

I hope you enjoy this replay and learn great ideas from it. Because Paul is not an independent DB2 consultant or trainer (implying he does not make a living from his materials), he has graciously permitted us to share a PDF of his slides for handy reference. This does not mean, however, that you can skip the replays - to the contrary, Paul adds a lot of value in what he says! BONGO agrees!



Rao Balaga at Huntington Bank in Columbus Ohio completed our survey after Episode #135 "DB2 DPF Challenges and Successes" and has won a $25 gift certificate! We'll get this sent out within the next few weeks! THANK YOU FOR COMPLETING OUR POST-SHOW SURVEY!!!

Did you attend IDUG in Phoenix?

Check out the 100's of uploaded pictures HERE and see if you can find your picture! If you took pictures, upload them!

A message from our sponsor:
DBI Software

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 63MB

To download a recorded replay of Episode #136 in WMV format, right click on the link below and choose "Save As..."
Episode #136, 6 June 2014, Why Wait!?!? DB2 LUW Locking with guest Paul Turpin!

MP4 Format - standard resolution - 112MB

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

BONUS!! PDF Handout!

We can't do this with all of our guests, but Paul has given permission for us to make a PDF handout of his presentation available. Don't skip the replays! GET THE PDF!

Did you learn something from this show?

See that "Mail this" link below? Click it and do a friend a favor - share this blog post and show with one of your friends or peers. THANKS! icon_biggrin

Share a great show with your friends and followers! Let's get this tweeted and retweeted like crazy to celebrate Paul's contributions to the DB2 LUW community!

Printer friendly