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

Lock Escalation


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

New User


Joined: 24 Oct 2023
Posts: 22
Location: India

PostPosted: Thu Nov 16, 2023 11:44 pm
Reply with quote

Hi All,

I saw lot of uncommitted read messages in log ,followed by lock escalation.

When I surfed about lock escaaltion ,I see articles describing locksize "any" as only reason,some states lockmax system ,numlkts,numlkus.I'm bit confused here.

When/why lock escaaltion occur.What is the reason for it?

locksize any ->acquires page level locks but manual states row level locks can escalate to tablespace lock.
Back to top
View user's profile Send private message
sergeyken

Senior Member


Joined: 29 Apr 2008
Posts: 2023
Location: USA

PostPosted: Fri Nov 17, 2023 12:21 am
Reply with quote

This is neither JCL nor VSAM question.
Back to top
View user's profile Send private message
Pete Wilson

Active Member


Joined: 31 Dec 2009
Posts: 581
Location: London

PostPosted: Fri Nov 17, 2023 1:16 pm
Reply with quote

30 seconds on Google using search 'what is locksize in db2' provides ample information.

Obviously this should have been raised in the DB2 forum!
Back to top
View user's profile Send private message
Rohit Umarjikar

Global Moderator


Joined: 21 Sep 2010
Posts: 3053
Location: NYC,USA

PostPosted: Fri Nov 17, 2023 4:53 pm
Reply with quote

Moved to db2 forum ..

This occurred when there is not enough memory to acquire any additional locks , so do analysis further to see what type of locks are present on the tables and then adjust the locklist parameter accordingly by consulting with DBA.
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 How to put exclusive lock on a file i... JCL & VSAM 4
No new posts dead lock while updating the DB2 table DB2 7
No new posts Dead lock in DB2 - CICS programs CICS 8
No new posts IRLM Lock Compatibility IMS DB/DC 0
No new posts How to lock and release keyboard in CICS CICS 1
Search our Forums:

Back to Top