Out of the box increase your bufferpool size the default is very small
50000 if you can.

Increase the logbufsiz in the db cofiguration, I believe, this is
critical in oltp or write intensive applications.

In the registry
DB2_PARALLEL_IO=*

IF YOU HAVE RAID 5 devices under your file systems.

There are a bunch of other heaps, sort, java, application... that may
need tweaking but the first two suggestions are in my opinion the best
"white washers". Good luck.




-----Original Message-----
From: vijaykumar
[mailto:db2udbdba-ezmlmshield-x28421229.[Email address protected]
Sent: Friday, April 28, 2006 8:28 AM
To: LazyDBA Discussion
Subject: for better performance (DB2 for windows)

how or what method i have to create my db2 UDB 8 for windows to make
good performance. very urgent

thank you

vijaykumar.g


---------------------------------------------------------------------
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