What are the isolation levels possible ?

db2 sql interview questions

Moderator: Moderator Group

Post Reply
User avatar
Krishna
Site Admin
Posts: 1052
Joined: Fri Jan 27, 2006 7:50 am

What are the isolation levels possible ?

Post by Krishna » Sun Mar 29, 2009 10:53 pm

What are the isolation levels possible ?

Sukanthi Darwin
Member
Posts: 6
Joined: Sun Nov 22, 2009 7:45 pm

Post by Sukanthi Darwin » Sun Nov 22, 2009 8:21 pm

Cursor Stability (CS), Repeatable Read (RR), Read Stability (RS), Uncommitted Read (UR). Cursor stability holds locks as long the cursor is position on the row. Repeatable read holds locks on all the rows on both qualifying and non-qualifying rows. Read stability holds locks only on qualifying rows only. Uncommitted read does not takes any locks but does take latches instead.

Post Reply

FREE TUTORIALS

Tutorials
Free tutorials from mainframegurukul
  • JCL Tutorial
    Covers all important JCL concepts.
  • Cobol Tutorial
    This tutorials covers all Cobol Topics from STRING to COMP-3.
  • DB2 Tutorial
    DB2 Tutorial focuses on DB2 COBOL Programming.
  • SORT Tutorial
    This Tutorial covers all important aspects of DFSORT with examples
  • CICS Tutorial
    This CICS tutorial covers CICS concepts and CICS Basics, CICS COBOL Programming.
Interview
Mainframe Interview questions



Other References
Mainframe Tools and others