• Replicator User Guide
  • 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
    • 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
  • A. 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
  • B. Cluster Support
    • Replicator in a Cluster Environment
    • -TPC Flag--Control Use of Two-phase Commit

Replicator User Guide

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