The comments about Optimization Service Center (OSC) and the free Data Studio were great last week. Sorry I could not reply because I am working with clients on their DB2 performance issues. I’m only able to look through the DB2-L Digest in the evenings.
I agree that IBM has a great free product in OSC . . . → Read More: What DB2 Tools Do You Use Most?
Analyzing SQL access and DB2 performance is difficult without any tools. The Optimization Service Center (OSC) is a great tool and resource within DB2 V9 for z/OS. This tool helps you with the cost of the SQL, Visual Explain of the access path and provides the ability to dump and then look through the Dynamic . . . → Read More: Free Tools for DB2 Help You Improve Access Performance