• Replicator User Guide
•  1. 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
•  2. 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
•  3. 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
•  4. 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
•  5. 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
•  6. 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
•  7. 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
•  8. 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

Ingres 10S

-TPC Flag—Control Use of Two-phase Commit