The Locklist is the area where DB2 stores Locks (application and internal locks on tables as well as DB2 catalog). It defaults to 100 4K pages. This isn't very large, but of course I don't know how much locking your applications do. You should probably increase this to minimize lock escalations (which appear in db2diag.log as message ADM5502W). I'll recommend you set it to 1000, which is 10x the default) until you can test more. 4 Megs is still not very large for a LOCKLIST.
The default prefetch size is usually good at 32. When DB2 is scanning your tablespace sequentially it will "block" the I/O's in groups of 32.
MAXAPPLs is the maximum number of applications (programs and/or users) who can connect concurrently to the database. The default setting of AUTOMATIC is recommended usually.
-----Original Message-----
From: Sudhir Anand - CTS <db2udbdba-ezmlmshield-x85672847.[Email address protected]
To: LazyDBA Discussion <[Email address protected]
Sent: Thu, 17 Nov 2005 22:12:53 +0530
Subject: URGENT ANSWER APPRECIATED
Can any one help me , why these parameters in Db2 configuration are used and
what should be ideal settings for the same on Db2 8.1.10
Max storage for lock list (4KB)
Default prefetch size (pages)
Max number of active applications
----------------------------------------------------------------------------
---------------------------------------------------
DISCLAIMER
This email and any files transmitted with it are confidential and are solely
for the use of the individual or entity to which it is addressed. Any use,
distribution, copying or disclosure by any other person is strictly
prohibited. If you receive this transmission in error, please notify the
sender by reply email and then destroy the message. Opinions, conclusions
and other information in this message that do not relate to official
business of the company shall be understood to be neither given nor endorsed
by NIIT Ltd. or NIIT Technologies Ltd. Any information contained in this
email, when addressed to Clients is subject to the terms and conditions in
governing client contract.
---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
DB2 & UDB email list listserv db2-l LazyDBA home page