View previous topic :: View next topic
|
Author |
Message |
mfhelp Warnings : 1 New User
Joined: 29 Jun 2006 Posts: 33
|
|
|
|
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 |
|
|
mani_jnumca
New User
Joined: 18 Jan 2006 Posts: 16 Location: PUNE
|
|
|
|
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 |
|
|
mbr_raja
New User
Joined: 15 Nov 2004 Posts: 26 Location: Chennai, India
|
|
|
|
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 |
|
|
|