Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Lock escalation

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
Pandora-Box

Moderator


Joined: 07 Sep 2006
Posts: 1535
Location: Andromeda Galaxy

PostPosted: Fri Nov 18, 2011 1:45 pm    Post subject: Lock escalation
Reply with quote

Hi all,

I have a doubt on Lock escalation which is would frequent commits in the application program reduce the possibility of getting LOCK ESCALATION

I know that lock escalation occurs when the number of locks aquired is greater than what is being defined as the threshold limit.

I too understand that too many commits is an over head too

Please advice.
Back to top
View user's profile Send private message

GuyC

Senior Member


Joined: 11 Aug 2009
Posts: 1281
Location: Belgium

PostPosted: Fri Nov 18, 2011 5:39 pm    Post subject:
Reply with quote

it depends on Isolation level, but yes : "commit" releases locks
Back to top
View user's profile Send private message
Pandora-Box

Moderator


Joined: 07 Sep 2006
Posts: 1535
Location: Andromeda Galaxy

PostPosted: Fri Nov 18, 2011 7:59 pm    Post subject:
Reply with quote

Thanks Guyc
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 How to put exclusive lock on a file i... sudarshan.srivathsav JCL & VSAM 4 Fri Jun 05, 2015 10:36 pm
No new posts dead lock while updating the DB2 table abdulrafi DB2 7 Tue Oct 22, 2013 7:02 pm
No new posts Dead lock in DB2 - CICS programs Pandora-Box CICS 8 Fri Sep 13, 2013 3:47 pm
No new posts IRLM Lock Compatibility Amit.Agarwal IMS DB/DC 0 Sat Mar 30, 2013 5:15 pm
No new posts How to lock and release keyboard in CICS baratchandar CICS 1 Wed Dec 05, 2012 11:21 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us