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