Upgrading a DB2® server with multiple pre-Version 9.7 DB2 copies, requires that you install DB2 Version 9.7 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 9.5 and 9.1 installed. On Linux and UNIX,
you could also have multiples copies of DB2 Enterprise Server Edition (ESE)
Version 8 on the same DB2 server
if have installed several alternate fix packs as a completely new
copy of DB2 ESE Version 8.
You can manually upgrade a pre-Version 9.7 instance
at any fix pack level by executing the db2iupgrade command
from the target DB2 Version
9.7 copy of your choice. After an instance is upgraded to a DB2 Version 9.7 copy, you cannot
upgrade it to another DB2 Version
9.7 copy. However, you can update an instance between different DB2 Version 9.7 copies using the db2iupdt command.
About this task
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
9.7 as a new copy of DB2 Version
9.7 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
9.7 copies, if you want to upgrade your existing instances to different DB2 Version 9.7 copies.
- Upgrade instances using
the db2iupgrade command from the installation
path of the DB2 Version 9.7
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 |
/usr/opt/db2_08_FP7/ |
db2inst2 |
AIX |
/opt/IBM/db2/V9.1 |
db2inst3 |
AIX |
/home/db2/myV9.5 |
No instances created |
AIX |
/opt/IBM/db2/V9.7
/home/db2/myV9.7
|
DB2 |
Windows |
C:\Program Files\IBM\SQLLIB\ (Version
8.2) |
DB2_91 |
Windows |
C:\Program Files\IBM\SQLLIB_91\ |
DB2_95 |
Windows |
D:\Program Files\IBM\V_95\ |
No instances created |
Windows |
C:\Program Files\IBM\SQLLIB_97\ |
You can then run the following commands to successfully
upgrade your instances to DB2 Version
9.7:
Table 2. Instance upgrade command examples.Upgrade Instance |
Commands |
db2inst1 |
cd /opt/IBM/db2/V9.7/instance
./db2iupgrade -u db2fenc1 db2inst1
|
db2inst2 |
cd /opt/IBM/db2/V9.7/instance
./db2iupgrade db2inst2
|
db2inst3 |
cd /home/db2/myV9.7/instance
./db2iupgrade db2inst3
|
DB2 |
cd C:\Program Files\IBM\SQLLIB_97\BIN
db2iupgrade DB2 /u:db2admin1,password1
|
DB2_91 |
cd C:\Program Files\IBM\SQLLIB_97\BIN
db2iupgrade DB2_91 /u:db2admin2,password2
|
DB2_95 |
cd C:\Program Files\IBM\SQLLIB_97\BIN
db2iupgrade DB2_95 /u:db2admin3,password3
|
- Optional: Upgrade the DB2 Administration Server if
you want to keep your existing configuration and to administer your DB2 Version 9.7 instances using
the Control Center.
- 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.