Henry,

There's a lot to tuning any application that uses a dbms. From your message,
I assume that you are talking about UDB on the distributed envirnments(NT,
AIX or OS/2). The first step in tuning is identifying what is the current
performance level. From there you can identify the hotspots and slow
performers. A monitoring tool is invaluable for this, some companies that
provide tools are Quest and DGI. IBM also provides, within UDB, monitoring
tools. For starters, download a copy of the UDB System Monitor Guide and
Reference from the IBM website. It contains special instructions for
capturing SQL performance information.

DB2 Magazine which is free to professionals in the industry has many
articles on tuning. Plus the UDB Administration Guide provides valuable
information.


Roland DePratti



-----Original Message-----
From: Henry O'Keeffe [SMTP:[Email Address Removed] Sent: Thursday, October 24, 2002 7:57 PM
To: [Email Address Removed] Subject: Performance tuning udb/db2

Hi,

What's considered the best technique for tuning db2/udb ? Can anyone
give me
some pointers to a good book or website on tuning methodology (or
better
still just tell me what you normally do that gets results! )

Regards,
Henry.





---------------------------------------------------------------------
To unsubscribe, e-mail: db2udbdba-[Email Address Removed] For additional commands, e-mail: db2udbdba-[Email Address Removed]

------------------------------------------------------------------------------
CONFIDENTIALITY NOTICE: If you have received this e-mail in error, please immediately notify the sender by e-mail at the address shown. This e-mail transmission may contain confidential information. This information is intended only for the use of the individual(s) or entity to whom it is intended even if addressed incorrectly. Please delete it from your files if you are not the intended recipient. Thank you for your compliance. Copyright (c) 2002 CIGNA

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

DB2 & UDB email list listserv db2-l LazyDBA home page