Upgrading a Db2 server with multiple Db2 copies

Upgrading a Db2 server with multiple pre- version 11.5 copies, requires that you install Db2 version 11.5 as a new copy and then manually upgrade the instances and databases after installation.

You can have a Db2 server with multiple copies of Db2 database products version 11.1 and version 10.5 installed.

You can manually upgrade a pre-Db2 version 11.5 instance at any fix pack level by executing the db2iupgrade command from the target Db2 version 11.5 copy of your choice.

After an instance is upgraded to a Db2 version 11.5 copy, you cannot upgrade it to another version 11.5copy. However, you can update an instance between different version 11.5 copies using the db2iupdt command.

Before you begin

Ensure that you have root access on Linux® and UNIX operating systems or Local Administrator on Windows.
Ensure that you meet the installation requirements for Db2 database products.. The requirements for operating systems have changed.
Review upgrade recommendations and disk space requirements.
Perform pre-upgrade tasks.

Restrictions

This procedure does not apply to upgrade from Db2 32-bit servers to 64-bit systems on Windows. Refer to Upgrading Db2 32-bit servers to 64-bit systems (Windows) for details.
On Linux and UNIX operating systems, you must not setup the instance environment for the root user. Running the db2iupgrade or the db2icrt command for a root user is not supported.
Review the upgrade restrictions for Db2 servers.

Procedure

To upgrade a Db2 server with multiple Db2 copies:

Log on to the Db2 server as root or a user with Local Administrator authority.
Install Db2 version 11.5 at a new install path by running the Db2 Setup wizard and select the Install New option on the Install a Product panel. Refer to the following tasks for details:
- Installing Db2 servers (Windows)
- Installing Db2 servers (Linux and UNIX)
You can install multiple Db2 version 11.5 copies, if you want to upgrade your existing instances to different Db2 version 11.5 copies.

Upgrade instances using the db2iupgrade command from the installation path of the Db2 version 11.5 copy of your choice.

For example, assume that you have the following Db2 copies and instances on an AIX® server and a Windows server:

Table 1. Directory examples for Db2 copies.
Instance name	OS	Db2 copy directory
db2inst1	AIX	/opt/IBM/db2/V10.5
db2inst2	AIX	/opt/IBM/db2/V11.1
db2inst3	AIX	/home/db2/myV11.1
No instances created	AIX	/opt/IBM/db2/V11.5 /home/db2/myV11.5
DB2_105	Windows	C:\Program Files\IBM\SQLLIB_10.5\
No instances created	Windows	C:\Program Files\IBM\SQLLIB_11.5\

You can then run the following commands to successfully upgrade your instances to Db2 version 11.5:

Table 2. Instance upgrade command examples.
Upgrade Instance	Commands
db2inst1	`cd /opt/IBM/db2/V11.5/instance` `./db2iupgrade -u db2fenc1 db2inst1`
db2inst2	`cd /opt/IBM/db2/V11.5/instance` `./db2iupgrade db2inst2`
db2inst3	`cd /home/db2/myV11.5/instance` `./db2iupgrade db2inst3`
DB2_105	`cd C:\Program Files\IBM\SQLLIB_11.5\` `db2iupgrade DB2_105 /u:db2admin1,password1`

Optional: Upgrade the Db2 Administration Server if you want to keep your existing configuration to administer your Db2 version 11.5 instances.
Log on to the Db2 server as a user with SYSADM authority.
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.