Skip to content

Tag Archives: lock_timeouts

DB2 Database Snapshot Counter LOCK_TIMEOUTS not being incremented for Lock Timeouts

28-Aug-08

DB2 System Monitor elements LOCK_TIMEOUTS and DEADLOCKS both are incremented for SQLCODE -911 (sql0911n) but LOCK_TIMEOUTS is incremented for Reason Code 68 whereas DEADLOCKS is incremented for Reason Code 2. SQLCODE -911 actually covers 3 different timeout scenarios (the third related to DB2 Data Links Manager, Reason Code 72). I don’t know why IBM wouldn’t have given us three separate SQLSTATE’s, it would have been less confusing.