Difference between Repeatable read and Cursor stabilty

sandeepc_savithri · New User Joined: 25 May 2007 Posts: 10 Location: chennai

Hi All,
Can any one tell me the difference between Repeatable read ( RR) and Cursor stability (CS) of Isolation level in DB2
when we use SPUFI we can see the isolation level as RR or CS

Thanks and regards
Sandeep

shane · Posted: Sun Jun 10, 2007 9:36 am

Hi,

Have you gone through the Forum for this answer?
This things are there.......in this Forum.
Search it out yourself

bansal · New User Joined: 03 Jan 2007 Posts: 27 Location: Hyderabad

Hi,

I think SHANE is correct. Before posting on this forum you should first search for your query in it. Since you have asked, So

CS- When we move to second page, release the lock over the first page. It avoids concurrent update and provides write integrity.

RR- All locks acquired until commit point. Prefer this, when u have to read same rows again and want the same data on those. Provide read and write integrity.

chtrisa · New User Joined: 19 Dec 2006 Posts: 12 Location: chennai

Hi,

Just see this link
publib.boulder.ibm.com/infocenter/iseries/v5r3/index.jsp?topic=/db2/rbafzmstisol.htm

sandeepc_savithri · New User Joined: 25 May 2007 Posts: 10 Location: chennai

Thanks chtrisa
The link you provided was awsome and i have to to explore lot from that