• Introducing This Guide
  • In This Guide
  • Audience
  • System-specific Text in This Guide
  • Terminology Used in This Guide
  • Path Notation in This Guide
  • Query Languages
  • ISO Entry SQL92
  • Syntax Conventions Used in This Guide
• Understanding the Replicator
  • Replicator Functionally Stabilized
  • Replication
  • Ingres Replicator
    • Advantages of Replication
    • Replicator Data Control
    • Replicator Versus Ingres Star
    • Security for Replicator
  • Product Requirements for the Replicator
  • Replicator and Other Products
  • Replicator Concepts
  • Replicator Components
    • Change Recorder
      • How the Change Recorder Works
    • Distribution Threads
      • How the Distribution Thread Works
    • Replicator Server
      • How the Replicator Server Process Works
    • How Replication of Data Occurs
      • How Two-phase Commit Works
    • Replicator Management and Monitoring Tools
  • Replicator Processing Tables
    • Base Table
    • Shadow Table
    • Archive Table
    • Input Queue Table
    • Distribution Queue Table
  • Replicator Design Concepts
    • Consistent Distributed Data Set (CDDS)
    • CDDS Example: Subset of Tables
    • CDDS Example: Vertical Partitioning
    • CDDS Example: Horizontal Partitioning
    • Data Propagation Paths in the CDDS
      • Example: Data Propagation Path
    • CDDS Target Types
      • Full Peer Target
      • Protected Read-Only Target
      • Unprotected Read-Only Target
  • Sample Configurations
    • Peer-to-Peer Configuration
    • Central-to-Backup Configuration
    • Cascade Configuration
    • Central-to-Branch Configuration
    • Hub-and-Spoke Configuration
    • Combination Configurations
  • Responsibilities of the Distributed Database Administrator
• Planning Your Replication Scheme
  • Replication Planning
  • Application Design Issues
    • Derived Information
      • Example: Risks of Replicating Derived Data
      • Example: Avoiding Risks in Replicating Derived Data
    • Data Ownership
    • Data Aggregation
  • Replication Scheme Design Issues
    • Collision Design
      • How Collisions Are Caused
      • Collision Handling
      • Automatic Resolution of Collisions
      • Manual Resolution of Collisions
      • Collision Modes
    • How Errors Are Handled
      • How Error Modes Affect Server Behavior
    • Replicator Server Assignment
      • Replicator Server Scenarios
    • Storage Structures
    • Using Hash Structures to Avoid Deadlock
  • How You Implement Replicator
  • How You Prepare for Replication
    • Rules for Database Objects
    • Database Administrator Privileges
      • Define the ingrep Role
    • Ingres Net Entries
  • Replication Scheme
  • Replication Scheme Planning Worksheets
    • Database Worksheet
    • Identifying the CDDS
      • CDDS Summary Information
      • CDDS Diagram
      • Database Information
      • Propagation Paths
      • CDDS Worksheet
    • Table Worksheet
  • Replication Scheme Examples
    • Example: R.E.P.’s CDDS 0
    • Example: R.E.P.’s CDDS 2
    • Example: R.E.P.’s Server Assignments
      • Database Information for CDDS 1
      • Server Assignments for CDDS 0
      • Server Assignments for CDDS 1
      • Server Assignments for CDDS 2
• Configuring Replication Using Visual DBA
  • How You Configure Replicator Using VDBA
  • Installation of Replication Objects
  • Replication Branch in DOM Window
  • How You Work with Replication Databases
  • How You Create a CDDS
  • CDDS Definition Dialog
    • View Table Registration Information
  • Creation of Replication Keys
  • How Configuration Information Is Propagated
  • How Replication Is Activated
  • How You Deactivate Replication
  • Error Mail Destinations
• Configuring Replication Using Replicator Manager
  • Replicator Manager
    • Reregistering Renamed Tables and Tables with Renamed Columns
    • repmgr Command--Start the Replicator Manager
    • Navigation and Operation of Replicator Manager
      • Execute Menu Items
      • Standard Operations
      • Replicator Manager Menu Window
      • Replicator Manager Main Menu Map
  • How You Configure Replicator Using Replicator Manager
  • repcat Command--Create Replicator Catalogs
  • Run the Replicator Manager the First Time
  • Configuration Menu
    • Configuration Menu Map
  • Editing Operations
  • Database Summary
    • Add a Database to the Database Summary List
    • Edit a Database
    • Delete a Database
  • CDDS Summary
    • Add a CDDS
    • Edit a CDDS
    • Delete a CDDS
    • CDDS Database and Servers Window
      • Add Database and Server Information
      • Edit Database and Server Information
      • Delete Database and Server Information
    • Propagation Path Definition Window
      • Add Propagation Paths
      • Edit Propagation Paths
      • Delete Propagation Paths
    • View Table Registration Information
  • Table Registration Summary
    • Register Tables
    • Deregister Tables
    • Table Registration Details Window
      • Deregister a Column From a Register Field
      • Assign a Table to a Different CDDS
      • Assign Lookup Tables
    • Create Support Objects
    • Activate or Deactivate a Table
    • CreateKeys Options
      • Create Replicated Transaction Keys
  • Move Configuration Data Window
    • Move Configuration Data
    • How the MoveConfig Operation Works
  • Activate Change Recording Window
    • Activate or Deactivate a CDDS or Database
  • Mail Notification List Window
    • Create a Mail Notification List
    • Delete Mail Notification Entries
• Using the Replicator Server
  • Tools for Performing Replicator Server Tasks
  • Tools for Monitoring Replicator
  • Install Replicator Service on Windows
  • How You Start Replicator Server
  • How Server Behavior Is Controlled
    • Server Monitoring Configurations
      • Mail Alert Setup
      • Error Count Maximum
      • Replication Activity Monitoring
      • Message Logging
    • Error Handling
      • Configuration Errors
      • DBMS Server Errors
      • Replication Transmission Errors
    • Server Processing Activity
      • Server, Database, and CDDS Status
      • Lock Contention Detection
      • Memory Management
  • Server Parameters
    • How the Replication Cycle Works
    • Server Flags
    • Server Startup Settings Worksheet
  • Replication Monitoring Using Visual Performance Monitor or Visual DBA
    • Monitor Replication Activity
    • View Server Statuses
    • Raise Events at the Database Level
    • Raise Events at the Server Level
    • View the Queue Collision Report
    • Create and View the Table Integrity Report
    • View the Distributed Configuration Checker Report
  • Replication Monitoring Using Replication Manager
    • Replication Monitor Window
      • Monitor Menu Map
      • Server Assignments Window
      • Edit the Configuration File
      • Start a Server
      • Check the Queues
      • Ping Servers
      • Send Database Event Window
      • Stop a Server
  • Advanced Options
    • How You Assign Server Numbers Greater Than Ten
    • Scheduling Servers
      • -SGL Flag--Run Replication Once
      • -QIT Flag--Run Server in Quiet Mode
      • -EVTn Flag--Use Event Timeout
    • rpserver Command--Start a Replicator Server
    • Database Events
• Maintaining the Replicator
  • Maintenance of Replicated Tables and Databases
    • How You Stabilize the Replication System
    • Copying Data into a Replicated Table
    • Using SQL Statements on Replicated Tables
      • Modify to Truncated Statement
      • Integrity Constraints
  • Reconfiguration of the Replicator
    • How You Add a Database to the Replicated Configuration
    • How You Copy Replicated Tables Between Replicated Databases
    • How You Change the Table Schema
    • Optimizing Replicator Catalogs and Support Tables
  • Collision Resolution
    • Collision Detection
      • Collisions in the Replication Server Log File
      • Queue Collision Report
    • Methods to Handle Collisions
      • How You Resolve Collisions Manually
      • Automatic Resolution of Collisions
  • Disaster Recovery
    • Recovering Transactions from a Peer Database Using the Reconciler
  • Resolver Reports Menu (Replicator Manager)
    • Queue Collision Report
      • How the Queue Collision Report Is Created
    • Table Integrity Report Window
      • How the Table Integrity Report Is Created
    • Distributed Configuration Checker Report
    • Replicated Databases Report
    • CDDS Data Propagation Paths Report
    • Registered Tables Report
  • How to Deactivate Replication
    • Deactivate the Change Recorder for a CDDS or Database
    • Removing Replication Objects
• Using Advanced Features
  • Lookup Tables
    • How You Set Up Horizontal Partitioning
      • How You Create a Horizontal Partitioning Lookup Table
      • How You Implement Horizontal Partitioning Using Visual DBA
      • How You Implement Horizontal Partitioning Using Replicator Manager
      • Example: R.E.P.’s Horizontal Partitioning
    • Priority Collision Resolution
      • How You Create a Priority Collision Resolution Lookup Table
  • Strategies for Avoiding Deadlock
    • Row Locking Option
    • rep_xx_lockmode Parameter--Override Default Locking
    • Maxlocks Values
    • Deadlock in the Distribution Threads
• C. Data Dictionary Tables
  • System Catalogs
    • dd_cdds Table
    • dd_databases Table
    • dd_db_cdds Table
    • dd_distrib_queue Table
    • dd_input_queue Table
    • dd_mail_alert Table
    • dd_paths Table
    • dd_regist_columns Table
    • dd_regist_tables Table
    • dd_servers Table
  • Base Table
  • Archive Table
  • Shadow Table
  • Internal Tables
• D. Cluster Support
  • Replicator in a Cluster Environment
  • -TPC Flag--Control Use of Two-phase Commit

Introducing This Guide

-TPC Flag--Control Use of Two-phase Commit