Installation Guide
1. Understanding Installation Considerations
An Ingres Instance
Instance ID
Multiple Instances
System Administrator Account
Ingres Files
Location of Ingres Files
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
Character Set
Date Alias Setting
JRE Requirement for Actian Director
Installation Parameters
General Installation Parameters
DBMS Server Installation Parameters
Ingres Servers
Valid Computer, Directory, and User Names
2. Installing Ingres
How You Install Ingres
Installing Ingres for Linux
Install Ingres for Linux Using the Installation Wizard
Installing Ingres for Linux at the Command Line
ingres_express_install Command—Install Ingres
instance_PATH
instance_ID
Install Ingres Using RPM Commands
How You Install Ingres with a Custom Configuration at the Command Line
Example: Response File to Install Ingres as a Two-Disk System
Example: Response File to Install Ingres as a Four-Disk System
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
path
response_file_name
Install Ingres for UNIX
Install Ingres for OpenVMS
How You Access the Instance on Linux and UNIX
Configuration Type Parameter Settings
3. Starting Ingres
Start Ingres on Linux and UNIX
Start Ingres using the Service Script on Linux
Startup and Shutdown on Windows
Start Ingres with the Ingres Service Manager
Start Ingres with Ingres Visual Manager
Start Ingres with Director
Start Ingres on OpenVMS
Getting Started with Databases and Applications
4. 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 for Linux Using the Installation Wizard
uninstall_ingres Command—Uninstall Ingres for Linux
instance ID
Uninstall Ingres for Windows
A. 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
ingres_express_install Command—Install Ingres Quickly
instance_PATH
instance ID
Install Ingres in Interactive Mode
Install Ingres in Command Line Mode
Set II_DISTRIBUTION
Ingbuild Command–Install Ingres
distribution_medium
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
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
B. Installing Ingres on OpenVMS
How You Install and Configure Ingres (First Time Installers)
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
logicalname
disk
dir
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
C. Configuring the High Availability Option for Red Hat Cluster Suite
What You Need to Know
A Database Service
How to Set Up a Cluster Service for an Ingres Database
How to Add an Ingres Service
D. Configuring the High Availability Option for Windows Clustering
What You Need to Know
Ingres High Availability Option
Failover
Configuration Guidelines for System and Data Files
Cluster Disk
Physical Disk Resource Type
Generic Service Resource Type
DBMS Server Requirements
Virtual Servers
Virtual Server Name
Windows Cluster Service Installation
Cluster Administrator
Verify Windows Cluster Service Installation
Cluster Command
Prerequisites for High Availability Option
Install High Availability Option for Windows Clustering
Functions Performed by the Ingres High Availability Option Setup Utility
Installation on Windows Server 2008
Starting and Stopping Ingres in a Cluster Environment
Start Ingres in a Cluster Environment
Stop Ingres in a Cluster Environment
How the High Availability Option Is Removed
E. 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
F. 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
G. Response File Parameters
Response File—Define Configuration for the Installation
Example Response File for Linux
Example Response File for Windows
Response File Parameters Generated by ingbuild
Response File Parameters
II_ADD_REMOVE_PROGRAMS
II_ADD_TO_PATH
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_SPATIAL
II_COMPONENT_STAR
II_COMPONENT_VISION
II_CONFIG_TYPE
II_DATABASE
II_DATE_TYPE_ALIAS
II_DATE_FORMAT
II_DEMODB_CREATE
II_DESTROY_TXLOG
II_DUAL_LOG
II_DUMP
II_ENABLE_NETBIOS
II_ENABLE_SPX
II_ENABLE_SQL92
II_ENABLE_TCPIP
II_GROUPID
II_INSTALL_ALL_ICONS
II_INSTALLATION
II_JOURNAL
II_LOCATION_DOCUMENTATION
II_LOCATION_DOTNET
II_LOG_FILE
II_LOG_FILE_SIZE_MB
II_MONEY_FORMAT
II_MTS_JAVA_HOME
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
Ingres 10S
II_WORK