|
Raoul,
I have an OLTP database with High LOCKLIST use,
The parameters are:
Max storage for lock list (4KB) (LOCKLIST) = 4096
Interval for checking deadlock (ms) (DLCHKTIME) = 5000
Percent. of lock lists per application (MAXLOCKS) = 80
Lock timeout (sec) (LOCKTIMEOUT) = 180
Changed pages threshold (CHNGPGS_THRESH) = 30
You need to find out which is the % of LOCKLIST used in your database.
This formula can be done:
LOCKLIST=`db2 get db cfg for $db |grep LOCKLIST \
| awk '{Bytes = (($9*4)*1024)} {printf ("%d",Bytes)} {exit}'`
LOCKLUSE=`db2 GET SNAPSHOT FOR DATABASE ON $db \
|grep "Lock list memory in use (Bytes)" | awk '{print $8}'`
echo $LOCKLIST $LOCKLUSE > $AWKvalues
LCKL="`awk '{avg = ($2*100)/$1} {printf ("%.2f%", avg)} {exit}' $AWKvalues`"
If %LockList in use exceeds 50% of the MaxStorage size
then, performance can degrade because lock escalation, thus reducing concurrency on shared objects in the db. If %LockList in use is too low, it may be overallocated
====================================================
Hi,
We use DB2 v7.2 on AIX.
We have a lot of lock escalations on our database.
The locking params are:
Locklists 1500
Maxlocks 10
I think we have to encrease the Locklists. But how do I know which value to
use?
Do you have a formula to calculate the correct values?
What does this Maxlocks=10 mean? Is it 10% of 1500 so 150 locklists per
application?
What values do you use for how many users and system memory?
Regards
Raoul Joemman
*****************************************************************
This e-mail and any attachment may contain confidential
and privileged material intended for the addressee only.
If you are not the addressee, you are notified that no part of
the e-mail or any attachment may be disclosed, copied or
distributed, and that any other action related to this e-mail
or attachment is strictly prohibited, and may be unlawful.
If you have received this e-mail by error, please notify the
sender immediately by return e-mail, and delete this message.
Martinair Holland N.V., its subsidiaries and/or its employees
shall not be liable for the incorrect or incomplete transmission
of this e-mail or any attachments, nor responsible for any
delay in receipt.
*****************************************************************
-
::: When replying to the list, please use 'Reply-All' and make sure
::: a copy goes to the list ([EMAIL PROTECTED]).
*** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
*** For more information, check http://www.db2eug.uni.cc
|
