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