Upgrading to DB2 Version 9.5 roadmap (formerly known as DB2 Version 9.5 migration roadmap)

Preventive Service Planning


This document applies only to the following language version(s):

English

Abstract


Upgrading to DB2® Version 9.5 might require migration of your environment components. These components are DB2 servers, clients, database applications, and routines. Migrating these components requires an understanding of the DB2 database product migration 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 or DB2 LUW Version 9.1 to DB2 Version 9.5

Content

Your first point of reference to learn how to migrate each component of your DB2 environment and how to create a migration plan is the DB2 Migration guide. The content of this guide is available in the DB2 Information Center. The highest level topic is Migrating to DB2 Version 9.5.


Prerequisites
Planning
Migrating
Education
Troubleshooting
Additional resources





Prerequisites
Ensure that you meet the operating system and hardware requirements for DB2 Version 9.5 described at Installation requirements for DB2 database products.

Review changes in Version 9.5 to existing functionality from previous releases that can impact your components migration:
Migration essentials for DB2 servers
Migration essentials for clients
Migration essentials for database applications
Migration essentials for routines
Changes in existing functionality

If you are upgrading from DB2 UDB Version 8, review changes in Version 9.1 to existing functionality from previous releases that can also impact your component migration:
What's new for V9.1: Changes in existing functionality
Version 9.1 incompatibilities with previous releases and changed behaviors

If you are upgrading from DB2 UDB Version 8.1 to DB2 Version 9.5, review also the DB2 UDB Version 8.2 upgrade considerations technote. In addition to the changes in upgrading to DB2 Version 9.5, you might need to address the changes and conversions that happen when you install DB2 UDB Version 8.2 (DB2 UDB Version 8.1 FixPak 7) or a higher level on a DB2 server that already has DB2 UDB Version 8.1 installed up to FixPak 6 level. You should consider upgrading to DB2 UDB Version 8.2 first.

Discontinue the use of functionality that is not supported in DB2 Version 9.5.
Discontinued or deprecated functionality that impacts DB2 server migration
Discontinued functionality summary

If you are upgrading from DB2 UDB Version 8, discontinue the use of functionality that is not supported since DB2 Version 9.1.
Version 9.1 discontinued or deprecated functionality in DB2 database product that impacts migration
What's new for V9.1: Discontinued functionality
Version 9.1 deprecated and discontinued features

There is no utility to fall back to a previous release after migrating your DB2 servers. Refer to the Planning section for details.


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 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.
Planning migration for your DB2 servers
Planning migration for your clients
Planning migration for your database applications and routines

For each component, you must include in your migration plan:
Migration prerequisites
Pre-migration tasks
Migration tasks
Post-migration tasks

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

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

You should plan how to discontinue the use of deprecated functionality.
Discontinued or deprecated functionality that impacts migration DB2 server migration
Deprecated functionality summary

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


Adopting new DB2 Version 9.5 functionality

Consider also adopitng new functionality in your migrated databases and database applications to enhance their functionality and improve their performance.
Enabling new DB2 Version 9.5 functionality in migrated databases
Enabling new DB2 Version 9.5 functionality in database applications and routines

If you want to convert your Version 9.1 or Version 8 database to a Version 9.5 Unicode database, migration is not required because you need to re-create your database in Version 9.5 as a Unicode database.
Converting non-Unicode databases to Unicode


Articles and white papers

XML in a non-Unicode database
This article explains how to use the XML native data type in a non-Unicode database in DB2 Version 9.5.


Understanding global variables in DB2 Version 9.5
Discover how to maximize the flexibility of a relational database system using DB2 Version 9.5 global variables.


Exchange data using arrays in SQL PL
This article gives you an overview of arrays in SQL PL and includes examples of the different operations on arrays, the different ways of creating array values, and the use of arrays on the client side. It also includes brief comparison of arrays in DB2 Version 9.5 with the VARRAY data type supported in Oracle.


Best Practices: Deploying IBM DB2 Products
Learn best practices for deploying the DB2 Version 9.5 family of products on Linux, UNIX, and Windows platforms across multiple computers quickly, easily, and consistently.

If you are upgrading from DB2 UDB Version 8, review Articles and white papers in the DB2 Version 9.1 Migration Roadmap that can help you manage the changes between DB2 Version 9.1 and DB2 UDB Version 8 that also apply to your applications when you upgrade to DB2 Version 9.5.


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 in the DB2 Migration documentation:
Migrating DB2 servers
Migrating 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.


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

Webcasts

What is new with Viper 2 for Developers
This webcast focuses on the variety of means that DB2 Viper 2 provided to help you move your applications from the development stage to the deployment more rapidly. Also, learn about the latest tools for developing DB2 applications.


Chat with the Lab: Viper 2 Features
This chat focuses on the new features of DB2 Viper 2. It covers the upcoming release and the Viper 2 Open Beta program. This is a great opportunity to learn more about the future of DB2 and how you can shape it.


Chat with IBM's Lab: DB2 9.5 - Upgrade Benefits and Best Practices
In this educational eSeminar, experts from the IBM DB2 labs share their expertise and discuss case studies and real-world experiences with DB2 9.5, why others have upgraded, improvements in the upgrade process, best practices, and what to avoid when planning an upgrade.


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

Upgrading to DB2 9.5
This presentation provides an overview about upgrading to DB2 Version 9.5 and explains when migration is required. It also includes a summary of changes in DB2 Version 9.5, migration considerations, migration best practices, and enabling new features.
Upgrading to DB2 9.5_02052009.pdf


Overview of DB2 Viper 2
DB2 Viper 2 Open Beta.pdf


New features in DB2 Viper 2 to help your business grow
This article shows how you can leverage three important features in DB2 Viper 2 to overcome these challenges: the new redesigned redistribute utility, enhancements to row compression, and database roles.

Best practices for DB2 for Linux, UNIX, and Windows
The Best Practice papers present advice on the most optimal ways you can use DB2 to satisfy key business data processing needs. Each Best Practice paper is designed to provide practical guidance for the most common DB2 product configurations. These papers are authored by leading experts in IBM's development and consulting teams, and have been extensively tested.

Search developerWorks for all of the articles on DB2 Version 9.5.

Search through DB2 database product documentation by visiting the IBM DB2 Information Center. Refer to the Migrating topic under Database fundamentals to learn how to migrate 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 DB2 Version 9.5.


Back to top




Troubleshooting

You can find error information about migration in the following files:

migration.log when you run the db2ckmig command 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:

Migration to DB2 Version 9.5 FAQs
This document answers some of the more Frequently Asked Questions for migration to DB2 Version 9.5 from DB2 Version 9.1 or DB2 UDB Version 8


Known issues on Windows operating systems when migrating to DB2 Version 9.1
This document describes known issues related to migration to DB2 Version 9.1 on Windows and their resolutions that still apply when you migrate from DB2 UDB Version 8 to DB2 Version 9.5.


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.


Migrating to DB2 Version 9.5 Technotes
Search existing technotes to find out about known issues and how to resolve them.


IBM DB2 for Linux, Unix, and Windows forum
This forum is a place to exchange ideas and share solutions with your peers in the IBM DB2 9 community. You can also review any topics about migration or report any problems with this release.


DB2 Version 9.5 APARs related to migration
This document contains a list of APARs which address migration issues in DB2 Version 9.5.


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


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 migration are available at:

DB2 Version 9.5 trial download
You can now download a trial version of DB2 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 Version 9.5 manuals in PDF format download
You can download the DB2 Migration guide and all the DB2 Version 9.5 manuals in PDF format.


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, there are 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

Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

DB2 for Linux, UNIX and Windows
Installation - Instance Migration

Software version:

8, 9.1, 9.5

Operating system(s):

AIX, HP-UX, Linux, Solaris, Windows

Reference #:

1254493

Modified date:

2013-04-03

Translate my page

Machine Translation

Content navigation