View previous topic :: View next topic
|
Author |
Message |
PKB
New User
Joined: 06 Jul 2008 Posts: 10 Location: hyd
|
|
|
|
For UR, is it possible to read the rows updated by the other application?
Updating the row means the application must have applied the lock on the row. Is it possible to read the locked rows by other application with isolation UR? |
|
Back to top |
|
|
mastrahoyar
New User
Joined: 03 Mar 2007 Posts: 17 Location: hyd
|
|
|
|
Hi Praveen,
UR (Uncommitted Read) -There are no locks during READ and so it may read the data that is not committed. |
|
Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
YES,
updated but not yet COMMITed |
|
Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
mastrahoyar wrote: |
Hi Praveen,
UR (Uncommitted Read) -There are no locks during READ and so it may read the data that is not committed. |
There are no locks during READ - that is BS.
UR simply means that rows can/will be retrieved that are 'locked'
by another application. |
|
Back to top |
|
|
PKB
New User
Joined: 06 Jul 2008 Posts: 10 Location: hyd
|
|
|
|
Can we read the row using 'UR' which is locaked by other application using 'RR'? |
|
Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
bompally.praveen wrote: |
Can we read the row using 'UR' which is locaked by other application using 'RR'? |
how many times are you going to repeat a question
that we have already answered -
yes
and the CS level in the other applications has no effect. |
|
Back to top |
|
|
PKB
New User
Joined: 06 Jul 2008 Posts: 10 Location: hyd
|
|
|
|
I am very sorry, I drafted that question before you gave the answer. But because of slow internet it was processing for long time when I clicked on submit button.
When I refreshed the screen, then I came to know that you have already answered my quesion.
Thanks,
Praveen |
|
Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
Praveen,
no problem. |
|
Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
Back to top |
|
|
GuyC
Senior Member
Joined: 11 Aug 2009 Posts: 1281 Location: Belgium
|
|
Back to top |
|
|
PeterHolland
Global Moderator
Joined: 27 Oct 2009 Posts: 2481 Location: Netherlands, Amstelveen
|
|
|
|
Quote: |
the link is useful but it is to a manual of DB2 LUW V8 (which is old and wrong platform).
|
Well Guy, as long as it isnt clear which version/platform is used we have to guess sometimes. |
|
Back to top |
|
|
GuyC
Senior Member
Joined: 11 Aug 2009 Posts: 1281 Location: Belgium
|
|
|
|
PeterHolland wrote: |
Quote: |
the link is useful but it is to a manual of DB2 LUW V8 (which is old and wrong platform).
|
Well Guy, as long as it isnt clear which version/platform is used we have to guess sometimes. |
It wasn't critique,just an addition.
Besides : isolation level is practically the same.
But : since the forum is ibmmainframes.com we can be accurate about the platform, although some TSs are not. |
|
Back to top |
|
|
|