Introducing This Guide

The Replicator User Guide gives you a comprehensive look at Ingres® Replicator from the perspective of the database administrator. Specifically, this guide includes the following topics:

• An overview of the Ingres Replicator and its associated concepts
• Guidelines for designing a scheme to meet your replication needs
• Instructions on how to use and maintain Ingres Replicator
• Advanced Replicators, including creating lookup tables using Visual DBA or Replicator Manager

Audience

This guide is designed for the distributed database administrator who is responsible for configuring and maintaining Ingres Replicator.

The guide assumes that the reader is familiar with using Ingres, Ingres Net, and Visual DBA.

System-specific Text in This Guide

This guide provides information that is specific to your operating system, as in these examples:

Windows: This information is specific to the Windows operation system.

UNIX: This information is specific to the UNIX operation system.

VMS: This information is specific to VMS operating system.

When necessary for clarity, the symbol is used to indicate the end of the system-specific text.

For sections that pertain to one system only, the system is indicated in the section title.

Terminology Used in This Guide

This guide uses the following terminology:

• A command is an operation that you execute at the operating system level. An extended operation invoked by a command is often referred to as a utility.
• A statement is an operation that you embed within a program or execute interactively from a terminal monitor.

Note: A statement can be written in Ingres 4GL, a host programming language (such as C), or a database query language (SQL or QUEL).

Path Notation in This Guide

The directory structure of an Ingres installation is the same regardless of operating system. Rather than showing path examples for all environments, this guide uses UNIX notation only.

For example: When describing the location of the collation sequence file, the guide shows: $II_SYSTEM/ingres/files/collation/collation_name.

On Windows, the location is:
%II_SYSTEM%\ingres\files\collation\collation_name

On VMS, the location is:
II_SYSTEM:[INGRES.FILES.COLLATION]collation_name

Query Languages

The industry standard query language, SQL, is used as the standard query language throughout the body of this guide.

QUEL commands and system parameters, such as environment variables/logicals, are also included in this guide. For a complete description of available QUEL statements, see the QUEL Reference Guide.

ISO Entry SQL92

Ingres is compliant with ISO Entry SQL92. In addition, numerous vendor extensions are included. For details about the settings required to operate in compliance with ISO Entry SQL92, see the SQL Reference Guide.

Syntax Conventions Used in This Guide

This guide uses the following conventions to describe syntax: