Some questions to ask your prospective new DB2 LUW database administrator.
-
DB2 LUW DBA HowTo by Jeffrey Benner is licensed under a Creative Commons Attribution 3.0 United States License.
Based on a work at www.ebenner.com.
Tag Archives: db2
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.
