DB2 10.5 on Windows
I am having issues with timeouts in my dev system. The lock timeout parameter is set to 55 seconds. The way I understand it is that if the operation cannot acquire the lock it is trying for within 55 seconds it will error out with the message...
ERROR  [IBM][DB2/NT64] SQL0911N The current transaction has been rolled back because of a deadlock or timeout. Reason code "68".
The RC 68 is "The transaction was rolled back due to a lock timeout."
I have this happen when I am trying to create an index or an FK constant, which I can understand. It can also happen when I do
"SELECT * FROM TABLE WHERE ID = 5 WITH UR;"
So my question is two-fold.
1. How can I see what is preventing me from acquiring the lock?
2. How can if fix this to make it stop happening?
I have tried to use MON_GET_APPL_LOCKWAIT to figure it out but not sure what is being returned.
It is very frustrating. Any suggestions?