Installation Guide
Understanding Installation Considerations
An Ingres Instance
Instance ID
Multiple Instances
System Administrator Account
Ingres Files
Location of Ingres 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 Ingres 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 (UNIX)
World Region and Time Zone
Time Zone Names
Time Zone Name Compatibility with Older Installations
GMT Offset
IANA World Regions and Time Zone Names
Ingres 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
Ingres Servers
Valid Computer, Directory, and User Names
Installing Ingres
How You Install Ingres
Licensing
Installing Ingres for Linux
Install libaio
Import GPG Public Key
install Command—Install Ingres
Default Installation Configuration
Installing Multiple Instances
Install Ingres Using RPM Commands
How You Install Ingres 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
Install Ingres for Windows
Snap-in Components
Advanced Component Selection
Perform a Silent Install on Windows
Install Ingres for UNIX
Install Ingres for OpenVMS
How You Access the Instance on Linux and UNIX
Configuration Type Parameter Settings
Starting Ingres
Start Ingres on Linux and UNIX
Start Ingres using the Systemd Service on UNIX
Startup and Shutdown on Windows
Start Ingres with the Actian Service Manager
Start Ingres with Visual Manager
Start Ingres with Director
Start Ingres on OpenVMS
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 Ingres
uninstall_ingres Command--Uninstall Actian X for Linux
Uninstall Ingres for Windows
H. Installing Ingres on UNIX
How You Prepare for Installation on UNIX
How You Create the System Administrator Account on UNIX
Major Configuration Options
How You Install and Configure Ingres in a UNIX Environment
Set TERM_INGRES
Installation Modes
Extract Files from the Distribution
express_install Command--Install Ingres Quickly
Install Ingres in Interactive Mode
Install Ingres in Command Line Mode
Set II_DISTRIBUTION
Ensure Correct Path Settings
Ingbuild Command--Install Ingres
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
Transaction Log File as a Raw Device (UNIX Only--Not Linux)
Location of Your Raw Log File (UNIX)
Create and Configure the Raw Log File (UNIX)
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
I. Installing Ingres on OpenVMS
How You Install and Configure Ingres (First Time Installers)
Environment Prerequisites:
How You Install and Configure Ingres (Experienced Installers)
Define the TERM_INGRES Logical
Major Configuration Options
Multiple Instances on One Node
File Locations and Logicals
Define II_SYSTEM as a Logical
Define a Concealed, Rooted Logical
Guidelines for VMS Cluster Configuration
Owner of the System Administrator Account
UIC for an Installation
Run the Setup Programs
Post-Installation Tasks
How You Add an Automatic Startup Command
How You Establish User Access to Tools and Databases
Facilitate User Access to Tools
Installation History Log File
Edit the Installation History Log File
Ingres Cluster Solution for OpenVMS
Requirements for the Ingres Cluster Solution on OpenVMS
How You Prepare to Install the Ingres Cluster Solution for OpenVMS
How You Install the Ingres Cluster Solution for OpenVMS
How Client Applications Access an Ingres Cluster
J. Configuring Ingres High Availability Option for Linux
Configuring the OCF Resource Agent with Pacemaker
K. Configuring the High Availability Option for Windows Failover Clustering
What You Need to Know
How the Ingres 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 Ingres in a Cluster Environment
How to Remove the High Availability Option
How to Install an Ingres Patch in a Cluster Environment
L. Configuring the High Availability Option for Solaris Cluster
What You Need to Know
Failover
Configuration Guidelines for System and Data Files
Cluster File Systems
DBMS Server Requirements
Solaris Cluster Software Installation Verification
How You Install the Ingres High Availability Option for Solaris
How to Respond to Installation Script Prompts
How the Ingres High Availability Option Is Configured
How the Database Probe Function Is Configured
Turn on Debugging and Tracing for the High Availability Option
Starting and Stopping Ingres in a Cluster Environment
Start Ingres in a Cluster Environment
Stop Ingres in a Cluster Environment
Clear a Fault in a Resource Group
How You Remove the High Availability Option
M. System Requirements for OpenVMS
In This Appendix
System Hardware Requirements on OpenVMS
SYSGEN Parameters that Affect Operation
Recommended OpenVMS Process Resources
OpenVMS Quotas and Ingres Parameters
Required OpenVMS Privileges
N. 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_DUAL_LOG
II_DUMP
II_EMAIL
II_ENABLE_SQL92
II_ENABLE_TCPIP
II_FTP_IANA
II_GROUPID
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_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