Actually, there are two.
System i Navigator remains the standard - its free - and queries can be tuned in Visual Explain.
Or...you can go with the folks that invented their visual explain 4 or so years before IBM did, and have a set of tools that help you manage the queries, tune the db, optimize performance and more. <a href="http://www.centerfieldtechnology.com/homerun.asp">www.centerfieldtechnology.com/homerun.asp</a>
One of the newest modules, AutoDBA is worth a look to help manage unused indexes that have already been built (or shipped with the vendor app)
Happy holidays to all!!
Last Wiki Answer Submitted: December 10, 2008 11:11 pm by IGal45 pts.