DB2 Version 9.7 for Linux, UNIX, and Windows

Upgrading DB2 Connect servers

About this task

The latest version or release of DB2 Connect servers supports the upgrade of DB2 Connect instances, and any existing transaction manager and DB2 Connect federated databases created on the two previously supported versions of DB2 Connect servers.

Since DB2 Connect server products are host database connectivity servers, the only databases that can exist within a DB2 Connect server instance are transaction manager databases and DB2 Connect federated databases. The DB2 Connect transaction manager database stores transaction state information for DB2 coordinated transactions. The sole purpose of DB2 Connect federated databases is to contain information about data sources.

On Linux and UNIX operating systems, you should manually upgrade your DB2 Connect instances after installing the latest version of DB2 Connect. All the remote nodes and databases that you cataloged on the DB2 clients refer to these instances. If you create a new instance, again you will have to catalog nodes, DCS databases, and databases on the DB2 clients that existed in the instances from the previous version.

On Windows operating systems, you have an option to automatically upgrade an existing, supported DB2 Connect copy during installation. Your DB2 Connect instances are automatically upgraded. Alternatively, you can install a new copy of the latest version of DB2 Connect and then manually upgrade your DB2 Connect instances.

This procedure describes how to upgrade by installing a new copy of the latest version of DB2 Connect and then upgrade instances and any existing databases. To automatically upgrade an existing, supported DB2 Connect copy on Windows, follow the same steps specified in Upgrading a DB2 server (Windows) .

Restrictions

The bit size of the client instance is determined by the operating system where you install DB2 Connect. Refer to DB2 Version 9.5 32-bit and 64-bit support for details.
Additional upgrade restrictions for DB2 servers also apply to DB2 Connect servers.

Before you begin

Before upgrading to the latest the version of DB2 Connect™:

Ensure that you have the proper operating system access:
- Root access on UNIX
- Local Administrator on Windows
Ensure that you have SYSADM authority.
Ensure that you meet the installation requirements for DB2® database products . The requirements for Linux and UNIX operating systems have changed.
Review the upgrade recommendations .
Review the disk space requirements .
Perform the pre-upgrade tasks, especially backup your databases.

If you have DB2 Connect Version 7, you must migrate to DB2 Connect Version 8 first. Refer to the following topic for details: http://publib.boulder.ibm.com/infocenter/db2luw/v8/topic/com.ibm.db2.udb.doc/conn/t0008566.htm

Procedure

To upgrade your DB2 Connect server:

Export your connectivity configuration information for your existing, supported DB2 Connect server to an export profile. Use the db2cfexp tool to create a configuration profile:
```
   $ db2cfexp cfg_profile backup
```
This profile contains all of the instance configuration information, including the database manager configuration and registry profile because the option backup is specified. You can use this profile to recreate your connectivity configuration if necessary.
Install DB2 Connect by running the DB2 Setup wizard and select the option Install New on the Install a Product panel.
Upgrade your DB2 Connect instances using the db2iupgrade command.
Upgrade any existing transaction manager and DB2 Connect federated databases . You can also upgrade your databases by restoring a DB2 Connect backup from one of the two previous supported versions.

What to do next

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