Progress Fathom Replication
User’s Guide


Replication Remote Agents Status

If you select the Replication Remote Agents Status from the Startup Menu of the DSRUTIL Monitor Utility, the screen shown in Figure 3–4 appears.

Site Replication Monitor Version 2     Page 1 
     Database: /twoagent/sdb 
     Agent: 
        Name:                                   agent2 
        ID:                                     2 
        Host name:                              localhost 
        Target database:                        tdbb 
        State:                                  Normal processing 
        Critical:                               No 
        Method:                                 Asynchronous 
        Remote agent is:                        Connected via broker 
                                  Source and target are synchronized 
                                             In normal processing 
    Remote agent is waiting for:             Nothing 
    Recovery state:                          No recovery being performed 
    Maximum bytes in TCP/IP message:         30720 
    Server/Agent connection time:            Fri Jul 26 14:50:58 2002 
    Server/Agent connection timeout:         120.000 seconds 
    Transition information: 
        Type:                                Manual 
        Timeout limit:                       0 seconds 
    The last block was sent at:              Fri Jul 26 14:57:42 2002 
    Activity information: 
        Blocks sent:                         720 
        Blocks acknowledged:                 28 
        Synchronization points               12 
     AI Block Information: 
        Current RDBMS Block (Seq / Block):   5 / 1923 
        Last Sent Block (Seq / Block):       5 / 1923 
    Server to agent load check interval:     10 blocks 
    Time between server and agent load checks:  5.597 seconds 
    Time taken to respond to load check:        0.178 seconds 
RETURN - repeat, U - continue uninterrupted, Q - quit: 

Figure 3–4: Replication Remote Agents Status display

As shown in Figure 3–4, 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 Table 3–8.

Table 3–8: Replication Remote Agents Status
Field
Description
Agent 
Shows a group of basic remote agent information.
Name 
Shows the name of the remote agent.
ID 
Shows the remote agent identification number.
Host name 
Shows the host on which the target database associated with the remote agent resides.
Target database 
Shows the name of the database associated with the remote agent.
State 
Shows information about what the server knows about the remote agent:
  • Normal processing — Indicates the server and agent are performing normal processing.
  • Initial connection — Indicates agent is waiting for initial connection from server.
  • Startup synchronization — Indicates the server and agent are synchronizing.
  • Initialization —I ndicates agent is being initialized by server.
  • Initial connection failed — Indicates server could never connect an agent.
  • Invalid target database configuration — Indicates something in the target database does not match the source.
  • Agent terminated — Indicates target database shutdown or agent terminated using Terminate agent.
  • Recovery synchronization — Indicates recovery synchronization is being performed.
  • Recovery failed — Indicates failure recovery failed.
  • Unknown — Indicates an unknown state.
Critical 
Shows whether the remote agent is a critical agent (Yes) or not critical (No).
Method 
Shows the replication method: asynchronous or synchronous.
Remote agent is waiting for 
Shows why the agent might be waiting. It 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.
Recovery state 
Shows where the server and agent are in the failure recovery process. It can be one of the following:
  • Failed for the agent — Indicates failure recovery could not be completed for the agent.
  • No recovery being performed — Indicates there is currently no failure recovery being done.
  • Just entered recovery — Indicates the server has just started failure recovery, and will determine which remote agents remain connected and which must be reconnected.
  • Server attempting connection — Indicates the server is attempting to connect to those remote agents no longer communicating to the server.
  • Initialize synchronization with agents — Indicates the server is initializing the agent failure recovery synchronization.
  • Synchronizing agents — Indicates the connected agents are in the process of being brought up to date with the database changes made to the source database.
  • Recovery complete — Indicates the failure recovery of all connected agents has been completed.
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.
Server/Agent connection 
timeout 
Shows the number of seconds the Fathom Replication server will attempt to connect to the agent.
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 Progress database.
  • Automatic — Indicates a transition from a target database to a normal Progress database will take place without intervention.
Timeout limit 
Shows the maximum amount of time that will elapse before the transition of a target database to a normal Progress database. Shown for automatic transition only.
The last block was sent at 
Shows the date and time the last block was sent to the agent.
Activity information 
Shows a group of activity information.
Blocks sent 
Shows the number of blocks sent to the agent.
Blocks acknowledged 
Shows the number of blocks acknowledged by the agent.
Synchronization points 
Shows the number of synchronization points that have occurred.
AI Block Information 
Provides latency information that shows how far behind Fathom Replication is in updating the target database. This is important if the target database is transitioned due to source database failure.
Current RDBMS Block (Seq / 
Block) 
Shows the current RDBMS AI block.
Seq is the AI extent sequence number. It can be viewed using RFUTIL LIST.
Last Sent Block (Seq / 
Block) 
Shows the last AI block that was sent to the Fathom Replication agent.
Server to agent load check 
interval 
Shows the number of blocks the server will send to the agent, at which point the server will wait for an acknowledgement from the agent for the block just sent.
Time between server and 
agent load checks 
Shows the average elapsed time between the load checks.
Time taken to respond to 
load check 
Shows the average elapsed time the agent took to acknowledge the server for the block just sent.


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095