Updating Db2 copies (Windows)

You can update an existing Db2 copy and all instances running on that copy to a new fix pack level. You can also choose to install a new Db2 copy and selectively update instances to run on this new copy after installation.

Before you begin

  • Ensure that you have Local Administrator authority.
  • Download and extract a fix pack. The fix pack and the Db2 copy that you want to update must be of the same release.

About this task

Follow these instructions to update your Db2 copies from one fix pack level to another (within the same version level) or to install additional functionality.


Restrictions

  • You can only update an instance of the same release from a earlier release level copy to a later release level copy. You cannot update an instance from a later release level copy to a earlier release level copy.
  • You will not be able to update more than one Db2 copy at the same time. In order to update other Db2 copies that might be installed on the same computer, you must rerun the installation.
  • Coexistence of a 32-bit Db2 data server and a 64-bit Db2 data server on the same Windows x64 computer is not supported. It is not possible to upgrade directly from a 32-bit x64 Db2 installation at Version 8 to a 64-bit installation at Version 9.8.

Procedure

To update your Db2 copies:

  1. Log on as a user with Local Administrator authority.
  2. Stop all Db2 instances, services and applications.
  3. Run setup.exe to launch the Db2 wizard to install a Db2 copy. You have the following choices:
    • To update an existing Db2 copy and update all the instances running on this Db2 copy, select Work with Existing in the Install a Product panel. Then select the Db2 copy that you want to update with the update action. You cannot install additional functionality with this action.
    • To install a new Db2 copy and selectively update the instances running on an existing Db2 copy to the new copy after installation, select Install New in the Install a Product panel. This option allows you to also install additional functionality.
    • To add functionality to an existing Db2 copy, select Work with Existing in the Install a Product panel. Then select the Db2 copy that you want to update with the Add new function action. This action is only available when the Db2 copy is at the same release level as the install image.
  4. If you installed a new Db2 copy, use the db2iupdt command to update any instances that are running in a different Db2 copy of the same release that you want them to run under the new copy. The following table shows several examples of updating instances:
    Instance Db2 copy Example to update to another copy
    db2inst1 C:\Program Files\IBM\SQLLIB_91\BIN 
    cd D:\Program Files\IBM\SQLLIB_91_FP5\BIN 
db2iupdt db2inst1 /u: user-name,password
    db2inst2 C:\Program Files\IBM\SQLLIB_97\BIN 
    cd D:\Program Files\IBM\SQLLIB_97\BIN 
db2iupdt db2inst2 /u: user-name,password

Results

Once you have installed or updated a Db2 copy, you can always update instances that run in other Db2 copies of the same release, to run on this new Db2 copy by issuing the db2iupdt command.