Converting instances from one Db2 database product to another (Linux and UNIX)

To convert 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.

Before you begin

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

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.

Procedure

To convert between Db2 database products:

Complete the Db2 database product installation for the new edition.
You do not need to create an instance. Existing instances can be re-configured by issuing db2iupdt or db2nrupdt commands when the installation is complete.
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.
To obtain a list of the names of all instances on your system, run the db2ilist command:
```
DB2DIR/instance/db2ilist
```
Where DB2DIR represents the location where the original Db2 database product is installed. By default, it is /opt/ibm/db2/V11.5 on Linux and /opt/IBM/db2/V11.5 on UNIX operating systems.
Stop any of the instances that are running.
To re-configure the instances, issue the following commands:
- db2iupdt for each root instance
- db2nrupdt for the non-root instance.
For example:
```
DB2DIR/InstanceName/db2iupdt 
```
where DB2DIR represents the location where the new Db2 database product is installed and InstanceName represents the name of the instance.
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.
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.
  You will see product signatures for both the old and new Db2 database products. For example, EXPRESS_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.
  You will no longer see the old product signature in the output from the db2ls command.
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.