Regardin Isolation Levels

vadivem · New User Joined: 08 May 2006 Posts: 24 Location: pune

I having two programs A,B it runs simultaneously but while running the program the Isolation status has been CS(Cursor Stability) here both the programs access same row now which will be access first?

murmohk1 · Posted: Thu Nov 22, 2007 10:12 am

Vadie,

vadivem · New User Joined: 08 May 2006 Posts: 24 Location: pune

Murali,

How do you find if two programs access same row but the Isolation level has been (CS)?

Wheather is there any transaction lock contains the information ?

vadivem · New User Joined: 08 May 2006 Posts: 24 Location: pune

I having two programs A,B it runs simultaneously but while running the program the Isolation status has been CS(Cursor Stability) here both the programs access same row now which will be access first?

dick scherrer · Posted: Tue Nov 27, 2007 12:13 am

Hello,

Is there some additional question? Re-posting the original words usually will not accomplish much. . .

As the question is posted, the program that reads the row first will get it. I don't know if that is what you mean by predict or not

If you provide more info about what you are trying to do or are concerned about, we may be able to provide more suggestions.

vadivem · New User Joined: 08 May 2006 Posts: 24 Location: pune

I'm sorry,
How do you find if two programs access same row but the Isolation level has been (CS)?

Wheather is there any transaction lock contains the information?

vadivem · New User Joined: 08 May 2006 Posts: 24 Location: pune

can anyone give explaination on above question?

dbzTHEdinosauer · Posted: Mon Dec 03, 2007 10:50 pm

Isolation level is one thing, the locks (explicit and implicit) are another.

if both programs ran without one receive a negative sqlcode indicating that some kind of contention was occuring then you don't have a problem.

you are not stating a problem for which we can provide you a solution. You are posing an hypothetical half-problem; all you are going to get are half-ass answers and that is what you deserve.

If there is any contention, db2 will let you know in the form of a neg sql code for the program that is second in line, if the first program does not release any locks before the waiting period (db2 parms) is over for the second.

dick scherrer · Posted: Mon Dec 03, 2007 10:55 pm

Hello,

My guess would be that there have been no "answers" because the question is not completely understood. Please keep in mind that while your question is completely clear to you, it may not be clear to others.

If an answer is posted, how will you use the info?

If you need to control access to a row, it might be better to read for update.

If we understand your requirement, we may be able to offer suggestions.

vadivem · New User Joined: 08 May 2006 Posts: 24 Location: pune

The two sucessful programs runs simultanously while running the isolation level has been (CS) here both the programs access same row.

suppose the first program access that particullar row how do we find is it first program?

dick scherrer · Posted: Mon Dec 03, 2007 11:25 pm

Hello,

To receive help from the forum, you need to answer questions asked of you.

sreenivasreddyg · New User Joined: 23 Apr 2005 Posts: 39 Location: delhi

DB2 can execute the things at high speed. I do not understand why you trying to know which one will access first