IBM Support

Upgrading to DB2 Connect Version 9.7 roadmap

Preventive Service Planning


Abstract

Upgrading to DB2® Connect Version 9.7 might require upgrading your environment components. These components are DB2 Connect servers, DB2 servers, clients, and database applications. Upgrading these components requires an understanding of the DB2 products upgrade concepts and the DB2 products.

This document will help you navigate through the available information and resources related to upgrading from DB2 Connect Version 8, Version 9.1, and Version 9.5 to DB2 Connect Version 9.7 .

Content


Your first point of reference to learn how to create an upgrade plan and how to upgrade each component of your DB2 environment is the Installing and Configuring DB2 Connect Servers and the Upgrading to DB2 Version 9.7 guide. The content of this guide is available in the DB2 Information Center. The most high level topic is Upgrading to the latest version of DB2 Connect.

You will find that upgrade topics for DB2 Connect servers reference upgrade tasks for DB2 servers because they are exactly the same tasks for DB2 servers and DB2 Connect servers.


Table of contents
Prerequisites
Planning
Upgrading
Education
Troubleshooting
Additional resources




Prerequisites
If you are upgrading from DB2 Connect Version 7 or earlier, you need to upgrade to DB2 Connect Version 8 first.

Ensure that you meet the operating system and hardware requirements for DB2 Connect Version 9.7 described at Installation requirements for DB2 database products, and the prerequisites for connectivity to supported System z and IBM i data servers described at IBM i and mainframe support for DB2 Connect.

Review the changes in Version 9.7 to existing functionality from previous releases that can impact your DB2 Connect upgrade:

Upgrade essentials for DB2 Connect servers
Upgrade essentials for DB2 servers
Upgrade essentials for DB2 clients
Upgrade essentials for database applications
DB2 Connect enhancements summary

If you are upgrading from DB2 Connect Version 8, review the changes in Version 9.1 to existing functionality from previous releases that can also impact your DB2 Connect upgrade:

Upgrade essentials for DB2 Connect servers
What's new for V9.1: DB2 Connect enhancements summary

If you are upgrading from DB2 Connect Version 8.1 to DB2 Connect Version 9.7, you might need to address the changes and conversions that happen when you install DB2 Connect Version 8.2 (DB2 Connect Version 8.1 FixPak 7) or a higher level on a DB2 server that already has DB2 Connect Version 8.1 installed up to FixPak 6 level, in addition to the changes in upgrading to DB2 Connect Version 9.7.

Review the Discontinued and deprecated functionality sections in the following topics to determine if you have to discontinue the use of functionality that is not supported in DB2 Connect Version 9.7.

DB2 Connect enhancements summary for DB2 Connect Version 9.7
DB2 Connect enhancements summary for DB2 Connect Version 9.5
What's new for V9.1: DB2 Connect enhancements summary

Back to top



Planning
Planning upgrade for your environment requires that you determine a strategy on how to approach the upgrade of your environment and create a 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. For each component, you must include in your upgrade plan:

Upgrade prerequisites
Pre-upgrade tasks
Upgrade tasks
Post-upgrade tasks

Review the upgrade to DB2 Connect Version 9.7, pre-upgrade, upgrade and post-upgrade topics inInstalling and Configuring DB2 Connect Servers for upgrade process details. In addition, review the planning upgrade for your DB2 environment, pre-upgrade, upgrade and post-upgrade topics in Upgrading to DB2 Version 9.7.

You should plan how to discontinue the use of deprecated functionality. Refer to the Discontinued and deprecated functionality sections in DB2 Connect enhancements summary topic for details.

Back to top




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

Upgrading DB2 Connect servers
Upgrading DB2 servers
Upgrading Clients
Upgrading Database applications and routines

The upgrade process for each component includes:
Upgrade prerequisites
Pre-upgrade tasks
Upgrade tasks
Post-upgrade tasks

Back to top




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.

Tutorials

Search developerWorks for all of the tutorials and online courses about DB2 Connect

Webcasts

Stay current with developerWorks technical events and webcasts.

Documentation, articles, and white papers

Search through DB2 Connect product documentation
You have access to the entire DB2 Connect Version 9.7 documentation by visiting the IBM DB2 information center. Refer to the Upgrading topic to learn how to upgrade all components in your DB2 environment. Refer to the Installing topic to learn the new prerequisites, the new options, and how to install DB2 Connect Version 9.7.

Search developerWorks for all of the articles on DB2 Connect.

Back to top




Troubleshooting
You can find error information about the DB2 Connect 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:

IBM i and mainframe support for DB2 Connect
Review the connectivity support for supported System z and IBM i data servers to ensure that you meet the prerequisites.


DB2 Connect APARs
You should also review the list of current Authorized Program Analysis Reports (APARs), to learn about the fixes that are available for DB2 Connect.


DB2 Connect support site
You can view news alerts, FAQs, Redbooks, White papers, presentations, and hints and tips on the DB2 Connect support site.

Back to top




Additional resources
Additional resources to help you upgrading to DB2 Connect are available at:

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


DB2 Information Center Version 9.7 download
You can now download the latest version available of the DB2 Information Center. The documentation in the DB2 Information Center provides the most current information because it is updated more frequently than either the PDF or the hard-copy books.


Downloading DB2 Version 9.7 PDFs manuals
You can download the Installing and Configuring DB2 Connect Servers manual, the Upgrading to DB2 Version 9.7 manual, and all the DB2 Version 9.7 PDF manuals from this Web page.


Information Management forums
Hosted by developerWorks, these forums are places to exchange ideas and share solutions with your peers in the IBM DB2 product community. In addition, DB2 forums include forums that are mirrors to DB2 newsgroups, such as the ibm.software.db2.udb and ibm.software.db2.udb.beta newsgroups.



Roadmaps to upgrade or migrate DB2 products

Additional roadmaps are available at DB2 upgrade portal.

Back to top

[{"Product":{"code":"SSEPDU","label":"Db2 Connect"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Installation\/Migration","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"9.7;9.5;9.1;8","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
16 June 2018

UID

swg21326544