Hi Vasanth I have found the SQl Tuning tool offered by Quest Software to be extremely useful. It is part of their Quest Central for DB2 product. It has a compare feature which allows you to make changes to your SQL and immediately see the impact on performance. Their monitoring tool Spotlight also works great for EEE.
Regards Jay --- "Kumar, Vasanth" <[EMAIL PROTECTED]> wrote: > Hi, > > We are researching a few tools in particular > reference to sql tuning for > > the UDB EEE database (7.2) . There are some queries > which gobble up the > > whole temp tablespaces. > > Is there a most popular udb sql tuning tool ? > > thanks, > > Vasanth > > > ------------------------------------------------------------------------------ > > This email is confidential and may be legally > privileged. > > It is intended solely for the addressee. Access to > this email by anyone else, > unless expressly approved by the sender or an > authorized addressee, is > unauthorized. > > If you are not the intended recipient, any > disclosure, copying, distribution > or any action omitted or taken in reliance on it, is > prohibited and may be > unlawful. If you believe that you have received this > email in error, please > contact the sender, delete this e-mail and destroy > all copies. > > ============================================================================== > - ::: 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
