DB2 Version 9.7 for Linux, UNIX, and Windows

Upgrading DB2 Data Links Manager environments

Upgrading a DB2® server where Data Links Manager is installed or where Data Links functionality is enabled from DB2 UDB Version 8 to DB2 Version 9.7 is not supported. However, you can upgrade to DB2 Version 9.7 if you remove the Data Links Manager functionality.

About this task

Restrictions

Review the upgrade restrictions for DB2 servers.

Before you begin

Ensure that you have root access on Linux and UNIX operating systems or Local Administrator on Windows.
Ensure that you have SYSADM authority.
Ensure that you meet the installation requirements for DB2 database products. The requirements for Linux and UNIX operating systems have changed.
Review upgrade recommendations and disk space requirements.
Perform pre-upgrade tasks.

Procedure

To upgrade a DB2 server in the Data Links environment to DB2 Version 9.7:

Remove Data Links Manager from your databases.
If you installed DB2 Net Search Extender (NSE), you need to drop the following UDFs :
```
   db2 DROP SPECIFIC FUNCTION DB2EXT.DATALINKCONTENT1;
   db2 DROP SPECIFIC FUNCTION DB2EXT.DATALINKCONTENT2;
   db2 DROP SPECIFIC FUNCTION DB2EXT.DATALINKCONTENT4;
   db2 DROP SPECIFIC FUNCTION DB2EXT.DATALINKCONTENT3;
```
These UDFs are always created by NSE for Data Links support, regardless of Data Links Manager installation. Therefore you need to remove these functions even when Data Links Manager is not installed.
If you plan to upgrade by restoring from a database backup, you must drop these UDFs before you back up the database. You cannot restore from a database backup if these UDFs are defined.
Drop all references to the DATALINK data type from tables, distinct types, structured types, user-defined functions (UDFs), methods, and dependent objects.
Uninstall Data Links Manager on the DB2 server that you want to upgrade.
Update your instances to remove the Data Links functionality by running the db2iupdt command:
```
   db2iupdt instance-name
```
Optional: Disable use of DB2 Data Links functionality by setting the datalinks database manager configuration parameter to NO:
```
   db2 UPDATE DBM CFG USING datalinks NO
```
When you upgrade the instance, the datalinks parameter is set to NO.
Install a new DB2 Version 9.7 copy on your DB2 server. If you are installing DB2 Version 9.7 on Windows and you choose to upgrade your existing DB2 UDB Version 8 copy, proceed to step 10.
Upgrade instances from the new DB2 Version 9.7 copy .
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.
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.