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

Technote (FAQ)

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



Upgrading to DB2® Version 9 might require migration of your environment components. These components are DB2 servers, DB2 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 upgrade from DB2 UDB Version 8 to DB2 Version 9 .


End of support for DB2 Version 9.1 products is April 30, 2012. "End of support" indicates the last date on which you are entitled to base support. For more details about end of support for DB2 Version 9.1, see

DB2 Version 9.1, End of Support April 30, 2012.

Consider upgrading to Version 9.5 or later releases. For additional upgrade roadmaps, see DB2 upgrade portal.

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 at in the IBM Knowledge Center. The highest level topic is Migrating to DB2 Version 9.

Additional resources

Ensure that you meet the Installation requirements for DB2 database products.

Review changes to existing functionality that can impact your environment migration:
Migration essentials for DB2 servers
Migration essentials for DB2 clients
Migration essentials for database applications
Migration essentials for routines
New space requirements for database objects
What's new for V9.1: Changes in existing functionality
Version 9 incompatibilities with previous releases and changed behaviors

If you are upgrading from DB2 UDB Version 8.1 to DB2 Version 9, review also the DB2 UDB Version 8.2 upgrade considerations technote. In addition to the changes in upgrading to DB2 Version 9, 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.

Discontinue the use of functionality that is not supported in DB2 Version 9:
Discontinued or deprecated functionality in DB2 database product that impacts migration
What's new for V9.1: Discontinued functionality
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 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 DB2 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

To fall back to a previous release after migrating your DB2 servers, add details to the 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.

Consider migrating your DB2 servers, DB2 clients, database applications, and routines in a testing 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. Also in a test environment, you can determine the length of time required to migrate your database to DB2 Version 9 and the disk space requirements that are essential in developing a migration plan and performing a successful migration.
Migrating in a test environment
Estimating database migration time and disk space requirements

You should plan how to discontinue the use of deprecated functionality:
Functionality discontinued or deprecated in DB2 database product that impacts migration
What's new for V9.1: Deprecated functionality

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

Articles and white papers

Prepare your applications, routines, and scripts for migration to DB2 Viper
Learn about the IBM® DB2 Version 9 product changes that are most significant to ISVs, how they may affect existing database application code and scripts, and get guidance on how to plan to update your application.

XML application migration from DB2 V8.x to DB2 Viper, Part 1:
Partial updates to XML documents in DB2 Viper, the "update" stored procedure
Learn a method for performing partial updates to XML documents stored natively in DB2 Version 9, using a stored procedure that's included as a download with the article.

XML application migration from DB2 V8.x to DB2 Viper, Part 2:
Look at the XML functionality in DB2 Viper and compare it to that of DB2 V8.x.

This article discusses the new XML features introduced in DB2 Version 9 and describes the impact the new XML support has on migrating existing XML-based applications.

XML application migration from DB2 8.x to DB2 Viper, Part 3: Sample migration scenario
Step through the XML application migration process using an example scenario. You'll create a sample application using DB2 Universal Database Version 8.x XML functionality, then migrate that application using DB2 Version 9 XML capabilities.

Back to top


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 guide:
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


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.


DB2 9 Fundamentals certification 730 prep series (Available in August 2006)
This tutorial series provides an introduction to SQL (Structured Query Language) and covers how DB2 Version 9 is packaged and installed, how to create databases and database objects, and the basics of database security and transaction isolation. These tutorials are designed to help you prepare for the DB2 Version 9 for Linux®, UNIX® and Windows® Fundamentals (Exam 730)

DB2 9 Database administration 731 certification prep series
A series of seven tutorials designed to help you prepare for the DB2 Version 9 for Linux, UNIX and Windows Database Administration (Exam 731) certification exam to attain the certification "IBM Certified Database Administrator - DB2 Version 9 for Linux, UNIX and Windows."


DB2 Chat with the Lab
Listen to the DB2 experts who develop breakthrough technology and get your questions answered.

DB2 9 Webcasts series
Learn about the new capabilities available in DB2 Version 9 on Linux, UNIX, and Windows platforms. For a complete list of the DB2 9 Webcasts series visit the web page: http://www.ibm.com/software/data/db2/v9/learn_webcasts.html.

Stay current with developerWorks® technical events and webcasts.

Articles, white papers, and documentation

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

What's new in DB2 Viper
DB2 Version 9 features new query language, new storage technology, new indexing technology, and other features to support XML data and its inherent hierarchical structure.

Get off to a fast start with DB2 Viper
DB2 Version 9 features new support for storing, managing, and searching XML data. In this article, learn how to create database objects for managing your XML data and how to populate your DB2 database with XML data.

Introducing DB2 9, Part 3: Self-tuning memory in DB2 9
Learn how the new self-tuning memory management feature works to automatically configure database memory settings and adjusts them dynamically during run time to optimize performance. See the results of this feature in a benchmark setting.

Introducing DB2 9, Part 4: Autonomic and other enhancements in DB2 9
This article introduces some of the autonomic capabilities that are new in DB2 Version 9, and describes other noteworthy enhancements. Autonomic features in migrated databases help you derive more business value from your data, while spending less time managing it.

For more information on the new features of DB2 Version 9, read the other articles in the Introducing DB2 9 series. Consider enabling new features in migrated databases to gain the performance and manageability benefits that they provide, especially self-tuning memory management and other autonomic features.

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

Search through DB2 database product documentation by visiting IBM Knowledge 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 Version 9.

Back to top


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 enabled your instances to capture error and diagnostic information during migration

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

Migration to DB2 Version 9 from DB2 UDB Version 8 FAQs
This document answers some of the more Frequently Asked Questions for migration to DB2 Version 9 from 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.

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.

Changes to daylight savings time (DST) in the U.S. and Canada
The changes in DST starting March 2007 will impact DB2 tools such as the Control center and any applications that use JDK classes to get or display time. Read this technote for details on how to address this issue.

Problems with packed descriptors after issuing an ALTER TABLE statement
If you issue the RUNSTATS WITH DISTRIBUTION command on your tables followed by an ALTER TABLE statement with the ALTER COLUMN SET DEFAULT clause, packed descriptors might contain corrupt information.
If you experience problems accessing your tables, please contact DB2 support to confirm that your tables are affected specifically by this issue. Once you confirmed with support, you can fix the packed descriptors by always running the RUNSTATS command on your table after running the ALTER TABLE statement with the ALTER COLUMN SET DEFAULT clause.

Migrating to DB2 Version 9 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.1 APARs related to migration from DB2 UDB Version 8
This document contains a list of APARs which address migration issues in DB2 Version 9.1.

Authorized Program Analysis Reports (APARs)
APARs are bugs in the DB2 software 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 at ibm.com
You can now download DB2 Version 9 and install it to migrate in a test environment.

DB2 Version 9 manuals in PDF format
You can download the DB2 Migration guide and all the DB2 Version 9 manuals in PDF format at http://www.ibm.com/support/docview.wss?uid=swg27023554.

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.

Other DB2 upgrade roadmaps available at DB2 upgrade portal.

Back to top

Cross reference information
Segment Product Component Platform Version Edition
Information Management DB2 for Linux- UNIX and Windows Installation - Database Migration AIX, HP-UX, Linux, Solaris, Windows 9, 8

Document information

More support for:

DB2 for Linux, UNIX and Windows
Installation - Instance Migration

Software version:

8, 9.1

Operating system(s):

AIX, HP-UX, Linux, Solaris, Windows

Software edition:

Enterprise Server, Express, Personal, Personal Developer's, Workgroup Server

Reference #:


Modified date:


Translate my page

Content navigation