DB2 10.5 for Linux, UNIX, and Windows

Plan your DB2 environment upgrade

Your environment has several components such as DB2® servers, DB2 clients, database applications, routines, tools, and scripts. Planning your upgrade requires a thorough understanding of the upgrade process of each component in your environment.

First, devise a strategy on how to approach your environment upgrade. You must determine the order in which you are going to upgrade each component. The characteristics of your environment and the information in upgrade essentials, especially the best practices, and restrictions can help you determine your strategy.

The following is an example of a good upgrade strategy in which you test your database applications and routines and determine that they run successfully in DB2 Version 10.5.
  1. Review the new, deprecated, and discontinued functionality for DB2 Version 10.5 and for any releases between the release you are upgrading from and DB2 Version 10.5.
  2. Create a plan to modify your database applications and routines. Verify that they run successfully in DB2 Version 10.5.
  3. Set up a DB2 Version 10.5 test server and create test databases.
  4. Test your database applications and routines on a DB2 Version 10.5 test database to determine whether they run successfully. If your application requires a client, use a DB2 Version 10.5 client.
  5. Upgrade your DB2 servers and DB2 clients in a test environment. Determine the issues and solutions. Use this information to adjust your upgrade plan.
  6. Upgrade your DB2 servers to DB2 Version 10.5 in your production environment. Verify that the servers operate as expected.
  7. Upgrade your DB2 clients to DB2 Version 10.5 in your production environment. Verify that the clients operate as expected.
  8. Test your database applications and routines in the DB2 Version 10.5 upgraded production environment to determine whether they run as expected.
  9. Make your upgraded environment available to users.
After you devise a strategy that gives an outline of your upgrade plan, you can define the upgrade plan details for each component in your environment. An upgrade plan must include the following details for each component: If you have previous upgrade plans, review and compare them with the upgrade plan for DB2 Version 10.5. Include in your new plan any steps that are related to internal procedures to request access, software installation, or other system services within your organization.

Review also the DB2 upgrade portal at www.ibm.com/support (formerly known as DB2 migration portal) that provides access to more resources and up-to-date information about the upgrade process as they become available. These resources include educational material, white papers, and webcast for upgrade.

Finally, plan to remove the use of deprecated functionality and incorporate new functionality from DB2 Version 10.5. Although you are only required to remove the use of discontinued functionality, you must also plan to remove the use of deprecated functionality after upgrade because they will become unsupported in a future release. Also, you must take advantage of new functionality for your database products, applications, and routines to enhance functions and improve performance.