|
View previous topic :: View next topic
|
| Author |
Message |
Akil
New User
Joined: 24 Oct 2023
Posts: 22
Location: India
|
|
|
|
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 |
|
 |
sergeyken
Senior Member
Joined: 29 Apr 2008
Posts: 2023
Location: USA
|
|
|
|
| This is neither JCL nor VSAM question. |
|
| Back to top |
|
|
Pete Wilson
Active Member
Joined: 31 Dec 2009
Posts: 582
Location: London
|
|
|
|
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 |
|
|
Rohit Umarjikar
Global Moderator
Joined: 21 Sep 2010
Posts: 3053
Location: NYC,USA
|
|
|
|
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 |
|
|
|
|
