 |
Upgrading to DB2 Version 9.5 roadmap (formerly known as DB2 Version 9.5 migration roadmap)
|
| | 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
 |
If you are upgrading from DB2 UDB Version 7 or earlier, you need to upgrade to DB2 UDB Version 8 first.
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:
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:
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.
If you are upgrading from DB2 UDB Version 8, discontinue the use of functionality that is not supported since DB2 Version 9.1.
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.
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.
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.
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.
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.
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. |
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:
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
| |
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.
  |
 |
Overview of DB2 Viper 2
 |
 |
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. |
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:
Back to top | | | | | | | | | | |
|
|
| IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml. |
|
|
|
|
| Please take a moment to complete this form to help us better serve you. |
|
 |
|
|
|
|
|
|
| Product categories: |
|
| | Software | |
| | Data Management | |
| | Data Servers (Database Management Systems) | |
| | DB2 for Linux, UNIX and Windows | |
| | Installation - Instance Migration | |
|
| Operating system(s): |
| |
AIX, HP-UX, Linux, Solaris, Windows
|
|
| Software version: |
| |
8, 9.1, 9.5
|
|
| Reference #: |
| |
1254493
|
|
| IBM Group: |
| | Software Group |
|
| Modified date: |
| | 2009-11-02 |
|
|
