How can we differentiate 911 happened because of deadlock or timeout ?
Sometimes there is question which i frequently asked is "what ever happens the timeout error will be the result ? if the application is waiting for the resource longtime or App A is waiting for App B's resource and vice versa (Deadlock)" Then why the term deadlock silently influencing.. kind of unconcluded the discussion haunting around in my mind.
If time out happens then the resouce will be rolled back until the last commit point , this is -911 happened due to timeout.
in deadlock , any one application will be rolled back thought both application waiting for the resource and -911 happened. In this case why do not DB2 rolled back both applications ?