This E-Mail is sent in confidence for the addressee only. Unauthorised recipients must preserve this confidentiality and should notify the sender immediately by telephone on 0131-655-6789 and must delete the original E-Mail without taking a copy. If you are not the addressee you must not copy, distribute, disclose or use any of the information in any way.
This E-Mail is not intended nor should it be taken to create any legal relations, contractual or otherwise. We have taken all reasonable precautions to ensure that no viruses are transmitted from the Scottish Widows Group of companies to any third party. Scottish Widows accepts no responsibility for any loss or damage resulting directly or indirectly from the use of this E-Mail or the contents. ***************************************************************************** The IBM tools are OK, as far as they go. But IMHO if you are looking for serious performance monitoring and tuning tools for DB2 on UNIX you should be looking at the tools from DGI (now part of BMC). The tools that they produce are indispensible in our environment (DB2 on AIX and Solaris). My personal favourite is SQL-Guy, which allows you to virtually instantaneously find the worst SQL going through your system. It links with DB2 explain and advisors to allow you then to tune the SQL it finds. And it does this 24x7 in the background (other tools we looked at only monitored as long as you had a Windows based client open, which really wasn't much good). It may not have the "pretty front end" but it has the in depth power (and if you want the front end, I believe they have a product called Flight Deck which can provide this now). During the trial period (I think it was two weeks) alone we made SQL discoveries and tuning that we reckon exceeded the purchase price of the tool in savings made. The other tools we have (Pool-Guy, Space-Guy, Wise-Guy and Connection-Miner) are for more proactive monitoring. They produce information about the ongoing state of the system and can automatically tune it for you. You may be able to get away with the IBM tools in V8 to do these tasks however. I'd recommend that you test the IBM tools for your proactive monitoring, but look at SQL-Guy at least as well. HTH Phil Nelson Scottish Widows PLC (Note : I have no commercial interest in BMC or DGI, just am a seriously impressed customer) -----Original Message----- From: db2 dba [mailto:[EMAIL PROTECTED] Sent: 09 January 2004 14:36 To: [EMAIL PROTECTED] Subject: [DB2EUG] Performance Expert I am running UDB V8 on AIX 5.1. Does anyone have hands on experience with the IBM Performance Expert tools? I am not looking for Marketing info, but rather real world experience, "in the trenches" related feedback. I am trying to determine whether or not to take a look at Performance Expert before looking at other tools on the market. I am responsible for a partitioned environment that is becoming mission critical. My goals are performance monitoring and tuning. Thanks! _____ Do you Yahoo!? Yahoo! Hotjobs: Enter <http://pa.yahoo.com/*http://us.rd.yahoo.com/hotjobs/mail_footer_email/evt=2 1482/*http://hotjobs.sweepstakes.yahoo.com/signingbonus> the "Signing Bonus" Sweepstakes ***************************************************************************** Visit the Scottish Widows website at www.scottishwidows.co.uk Scottish Widows Group includes the following companies:- Scottish Widows plc, Company No. 199549. Authorised & Regulated by the Financial Services Authority. Scottish Widows Annuities Limited, Company No. 199550. Authorised & Regulated by the Financial Services Authority. Scottish Widows Services Limited, Company No. 189975. The Registered Office of all of the above companies is in the United Kingdom at 69 Morrison Street, Edinburgh, EH3 8YF. Telephone: 0131 655 6000 Scottish Widows Unit Trust Managers Limited, Company No. 1629925 Registered Office: is in the United Kingdom at Charlton Place, Andover, Hampshire SP10 1RE. Telephone: 0845 300 2244 Authorised & Regulated by the Financial Service Authority. Scottish Widows Investment Partnership Limited, Company No. 794936 Registered Office : is in the United Kingdom at 10 Fleet Place, London EC4M 7RH. Telephone: 0131 655 8500 Authorised & Regulated by the Financial Services Authority. Scottish Widows Fund Management Limited, Company No. 74517. Authorised & Regulated by the Financial Services Authority. Pensions Management (SWF) Limited, Company No. 45361. Authorised & Regulated by the Financial Services Authority. The Registered Office of the above two companies is in the United Kingdom at 15 Dalkeith Road, Edinburgh, EH16 5BU. Tel 0131 655 6000 The companies listed above are members of the Scottish Widows and Lloyds TSB Marketing Group- Scottish Widows Bank plc, Company No. 154554 Registered Office: is in the United Kingdom at 67 Morrison Street, Edinburgh, EH3 8YJ. Telephone: 0845 845 0829 Authorised & Regulated by the Financial Services Authority Hill Samuel Unit Trust Managers Limited, Company No 406604 Registered Office: is in the United Kingdom at 10 Fleet Place, London, EC4M 7RH Telephone: 0800 336600 Authorised & Regulated by the Financial Services Authority Hill Samuel Asset Management International Limited, Company No 106723 Registered Office: is in the United Kingdom at 15 Dalkeith Road, Edinburgh, EH16 5BU Telephone: 0131 655 8500 Authorised & Regulated by the Financial Services Authority All of the above companies are part of the Lloyds TSB Group. - ::: 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
