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.

No, once the comm link is broken, it is basically dead for use. How long is the transaction?

Andy

The transaction is very short. Not more than 10 records are handled at one time.
But the handheld and wireless connection are both very unreliable which means the connection can be cut anytime.

Your only alternative, as I see it, is to make the network more robust.

Andy