Unanswered: Client connection crash and Rollback..
When a client application crash in the middle of a transaction, db2
keeps the locks on tables updated in the transaction whereas the
connection has been killed...there is the same behavior under oracle
as long as the server do not check (by default) the state of
connection, but we can active it in a parameter file.
Is there a way under DB2 to automatically kill connection of client
that have crashed?
I have heard about the parameter IDTHTOIN but now way to find how to set it...any idea? and what about locktimeout? does it rollbacks all the transation when it unlock a table for timeout?