Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2002
    Posts
    10

    Unanswered: How to find out the SQL statements causing deadlock?

    Hello,

    We are runnig DB2 on AIX and have DB2 deadlock problem.
    Is there any way or any tool to find out which SQL statements cause the deadlock?

    Thanks a lot.

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: How to find out the SQL statements causing deadlock?

    If you have taken a moment to search for the word deadlock in the forum, you would have come across many threads with the information you want .... The most recent one is

    http://www.dbforums.com/showthread.php?threadid=952263

    Cheers
    Sathyaram

    Originally posted by dnlchou
    Hello,

    We are runnig DB2 on AIX and have DB2 deadlock problem.
    Is there any way or any tool to find out which SQL statements cause the deadlock?

    Thanks a lot.
    Visit the new-look IDUG Website , register to gain access to the excellent content.

Posting Permissions

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