Upgrading a DB2® server with multiple pre-DB2 Version 10.5 DB2 copies, requires
that you install DB2 Version 10.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 10.1 and Version
9.7 installed.
You can manually upgrade a pre-DB2 Version 10.5 instance at any fix pack level by executing the db2iupgrade command
from the target DB2 Version 10.5 copy of your choice. After an instance is upgraded
to a DB2 Version 10.5 copy, you cannot upgrade it to another DB2 Version 10.5 copy. However, you can update an instance between different DB2 Version 10.5 copies using the db2iupdt command.
Before you begin
Restrictions
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 10.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:
You can install multiple DB2 Version 10.5 copies, if you want to upgrade your existing instances
to different DB2 Version 10.5 copies.
- Upgrade instances using the db2iupgrade command
from the installation path of the DB2 Version 10.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/V9.7 |
db2inst2 |
AIX |
/opt/IBM/db2/V10.1 |
db2inst3 |
AIX |
/home/db2/myV10.1 |
No instances created |
AIX |
/opt/IBM/db2/V10.5
/home/db2/myV10.5
|
DB2_97 |
Windows |
C:\Program Files\IBM\SQLLIB_97\ |
No instances created |
Windows |
C:\Program Files\IBM\SQLLIB_10.5\ |
You can then run the following commands to successfully
upgrade your instances to
DB2 Version 10.5:
Table 2. Instance upgrade command examples.Upgrade Instance |
Commands |
db2inst1 |
cd /opt/IBM/db2/V10.5/instance
./db2iupgrade -u db2fenc1 db2inst1
|
db2inst2 |
cd /opt/IBM/db2/V10.5/instance
./db2iupgrade db2inst2
|
db2inst3 |
cd /home/db2/myV10.5/instance
./db2iupgrade db2inst3
|
DB2_97 |
cd C:\Program Files\IBM\SQLLIB_10.5\
db2iupgrade DB2_97 /u:db2admin1,password1
|
- Optional: Upgrade the DB2 Administration Server if you want
to keep your existing configuration to administer your DB2 Version 10.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.