Release 10.1C: OpenEdge Replication:
User Guide


Replication agent status

If you select the Replication agent status from the Startup Menu of the DSRUTIL Monitor Utility, the screen shown in Figure 5–5 appears.

OpenEdge Replication Monitor                  Page 1 
    Database:  /vobs_repl/solaris/bin/ks2 
    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:                                 Asynchronous  
    Agent is waiting for:                       Nothing 
    Maximum bytes in TCP/IP message:            8500 
    Server/Agent connection time:               Mon Nov 26 15:10:12 2007 
    Delay Interval (current / min / max):       5 / 5 / 500 
    Transition information: 
        Type:                                   Manual 
    The last block received at:                 Mon Nov 26 15:11:23 2007 
    Activity information: 
        Blocks received:                        493 
        Blocks processed:                       493 
        Blocks acknowledged:                    19 
        Notes processed:                        32972 
        Transactions started:                   505 
        Transactions ended:                     504 
        Synchronization points:                 8 
    AI Block Information: 
        Source RDBMS Block (Seq / Block):       2 / 5778 
        Last Processed Block (Seq / Block):     2 / 5734 
    Latency Information: 
        Repl Server behind Source DB by:        0     second(s) 
        Current Source Database Transaction:    25426 
        Last Transaction Applied to Target:     25405 
        Target Current as of (Target, Source):  Mon Nov 26 15:11:23 2007, Mon 
Nov 26 15:11:23 2007 with delta of 000:00:00  

Figure 5–5: OpenEdge Replication agent status screen

As shown in Figure 5–5, 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.

The remaining lines of the Replication Agent Status screen are defined in Table 5–12.

Table 5–12: Replication Agent Status details
Field
Description
Database is enabled as 
OpenEdge Replication 
Indicates whether the database is enabled as a replication source or 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 agent are performing normal processing.
  • Initial connection — The agent is waiting for initial connection from server.
  • Startup synchronization — The server and agent are synchronizing.
  • Initialization — The agent is being initialized by the server.
  • Initial connection failed — The server could never connect an agent.
  • Invalid target database configuration — Something in the target database does not match the source.
  • Agent terminated — The target database shut down or 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 
Lists whether the remote agent is a critical agent (Yes) or 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
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.


Copyright © 2008 Progress Software Corporation
www.progress.com