(Ep. 14) – DB2 Database Locking Concepts

The dreaded SQL0911N! The application failed because of a deadlock! It must be the database! (Hint: No, it’s not).

In this episode, we are going to discuss the basics of locking within Db2. What happens with a lock, what types of locking can happen, and does it mean something is wrong with my database?

Timestamps:
00:10 – Describe locking issues through analogy.
01:00 – Normal locking behavior in a database (by example)
01:28 – Lock Wait (by example)
02:15 – Lock Timeout (by example)
03:19 – Deadlock (by example)
05:18 – Is the database the cause of locking problems?

Useful Links:
(Blog) Locks – Timeout vs. Deadlock – https://tinyurl.com/82tsqtz
(Blog) DB2 Locking, Part 1: An Overview – https://tinyurl.com/y8rqwmmq
(KC) Locks and Concurrency Control – https://tinyurl.com/ydybyvff
(Reddit) Simulating a Lock Timeout and Deadlock Scenario – https://redd.it/67o6y0