Try OpenEdge Now
skip to main content
User Guide
Reference : OpenEdge Replication DSRUTIL MONITOR : Replication agent status
 

Replication agent status

If you select the Replication agent status from the Startup Menu of the DSRUTIL Monitor Utility, the screen shown in the following figure appears.
Figure 38. OpenEdge Replication agent status screen
OpenEdge Replication Monitor Page 1
Database: C:\OE117WRK\repl2

Database is enabled as OpenEdge Replication: Target

Agent:
Name: agent1
ID: 1
Host name: 127.0.0.1
State: Normal Processing
Ready: Yes
Critical: No
Method: Synchronous
Agent is waiting for: Nothing
Maximum bytes in TCP/IP message: 8512
Server/Agent connection time: Tue Jan 31 10:14:15 2017
Delay Interval (current / min / max): 265 / 5 / 500
Transition information:
Type: Manual
The last block received at: Tue Jan 31 10:14:18 2017
Activity information:
Blocks received: 497
Blocks processed: 497
Blocks acknowledged: 495
Notes processed: 30317
Transactions started: 1
Transactions ended: 1
Synchronization points: 8
AI Block Information:
Source RDBMS Block (Seq / Block): 3 / 313
Last Processed Block (Seq / Block): 3 / 313
Latency Information:
Repl Server behind Source DB by: 0 second(s)
Current Source Database Transaction: 53
Last Transaction Applied to Target: 53
Target Current as of (Target, Source): Fri Jan 27 10:57:55 2017, Fri Ja
27 10:57:55 2017 with delta of 000:00:00
Connect timeout: 1800
Listener port range: 1025-65500
Current listener port: 1025
Additional transition information:
Replication set: 1
Database role: Reverse
Transition to agents: agent1,agent2
Restart after transition: 1
Automatically begin AI: 1
Automatically add AI areas: 1
AI structure file: addai.st
Backup method: Full-offline

As shown in the previous figure, the first two lines of the Replication agent status screen are the utility title line and the fully qualified name of the database specified by the user.
When you use the Monitor utility for the agent on an encrypted target database, the utility displays the agent's wait status, as shown in the line in bold in the previous figure.
The remaining lines of the Replication Agent Status screen are defined in the table that follows.
Table 23. Replication Agent Status details
Field
Description
Database is enabled as OpenEdge Replication
Indicates whether the database is enabled as a replication source or a target.
Agent
Lists basic remote agent information.
Name
Lists the name of the remote agent.
ID
Lists the remote agent identification number.
Host name
Lists the host on which the target database associated with the remote agent resides.
State
Shows agent processing information:
*Normal processing — The server and the agent are performing normal processing.
*Initial connection — The agent is waiting for initial connection from server.
*Startup synchronization — The server and the agent are synchronizing.
*Initialization — The agent is being initialized by the server.
*Initial connection failed — The server could never connect to an agent.
*Invalid target database configuration — Something in the target database does not match the source.
*Agent terminated — The target database shut down or the agent terminated using Terminate agent.
*Online backup of Target Database — An online target database backup is being performed.
*Recovery synchronization — Recovery synchronization is being performed.
*Recovery failed — Failure recovery was unsuccessful.
*Unknown — The agent is in an unknown state.
Critical
Shows whether the remote agent is a critical agent (Yes) or is not (No).
Method
Lists the replication method: asynchronous or synchronous.
Agent is waiting for
Shows why the agent might be waiting. The field value might be one of the following:
*Nothing — Indicates no waiting is taking place
*Schema lock request — Indicates the server is waiting for the agent to acquire the schema lock so the database schema can be changed
*Encryption objects — For an encrypted database, the agent's wait status, or what the agent is waiting for
Maximum bytes in TCP/IP message
Shows the maximum number of bytes used for the TCP/IP communication messages.
Server/Agent connection time
Shows the date and time at which the server and agent connected.
Delay Interval (current / min / max)
Shows the amount of time, in milliseconds, the agent will wait between polling the TCP/IP connection for information to be replicated. Current is the current value, min is the minimum value, and max is the maximum value. Polling is used to increase the performance of the server, and the wait is used to limit the amount of overhead when no data is available to be replicated.
Transition information
Shows a group of remote agent-related transition information.
Type
Shows the type of transition to be performed:
*Manual — Indicates intervention is required to complete the transition of a target database to a normal OpenEdge database
*Automatic — Indicates a transition from a target database to a normal OpenEdge database will take place without intervention
The last block received at
Shows the date and time the last block was sent to the agent.
Activity information
Shows a selection of activity information.
Blocks received
Shows the number of blocks received from the server.
Blocks processed
Shows the number of blocks processed.
Blocks acknowledged
Shows the number of blocks acknowledged.
Notes processed
Shows the number of AI transaction notes processed by the agent.
Transactions started
Shows the number of transactions started on the agent.
Transactions ended
Shows the number of transactions completed on the agent.
Synchronization points
Shows the number of synchronization points that have occurred.
AI Block Information
Identifies the current AI block that is being written by the source database and provides the last AI block that was sent by Replication.
Source RDBMS Block (Seq / Block)
Provides the current source database block that the OpenEdge Replication agent is processing.
Last Processed Block (Seq / Block)
Provides the last source database block that the OpenEdge Replication agent processed.
Latency Information
Provides latency information that shows how far behind OpenEdge Replication is in updating the target database. This is important if the target database is transitioned due to source database failure.
Repl Server behind Source DB by
Provides the number of seconds the OpenEdge Replication server is behind the source database.
Current Source Database Transaction
Provides the current source database transaction that the OpenEdge Replication agent is processing.
Last Transaction Applied to Target
Provides the last source database transaction that was applied to the target database.
Target Current As Of
Provides the date of the last transaction applied to the target database by the OpenEdge Replication agent based on source database time.
Connect timeout
Number of seconds during which agent attempts to reconnect to server.
Listener port range
Range of ports for agent
Current listener port
Current port in use
Replication set
Set to 1 if Replication set is enabled, 0 otherwise.
Database role
Role of agent database in transition
Transition to agents
List of agents to transition to
Restart after transition
Indicates if restart should occur after transition. Set to 1 for yes, 0 for no.
Automatically begin AI
For replication set only, indicates if after-imaging should automatically be started on transition. Set to 1 to begin after-imaging, 0 to not.
If replication set is not enabled, set to the unknown value, "?"
Automatically add AI areas
Indicates if after-image areas should be automatically added to the target database that is transitioning to a source. Set to 1 to add after-image areas, 0 not to add AI.
AI structure file
The name of the structure file to use if automatically adding AI areas.
If Automatically add AI is not enabled, set to the unknown value, "?"
Backup method
The backup method for database during transition. Valid entries include:
*Full-offline
*Full-online
*Mark