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??
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 ....
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.