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
 

 

Difference between Repeatable read and Cursor stabilty

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

New User


Joined: 25 May 2007
Posts: 10
Location: chennai

PostPosted: Sat Jun 09, 2007 7:23 pm    Post subject: Difference between Repeatable read and Cursor stabilty
Reply with quote

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

shane

New User


Joined: 17 May 2007
Posts: 11
Location: Phoenix,Arizona

PostPosted: Sun Jun 10, 2007 9:36 am    Post subject:
Reply with quote

Hi,

Have you gone through the Forum for this answer?
This things are there.......in this Forum.
Search it out yourself
Back to top
View user's profile Send private message
bansal

New User


Joined: 03 Jan 2007
Posts: 27
Location: Hyderabad

PostPosted: Mon Jun 11, 2007 12:51 pm    Post subject: Re: Difference between Repeatable read and Cursor stabilty
Reply with quote

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

New User


Joined: 19 Dec 2006
Posts: 12
Location: chennai

PostPosted: Mon Jun 11, 2007 5:37 pm    Post subject:
Reply with quote

Hi,

Just see this link
http://publib.boulder.ibm.com/infocenter/iseries/v5r3/index.jsp?topic=/db2/rbafzmstisol.htm
Back to top
View user's profile Send private message
sandeepc_savithri

New User


Joined: 25 May 2007
Posts: 10
Location: chennai

PostPosted: Tue Jun 12, 2007 8:12 am    Post subject: Re: Difference between Repeatable read and Cursor stabilty
Reply with quote

Thanks chtrisa
The link you provided was awsome and i have to to explore lot from that
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
No new posts Getting -504 Cursor Name GTT-ARTS-CUR... Robin Sulsona DB2 2 Fri Mar 17, 2017 1:43 am
No new posts Release of Adabas Cursor mohitsethi All Other Mainframe Topics 1 Mon Feb 06, 2017 8:36 pm
No new posts Difference between TWALENG and TWASIZE Arunkumar Chandrasekaran CICS 3 Tue Jan 03, 2017 12:57 pm
No new posts Updating Cursor row withour using FOR... chandan.inst DB2 15 Tue Nov 08, 2016 11:17 am
No new posts Sticky: difference between ... DUMMY ... and ... enrico-sorichetti JCL & VSAM 0 Mon Oct 17, 2016 4:31 pm


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