Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2004
    Location
    Nottingham, England
    Posts
    0

    Unanswered: Deadlock Monitoring

    Can anyone tell me the best way to monitor for and pinpoint deadlocks. I need to identify which processes are in contention (if possible). I have a process reporting a deadlock, but need to know what is locking the data that this process is reporting as locked. Is there any way to do this ? We are running DB2 on AIX.

    Please help!

    Thanks

    Trish

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    You should set up deadlock event monitoring ...

    http://www.gseukdb2.org.uk/downloads/0405event.zip

    will show you how to setup and read event monitors

    Cheers
    Sathyaram
    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
  •