Results 1 to 5 of 5
  1. #1
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367

    Unanswered: detect and terminate appl holding locks

    v9.5

    Is there a way to detect and terminate an application that is holding locks for longer than some specified amount of time?

    WLM? Governor?

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    What about LOCKTIMEOUT?

  3. #3
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    I want it to detect/terminate the one who is holding the locks, not the one who is waiting.

    Appl A executes a query and doesn't commit
    Appl B wants to do a reorg on the same table and is waiting for Appl A to release the lock (LOCKTIMEOUT = -1)


    I want to detect/terminate Appl A.

  4. #4
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Doesn't look trivial. I don't think the lock _holding_ time is being monitored. You could possibly arrive at it from the UOW start time: get the transaction ID holding the lock, then find the UOW start time or something.

  5. #5
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    What they're looking for is some feature built into the product that can be used to monitor lock_holding_time. Perhaps you're right and this is not being monitored. Thanks.

Posting Permissions

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