Having the right tools can facilitate your ability to more smoothly upgrade to the latest versions of the database. In building a baseline to upgrade to new versions of DB2 for z/OS, and charting comparisons between versions, tools such as DB2 Path Checker can help make upgrading smoother and easier. In addition, DB2 SQL Performance Analyzer provides you with an extensive analysis of SQL queries without executing them. This analysis aids you in tuning your queries to achieve maximum performance, and reduces costs of queries by estimating them prior to execution.
In the IMS world, IMS Parameter Manager can provide migration assistance when upgrading to newer versions of IMS. The tool evaluates all the current system parameters and shows whether they will work in the new version. These and other IMS tools let you to take full advantage of IMS enhancements without overtaxing and overloading limited IMS resources.
This solution allows you to support and exploit new database functionality to meet business needs.
