The DB2Night Show #21: DB2 LUW Locking with Mike Winer, IBM STSM

In our 21st show, we were joined by special guest Mike Winer, IBM STSM, from the Toronto Lab. We ran a special 90 minute show so that Mike could cover his entire IDUG presentation on Locking. This guy is the LOCK MASTER! Mike covered types of DB2 LUW locks, lock memory, lock isolation levels, locking related registry variables (and you need to pay attention to these! ), DB2 9.7 Currently Committed, SQL options for locking, lock avoidance (the new standard! ), lock escalation, timeouts, and deadlocks, and how to monitor locking!

I'd also like to apologize to Mike and our audience. I have multiple computers, microphones, speakers, and headsets going when we produce these shows and I made a goof. The volume was turned down all the way on my headset in the beginning so I couldn't hear Mike speaking and I thought he'd gone for coffee, but, of course, he was there and freaking out because he thought the audience couldn't hear them. You all could hear him, but I couldn't. I chock this up to my most embarrassing show moment in 21 shows and I'm sorry for this goof. I'll try to do better in the future.

With all this said, pop yourself some popcorn and WATCH THIS SHOW...

[ more .. ]