Status: Verified
GOAL:
How to know the status of replication?
GOAL:
Is there a way to detect if replication is active?
FACT(s) (Environment):
Progress 9.x
OpenEdge 10.x
All Supported Operating Systems
FIX:
In order to check the status of replication, use the DSRUTIL command which will return a code between 1100 and 3255.
$ dsrutil <db-name> -C status
$ dsrutil <db-name> -C status <agentname> -detail
The status is returned as a four digit number.
- the first digit identifies the replication component:
1 is for the source database
2 for the source database named agent
3 for the target database.
- the next 3 digits indicate the replicaiton state.
Common examples:
100 Initial Connection, Initializing, Server Initialization, Connecting to
Agents or Configuring Agent(s).
101 Startup Synchronization, Normal Processing, Recovery Synchronization,
Recovery Processing, Startup Synchronization, Normal Processing.
102 Target database is in quiet point
103 Replication agent is in pre-transition or applying AI extents
104 The agent is listening for the server to make contact (as the agent may have
just been started or a communications error could have occurred).
105 Transitioning ...
199 Initial Connection Failed, Recovery Failed, Invalid Target Database
Configuration, Agent Failed, Agent is Ignored, Agent is Stopped, Agent is
Terminated, Agent is Ended or Server is ended.
255 Replication is in unknown state.
Examples:
1. The database is a source database and processing is taking place
$ dsrutil <dbname> -C status 1101
2. The database is a target database and processing is taking place.
$ dsrutil <dbname> -C status 3101
3. The following command is used to obtain the status of the replication agent
and normal processing is taking place.
$ dsrutil test -C status agent1 -detail 3049
4. The database is a target database and the RPLA is listening for connection from RPLS
$ dsrutil <dbname> -C status 3104
5. The database is a target database and is in pre-transition mode
$ dsrutil <dbname> -C status 3104
Please refer to the OpenEdge® Replication User Guide under "Reference" DSRUTIL utility for a full list and interpretation of return codes.