Upgrading to DB2 Version 9.7 roadmap

Planning your DB2 environment upgrade requires that you determine a strategy on how to approach your DB2 environment upgrade and create an upgrade plan that includes all of the upgrade process details.

Determine all of the upgrade process details for each component in your environment that you need to know to write your upgrade plan.

• Planning your DB2 servers upgrade
• Planning your DB2 clients upgrade
• Planning database applications and routines upgrade

For each component, you must include in your upgrade plan:

• Upgrade prerequisites

• Pre-upgrade tasks

• Upgrade tasks

• Post-upgrade tasks

Review APARs and known issues related to upgrading to DB2 Version 9.7 in the Troubleshooting section. If these issues impact the your DB2 environment upgrade, add to your upgrade plans the actions on how to resolve them.

To fall back to a previous release after upgrading your DB2 servers, add details to your upgrade plan about the tasks required to reverse a DB2 server upgrade. These details should include any steps required in the upgrade task that enables you to reverse an upgrade.

You should plan how to discontinue the use of deprecated functionality.

• Discontinued or deprecated functionality that affects DB2 server upgrades
• Deprecated functionality summary

If you are still using the deprecated Control Center tools, review the mapping between the recommended Optim tools and Control Center tools that is available at Table of Recommended tools versus Control Center tools.

Consider upgrading your DB2 servers, clients, database applications, and routines in a test environment to learn how to address any issues that may arise during the upgrade process and to evaluate the impact of changes introduced in DB2 Version 9.7. Also in a test environment, you can determine the length of time required to upgrade your database to DB2 Version 9.7 and the disk space requirements that are essential in developing an upgrade plan and performing a successful DB2 environment upgrade.

• Upgrading DB2 servers in a test environment
• Upgrading clients in a test environment

Adopting new DB2 Version 9.7 functionality

Consider also enabling new functionality in your migrated databases and database applications to enhance their functionality and improve their performance.

• Adopting new DB2 Version 9.7 functionality in upgraded databases
• Adopting new DB2 Version 9.7 functionality in database applications and routines

If you want to convert your pre-Version 9.7 non-Unicode database, a DB2 upgrade is not required because you need to re-create your database in Version 9.7 as a Unicode database.

• Converting non-Unicode databases to Unicode

Articles and white papers

• Enhance business insight and scalability of XML data with new DB2 9.7 pureXML features

  This article explains new database design, administration, and development features for pureXML.

Follow the upgrade plan for your environment. The DB2 upgrade process for each component of your environment is described on the following topics:

• DB2 servers upgrade
• Clients upgrade
• Database applications and routines upgrade

The upgrade process for each component includes:

• Upgrade prerequisites

• Pre-upgrade tasks

• Upgrade tasks

• Post-upgrade tasks

DB2 database product education

• The Information Management Training Web site offers a wide variety of training options and the list of skills resources and communities to help you find the educational resources that are right for you.

• Review the list of complimentary DB2 database product self-study courses that can help you build skills at your own pace.

Webcasts

• Chat with the Lab: DB2 9.7 Overview

  Sal Vella, VP of Development, and Tim Vincent, Chief DB2 LUW Architect presented what's new in DB2 9.7.

• Check the IBM DB2 for Linux, Unix, and Windows forum for webcast announcements.

• Stay current with developerWorks technical events and webcasts.

Articles, white papers, and documentation

• Best practices for DB2 for Linux, UNIX, and Windows

• Articles on DB2 Version 9.7 at developerWorks

• DB2 database product documentation available at IBM Knowledge Center. Refer to the Upgrading topic under Database fundamentals to learn how to upgrade all components in your DB2 environment. Refer to the Installing topic under Database fundamentals to learn the new prerequisites, the new options, and how to install Version 9.7.

You can find error information about DB2 upgrade in the following files:

• db2ckupgrade.log when you run the db2ckupgrade command to verify that your databases are ready for upgrade

• db2diag.log when you run the commands to upgrade instances and databases, diagnostic information is also captured if you have set the DIAGLEVEL database manager configuration parameter to 3 (default value) or higher.

You can find information about known issues or defects in the following references:

• Known issues for DB2 database products on AIX operating systems

  This document describes known issues related to DB2 database products and the minimum AIX maintenance level that you should use for DB2 database products.

• Known issues for DB2 database products on HP-UX operating systems

  This document describes known issues related to DB2 database products on HP-UX operating systems.

• Known issues for DB2 database products on Solaris operating systems

  This document describes known issues related to DB2 database products on Solaris operating systems.

• Known issues on Windows operating systems when Upgrading to DB2 Version 9.1

  This document describes known issues related to upgrade to DB2 Version 9.1 on Windows and their resolutions that still apply when you upgrade from DB2 UDB Version 8 to DB2 Version 9.7.

• Removing XML Extender functionality manually from an enabled database in DB2 version 9.7

  If you did not remove the XML Extender functionality before the upgrade, you can follow the steps in this technote to remove it after the upgrade. The procedure described in the technote is unsupported. Consider using the supported procedure described in Upgrading a DB2 server with XML Extender to DB2 Version 9.7.

• Upgrading to DB2 Version 9.7 Technotes

  Search existing technotes to find out about known issues and how to resolve them.

• APARs related to Version 9.7 upgrades

  This document contains a list of APARs which address known issues when upgrading to DB2 Version 9.7.

• Fix list for DB2 Version 9.7 for Linux, UNIX, and Windows

  Contains the list of shipped Authorized Program Analysis Reports (APARs). APARs are bugs in DB2's code that require fixes which are provided through DB2 FixPaks. You should review this list because it is recommended that you apply the latest FixPak prior to Upgrading.

• DB2 database product support site

  You can view news alerts, FAQs, Redbooks®, white papers, presentations, and hints and tips on the DB2 UDB support site.

Additional resources to help you with DB2 upgrade are available at:

• DB2 Version 9.7 trial download

  You can now download a trial version of DB2 Version 9.7 and install it to upgrade in a test environment.

• DB2 Information Center Version 9.7 download

  You can download the latest version available of the DB2 Information Center. The documentation in the DB2 Information Center is updated more frequently than either the PDF or the hard-copy books.

• DB2 Version 9.7 manuals in PDF format download

  You can download the Upgrading to DB2 Version 9.7 guide and all the DB2 Version 9.7 manuals in PDF format.