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.

UR does take locks, but they are not blocking anyone else or being blocked by anyone else. What exact lock type did you see?

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