Preventive Service Planning
Abstract
Upgrading to DB2® Connect Version 9.5 might require migration of your environment components. These components are DB2 Connect servers, DB2 servers, clients, and database applications. Migrating these components requires an understanding of the DB2 products migration 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 and Version 9.1 to DB2 Connect Version 9.5 .
Content
Your first point of reference to learn how to create a migration plan and how to migrate each component of your DB2 environment is the Quick Beginnings for DB2 Connect Servers and the DB2 Migration guide. The most high level topic is Migration to DB2 Connect Version 9.5.
You will find that migration topics for DB2 Connect servers reference migration tasks for DB2 servers because they are exactly the same tasks for DB2 servers and DB2 Connect servers.
Prerequisites
Planning
Migrating
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.5 described at Installation requirements for DB2 database products, and the prerequisites for connectivity to supported host and iSeries data servers described at Recommended Service Upgrades for DB2 Connect targets.
Review the changes in Version 9.5 to existing functionality from previous releases that can impact your migration:
 | Migration essentials for DB2 Connect servers |
 | Migration essentials for DB2 servers |
 | Migration essentials for DB2 clients |
 | Migration 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 environment migration:
 | Migration essentials for DB2 Connect servers |
 | What's new for V9.1: DB2 Connect enhancements summary |
If you are migrating from DB2 Connect Version 8.1 to DB2 Connect Version 9.5, 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.5.
Review the Discontinued and deprecated functionality sections in the DB2 Connect enhancements summary topic to determine if you have to discontinue the use of functionality that is not supported in DB2 Connect Version 9.5.
If you are upgrading from DB2 Connect Version 8, review the Discontinued and deprecated functionality section in the What's new for V9.1: DB2 Connect enhancements summary topic to determine if you have to discontinue the use of functionality that is not supported in DB2 Connect Version 9.1.
Back to top
Planning
Planning migration for your environment requires that you determine a strategy on how to approach the migration of your environment and create a migration plan that includes all of the migration process details.
Determine all of the migration process details for each component in your environment that you need to know to write your migration plan. For each component, you must include in your migration plan:
 | Migration prerequisites |
 | Pre-migration tasks |
 | Migration tasks |
 | Post-migration tasks |
Review the migration to DB2 Connect Version 9.5, pre-migration, migration and post-migration topics in the Quick Beginnings for DB2 Connect Servers for migration process details. In addition, review the planning migration for your DB2 environment, pre-migration, migration and post-migration topics in the DB2 Migration guide.
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
Migrating
Follow the migration plan for your environment. The migration process for each component of your environment is described on the following topics:
 | Migrating DB2 Connect servers |
 | Migrating DB2 servers |
 | Migrating DB2 clients |
 | Migrating database applications and routines |
The migration process for each component includes:
 | Migration prerequisites |
 | Pre-migration tasks |
 | Migration tasks |
 | Post-migration 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.
Tutorials
Search developerWorks for all of the tutorials and on-line 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.5 documentation by visiting the IBM DB2 information center. Refer to the Migrating topic to learn how to migrate 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.5.
Search developerWorks for all of the articles on DB2 Connect.
Back to top
Troubleshooting
You can find error information about migration in the following files:
 | migration.log when you run db2ckmig to verify that your databases are ready for migration |
 | db2diag.log when you run the commands to migrate 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:
 | Host and iSeries support for DB2 Connect Review the connectivity support for host and iSeries 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 with migration are available at:
 | DB2 Connect Version 9.5 trial download You can now download DB2 Connect Version 9.5 and install it to migrate in a test environment. |
 | DB2 Information Center Version 9.5 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. |
 | DB2 Connect Version 9.5 manuals in PDF format You can download the Quick Beginnings for DB2 Connect Servers, the DB2 Migration guide, and all the DB2 product Version 9.5 manuals in PDF format. |
 | DB2 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. |
Other DB2 upgrade roadmaps available at DB2 upgrade portal.
Back to top
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21271872