Skip to content

Tag Archives: pmr

UPDATE: DB2 Health Monitor Problems


This post details a serious problem encountered running DB2 Health Monitor version 9. It might be resolved using DB2 registry variable DB2_HMON_DFT_STACK_SZ.

DB2 Database Snapshot Counter LOCK_TIMEOUTS not being incremented for Lock Timeouts


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.