Upgrading a DB2® server on Windows to DB2 Version 9.7 requires that you
install a new DB2 Version 9.7
copy and then upgrade your existing instances and databases to this
new copy.
If you choose to automatically
upgrade your existing pre-Version 9.7 copy during the DB2 Version 9.7 installation, your instances
and DB2 administration server
(DAS) are upgraded but you still need to upgrade your databases after
installation. If you choose to install a new DB2 Version 9.7 copy, you must manually upgrade
your instances, your DAS, and databases.
This
upgrade task describes the steps for direct upgrade to DB2 Version 9.7 from DB2 Version 9.5, DB2 Version
9.1, or DB2 UDB Version 8. Review upgrading environments with specific characteristics and
determine which task applies better to your environment.
About this task
Restrictions
This procedure applies only to upgrade from DB2 32-bit servers when you install the DB2 Version 9.7 32-bit database
product or from DB2 64-bit servers
when you install the DB2 Version
9.7 64-bit database product. The instance bit size is determined by
the operating system and the DB2 Version
9.7 database product that you install, see Support changes for 32-bit and 64-bit DB2 servers for
details.
- If you are performing a
response file installation to automatically upgrade a DB2 UDB Version 8 copy with multiple DB2 products installed, your copy
must be at DB2 UDB Version 8
FixPak 7 or later.
Additional upgrade restrictions apply.
Review the complete list.
Procedure
To upgrade a DB2 server
to DB2 Version 9.7:
- Log on to the DB2 server
as a user with Local Administrator authority.
- Install DB2 Version
9.7 by running the setup command to launch
the DB2 Setup wizard. You have
three choices:
- To automatically upgrade a DB2 copy,
all the instances running on the selected DB2 copy, and your DAS, select the Work
with Existing option on the Install a Product panel.
Then, in the Work with Existing window, choose
the DB2 copy name with the upgrade action.
The selected DB2 copy and add-on
products are uninstalled.
You will get a warning that recommends
that you run the db2ckupgrade command if you have
local databases. If you completed the pre-upgrade tasks, ignore this
warning and continue the upgrade. Otherwise, verify
that your databases are ready for DB2 upgrade before
continuing with the installation.
To create a new copy of DB2 Version
9.7, select the Install New option on the Install
a Product panel.
To create a response file and perform a response
file installation, select the Work with Existing option
on the Install a Product panel. Then in the Work
with Existing window, choose the DB2 copy name with the upgrade action.
Finally, in the Select the installation, response file
creation, or both window, select the Save my
installation setting in a response file option to create
a response file for a response file installation. The response file
has the required UPGRADE_PRIOR_VERSIONS keyword, the DB2 copy name to upgrade, and the installation
path.
The result of the response file installation will be
the same as in the first choice, all your instances running on the
selected DB2 copy and your DAS
are automatically upgraded to the DB2 Version
9.7 copy.
- Install all DB2 add-on
products that were installed in the DB2 copy
from which you are upgrading.
- If you installed a new copy of DB2 Version 9.7, upgrade
your instances to this new copy.
- If you want your applications to access the DB2 Version 9.7 copy through the default interface
or if you upgraded your existing DB2 UDB
Version 8 copy, set the DB2 Version
9.7 copy as the DB2 default
copy.
You must define a default copy if you upgraded from DB2 UDB Version 8 because there is no default
copy defined in your DB2 server.
- Optional: If you installed a new copy, upgrade the DAS if you want to keep your existing DAS
configuration and use new functionality available in DB2 Version 9.7. If your DAS is running on DB2 UDB Version 8, upgrade it to
use the Control Center to administer your instances running under DB2 Version 9.1 or later.
- Upgrade your databases.
What to do next
After upgrading the DB2 server,
perform the recommended
post-upgrade tasks such
as resetting the diagnostic error level to its pre-upgrade value,
adjusting log space size, and rebinding packages. In addition,
verify that the upgrade of your DB2 server was successful.