IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

relation b/w locks and isolation levels


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
mfhelp
Warnings : 1

New User


Joined: 29 Jun 2006
Posts: 33

PostPosted: Mon Sep 04, 2006 3:44 pm
Reply with quote

if mentioning the isolation level acquires suitable locks on DB2 objects, then why dont we direcltly mention the locks (say page lock or table lock
) instead of isolation level. why the concept of isolation level has come?

if for eg: while defining a table in a table-space, DB admin puts table lock, then will any isolation level kept by application-programmer override this lock size??
Back to top
View user's profile Send private message
mani_jnumca

New User


Joined: 18 Jan 2006
Posts: 16
Location: PUNE

PostPosted: Mon Sep 04, 2006 5:44 pm
Reply with quote

Dear MFHELP!!!
for Ur kind information isolation level is different from the Lock imposed by the Admin ...
Lock is some what access granted on any specific table for particular Id.and type of the lock whether it is update ...read nd so on.
while isolation level u can say subset of Lock
in which based on that lock if u access any table and for that table or table space will lock for consistency in the data base ...no other can modify that table or table space same time ....
Back to top
View user's profile Send private message
mbr_raja

New User


Joined: 15 Nov 2004
Posts: 26
Location: Chennai, India

PostPosted: Wed Sep 06, 2006 3:03 pm
Reply with quote

Isolation levels and locks remains the same, but isolation levels will be in the high priority and it will applicable to the whole DB2 objects. but locks applicable in the individual for every row or a table. Isolation levels will overide other locks used in the application side.

Isolation levels are CS, RR, RS and UR

Locks: IN, IS, IX, SIX, S, U, X, Z .....
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts Need clarification of VSAM FCT and DF... CICS 15
No new posts Finding locks on z/OS DB2? DB2 2
No new posts Easytrieve provides how many levels o... Mainframe Interview Questions 11
No new posts Current Isolation level DB2 2
No new posts Problem related to isolation level. DB2 1
Search our Forums:

Back to Top