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
 
relation b/w locks and isolation levels

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
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    Post subject: relation b/w locks and isolation levels
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    Post subject: Re: relation b/w locks and isolation levels
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    Post subject: Re: relation b/w locks and isolation levels
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    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Need clarification of VSAM FCT and DF... pkmurali CICS 15 Sun Apr 10, 2016 1:06 am
No new posts Finding locks on z/OS DB2? Ed Goodman DB2 2 Fri Aug 22, 2014 11:55 pm
No new posts Easytrieve provides how many levels o... enrico-sorichetti Mainframe Interview Questions 11 Wed Feb 29, 2012 12:49 pm
No new posts Current Isolation level Pandora-Box DB2 2 Fri Jan 13, 2012 6:59 pm
No new posts Problem related to isolation level. G1NXU6T DB2 1 Fri Feb 25, 2011 6:50 pm

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