RE: [DB2EUG] db2 udb sql tuning tool !

[James Dey]

Title: Message

Why not just use DB2 Event Monitor/analyser. That let's you see which queries use most cpu, lookup most rows etc.

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Kumar, Vasanth
Sent: 15 March 2004 19:26
To: [EMAIL PROTECTED]
Subject: [DB2EUG] db2 udb sql tuning tool !

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.

==============================================================================