Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

can Isolation UR allows the application to read the rows ..?

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
PKB

New User


Joined: 06 Jul 2008
Posts: 10
Location: hyd

PostPosted: Fri Jun 04, 2010 11:54 am    Post subject: can Isolation UR allows the application to read the rows ..?
Reply with quote

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? icon_question.gif
Back to top
View user's profile Send private message

mastrahoyar

New User


Joined: 03 Mar 2007
Posts: 17
Location: hyd

PostPosted: Fri Jun 04, 2010 12:13 pm    Post subject: Reply to: can Isolation UR allows the application to read th
Reply with quote

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
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Fri Jun 04, 2010 12:14 pm    Post subject:
Reply with quote

YES,
updated but not yet COMMITed
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Fri Jun 04, 2010 12:16 pm    Post subject: Re: Reply to: can Isolation UR allows the application to rea
Reply with quote

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
View user's profile Send private message
PKB

New User


Joined: 06 Jul 2008
Posts: 10
Location: hyd

PostPosted: Fri Jun 04, 2010 12:19 pm    Post subject:
Reply with quote

Can we read the row using 'UR' which is locaked by other application using 'RR'?
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Fri Jun 04, 2010 12:25 pm    Post subject:
Reply with quote

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
View user's profile Send private message
PKB

New User


Joined: 06 Jul 2008
Posts: 10
Location: hyd

PostPosted: Fri Jun 04, 2010 1:00 pm    Post subject:
Reply with quote

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
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Fri Jun 04, 2010 1:38 pm    Post subject:
Reply with quote

Praveen,

no problem.
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Fri Jun 04, 2010 2:17 pm    Post subject:
Reply with quote

Praveen,

I apologize for my abruptness.

in a related thread,
Peter Holland provided an excellent link from which you may benefit:
http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp?topic=/com.ibm.db2.udb.doc/admin/c0007870.htm
Back to top
View user's profile Send private message
GuyC

Senior Member


Joined: 11 Aug 2009
Posts: 1278
Location: Belgium

PostPosted: Fri Jun 04, 2010 2:34 pm    Post subject:
Reply with quote

the link is useful but it is to a manual of DB2 LUW V8 (which is old and wrong platform).

http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/topic/com.ibm.db29.doc.perf/db2z_bindoptions4locks.htm

In DB2 9 you can also have a look at SKIP LOCKED DATA
Back to top
View user's profile Send private message
PeterHolland

Global Moderator


Joined: 27 Oct 2009
Posts: 2422
Location: Netherlands, Amstelveen

PostPosted: Fri Jun 04, 2010 2:43 pm    Post subject:
Reply with quote

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
View user's profile Send private message
GuyC

Senior Member


Joined: 11 Aug 2009
Posts: 1278
Location: Belgium

PostPosted: Fri Jun 04, 2010 4:50 pm    Post subject:
Reply with quote

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
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
This topic is locked: you cannot edit posts or make replies. Db2 SQL query to convert rows into co... subratarec DB2 5 Thu Nov 17, 2016 4:51 pm
No new posts Row-Numbers of distinct rows? Auryn DB2 1 Thu Oct 20, 2016 4:38 pm
No new posts CICS VSAM RLS READ akodakka CICS 3 Tue Oct 04, 2016 3:09 pm
No new posts Multi row fetch - "for read only... Nileshkul DB2 3 Sun Aug 14, 2016 12:52 am
No new posts Can we use OPTIMIZE FOR 1 ROWS for fe... cvijay784 DB2 1 Fri Aug 05, 2016 11:56 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us