Results 1 to 2 of 2
  1. #1
    Join Date
    May 2006

    Unanswered: DB2 Deadlocks Urgent Please

    We are getting into SQL0911N error on our DB2 Linux on Z 8.2.

    Attached is the Deadlock file Log, please please help in solving the problem

    thanks in advance.
    Attached Files Attached Files

  2. #2
    Join Date
    Jun 2006


    from a snapshot/event file, it is not easy to analyze in a quicky
    the most common problem is different applications - multithread -
    doing delete - select
    not easy to say what is exactly wrong
    - execute program in 1 process
    - if delete - select.. are executed in same program
    - try todo commit whenever possible
    - for select use : select .. for update .. in that case a u-lock will be requested instead of s-lock and has to wait on other u-lock
    Best Regards, Guy Przytula
    DB2 UDB LUW certified V6/7/8

Posting Permissions

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