Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2011
    Columbus, OH

    Unanswered: Tracking down transaction details

    DB2 9.5 on AIX

    I have 2 applications writing to a single table. A couple times a week a transaction is rolled back because of a deadlock/timeout. The applications batch their inserts, but I do not know if it's 1 transaction with multiple insert statements or a single transaction for every insert statement.

    Is there a db2pd command or similar tool I can use to see if records inserted into the table were from a single transaction? I'm open to any suggestions that will help me learn more about how the database handled the transactions.

    Thanks db friends!

  2. #2
    Join Date
    Jan 2003
    Provided Answers: 5
    You need to know whether it is a deadlock or a timeout. You approach each one differently. With a deadlock, you can use an event monitor to locate the cause. With a timeout, you have a transaction taking up a lot of time and not releasing locks in a timely manner. Look here for how to diagnose these: IBM DB2 9.5 Information Center for Linux, UNIX, and Windows


Posting Permissions

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