(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 - tinyurl.com/82tsqtz
(Blog) DB2 Locking, Part 1: An Overview - tinyurl.com/y8rqwmmq
(KC) Locks and Concurrency Control - tinyurl.com/ydybyvff
(Reddit) Simulating a Lock Timeout and Deadlock Scenario - redd.it/67o6y0

[@moneerrifai2764]

This was an epic video! thank you to your kiddos for helping us understand database locking!

[@gfunkonthecheesetree]

This is a great example, thank you!

[@kiddshellac]

i'm out refreshing my memory on 'commit' logic, and came across your 'lock' video. Cute kids, and good fun. imagine little sister's response if she were forced to 'backout' her changes? haha.. Nice job!

[@technicalknowledge9828]

Nice video

[@hanurao8078]

Please do session on deadlock,lock waits,lock escalation,lock timeout with practical

[@sandynoby]

A question sir : suppose we modify a LOCKRULE rule for a Tablespace which has 1 table from PAGE to ROW , do I need to recompile program accessing view of that table or do a rebind of package-plan

[@aravindachalla4398]

It’s good example and lock mode will be next session ?

[@DISCOVERDB2]

You mean lock isolation?

[@aravindachalla4398]

DISCOVER.DB2 yup