DB2 Version 9.7 for Linux, UNIX, and Windows

Moving between DB2 database products (Linux and UNIX)

To move from one DB2® database product to another (or from one DB2 copy to another) on Linux or UNIX operating systems, install the product, update the licensing information, then reconfigure the instances.

About this task

Be careful when you issue the db2_deinstall command. If you issue the command without specifying appropriate command options, you might remove all DB2 database product components.

These instructions apply only when switching among the same version of a DB2 database product.

Before you begin

Your system must comply with the system prerequisites for the DB2 database product edition that you are installing.

Procedure

To move between DB2 database products:

  1. Complete the DB2 database product installation for the new edition.

    You do not need to create an instance. Existing instances can be reconfigured by issuing db2iupdt or db2nrupdt commands when the installation is complete.

  2. Add the license file for the new database product by issuing the db2licm command.
    db2licm -a LicenseFile
    The license file is found in the db2/license directory on the product activation CD.
  3. To obtain a list of the names of all instances on your system, run the db2ilist command:
    DB2DIR/db2ilist
    Where DB2DIR represents the location where the original DB2 database product is installed. By default, it is /opt/ibm/db2/V9.7 on Linux and /opt/IBM/db2/V9.7 on UNIX operating systems.
  4. Stop any of the instances that are running.
  5. To reconfigure the instances, issue the following commands:
    • db2iupdt for each root instance
    • db2nrupdt for the non-root instance.
    For example:
    DB2DIR/bin/db2iupdt InstanceName
    where DB2DIR represents the location where the new DB2 database product is installed and InstanceName represents the name of the instance.
  6. Remove the original DB2 database product license by running the db2licm command.
    1. Run the command db2licm -l to find the original DB2 database product product-identifier value.
    2. Issue the following command to remove the license:
      db2licm -r product-identifier
    3. Issue the command db2licm -l and check the expiry date value. If the original DB2 database product does not have an expiry date of Expired, repeat the db2licm -r command until you have successfully removed all of the original licenses for the DB2 database products.
  7. Remove the product signature of the original DB2 database product:
    1. Find the product signature by issuing the db2ls command:
      db2ls -q -a -b DB2DIR
      Where DB2DIR represents the location where the new DB2 database product is installed.

      The command output contains product signatures for both the old and new DB2 database products. For example, EXPRESS_PRODUCT_SIGNATURE or WSE_PRODUCT_SIGNATURE.

    2. Remove the old product signature by issuing the db2_deinstall command:
      DB2DIR/install/db2_deinstall -F product_signature
      Where DB2DIR represents the location where the new DB2 database product is installed. The old product signature is not contained in the output from the db2ls command.
  8. Optional: Uninstall the original DB2 database product.

Results

When these steps are completed, your instances are configured to run in the new DB2 database product installation.