Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2005

    Unanswered: Dead locks..and Lock waits..

    UDB ..8.2 ..OS AIX

    Please throw some light on Dead lock issues..
    why it occurs ?
    when two applications tried to do some work on a same table they go into deadlock state?

    can some one give me more explanation with some examples...

  2. #2
    Join Date
    Nov 2004


    deadlock is related to locking
    if 2 or more applications are involved and trying in the same luw doing select and update - and this for both appl, you usually get a deadlock, because luw 1 is waiting for luw2 and vice versa
    luw1 luw2
    select select
    update update

    update1 -> wait update2
    update2 -> wait update1
    this is detected by system and latest luw is forced
    such cases should be handled :
    - in different luw
    - doing select .. for update (and getting ulock instead of slock) preventing select 2 to come in
    Best Regards, Guy Przytula
    DB2/ORA/SQL Services
    DB2 DBA & Advanced DBA Certified
    DB2 Dprop Certified

Posting Permissions

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