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.
The procedure for uninstalling the package that contains the older functions and then installing the package that contains the newer versions is:
- Find the version numbers and schemas of the installed functions, using the instructions in Finding Function Version Numbers.
- Ensure 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 6.21 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_6.21
-
Run the SQL script that installs the newer package. For example:
install_aster_analytics.sql
or:
install_ASTER_ANALYTICS_from_SCHEMANAME.sql
The alternative to the recommended procedure is to use the ACT commands \remove and \install on each function:
- beehive=> \remove function_filename
- beehive=> \install function_filename
For more information about the \remove and \install commands, refer to Managing Files with ACT Commands.