Skip to content

Monthly Archives: August 2008

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.

Hosting DB2 on Solaris Zones


My current client runs DB2 version 9 on Solaris 10 Zones (virtual machines), and we have had no problems. This post details the installation.