Installation Guide
Understanding Installation Considerations
An Actian X Instance
Instance ID
Multiple Instances
System Administrator Account
Actian X Files
Location of Actian X Files
Path Names (Windows)
File Location Guidelines
II_SYSTEM (System Files) Location Guidelines
II_DATABASE (Database Files) Location Guidelines
Warnings on Specific File and Storage Systems
II_CHECKPOINT, II_JOURNAL, II_DUMP (Checkpoint, Journal, Dump Files) Location Guidelines
II_WORK (Temporary Work Files) Location Guidelines
Transaction (and Backup) Log Location Guidelines
II_LOG (Log Files) (Windows)
Use of Actian X Locations
Location Use During Normal Operations
Location Use During OLTP Operations
Location Use During DSS or OLAP Operations
Location Use During Checkpointing
Location Use During Recovery from a Checkpoint
Location Use During Replay of Journals
Sample Disk Configurations
Four-Disk DBMS Server Configuration
Three-Disk DBMS Server Configuration
Two-Disk DBMS Server Configuration
One-Disk DBMS Server Configuration
Client-only Disk Configuration
NFS Client Disk Configuration (Linux)
World Region and Time Zone
Time Zone Names
Time Zone Name Compatibility with Older Installations
GMT Offset
IANA World Regions and Time Zone Names
Actian X World Regions and Time Zone Names
Time Zone Name Mappings
Character Set
Java Requirement for Management Server
Date Alias Setting
Installation Parameters
General Installation Parameters
DBMS Server Installation Parameters
Installing Docker for Containerized UDFs
Actian X Servers
Valid Computer, Directory, and User Names
Installing Actian X
How You Install Actian X
Licensing
Installing Actian X for Linux
Install libaio
Import GPG Public Key
install Command—Install Actian X for Linux
Default Installation Configuration
Install Actian X Using RPM Commands
How You Install Actian X for Linux Using a Response File
Response File—Define Configuration for the Installation
Configure and Start the Instance
Set the II_RESPONSE_FILE Variable
Run iisystemd Specifying II_RESPONSE_FILE
Installing Multiple Instances
Rebuild RPM Package with Unique Name
How You Upgrade Using RPM
How You Access the Instance on Linux
Install Actian X for Windows
Snap-in Components
Advanced Component Selection
Perform a Silent Install on Windows
Configuration Type Parameter Settings
Starting Actian X
Start Actian X on Linux
Start Actian X using the Systemd Service on Linux
Startup and Shutdown on Windows
Start Actian X with the Actian Service Manager
Start Actian X with Visual Manager
Start Actian X with Director
Getting Started with Databases and Applications
Understanding Post-installation Tasks
How You Further Customize Your Instance
How You Prepare Your Installation for General Use
How You Safely Uninstall Actian X
uninstall Command--Uninstall Actian X for Linux
Uninstall Actian X for Windows
E. Installing Actian X Using ingbuild
How You Create the System Administrator Account on Linux
Set TERM_INGRES
Extract Files and Set II_DISTRIBUTION
Setting II_DISTRIBUTION
Installation Modes
Install Actian X in Interactive Mode
Install Actian X in Command Line Mode
Ensure Correct Path Settings
Ingbuild Command--Install Actian X
Run the Setup Programs
How You Install and Configure NFS Clients
Set Up Each NFS Client Individually
Set Up NFS Clients from the DBMS Server
Post-Installation Tasks
Automatic Startup Command
Management Server Service
Upgrading from a Previous Release with a “SYSV” Service Script
Allow Access on Systems Using Shadow Passwords
How You Establish User Access to Tools and Databases
Edit User Login File to Facilitate User Access to Tools
Edit User Login File to Set Up Shared Library Paths
View Contents of Your Current Installation
Currently Installed Components Screen
F. Configuring Actian X High Availability for Linux
Configuring the OCF Resource Agent with Pacemaker
G. Configuring the High Availability Option for Windows Failover Clustering
What You Need to Know
How the Actian X High Availability Option Works
Cluster Service Installation
Failover Cluster Manager
Cluster Disk
Physical Disk Resource Type
Generic Service Resource Type
Prerequisites for the High Availability Option
DBMS Server Requirements
Virtual Servers
Install the High Availability Option
How the High Availability Option Setup Works
Installation When Using iSCSI Storage
Start and Stop Actian X in a Cluster Environment
How to Remove the High Availability Option
How to Install an Actian X Patch in a Cluster Environment
H. Response File Parameters
Response File--Define Configuration for the Installation
Example Response File for Linux
Example Response File for Windows
Example Response File Generated by ingbuild
Example Response File for DBA Tools for Windows
Response File Parameters
CONNECT_LIMIT
II_ADD_REMOVE_PROGRAMS
II_ADD_TO_PATH
II_AUTH_STRING
II_CHARSET
II_CHECKPOINT
II_COMPONENT_CORE
II_COMPONENT_DBMS
II_COMPONENT_DOCUMENTATION
II_COMPONENT_DOTNET
II_COMPONENT_FRONTTOOLS
II_COMPONENT_JDBC_CLIENT
II_COMPONENT_NET
II_COMPONENT_ODBC
II_COMPONENT_REPLICATOR
II_COMPONENT_STAR
II_COMPONENT_VISION
II_CONFIG_TYPE
II_CONNECT_LIMIT
II_DATABASE
II_DATE_TYPE_ALIAS
II_DATE_FORMAT
II_DBMS_AUTHENTICATION
II_DBMS_PASSWORD
II_DEMODB_CREATE
II_DESTROY_TXLOG
II_DOWNLOAD_GCS_CONNECTOR
II_DOWNLOAD_HADOOP
II_DOWNLOAD_SPARK
II_DOWNLOAD_UDFC_REPO
II_DUAL_LOG
II_DUMP
II_EMAIL
II_ENABLE_SQL92
II_ENABLE_TCPIP
II_FTP_IANA
II_GCS_CONNECTOR_LOCATION
II_GROUPID
II_HADOOP_LOCATION
II_INSTALL_ALL_ICONS
II_INSTALLATION
II_JOURNAL
II_LICENSE_DIR
II_LOCATION_DOCUMENTATION
II_LOCATION_DOTNET
II_LOG_FILE
II_LOG_FILE_SIZE_MB
II_MAILHOST
II_MAILPORT
II_MONEY_FORMAT
II_MTS_JAVA_HOME
II_NUM_OF_PROCESSORS
II_REMOVE_ALL_FILES
II_SERVICE_START_AUTO
II_SERVICE_START_USER
II_SERVICE_START_USERPASSWORD
II_SPARK_LOCATION
II_START_INGRES_ON_COMPLETE
II_START_IVM_ON_COMPLETE
II_START_ON_BOOT
II_SYSTEM
II_TERMINAL
II_TIMEZONE_NAME
II_UPGRADE_USER_DB
II_USERID
II_WORK
SILENT_INSTALL
Installation Guide
SILENT_INSTALL