What DB2 Tools Do You Use Most for DB2 Performance?

By Dave Beulke, on July 6th, 2010

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?

Leave a comment   DB2 Performance   , , , , ,  

Free Tools for DB2 Help You Improve SQL Access and DB2 Performance

By Dave Beulke, on June 30th, 2010

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

Leave a comment   DB2 Performance   , , , , , , , , , , ,