Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2007
    Posts
    15

    Unanswered: Can "WITH UR" still take lock?

    I noticed on deadlock monitor today there's a select statement with "for fetch only with ur" that is apparently holding the lock.

    Is this possible? Is the deadlock monitor reading from the buffer pool instead?? please help, thanks.

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    UR does take locks, but they are not blocking anyone else or being blocked by anyone else. What exact lock type did you see?
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Jul 2009
    Location
    NY
    Posts
    963
    Quote Originally Posted by HanbingL
    I noticed on deadlock monitor today there's a select statement with "for fetch only with ur" that is apparently holding the lock.

    Is this possible? Is the deadlock monitor reading from the buffer pool instead?? please help, thanks.
    Commit and only Commit can release resurces.

    Maybe someone get X-control on tablespace same time, or you try to fetch too huge RS with sort and get deadlock on temporary space.

    Lenny

Posting Permissions

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