View previous topic :: View next topic
|
Author |
Message |
vasanthz
Global Moderator
Joined: 28 Aug 2007 Posts: 1742 Location: Tirupur, India
|
|
|
|
Hi,
We are facing deadlocks in a DB2 table and the table is created with LOCKSIZE=ANY.
Manual says that ANY lets DB2 choose the locking size.
Is it possible to determine what LOCKSIZE was chosen by DB2 during a period of deadlock. We have BMC DB2 tools and SMF.
Regards,
Vasanth.S |
|
Back to top |
|
|
Rohit Umarjikar
Global Moderator
Joined: 21 Sep 2010 Posts: 3051 Location: NYC,USA
|
|
|
|
Usually it will be LOCKSIZE PAGE
Change to LOCKSIZE ROW and watch , if you see frequent contention. |
|
Back to top |
|
|
vasanthz
Global Moderator
Joined: 28 Aug 2007 Posts: 1742 Location: Tirupur, India
|
|
|
|
Thank you.
Would it be ok to change it to ROW without identifying what level locking was used prior to the deadlock. I thought we could go one lower level of lock than the lock that caused deadlocks |
|
Back to top |
|
|
Rohit Umarjikar
Global Moderator
Joined: 21 Sep 2010 Posts: 3051 Location: NYC,USA
|
|
|
|
LOCKSIZE ROW is the lower level than LOCKSIZE PAGE. I don't think LOCKSIZE ANY would use LOCKSIZE ROW by itself in a situations like when LOCKSIZE PAGE is not sufficient.
I would look at LOCK ESCALATIONS too to know what it is defined.
This is my understanding but double check with DBA and if its different than above then I would learn something. |
|
Back to top |
|
|
PeterHolland
Global Moderator
Joined: 27 Oct 2009 Posts: 2481 Location: Netherlands, Amstelveen
|
|
Back to top |
|
|
vasanthz
Global Moderator
Joined: 28 Aug 2007 Posts: 1742 Location: Tirupur, India
|
|
|
|
Thanks Rohit and Peter. I will review the information provided |
|
Back to top |
|
|
|