we are just updating a talbe via a view, and it works days ago, but today when I do it again, it said:
- DB2 Database Error: ERROR  [IBM][DB2/SUN] SQL0911N The current transaction has been rolled back because of a deadlock or timeout. Reason code "68".
how can I know which query lock the underly table so that I can kill.
the kill command is kill and then followed by what number?
tell me how you guys troubleshoot it.
this is the best link I found :
but it seems that I get problem when login, any script to run by IBM data studio/Toad UI ?