Replication remote agents status

If you select the Replication server remote agents status from the Startup menu of the DSRUTIL Monitor Utility and select a valid remote agent from the sub-menu, the following screen appears:

Figure 1. OpenEdge Replication remote agents status screen
OpenEdge Replication Monitor          Page 1

    Database: C:\OE120WRK\repl1
    Agent:
        Name:                                   agent1
        ID:                                     1
        Host name:                              127.0.0.1
        Target database:                        C:\OE120WRK\repl2
        State:                                  Normal Processing
        Critical:                               No
        Method:                                 Asynchronous
    Server/Agent connection time:               Fri Mar 16 10:14:16 2010
    Remote agent is waiting for:                Nothing
    Recovery state:                             No recovery being performed
    Maximum bytes in TCP/IP message:            8512
    Server/Agent connection timeout:            60.000 seconds
    Transition information:
        Type:                                   Automatic
        Timeout limit:                          88090 seconds
    The last block was sent at:                 Fri Mar 16 10:14:18 2018
    Activity information:
        Blocks sent:                            497
        Blocks acknowledged:                    1
        Synchronization points                  8
    AI Block Information:
        Current RDBMS Block (Seq / Block):      3 / 313
        Last Sent Block (Seq / Block):          3 / 313
    Server to agent load check interval:        10 blocks
    Time between server and agent load checks:  7002.666 seconds
    Time taken to respond to load check:        0.093 seconds
    Port:                                       1025
    Last message was received at:               Mon Mar 19 20:28:00 2018
    Connection state:                           Connected

As shown in the previous figure, the first two lines of the Replication remote agents status screen are the utility title line and the fully qualified name of the database specified by the user.

The remaining lines of the Replication remote agents status screen are defined in the table that follows.

Table 1. Replication remote agents status details
Field Description
Agent Shows information related to remote replication agent operational state and configuration.
Name The name of the replication agent as configured in the repl.properties file.
ID The ID of the replication agent as assigned by replication server.
Host name The name of the host where the replication agent is running.
Target database Fully qualified database name to which the replication agent is connected.
State The current operational state of the replication agent.
Valid values are:

  • Unknown

  • Initializing

  • Initial Connection

  • Initial Connection Failed

  • Invalid Target Database Configuration

  • Startup Syncrhonization

  • Recovery Synchronization

  • Recovery Failed

  • Normal Processing

  • Target Database in Quiet Point

  • Target Database in BI Stall

  • Target Database in AI Stall

  • Online backup of Target Database

  • Being Transitioned

  • Agent is Terminated
Critical Critical agent flag. Valid values are:
  • Yes — Critical
  • No — Not Critical
For more information, see Designate a critical agent.
Method The type of replication that is being performed with the replication agent. Valid value is — Asynchronous.
Note: Asynchronous replication is the only supported replication method. Synchronous replication is no longer supported.
Server/Agent connection time The date and time when the replication server successfully connected to the replication agent.
Remote agent is waiting for Specifies what the replication agent is waiting for. Valid values are:
  • Nothing — Indicates no waiting is taking place.
  • Schema lock request —Indicates that the replication agent is awaiting the acquisition of the schema lock on the target database.
Recovery state The recovery state of the replication agent. Valid values are:
  • Failed for the agent — Failure recovery could not be completed for the replication agent.
  • No recovery being performed — There is currently no failure recovery being done.
  • Just entered recovery — The replication agent needs to be reconnected to the replication server due to a lost connection.
  • Server attempting to connect to agent— The replication server is attempting to reconnect with the replication agent.
  • Initialize synchronization — The replication server is configuring the data required to synchronize with the replication agent.
  • Synchronizing — The replication agent is in the process of synchronizing the target database with the source database.
  • Recovery complete — The recovery process for the replication agent is complete.
Maximum bytes in TCP/IP message Maximum number of bytes in a TCP message.
Server/Agent connection timeout

The value used by the replication server to determine the number of retries and timeout interval when establishing a network connection to the replication agent.

For more information, see Connect-timeout property.
Transition information Shows information related to replication transition for the replication agent.
Type Specifies whether the replication agent will perform recovery transition automatically, or with manual intervention. Valid values are:
  • Manual—Specifies that manual intervention is required to complete the transition of a target database to its new replication role.
  • Automatic—Specifies that the transition from a target database to its new replication role will take place automatically upon expiration of the transition timeout limit.
Timeout limit For automatic transition, the time (in seconds) that the replication agent waits for reconnection with the replication server before automatically starting recovery transition.
Note: This line appears in the monitor display only when the transition Type is Automatic.
The last block was sent at The date and time when the last after-image (AI) block was sent to the replication agent.
Activity information Shows information related to AI block processing on the remote target database.
Blocks sent The number of AI blocks the replication server has sent to the replication agent.
Blocks acknowledged The number of AI block acknowledgments that the replication server has received from the replication agent.
Synchronization points The number of synchronization points established by the replication agent.
AI Block Information Shows information related to most recent AI block write on the source database and most recent AI block transmission to the replication agent.
Current RDBMS Block (Seq / Block)
  • Current RDBMS Block Seq—The sequence number of AI extent containing the AI block that is currently being written to the source database.
  • Current RDBMS Block—The AI block number that is currently being written to the source database.
Last Sent Block (Seq / Block)
  • Last Sent Block Seq—The sequence number of AI extent containing the last AI block that was sent to the replication agent.
  • Last Sent Block—The block number of last AI block that was sent to the replication agent.
Server to agent load check interval Specifies the request-agent-ack-interval value for this [control-agent] in the repl.properties file.
Time between server and agent load checks The average time, measured in seconds, between AIBLOCK messages sent to the replication agent with a request for acknowledgment.

This only applies when the control agent in consideration has request-agent-ack enabled.
Time taken to respond to load check The average time, measured in seconds, between when the replication server sends the replication agent an AIBLOCK message with request for acknowledgment and when the replication agent responds with acknowledgment.

This only applies when the control agent in consideration has request-agent-ack enabled.
Port The TCP listening port of the replication agent.
Last message was received at The date and time when the last message was received from the replication agent.
Connection state The network communication status of the replication server with the replication agent. Valid values are:
  • Connected
  • Disconnected
  • Listening
If the replication server is not running when the replication server status monitor screen is displayed for the first time, the replication server data is not displayed and replaced with the following message: 
Database is not running as a OpenEdge Replication source
If the replication server is not running when the replication server status monitor screen is refreshed, the replication server data is not displayed and replaced with the following message:
Cannot obtain server information. Quitting.