DB2 Version 9.7 for Linux, UNIX, and Windows

DB2 servers upgrade

Upgrading to DB2® Version 9.7 requires that you upgrade your existing DB2 servers.

Upgrading your DB2 server requires that you install a DB2 Version 9.7 copy and then upgrade all the instances and databases to be able to run them under the DB2 Version 9.7 copy.

You can directly upgrade existing DB2 Version 9.5, DB2 Version 9.1, or DB2 UDB Version 8 instances and databases to DB2 Version 9.7. Learn details, limitations about the upgrade process, and possible issues that you must be aware of in the upgrade essentials section. Refer to the upgrading DB2 server tasks for details on how to upgrade to DB2 Version 9.7. In the upgrading DB2 server topics, the term pre-Version 9.7 DB2 copy refers to a DB2 Version 9.5, DB2 Version 9.1, or DB2 UDB Version 8 copy.

On Windows operating systems, you have an option to automatically upgrade an existing pre-Version 9.7 DB2 copy. If you choose to upgrade your existing DB2 copy during installation, you only need to upgrade your databases after installation.

If your DB2 servers are running on a release prior to DB2 UDB Version 8, migrate them first to DB2 UDB Version 8, and then upgrade to DB2 Version 9.7. It is recommended that you migrate to the latest fix pack of DB2 UDB Version 8.2. Refer to the DB2 UDB Version 8 migration roadmap for details on how to migrate to DB2 UDB Version 8.2.

Upgrade to DB2 Version 9.7 is supported for the following DB2 products:
Table 1. DB2 database products supported for upgrade
DB2 Version DB2 product name
Version 9.5
  • DB2 Enterprise Server Edition
  • DB2 Workgroup Server Edition
  • DB2 Personal Edition
  • DB2 Express® Edition
  • DB2 Express-C
  • DB2 Connect™ Enterprise Edition
  • DB2 Connect Personal Edition
  • DB2 Connect Unlimited Edition
  • DB2 Connect Application Server Edition
  • DB2 Query Patroller
  • IBM® Data Server Client
  • IBM Data Server Runtime Client
Version 9.1
  • DB2 Enterprise Server Edition
  • DB2 Workgroup Server Edition
  • DB2 Personal Edition
  • DB2 Express Edition
  • DB2 Connect Enterprise Edition
  • DB2 Connect Personal Edition
  • DB2 Connect Unlimited Edition
  • DB2 Connect Application Server Edition
  • DB2 Client
  • DB2 Runtime Client
  • DB2 Query Patroller
Version 8
  • DB2 UDB Enterprise Server Edition
  • DB2 UDB Workgroup Server Unlimited Edition
  • DB2 UDB Workgroup Server Edition
  • DB2 UDB Personal Edition
  • DB2 Express Edition
  • DB2 Universal Developer's Edition
  • DB2 Personal Developer's Edition
  • DB2 UDB Express Edition
  • DB2 Connect Unlimited Edition
  • DB2 Connect Enterprise Edition
  • DB2 Connect Application Server Edition
  • DB2 Connect Personal Edition
  • DB2 Query Patroller
  • DB2 Administration Client
  • DB2 Application Development Client
  • DB2 Runtime Client
For DB2 products not supported, refer to functionality deprecated or discontinued in DB2 database products that impacts upgrade.