Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2008
    Posts
    3

    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.

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    No, once the comm link is broken, it is basically dead for use. How long is the transaction?

    Andy

  3. #3
    Join Date
    Apr 2008
    Posts
    3
    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.

  4. #4
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Your only alternative, as I see it, is to make the network more robust.

    Andy

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •