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
 

 

Want in depth description on CS and RR (DB2)

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Testing & Performance analysis
View previous topic :: :: View next topic  
Author Message
sasidhar001
Warnings : 1

New User


Joined: 14 May 2006
Posts: 3
Location: Bangalore

PostPosted: Thu Nov 09, 2006 10:48 am    Post subject: Want in depth description on CS and RR (DB2)
Reply with quote

Hi Can anybody post in depth explanation of RR and CS in practical situation. It would be helpful because this is the must question for every interview.
Back to top
View user's profile Send private message

guptae

Moderator


Joined: 14 Oct 2005
Posts: 1187
Location: Bangalore,India

PostPosted: Thu Nov 09, 2006 11:33 am    Post subject:
Reply with quote

Hi there,

RR: Repeatable read holds all locks untile the transaction completes or a syncpoint is issued.
CS: Cursor stablity means that DB2 takes a lock on the page the cursor is accessing and releases the lock when the cursor moves to another page.
Back to top
View user's profile Send private message
chettiyar
Currently Banned

New User


Joined: 27 Sep 2006
Posts: 6
Location: india,kerala

PostPosted: Tue Nov 21, 2006 2:42 pm    Post subject:
Reply with quote

Isolation level refers to the extent by which the data
accessed by a transaction is isolated from all other
transactions.

DB2 supports 2 Isolation Levels for every transaction

Cursor Stability (CS).

Repeatable Read (RR) (Default).

Cursor Stability (CS)
DB2 takes a lock on the page the cursor is accessing and releases the lock on that page when the cursor moves onto a different page. This is not done when we use FOR UPDATE OF statement in cursor.

The lock on the last page is released at commit time or at thread deallocation time.
Repeatable Read (RR)
In CS, while your transaction reads data, other transaction could change the data you have already read.

In RR, DB2 holds all the page locks while the cursor is moving on till the transaction commits or the thread is deallocated.

CS provides higher concurrency.

RR provides higher consistency.

Read Stability (RS)
Is similar to RR, but without allowing qualifying data to be updated or deleted by another process. It offers greater concurrency than repeatable read, because although other applications cannot change rows that are returned to the original application, they can insert
new rows, or update rows that did not satisfy the original application's search condition.
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 -> Testing & Performance analysis All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts TWS EQQYCAIN - not sure how to get ap... mbenaud IBM Tools 0 Wed Dec 14, 2016 8:45 pm
No new posts Error message description while putti... Aradhana Rathore. JCL & VSAM 8 Mon Jul 22, 2013 11:27 pm
No new posts DSNTIAR - ERROR message description dick scherrer TSO/ISPF 5 Thu Nov 01, 2012 2:57 pm
No new posts adding a description suzeet DFSORT/ICETOOL 1 Fri Oct 19, 2012 11:14 pm
No new posts What is the keyword to see error desc... shweta bansal5 CLIST & REXX 5 Mon Oct 03, 2011 5:25 pm


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