Skip Navigation Links

DB2 Upgrade Analysis

Leveraging the enhancements and fixes that are part of every new release requires that DB2, as any other software package, be upgraded from time to time. Moreover, DB2 is not just another software package. Being a DBMS, DB2 is tightly coupled with the application using the data stored in it. As a result of these tight connections, upgrading DB2 is not a straight forward and riskless task.

Ignoring this complexity and upgrading DB2 without preliminary analysis might cause serious performance degradation, as a result of non-optimal use of the database by the application. This degradation can happen even in well performing systems, as the application’s usage of DB2 remains unchanged, while the underlying DB2 database is different. This can be summarized in the following phrase: “The DB2 thinks in terms of version X while the application is in an older version”.

In order to prevent performance degradation because of upgrading DB2, InnovizeIT offers the “DB2 Upgrade Analysis” service using its InnovizeIT for DB2 technology. The service includes deep analysis of the DB-related applications in order to identify potential risk areas which may cause performance issues after conducting the upgrade. These areas include: SQL issues, workarounds used for achieving missing functionality, Data Model and other logical issues. Based on this thorough analysis, InnovizeIT provides detailed recommendations for change prior to conducting the upgrade. Following these recommendations ensures a smoother upgrade of DB2.