To update Aster Analytics functions that are already installed, you must first uninstall them and then install their newer versions. Teradata recommends uninstalling the package that contains the older functions and then installing the package that contains the newer versions.
During this process, the functions are unavailable to users. If you want to maintain the older versions of the functions, install the new versions on a different schema.
This procedure is the recommended way to uninstall the package that contains the older functions and then install the package that contains the newer versions. Alternatively, you can use the ACT commands \remove and \install on each function. For information about ACT commands, see ACT Commands for Managing Files.
on each function.- Find the version numbers and schemas of the installed functions, using the instructions in Finding Function Version Numbers.
- Verify that you have the necessary privileges for uninstalling the Aster Analytics functions in their schema.
-
In the list of version numbers, find the release number of the functions in the package.
For example, in Finding Function Version Numbers, the installed Aster Analytics functions have release number 6.20.
-
Go to the directory where the functions from the older package are. For example:
cd /opt/teradata/AsterAnalytics_Foundation/AA_6.20
Uninstall scripts for older packages are also available in the Aster Analytics 7.00 packages.
-
Run the SQL script that uninstalls the older package. For example:
un_install_aster_analytics.sql
or:
un_install_ASTER_ANALYTICS_from_SCHEMANAME.sql - Go to the directory where the functions from the newer package are. For example: cd /opt/teradata/AsterAnalytics_Foundation/AA_7.00
-
Run the SQL script that installs the newer package. For example:
install_aster_analytics.sql
or:
install_ASTER_ANALYTICS_from_SCHEMANAME.sql