Unanswered: Resume transaction after comm link failure
Is there a way on DB2 (on AS400) to resume a transaction after a comm link failure?
Our .net client has code where we are doing multiple insert/update/delete before committing. The problem we are facing is that the if the connection fails between two of these calls, the rows get locked and there is no way for us release them until the 2 hrs timeout. We can't find a way to reestablish the same connection either.