Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2003
    Posts
    2

    Unanswered: deadlock question

    Dear all,
    I am a newbie to DB2. I have implemented simple session and entity bean (on Websphere 5.0) to update a row of a table (DB2 v8.1). I tried to stress the bean, and make it to update the same row with 3 concurrent accesses. I encounter deadlock always. Sometimes, the program can run smoothly, but the row is not updated correctly.
    Any setting / related information I missed? Appreciate all the advice.

  2. #2
    Join Date
    Sep 2002
    Posts
    456

    Re: deadlock question

    well, I am sure you know why deadlock situation can occur, if not; would you mind posting the SQL or explaining what exactly you query suppose to do?

    dollar
    Originally posted by chpoon
    Dear all,
    I am a newbie to DB2. I have implemented simple session and entity bean (on Websphere 5.0) to update a row of a table (DB2 v8.1). I tried to stress the bean, and make it to update the same row with 3 concurrent accesses. I encounter deadlock always. Sometimes, the program can run smoothly, but the row is not updated correctly.
    Any setting / related information I missed? Appreciate all the advice.

  3. #3
    Join Date
    Dec 2003
    Posts
    2
    Thank you for your prompt reply.
    The table I used is a simple 2 column table, which has an integer(primary key) and string field (VARCHAR 2048) only. The SQL statement is to add the string by 1 each time. ( I store numeric in the string field as well ).

  4. #4
    Join Date
    Jan 2003
    Posts
    1,636
    Provided Answers: 1
    Hi,

    Please also read something about isolation levels.

    Please also read Must Read before posting to get more info about how to write effective questions.

    Hope this helps,
    Grofaty

Posting Permissions

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