Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
When will be the lock released?

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Mainframe Interview Questions
View previous topic :: :: View next topic  
Author Message
shyam6385

New User


Joined: 14 Oct 2009
Posts: 6
Location: bangalore

PostPosted: Tue Oct 27, 2009 11:43 am    Post subject: When will be the lock released?
Reply with quote

In RR isolation level, there is a update lock in the table.when the lock will be released.
a. When the cursor moves to the next row
b. When the transaction is committed
c. When the cursor moves to the next row and cursor closed
d. none
Back to top
View user's profile Send private message

Steve Davies

New User


Joined: 15 Oct 2009
Posts: 32
Location: UK

PostPosted: Tue Oct 27, 2009 12:00 pm    Post subject:
Reply with quote

A quick google tells me...

Under an RR isolation level all page locks are held until they are released by a COMMIT (or ROLLBACK), whereas with CS read-only page locks are released as soon as another page is accessed. Repeatable read is the default isolation level if none is specified at BIND time.
Back to top
View user's profile Send private message
Terry Heinze

JCL Moderator


Joined: 14 Jul 2008
Posts: 1249
Location: Richfield, MN, USA

PostPosted: Tue Oct 27, 2009 8:46 pm    Post subject:
Reply with quote

The answer could have been found by looking at the Sticky entitled: DB2 - Interview Questions with Answers. Also, the intent of this forum is for the poster to attempt to answer their own question and then invite responses.
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 -> Mainframe Interview Questions All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Released Init 0 Yolanda Harvey All Other Mainframe Topics 13 Thu Aug 11, 2016 8:51 pm
No new posts How to put exclusive lock on a file i... sudarshan.srivathsav JCL & VSAM 4 Fri Jun 05, 2015 10:36 pm
No new posts dead lock while updating the DB2 table abdulrafi DB2 7 Tue Oct 22, 2013 7:02 pm
No new posts Dead lock in DB2 - CICS programs Pandora-Box CICS 8 Fri Sep 13, 2013 3:47 pm
No new posts IRLM Lock Compatibility Amit.Agarwal IMS DB/DC 0 Sat Mar 30, 2013 5:15 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us