DB2 Version 9.7 for Linux, UNIX, and Windows

Upgrading a DB2 server (Linux and UNIX)

Upgrading a DB2® server to DB2 Version 9.7 on Linux and UNIX requires that you install a new DB2 Version 9.7 copy and then manually upgrade your existing instances and databases to this new copy.

About this task

This upgrade task describes the steps for direct upgrade to DB2 Version 9.7 from DB2 Version 9.5, DB2 Version 9.1, or DB2 UDB Version 8 regardless of the instance bit size. Review upgrading environments with specific characteristics and determine which task applies better to your environment.

Restrictions

On Linux and UNIX operating systems except for Linux on x86, your existing 32-bit or 64-bit instances are upgraded to DB2 Version 9.7 64-bit instances. The operating system and DB2 Version 9.7 database product that you installed determines the instance bit size, see Support changes for 32-bit and 64-bit DB2 servers for details.
Additional upgrade restrictions apply. Review the complete list.

Before you begin

Before upgrading the DB2 server:

Ensure that you have root access.
Ensure that you meet the installation requirements for DB2 database products.
Review upgrade recommendations and disk space requirements.
Perform pre-upgrade tasks.

If a IBM® PowerHA® SystemMirror for AIX® cluster is running, you can not perform a IBM Tivoli® System Automation for Multiplatforms (SA MP) installation, upgrade or update because SA MP bundles Reliable Scalable Cluster Technology (RSCT) filesets that are dependent on PowerHA SystemMirror. To skip the SA MP installation use the db2setup command or the installFixPack command. For information on installing or upgrading SA MP using a PowerHA SystemMirror cluster, see the white paper entitled "Upgrade guide for DB2 Servers in HACMP™ Environments", which is available from the IBM Support and downloads web site (http://www.ibm.com/support/docview.wss?uid=swg21045033).

Procedure

To upgrade a DB2 server to DB2 Version 9.7:

Log on to the DB2 server as root.
Install DB2 Version 9.7. Run the db2setup command and select the Install New option on the Install a Product panel to install a new copy of DB2 Version 9.7.
Install all DB2 add-on products that were installed in the DB2 copy from which you are upgrading.
Upgrade instances from the same installation path that you indicated during DB2 Version 9.7 installation. Any 32-bit instances are upgraded to DB2 Version 9.7 64-bit instances except for Linux on x86.
Optional: Upgrade your DAS if you want to keep your existing DAS configuration and use new functionality available in DB2 Version 9.7. If your DAS is running on DB2 UDB Version 8, upgrade it to use the Control Center to administer your instances running under DB2 Version 9.1 or later.
Upgrade databases.

What to do next

After upgrading the DB2 server, perform the recommended post-upgrade tasks such as resetting the diagnostic error level, adjusting log space size, and rebinding packages. In addition, verify that the upgrade of your DB2 server was successful.