Progress Fathom Replication
User’s 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 3–5 appears.

>     Site Replication Monitor Version 2     Page 1
>          Database: /twoagent/tdba
>          Database is enabled as Fathom Replication: Target
>        Agent:
>        Name:                                   agent1
>        ID:                                     1
>        Host name:                              localhost
>        State:                                  Normal processing
>        Critical:                               No
>        Method:                                 Asynchronous
>        Agent is waiting for:                   Nothing
>        Maximum bytes in TCP/IP message:        30720
>        Server/Agent connection time:           Fri Jul 26 14:50:56 2002
>        Delay Interval (current / min / max):   5 / 5 / 500
>        Transition information:
>         Type:                                   Manual
>         Timeout limit:                          600 seconds
>         Time remaining before transition:       600 seconds
>         The last block received at:                 Fri Jul 26 14:56:43 2002
>        Activity information:
>         Blocks received:                        192
>         Blocks processed:                       192
>         Blocks acknowledged:                    8
>         Notes processed:                        14557
>         Transactions started:                   565
>         Transactions ended:                     565
>         Synchronization points:                 3
>        AI Block Information:
>         Source RDBMS Block (Seq / Block):       5 / 1923
>         Last Processed Block (Seq / Block):     5 / 1923
>        Latency Information:
>         Repl Server behind Source DB by:        0 second(s)
>         Current Source Database Transaction:    32898
>         Last Transaction Applied to target:     32898
>         Target Current_As_Of
>     RETURN - repeat, U - continue uninterrupted, Q - quit:

> Figure 3–5: Replication Agent Status Display

> As shown in Figure 3–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 3–9.

> Table 3–9: Replication Agent Status
> Field | Description
> --- | ---
>     Database is enabled as
>     Fathom Replication
> | Indicates whether the database is enabled as a replication Source or Target.
>     Agent
> | Lists a group of 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 — Indicates the server and agent are performing normal processing. Initial connection — Indicates agent is waiting for initial connection from server. Startup synchronization — Indicated the server and agent are synchronizing. Initialization — Indicates 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
> | 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. 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.
>     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 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.
>     Time remaining before
>     transition
> | Shows the amount of time remaining before a transition of the database will occur.
>     The last block received at
> | Shows the date and time the last block was sent to the agent.
>     Activity information
> | Shows a group 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
> | 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.
>     Source RDBMS Block (Seq /
>     Block)
> | Provides the current source database block that the Fathom Replication agent is processing.
>     Last Processed Block (Seq /
>     Block)
> | Provides the last source database block that the Fathom Replication agent processed.
>     Latency 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.
>     Repl Server behind Source DB
>     by
> | Provides number of seconds the Fathom Replication server is behind the source database.
>     Current Source Database
>     Transaction
> | Provides the current source database transaction that the Fathom 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 Fathom Replicationagent based on source database time.

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