Installing Vector for Linux
Vector for Linux is distributed in RPM, DEB, and non-package manager (ingbuild) format.
Install libaio
The Linux Asynchronous I/O library, libaio, must be installed before installing Vector.
Libaio has a huge performance benefit over the standard POSIX asynchronous I/O facility because the operations are performed in the Linux kernel instead of as a separate user process.
Note: The Vector installer may install libaio automatically or flag it as missing, depending on the Vector distribution you downloaded.
To install libaio
Using RPM:
rpm ‑ivh libaio*.rpm
Using the yum system update tool:
yum install libaio
Using Ubuntu:
apt-get update
apt-get install libaio1
Import GPG Public Key (RPM and DEB Only)
The RPM and DEB packages are signed with a GPG key pair to ensure their authenticity. To enable the installation process to verify the packages, the public key must be downloaded and imported into the package management system.
The GPG public key file can be downloaded from the same location as the distribution:
http://esd.actian.com/.
To import the key
Specify the key file name on the appropriate command. For example:
Using RPM:
rpm --import actian-vector-5.1.0-103-com-linux-rpm-x86_64-key.asc
Using Ubuntu:
apt-key add actian-vector-5.1.0-103-com-linux-deb-amd64-key.asc
install.sh Command--Install Vector
The install.sh command can be used for both interactive and unattended installs.
Note: Not all command flags are valid for all distribution formats.
Debian/Ubuntu: The DEB distribution installs Vector under /opt/Actian/Vector; this location cannot be changed. Only one DEB instance per machine is allowed. If you want to install Vector in a different directory or install more than one instance on a machine, download the ingbuild distribution.
This command has the following format:
install.sh [-interactive|-express] [‑acceptlicense]
[-uid uid] [-user username] [-noroot] [-usesudo]
[-withad|-noad] [-respfile filename] [-?|‑help] [instance_ID] [install_dir]
-interactive
Installs interactively, prompting for all configuration options. (For advanced users only.)
Note: For RPM and DEB installs, prompting is limited. For full control, use a response file or the GUI installer.
-express
Installs with no user prompts (implies -acceptlicense.)
-acceptlicense
Accepts all license prompts.
-uid uid
Specifies the user ID (UID) to be used when creating user. The username must exist. (Disallowed with -noroot.) (Not valid for RPM and DEB.)
-user username
Installs as username instead of actian. The username must exist. (Disallowed with -noroot.) (Not valid for RPM and DEB.)
-noroot
Installs Vector as the current user. All installation locations must exist and be writable as current user for the installation to succeed. Instance will be owned by current user. (Not valid for RPM and DEB.)
-usesudo
Installs Vector using the current user and invokes sudo for root access, locally and remotely. The instance is owned as “actian” by default. If required, the current user is used for remote connections and sudo is invoked for root access. (Not valid for RPM and DEB.)
-withad | ‑noad
Installs or excludes Actian Director.
-respfile filename
Uses filename as the response file when running setup. The absolute path to the filename must be specified. A response file lets you customize the installation. (Requires -express or ‑acceptlicense; not valid with ‑interactive.)
instance_ID
Defines a two-character string where the first character must be an uppercase letter and the second character must be an uppercase letter or a number from 0 to 9.
install_dir
Specifies the full path to the location where Vector is to be installed (II_SYSTEM).
Note: Not valid for DEBs, in which case II_SYSTEM is hard coded to: /opt/Actian/VectorVW.
-? | ‑help
Displays usage information.
Notes:
• install.sh will fail if another instance of Vector exists with the same instance ID as the one being installed.
• If logged in as a user other than "actian", after install.sh completes, do the following:
1. Log off from the current user.
2. Log on as the "actian" system user and source .ingXXsh (where XX is the instance ID), which is found in the home directory ($HOME) of the "actian" system user.
Install Vector for Linux Using the Graphical Installation Wizard
The installation wizard is recommended if you have a Linux or OS X desktop environment.
The wizard is available for DEB and RPM distributions only.
The installation wizard uses the package manager on your Linux to install Vector. The wizard easily installs the software without your having to know package manager commands.
Debian/Ubuntu: The DEB distribution installs Vector under /opt/Actian/Vector; this location cannot be changed. Only one DEB instance per machine is allowed. If you want to install Vector in a different directory or install more than one instance on a machine, download the ingbuild distribution.
To install Vector using the Installation Wizard
1. Run the following script located in the root directory of the distribution:
./install.sh
The first page of the wizard is displayed.
2. Click Next.
The license dialog is displayed.
3. Select "I accept the terms of this license agreement," and then click Next.
The Installation Mode page is displayed.
4. Select Install.
The installation program installs Vector.
Note: If the maximum size for shared memory segments for Linux (kernel.shmmax) is set too low, Vector will automatically adjust the setting.
The Installation Complete page is displayed.
5. Click Finish.
You are exited from the installation program.
Install Vector at the Command Line
You can install Vector using the installation shell script install.sh for package manager or non-package manager (ingbuild) distributions.
To install Vector at the command line
1. Copy the distribution TGZ file to a location where other users and not just root can read it, for example, /tmp.
Running the installer from a location such as /root will not work because other users do not have read access to this directory.
2. Unpack the distribution TGZ file. For example:
tar xf actian-vector-5.1.0-103-com-linux-ingbuild-x86_64.tgz
Note: You may need to use the z option, depending on the version of tar.
actian-vector-5.1.0-103-com-linux-ingbuild-x86_64
3. Change to the directory created in the previous step. For example:
cd ./actian-vector-5.1.0-103-com-linux-ingbuild-x86_64
4. Enter the following command as the root user to run the installation utility:
./install.sh
Note: For RPM or DEBs distribution, use either the ‑express or ‑interactive flag to prevent launching the graphical wizard. For example: ./install.sh -interactive
If you are logged in as a user other than root, use sudo to run the utility:
sudo ./install.sh
The installation utility starts.
5. Respond to the installation prompts.
All components are installed as user "actian" in the location: /opt/Actian/VectorVW/.
When the installation is complete, the instance is running.
Examples of install.sh Command
The .install.sh command will install package manager or non-package manager (ingbuild) distributions.
Examples for package manager distributions:
1. Install Vector using the graphical wizard:
./install.sh
2. Install all packages with an instance ID of V1, prompting for other configuration options:
./install.sh ‑interactive V1
3. Install all packages with the default configuration into "/opt/VectorV2", with an instance ID of V2, without further prompting:
install.sh ‑express /opt/VectorV2 V2
Note: Not valid for DEBs, whose II_SYSTEM cannot be changed.
Examples for Ingbuild distribution:
1. Install Vector with default configuration, prompting for basic configuration options:
./install.sh
2. Install Vector under /opt/VectorV2, with an instance ID of V2 with a default configuration without further prompting:
install.sh -express /opt/VectorV2 V2
3. Install Vector, prompting for all configuration options:
./install.sh -interactive
Install Vector as a User Other than root
Vector can be installed without requiring full root access by using one of the following flags on the install.sh command.
Note: These flags are supported with the ingbuild distribution only.
-noroot
Installs Vector as the current user and does not require root access. All installation locations must exist and be writable as current user.
For example:
./install.sh -noroot
-usesudo
Installs Vector using the current user and invokes sudo for root access.
For example:
./install.sh -usesudo
Install Vector Using RPM Commands
You can install Vector by invoking RPM directly.
Vector packages that can be installed include the following:
• Core--Prerequisite of all other packages
• DBMS--DBMS Server
• Net--Communications servers
• Director--Actian Director
To install a single package
Invoke RPM with the appropriate installation flags, including the path of the package you want to install, as follows:
rpm ‑Uvh path_to_directory/Vector_package.rpm
To install more than one package at a time
Pass multiple file names, specifying the path to each package, as follows:
rpm ‑Uvh path_to_directory/Vector_package.rpm path_to_directory/Vector_package2.rpm path_to_directory/Vector_package3.rpm
To install all packages in the same directory
Specify the following:
rpm ‑Uvh path_to_directory/*.rpm
To install a package into a non-default location (that is, with an II_SYSTEM value other than the default)
Use the -‑prefix flag when invoking RPM. The following command installs the specified package with II_SYSTEM=/home/actian/VectorVZ:
rpm ‑Uvh ‑‑prefix=/home/actian/VectorVZ path_to_directory/Vector_package.rpm
Notes:
• The default instance ID is VW regardless of the installation directory. To change the instance ID, you must rebuild the RPM packages with a unique name, as described in
Installing Multiple RPM Package Instances.
• All packages installed in a single instance must have the same value of II_SYSTEM. So if you use the -‑prefix flag to install the base package, you must install all subsequent packages with the same --prefix value.
• After you have installed Vector using the RPM command, you must run the service script to configure the instance.
Installing Multiple RPM Package Instances
To install multiple Vector instances on one machine using RPM, you need a unique set of package names for each instance. You must rebuild each RPM packages to include an instance ID that is unique to the machine. You can then install this package using the instructions described in
Install Vector Using RPM Commands.
To rebuild the package, use the iirpmrename command. Multiple RPMs can be specified for renaming.
For example, to rebuild the base package named actian-vector-5.1.0-000.rpm to use an II_INSTALLATION of XX, issue the following command:
iirpmrename [path_to_directory]/actian-vector-5.1.0-000.rpm XX
A new RPM package is created in the current working directory called actian-vector-XX-5.1.0-000.rpm. The package will install with II_SYSTEM=/opt/Actian/VectorXX and II_INSTALLATION=XX.
Notes:
• While you can still override the value for II_INSTALLATION using the response file or other methods mentioned above, we do not recommend it.
• The rpm-build package must be installed for iirpmrename to work.
Configure and Start the Instance
When installing Vector using the RPM command, you must complete the setup portion of the installation process by running the service script. The service script configures and starts the instance.
To configure the instance
After the installation has completed, run the service script as follows:
/etc/init.d/actian-vectorXX configure
where XX is the instance ID.
To set up Vector by running the configuration defined in a response file:
/etc/init.d/actian-vectorXX configure /path/to/response/file
The instance is configured but not started.
To run the setup programs with their default configuration and start the instance
After the installation has completed, run the service script as follows:
/etc/init.d/actian-vectorXX start
where XX is the instance ID.
The instance is configured and started.
How to Access the Instance on Linux
To access your instance, you must source the environment file that was written to the home directory ($HOME) of the operating system user ID defined during installation (the default is "actian").
The name of the environment file depends on the value of II_INSTALLATION:
.ingXXsh or .ingXXcsh
where XX is the instance ID.
To source the environment file created during installation
Issue the following command. (The following example assumes an operating system user ID of actian.)
source ~actian/.ingXXsh
For other users to access the instance and the Vector tools, they must have access to the .ingXXsh and .ingXXcsh scripts. The scripts can be copied to the home directory of any user.
Virtual Address Space Allocation (Linux)
For optimal performance, Vector by default allocates a large amount of virtual address space to be able to use it most efficiently when needed. In some circumstances, this amount can be larger than the amount of physical memory.
Some Linux distributions by default disallow reserving unlimited virtual address space. We recommend that you configure your system to allow unlimited allocation of virtual address space unless there are compelling reasons (unrelated to Vector) not to.
To check if your system allows unlimited allocation of virtual address space:
# cat /proc/sys/vm/overcommit_memory
should return 1.
# ulimit –v
should return unlimited.
To ensure the system does not limit allocation of virtual address space
Issue these commands after every system restart:
# echo 1 > /proc/sys/vm/overcommit_memory
# ulimit –v unlimited
To learn how to make this setting persistent, refer to your Linux documentation.
Alternatively, Vector can be configured to not reserve virtual address space by setting the [memory] max_overalloc configuration parameter to 0. This may limit the maximum performance your system can deliver.
Note: If your system limits allocation of virtual address space by default, such allocation is automatically turned off in Vector during installation. If you reconfigure your system after Vector is installed to allow unlimited allocation of virtual address space, then you must also set the max_overalloc parameter correctly (to 2G by default).
Configuring the High Availability Option for Red Hat Cluster Suite
The mkrc utility can generate a service script, ha_actian-vectorXX, that can be used to monitor and control the Vector instance in the cluster. The script is distributed as a template, ha.rc, in $II_SYSTEM/ingres/files/rcfiles.
Install the Cluster Service Script
To install the service script, follow these steps:
1. Log in as the instance owner and source the instance environment:
$ . ~/.ingXXsh
where XX is the Vector instance ID.
2. Generate the HA service script:
$ mkrc -s ha
3. As root, install the HA service script under ==/etc/init.d==:
$ su -c "$II_SYSTEM/ingres/utility/mkrc -s ha -i"
4. Verify the script has been installed correctly:
$ ls -l /etc/init.d/ha_actian-vectorXX
-rwxr-xr-x. 1 root root 1064 May 29 19:34 /etc/init.d/ha_actian-vectorXX
$ chkconfig ha_actian-vectorXX --list
ha_actian-vectorXX 0:off 1:off 2:off 3:off 4:off 5:off 6:off
Note: It should be off by default.
Set up the Cluster Service
To set up the cluster service for the Vector database, follow these steps:
1. Install Vector onto a shared disk, visible to all nodes to be used for failover:
$ sudo -s
$ II_HOSTNAME=localhost ./install.sh HA /sharedisk1/VectorHA
2. Generate and install RC service scripts:
Vector
$ source ~/.ingXXsh
$ mkrc
$ su -c "$II_SYSTEM/ingres/utility/mkrc -i"
Management Server for Actian Director (optional)
$ source ~/.ingXXsh
$ mkrc -s iimgmtsvc
$ su -c "$II_SYSTEM/ingres/utility/mkrc -s iimgmtsvc -i"
3. Generate and install HA failover script:
$ source ~/.ingXXsh
$ mkrc -s ha
$ su -c "$II_SYSTEM/ingres/utility/mkrc -s ha -i"
4. For each node in the cluster, copy the installation environment script to the 'actian' home directory and repeat steps 2 and 3:
$ scp ~/.ingXXsh clusternode2:/home/actian
The cluster service is configured.