This topic describes how to upgrade to a new release of
the Optim™ data privacy user-defined
functions (UDFs) for Oracle and DB2® for Linux™, UNIX™, and Windows™.
This topic assumes that you are upgrading your data privacy
UDF installation in the original location, under the same user profile
used for the original installation. If you are installing the new
release in a different location, then follow all the required installation
and configuration steps for your database and operating system.
Before
you upgrade to a new release of the data privacy UDFs,
- Ensure that no UDFs are in use or loaded in memory
- Back up all the current UDF installation folders: bin, icufiles, include, lib, samples, scripts.
Use the following steps to upgrade your data privacy
UDF installation.
- Create a temporary folder for the new release on the production
host machine where the data privacy UDFs are already installed.
- Unzip the new release folders in the temporary folder.
- Overwrite the existing UDF folders with the new ones from
the temporary folder.
- If you created a license folder for the data privacy license
files during the original installation, the upgrade process does not
overwrite the license files. If the original license files were in
one of the base installation folders (such as bin), then the upgrade
process would overwrite them. In this case, you must copy the license
files from the backup or generate them using the license file generation
executable, ODPPLicp.
- Run the UDF registration script (registerudfs) from the
scripts folder, using the user account that owns the existing UDFs.
- If you are upgrading the data privacy UDFs for Oracle,
stop and restart the database and listener.
- Run the UDF verification script (udfverificationsqls) from
the scripts folder.