Dear All,

We encountered this issue suddenly with the following error message:

com.ibm.db2.jcc.c.SqlException: DB2 SQL error: SQLCODE -911, SQLSTATE: 40001, SQLERRMC: 68

The application was working fine before. Could it due to the corruption of index on the tables. I'd appreciate if there is any hint.


Thanks,
qxz

This is not a deadlock, but a lock timeout. I would start with looking at the lock snapshot to determine what statements and database objects are involved.

Sorry that I am not a DBA. How to run the lock snapshot in DB2 8? Will it affect the performance of the database server?

Thanks!

Some folks would see it as a good thing


Log in to the server as the DB2 instance owner. Issue "db2 update monitor switches using lock on statement on uow on timestamp on". For locks, issue "db2 get snapshot for locks on <database name>". For statements, "db2 get snapshot for dynamic sql on <database name>". Take snapshots periodically, redirecting results to a text file, until you catch the lock wait that times out.

Having snapshot monitor elements turned on does affect performance a little bit (general estimate is about 5% if all switches are on), but it's the only way to obtain diagnostic information.