I think you've confused the two parameters here...
MAXLOCKS is the maximum percent of lock list before escalation.
LOCKLIST is the amount of storage allocated to the lock list.
You probably meant to say LOCKLIST 600 and MAXLOCKS 20.....right?
Bob Lewis
-----Original Message-----
From: Steve Levy [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 18, 2001 7:23 AM
To: [EMAIL PROTECTED]
Subject: RE: DB2EUG: DB2 lock timeout / deadlock problem
With a MAXLOCKS parameter of 100 only 100 rows may be locked at one time.
You cursors (selects statements) are hitting this wall then escalating to
table locks on your "3 main tables." First LOCKLIST is a %-age so 100 is
not a great choice unless you really WANT one use to be able to "use up" all
of your databases locks (only for REAL heavy batch-based apps would this be
the case). If you increase your MAXLOCKS you will find you are able to
support more users. Try MAXLOCKS 600 and LOCKLIST
20. This will give each user 20% of 600 possible locks or everyone will get
about 100 rows. If these numbers seem too high decrease as you need to.
Good Luck
