Replication agent status

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

Figure 1. OpenEdge Replication agent status screen
OpenEdge Replication Monitor                  Page 1
Database:  /scratch/doc/120/demo/repl2

    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:            8496
    Server/Agent connection time:               Tue May 15 18:08:41 2018
    Delay Interval (current / min / max):       10 / 5 / 500
    Transition information:
        Type:                                   Manual
    The last block received at:                 Tue May 15 18:16:40 2018
    Activity information:
        Blocks received:                        1857
        Blocks processed:                       1858
        Blocks acknowledged:                    0
        Notes processed:                        184042
        Transactions started:                   0
        Transactions ended:                     0
        Synchronization points:                 29
    AI Block Information:
        Source RDBMS Block (Seq / Block):       4 / 6905
        Last Received Block (Seq / Block):      4 / 6884
        Last Processed Block (Seq / Block):     4 / 6884
    Latency Information:
        Repl Server behind Source DB by:        0     second(s)
        Current Source Database Transaction:    2303
        Last Transaction Applied to Target:     2303
        Target Current as of (Target, Source):  Tue May 15 18:15:58 2018, Tue May 15 18:15:58 2018 with delta of 000:00:00
        Number of blocks to send on Source:     0 as of Tue May 15 18:16:40 2018
        Number of blocks to process on Target:  0 as of Tue May 15 18:16:40 2018
        Time delay to process the last block:   0 second(s)
    Connect timeout:                            1800
    Listener port range:                        1025-65500
    Current listener port:                      1037
    Additional transition information:
        Replication set:                        1
        Database role:                          Reverse
        Transition to agents:                   agent1,agent2
        Recovery transition to agents:
        Restart after transition:               1
        Automatically begin AI:                 ?
        Automatically add AI areas:             1
        AI structure file:                      addai.st
        Backup method:                          Full-offline
        Transition end trigger:                 0
        AI Streaming enabled:                   1
        Apply Streaming Data:                   1
    Replication streaming block cache:
        Cache size:                             1000
        Free cache entries:                     999
        Used cache entries:                     1
        Cache high water mark:                  175
        Number of times cache filled:           0

As shown in the previous figure, 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 the table that follows.

Table 1. Replication Agent Status details
Field Description
Database is enabled as OpenEdge Replication Indicates whether the database is enabled as a replication source or a 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 the agent are performing normal processing.
  • Initial connection — The agent is waiting for initial connection from server.
  • Startup synchronization — The server and the agent are synchronizing.
  • Initialization — The agent is being initialized by the server.
  • Initial connection failed — The server could never connect to an agent.
  • Invalid target database configuration — Something in the target database does not match the source.
  • Agent terminated — The target database shut down or the 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 Shows whether the remote agent is a critical agent (Yes) or is not (No).
Method Lists the replication method: asynchronous.
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
  • Encryption objects — For an encrypted database, the agent's wait status, or what the agent is waiting for
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 Received Block (Seq / Block) Provides the AI location, defined by AI sequence number and AI block number, of the last block received by the replication agent.
Last Processed Block (Seq / Block) Provides the AI location, defined by AI sequence number and AI block number, of the last processed block by the replication agent.
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.
Number of blocks to send on Source Provides the number of AI blocks to send on the source database.
Number of blocks to process on Target Provides the number of AI blocks to process on the target database.
Time delay to process the last block Provides the time it takes for an AI block to be processed by the agent after it has been received.
Connect timeout Number of seconds during which agent attempts to reconnect to server.
Listener port range Range of ports for agent
Current listener port Current port in use
Replication set Set to 1 if Replication set is enabled, 0 otherwise.
Database role Role of agent database in transition
Transition to agents Displays the names of the agents for transition. If the next line (Recovery transition to agents) is set, this field represents the agent list for failover transition; if not set, this line represents the agent list for both failover and recovery transition. If replication-set=1, the first agent in this is selected to become the new source.
Recovery transition to agents Displays the names of the agents for recovery transition.
Restart after transition Indicates if restart should occur after transition. Set to 1 for yes, 0 for no.
Automatically begin AI For replication set only, indicates if after-imaging should automatically be started on transition. Set to 1 to begin after-imaging, 0 to not.

If replication set is not enabled, set to the unknown value, "?"
Automatically add AI areas Indicates if after-image areas should be automatically added to the target database that is transitioning to a source. Set to 1 to add after-image areas, 0 not to add AI.
AI structure file The name of the structure file to use if automatically adding AI areas.

If Automatically add AI is not enabled, set to the unknown value, "?"
Backup method The backup method for database during transition. Valid entries include:
  • Full-offline
  • Full-online
  • Mark
Transition end trigger Indicates if a transition end trigger should run at the end of transition. Set to 1 to indicate the trigger property is enabled, and set to 0 to indicate no transition end trigger.
AI Streaming enabled Indicates if Replication AI Streaming is enabled. 1 indicates enabled, 0 indicates not enabled.
Apply Streaming Data If Replication AI Streaming is enabled, indicates how to treat data in the RSB cache during auto transition. 1 indicates that data in the RSB cache is applied before transition; 0 indicates that data in the RSB cache is not applied before auto transition.
Replication streaming block cache Shows a group of related information about the cache for Replication AI Streaming.
Cache size Displays the cache size in units of Replication Streamed Blocks (RSB).
Free cache entries Displays the number of free cache entries in the RSB cache.
Used cache entries Displays the number of used cache entries in the RSB cache.
Cache high water mark Displays the maximum number of cache entries that have been in use at one point in the life cycle of the cache.
Number of times cache filled Displays the number of times the RSB cache has filled.