Home > IT Answers > AS/400 > Tuning DB2/400 queries on iSeries
AS400 - Ask the Expert
485 pts.
 Tuning DB2/400 queries on iSeries
AS/400, DB2/400, iSeries, performance tuning
We are using lot of DB2/400 queries in our iSeries system. Are there any tools available on the market to tune them?

Software/Hardware used:
ASKED: December 10, 2008  9:40 PM
UPDATED: December 10, 2008  11:11 PM
RELATED QUESTIONS
Answer Wiki:
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!! Jen
Last Wiki Answer Submitted:  December 10, 2008  11:11 pm  by  IGal   45 pts.
All Answer Wiki Contributors:  IGal   45 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _