Upgrading Db2 Connect servers

Db2 Connect version 11.5 servers support the upgrade of Db2 Connect instances, and any existing transaction manager and Db2 Connect federated databases created on Db2 Connect version 9.7 and version 9.5 servers.

Before you begin

Before upgrading to Db2 Connect version 11.5:
  • Ensure that you have the proper operating system access:
    • Root user authority 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 backing up your databases.

About this task

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, refer to Upgrading a Db2 server (Windows).


Restrictions

  • The bit size of the client instance is determined by the operating system where you install Db2 Connect.
  • Additional upgrade restrictions for Db2 servers also apply to Db2 Connect servers.

Procedure

To upgrade your Db2 Connect server version 11.5:

  1. 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 re-create your connectivity configuration if necessary.
  2. Install Db2 Connect by running the Db2 Setup wizard and selecting the option Install New on the Install a Product panel.
    Refer to Db2 Connect Server products: installation and configuration overview.
  3. Upgrade your Db2 Connect instances using the db2iupgrade command.
  4. 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. Refer to Post-upgrade tasks for Db2 Connect servers.