Results 1 to 3 of 3

Thread: lock wait

  1. #1
    Join Date
    Aug 2016
    Posts
    55
    Provided Answers: 2

    Unanswered: lock wait

    Hi

    Aix 7

    db2 V 10.5 fp 5

    executing select statement on sysibmadm.admintabinfo with UR, the session is going in Lock wait in between.

    set the current isolation level to UR.

    Normally it shld not correct ?

    regds
    paul

  2. #2
    Join Date
    Apr 2012
    Posts
    1,143
    Provided Answers: 27
    the 'set current isolation' is only effective (from the CLP) before you connect. If your statements lack the 'with UR' clause you might not have the isolation that you think. Be aware that UR cannot ignore certain types of locks. It depends what else is happening in your session, and in other active sessions.

  3. #3
    Join Date
    Aug 2016
    Posts
    55
    Provided Answers: 2
    blocker was executing alter statement on table.

    regds
    paul

Posting Permissions

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