Preventive Service Planning
Abstract
Upgrading to DB2® Version 9.7 might require upgrading your environment components. These components are DB2 servers, DB2 clients, database applications, and routines. Upgrading these components requires an understanding of the DB2 database product upgrade concepts and the DB2 database products.
This roadmap will help you navigate through the available information and resources related to upgrading from DB2 Universal Database (DB2 UDB®) Version 8, DB2 LUW Version 9.1, or DB2 LUW Version 9.5 to DB2 Version 9.7
Content
Your first point of reference to learn how to upgrade each component of your DB2 environment and how to create a upgrade plan is the Upgrading to DB2 Version 9.7 guide. The content of this guide is available in IBM Knowledge Center. The highest level topic is Upgrading to DB2 Version 9.7.
Table of contents
Prerequisites
Ensure that you meet the operating system and hardware requirements for DB2 Version 9.7 described in Installation requirements for DB2 database products.
Review changes in Version 9.7 to existing functionality from previous releases that can impact your DB2 environment upgrade:
- Upgrade essentials for DB2 servers
- Upgrade essentials for DB2 clients
- Upgrade essentials for database applications
- Upgrade essentials for routines
- Changes in existing functionality
If you are Upgrading from DB2 UDB Version 8 or DB2 Version 9.1, review changes between pre-Version 9.7 releases to existing functionality from previous releases that can also impact your DB2 environment upgrade:
If you are Upgrading from DB2 UDB Version 8.1 to DB2 Version 9.7. In addition to the changes in Upgrading to DB2 Version 9.7, you might need to address the changes and conversions that happen when you install DB2 UDB Version 8.2 (DB2 UDB Version 8.1 Fix Pack 7) or a higher level on a DB2 server that already has DB2 UDB Version 8.1 installed up to Fix Pack 6 level.
Discontinue the use of functionality that is unsupported in DB2 Version 9.7.
- Discontinued or deprecated functionality that affects DB2 server upgrades
- Discontinued functionality summary
If you are Upgrading from DB2 UDB Version 8 or DB2 Version 9.1, discontinue the use of functionality that is unsupported in pre-Version 9.7 releases.
- Version 9.5: Discontinued or deprecated functionality that impacts DB2 server migration
- Version 9.5: Discontinued functionality summary
XML Extender is discontinued in DB2 Version 9.7, you must remove XML Extender functionality before you can upgrade to DB2 Version 9.7. See Upgrading a DB2 server with XML Extender to DB2 Version 9.7 for details.
There is no utility to fall back to a previous release after upgrading your DB2 servers. Refer to the Planning section for details.
Back to top
Planning
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.
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.
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.
Back to top
Upgrading
Follow the upgrade plan for your environment. The DB2 upgrade process for each component of your environment is described on the following topics:
The upgrade process for each component includes:
Upgrade prerequisites
Pre-upgrade tasks
Upgrade tasks
Post-upgrade tasks
Back to top
Education
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.
Back to top
DB2 Troubleshooting
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.
Back to top
Additional resources
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.
Back to top
Additional roadmaps to upgrade or migrate DB2 products are available at DB2 upgrade portal.

For further discussion on this topic, visit this developerWorks forum thread:
https://www.ibm.com/developerworks/community/forums/html/topic?id=c6015de4-3677-40b3-9d7a-19fbd3dc2824
Document Information
Modified date:
16 June 2018
UID
swg21313253