Install Analytics Engine
To install Analytics Engine, see the Analytics Engine installation instructions for your platform.
During the installation process, the DBMS Server setup asks whether all databases are to be upgraded; answer No. The installation procedure automatically upgrades the iidbdb. If the upgrade of iidbdb fails, see the chapter “Troubleshooting Upgradedb.” It is better to complete the Analytics Engine setup, and then use the upgradedb command to upgrade the user databases.
After the iidbdb is upgraded, the DBMS Server setup attempts to upgrade imadb and install Remote Command Server objects into imadb. Some versions of upgradedb neglect to create imadb first, and you will get “Database does not exist: imadb” errors. These will be corrected in the next step.
How to Upgrade Using install.sh
Go to the folder where the distribution resides, and then use one of the following ways to upgrade:
• As root user
• As non-root user using the –noroot flag
• As non-root user using the –usesudo flag
All operations performed during the upgrade are recorded in $II_SYSTEM/ingres/files/install.log.
To upgrade using install.sh
As root
Issue the following command:
./install.sh
Accept the license.
Choose as II_SYSTEM the path where the instance is installed. For example: /opt/Actian/AnalyticsEngineVW.
A message indicates that an upgrade scenario was detected:
An instance of:
Actian AnalyticsEngine
already exists under:
/opt/Actian/AnalyticsEngineVW
This instance will be upgraded.
Do you wish to continue? (y/n) [y]
Choose "y" to continue.
Settings will be kept from your old installation.
After a while you see a message that databases are being upgraded:
Upgrading AnalyticsEngine master and system databases...
Continue to choose the defaults.
The installation starts, and the upgrade completes.
As non-root user, using -noroot flag
When installing as non-root using -noroot, you do not inherit any root rights, which means all the folders must be owned by you.
As the instance owner (for example "actian"), issue this command:
./install.sh -noroot
Respond to the installation utility prompts, as described previously.
As non-root user, using the -usesudo flag
When installing as non-root using –usesudo, you will inherit root rights.
As the instance owner (for example "actian"), issue the following command:
./install.sh -usesudo
Respond to the installation utility prompts, as described previously.
How to Upgrade Using RPM
The process for safely upgrading any Analytics Engine release using RPM is as follows.
1. Make sure the instance you want to upgrade is completely shut down and that you have taken a backup.
Note: Files that you have customized may be lost during the upgrade. Copy your customized files to a safe place.
2. Run rpm -Uvh to install the new RPM packages over the existing instance.
For default instance location:
cd actian-analyticsengine-8.0.0-xxx-com-linux-rpm-x86_64
cd rpm
rpm -Uvh --nopreun --nopostun --prefix=/opt/Actian/VectorVW actian-analyticsengine-8.0.0-xxx.x86_64.rpm actian-analyticsengine-dbms-8.0.0-xxx.x86_64.rpm actian-analyticsengine-net-8.0.0-xxx.x86_64.rpm
For any other instance location:
cd actian-analyticsengine-8.0.0-xxx-com-linux-rpm-x86_64
cd rpm
rpm -Uvh --nopreun --nopostun --prefix=<Existing-installation-location> actian-analyticsengine-8.0.0-xxx.x86_64.rpm actian-analyticsengine-dbms-8.0.0-xxx.x86_64.rpm actian-analyticsengine-net-8.0.0-xxx.x86_64.rpm
Note: If you are upgrading an instance that was installed using RPMs that were renamed to embed an instance ID, then use "actian-AnalyticsEngine-XX" or "actian-analyticsengine-pkgname-XX" instead.
Note: All packages must be upgraded at once. Any attempt to perform an upgrade on a single or smaller group of packages will fail.
3. Run the systemd service to configure and start the instance:
% systemctl start actian-analyticsengineXX
where XX is the instance ID.