Results 1 to 6 of 6

Thread: lock wait

  1. #1
    Join Date
    Dec 2003
    Posts
    78

    Unanswered: lock wait

    hi, for a aix db2 udb v7.2 fixpack 10a server, for a database we got -911 messages.
    above that message it writes the timeout caused by lock.


    2004-09-09-09.16.24.328967 Instance:db2inst1de:000
    PID:12642(db2agent (SATDB)) Appid:yyyyyyyyy.yyyyy.yyyyyyyyyy
    lock_manager sqlplnfd Probe:80 DatabaseATDB

    Request for lock "REC: (15, 2) RID 00000205" in mode ".NS" timed out
    Application caused the lock wait is "xxxxxxxx.xxxxxx.xxxxxxxxx"
    Statement: 7245 6c65 6374 2134 3253 5449 4e43 5430 SELECT
    2053 5542 5f54 494c 5f55 5352 5f53 4943 <there is a statement here>
    494c 2020 6672 6f6d 2054 5355 422e 5355



    my question is that: is this statement the cause of the timeout or is it the statement that waited for lock and timed out?

    tnx all

  2. #2
    Join Date
    Dec 2003
    Posts
    78
    hi
    that'a an urgent problem
    can anyone help??

  3. #3
    Join Date
    Jan 2004
    Location
    Europe, Finland, Helsinki
    Posts
    64
    Hi!

    I think:

    'Application caused the lock wait is "xxxxxxxx.xxxxxx.xxxxxxxxx"' is probably the guilty party.

    And 'PID:12642(db2agent (SATDB)) Appid:yyyyyyyyy.yyyyy.yyyyyyyyyy' describes the victim.

    Yours, Bill


    (ps. my knowledge IS for z/OS but this looks familiar...)

  4. #4
    Join Date
    Dec 2003
    Posts
    78
    what about the sql statement written there(i erased the exact sql statement in forum, but the log message writes a SELECT statement there)
    is it the cause or the victim?

  5. #5
    Join Date
    Jan 2004
    Location
    Europe, Finland, Helsinki
    Posts
    64
    The log message SELECT is the victim.

    Yours, Bill

  6. #6
    Join Date
    Dec 2003
    Posts
    78
    ok thanx a lot Bill

Posting Permissions

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