Preface
Purpose
Audience
Organization
Using ABL documentation
References to ABL compiler and run-time features
References to ABL data types
Typographical conventions
Examples of syntax descriptions
Long syntax descriptions split across lines
Complex syntax descriptions with both required and optional elements
OpenEdge messages
Obtaining more information about OpenEdge messages
Introducing OpenEdge Replication
What is data replication
How OpenEdge Replication works with two databases
How OpenEdge Replication works with a replication set
Key features of OpenEdge Replication
OpenEdge Replication terminology
Primary and secondary databases
Source and target databases
The source database
The target database
Other source and target database characteristics
Target quiet points
Schema lock
A Replication Set
OpenEdge Replication property files
OpenEdge Replication server
OpenEdge Replication agent
Designating a critical agent
Enhanced Read-Only mode
OpenEdge Replication Model
Failover
Failback
Transition
Source and target architecture requirements
Guidelines for working with source and target databases
Using synchronous or asynchronous replication
Synchronous configuration and replication
Asynchronous configuration and replication
OpenEdge Replication activity during normal processing
Normal source database activity
Normal target database activity
What happens if there is a database failure
Choosing a hot standby database
Synchronization between server and agent
If the server detects a communication failure with the agent
If the agent detects a communication failure with the server
OpenEdge Replication utilities and commands
OpenEdge Replication and after-imaging
Understanding OpenEdge Replication after-image requirements
Calculating current database after-image volume
Using after-image VST information
Using the RFUTIL command
Using the PROMON command
Using before-image VST information
The role of after-image extents in the Replication process
After-image extent types
After-image extent states
After-image extent sizing on a source database
Calculating fixed after-image extent size
After-image extent sizing based on hourly data
After-image extent sizing based on weekly data
Using variable extents
After-image interdependency between source and target databases
Determining OpenEdge Replication network bandwidth
Estimating network bandwidth
Anticipating additional network overhead
Ensuring success when using after-imaging
OpenEdge Replication and after-imaging: a summary
Planning for OpenEdge Replication
Preliminary planning tasks
Step 1: Reviewing after-image information
Step 2: Creating a database backup plan
Step 3: Evaluating your production database
Step 4: Determining if you will be replicating an encryption-enabled database
The replication process for databases also enabled for encryption
Understanding the importance of after-imaging in OpenEdge Replication planning
Determining acceptable latency
Determining acceptable target database downtime
Determining appropriate failover behavior
Understanding limitations and restrictions
Setting Up OpenEdge Replication
Overview
Getting started
Choosing an online or an offline backup of the source database
Choosing the OpenEdge Replication agent startup mode
Setting up the OpenEdge Replication databases
Setting up the source database with an offline backup
Step 1: Back up the source database
Step 2: Create a structure file
Step 3: Enable database after-imaging
Enable AI on your source database
Step 4: Enable the source database for OpenEdge Replication
Step 5: Perform an incremental backup of the source database
Step 6: Where to go next
Setting up the source database with an online backup
Step 1: Create a structure file
Step 2: Enable the database for after-imaging
Enabling after-imaging on your source database
Step 3: Enable the source database for OpenEdge Replication
Step 4: Perform an online backup
Step 5: Configure the OpenEdge Replication server for deferred agent startup
Step 6: Where to go next
Setting up the OpenEdge Replication target database
Create the OpenEdge Replication target database
Enabling before-image encryption for a Replication-enabled target database
Configuring the OpenEdge Replication property files
Sample OpenEdge Replication property files
Sample OpenEdge Replication source property file
Sample OpenEdge Replication target properties file
Sample OpenEdge Replication combined properties file
Server properties
Control agent properties
Agent properties
Configuring the source database property file
Properties file example
Agent rules in the source replication properties file
Configuring the target database property file
Properties file example
Choosing the OpenEdge Replication agent startup mode
Using the immediate agent startup mode
Using the deferred agent startup mode
Setting up the deferred agent startup implementation
Starting OpenEdge Replication
Message logging during startup
Starting the source database
Starting the target database
OpenEdge Replication startup and initialization process
Starting OpenEdge Replication with the DBMAN utility or OpenEdge Explorer
Database connection considerations
Accessing a running replication-enabled database
Accessing a target database
Accessing a source database
Enabling transparent data encryption for an OpenEdge Replication-enabled source database
Enabling encryption for a Replication-enabled source database that is online
Stopping OpenEdge Replication
Shutting down the source database
Shutting down the target database
Terminating the OpenEdge Replication server when the source database is running
Terminating the OpenEdge Replication agent when the target database is running
Disabling OpenEdge Replication on the server
Disabling OpenEdge Replication on the agent
Moving From Failure to Recovery with OpenEdge Replication
Overview of database failure recovery
Automated transition functions
Possible types of failure
Detecting TCP/IP communications failures
Source failure recovery after losing connection
Target transition after losing connection
Restoring a source database
Transition
Transition scenarios
Intuitive transition processing
JTA transactions and transition
Configuring transition
Choosing either one or two target databases
Setting up automatic transition
Setting up manual transition
Planning for transition
OpenEdge Replication from normal activity through failure and recovery
Step 1: Primary replication before a failure
Step 2: Primary machine failure
Step 3: Entering pretransition
Manually applying after-image extents
Step 4: Transitioning the target database to a source database
Step 5: Failover
Step 6: Primary machine repair complete
Step 7: Initiating primary database transition
Step 8: Secondary replication is performed
Step 9: The Replication failback process
Failback processing using transition failover
Advantages and disadvantages of using transition failover to perform failback
Failback processing using controlled transition
Initiating failback with controlled transition
Advantages and disadvantages of performing failback with controlled transition
Transition of a Replication Set
Recovery from transition failures
Transition logging
Transition properties
Setting transition properties
Sample of a startup parameter file used by transition
Source database startup parameter file
Target database startup parameter file
Normal database startup parameter file
Transition property reference
Transition command actions
Transition properties summary
Reference
DSRUTIL utility
DSRUTIL applyextent qualifier
DSRUTIL canceldefer server qualifier
DSRUTIL connectagent database qualifier
DSRUTIL disablesitereplication qualifier
DSRUTIL monitor qualifier
DSRUTIL recovery qualifier
DSRUTIL relwaits qualifier
DSRUTIL restart agent qualifier
DSRUTIL restart server qualifier
DSRUTIL startagent database qualifier
DSRUTIL status qualifier
When the detail or verbose argument is used
When the detail or verbose argument is not used
DSRUTIL terminate qualifier
DSRUTIL transition qualifier
DSRUTIL transition failover qualifier
DSRUTIL triggertransition qualifier
OpenEdge Replication DSRUTIL MONITOR
Startup menu
Monitoring latency between the source and target databases
From the OpenEdge Replication server perspective
From the OpenEdge Replication agent perspective
Replication server status
Replication server remote agents
Replication remote agents status
Replication agent status
Replication inter-agent status
Virtual system tables for OpenEdge Replication
_Repl-Server VST field descriptions
_Repl-AgentControl VST field descriptions
_Repl-Agent VST field descriptions
_DbServiceManager VST field descriptions
_DbServiceManagerObjects VST field descriptions
_Repl-AgentActivity VST field descriptions
_Repl-AgentControlActivity VST field descriptions
_Repl-InterAgentActivity VST field descriptions
Utilities and OpenEdge Replication
OpenEdge Replication and database management systems
OpenEdge Replication Quick Command Summary
Configuring the OpenEdge Replication property files
Setting up the source and target databases
Setting up the source database with deferred agent startup for online backup
Set up the target database
Enabling before-image encryption for a Replication-enabled target database
Configuring OpenEdge Replication with deferred agent startup
Configuring OpenEdge Replication for one agent
Configuring OpenEdge Replication for two agents
Starting OpenEdge Replication
Stopping OpenEdge Replication
Terminating the OpenEdge Replication server and agent
Configuring for automatic transition
Configuring for manual transition
Using manual transition
Re-enabling OpenEdge Replication after transition
Restarting the OpenEdge Replication server after target shutdown
Monitoring an OpenEdge Replication database
Backing up an online target database
Preface
Backing up an online target database