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
        Timeout limit:                          88090 seconds
        Time remaining before transition:       24 Hr 28 Min 6 Sec
    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 Database replication role. Valid value is:
  • Target
Agent

Shows information related to replication agent operational state and configuration.
Name The name of the replication agent as configured in the repl.properties file.
ID The replication agent ID as assigned by the replication server.
Host name The name of the host where the replication server is running.
State Replication agent state. Valid values are:
  • Terminating
  • In Normal Processing
  • In Synchronization Processing
  • In Forced Transition
  • In Pre-Transition
  • Ready For Manual Transition

  • In Online Backup

  • Applying extent

  • Listening

  • Wait Resolve JTA

  • Connection Failed

  • In Startup Synchronization

  • In Recovery Synchronization

  • Being Transitioned

  • Unknown
Ready Replication agent ready status. Valid values are:
  • No — Not ready
  • Yes — Ready
Critical Critical agent flag. Valid values are:
  • Yes—Critical
  • No—Not critical

For more information, see Designate a critical agent.
Method The type of replication that is being performed with the replication agent. Valid value is : Asynchronous.
Note: Asynchronous replication is the only supported replication method. Synchronous replication is no longer supported.
Agent is waiting for Specifies what the replication agent is waiting for. Valid values are:
  • Nothing — Indicates no waiting is taking place.
  • Schema lock request — Indicates that the replication agent is waiting for the exclusive schema lock on the target database.
  • Encryption objects — For a newly enabled encrypted database, this value indicates the replication agent is waiting for the encryption area and encryption key-store file to materialize on disk.
  • Schema Object state change — Indicates replication agent is waiting for no-lock readers to see the latest OM cache changes from a transaction involving updates to database schema objects.
Maximum bytes in TCP/IP message Maximum number of bytes in a TCP message.
Server/Agent connection time The date and time when the replication server successfully connected to the replication agent.
Delay Interval (current / min / max)
  • Current delay interval—Current message polling delay interval (in seconds)
  • Minimum delay interval—Minimum message polling delay interval (in seconds).
  • Maximum delay interval— Maximum message polling delay interval (in seconds).
Transition information Shows information related to replication transition.
Type

Specifies whether the replication agent will perform recovery transition automatically, or with manual intervention. Valid values are:

  • Manual —Specifies that manual intervention is required to complete the transition of a target database to its new replication role.
  • Automatic —Specifies that the transition from a target database to its new replication role will take place automatically upon expiration of the transition timeout limit.
Timeout limit The time (in seconds) that the replication agent waits for reconnection with replication server, before automatically starting recovery transition.
Note: This line appears in the monitor display only when the transition Type is Automatic.
Time remaining before transition The time (in HH:MM:SS) remaining before automatic recovery transition.

For more information, see Understand automatic transition with AI Streaming.

Note: This line appears in the monitor display only when the transition Type is Automatic and the replication agent is in the pre-transition state.
The last block received at The date and time when the replication agent last received an after-image (AI) block from the replication server.
Activity information Shows information related to AI block processing on the target database.
Blocks received The number of AI blocks that the replication agent has received from the replication server.
Blocks processed The number of AI blocks that the replication agent has applied to the target database.
Blocks acknowledged The number of AI block acknowledgements that the replication agent has sent to the replication server.
Notes processed The number of AI notes that the replication agent has applied to the target database.
Transactions started The number of transaction begin notes that have been applied to the target database by the replication agent.
Transactions ended The number of transaction end notes that have been applied to the target database by the replication agent.
Synchronization points The number of synchronization points that the replication agent has established with the replication server.
AI Block Information Shows information related to most recent AI block write on the source database and most recent AI note application on the target database.

Displays as Not yet Available if the replication agent has not yet received the AI note bootstrap information message from the replication server during startup synchronization.
Source RDBMS Block (Seq / Block)
  • Source RDBMS Block Seq—The sequence number of the AI extent containing the AI block being written to on the source database during forward processing of transactions at the time the replication server last assembled an AIBLOCK message for transmission to the replication agents.
  • Source RDBMS Block—The block number of the AI block being written to the source database during forward processing of transactions at the time the replication server last assembled an AIBLOCK message for transmission to the replication agents.
Last Received Block (Seq / Block)
  • Last Received Block Seq—The sequence number of the AI extent containing the last AI block received by the replication agent.
  • Last Received Block—The block number of the last AI block received by the replication agent.
Last Processed Block (Seq / Block)
  • Last Processed Block Seq—The sequence number of the AI extent containing the most recent AI note that the replication agent began applying to the target database.
  • Last Processed Block—The block number of the AI block containing the most recent AI note that the replication agent began applying to the target database.
Latency Information Shows information on replication latency, indicating how far behind replication is from the forward processing of transactions on the source database.

The monitor displays this section only if the replication agent has received the AI note bootstrap information message from the replication server during startup synchronization.
Repl Server behind Source DB by
Provides, in seconds, the difference between:
  • Time of note creation, during forward processing of transactions on the source database, of last transaction end, global transaction end, or AI extent switch note that was applied to the target database by the replication agent.
  • The last time an AI block was filled and sent to the PICA queue of the source database (factoring in the potential waiting time for a free plugin communication area (PICA) queue message entry) at the point when the replication server last assembled an AIBLOCK message for transmission to the replication agents.
Displays as 0 when any of the following conditions are met:
  • The replication agent has not yet received an AIBLOCK message from the replication server.
  • The replication agent has not yet started to apply a transaction end, global transaction end, or AI extent switch note.
  • The last transaction begin or global transaction begin note that the replication agent has applied to the target database is from the last transaction started on the source database at the time the last AIBLOCK message was assembled for transmission to the replication agent.
  • The replication agent has not yet fully applied a transaction end, or global transaction end note.
  • The last AI block processed by the replication agent is the last AI block that was written to on the source database, at the time the last AIBLOCK message was assembled for transmission to the replication agent.

Displays as Not available during Startup Synchronization when the replication agent is in the startup synchronization state.
Current Source Database Transaction The Transaction ID (TRID) of the last transaction started on the source database at the time the replication server last assembled an AIBLOCK message for transmission to the replication agents.
Last Transaction Applied to Target TRID of the last transaction begin note that was applied to the target database by the replication agent.
Target Current As Of (Target, Source)
  • Target—Date and time of note creation during forward transaction processing on the source database, of the last transaction end, global transaction end, or AI extent switch note applied to the target database by the replication agent.
  • Source—An approximate date and time on the target database when the replication agent applied the last transaction end, global transaction end, or AI extent switch note.
  • Delta—The approximate time it takes for the replication server to transmit network messages and the replication agent to process them.
Number of blocks to send on Source The count of AI Blocks in the PICA queue on the source database at the time the replication server last assembled an AIBLOCK message for transmission to the replication agents.
Number of blocks to process on Target The number of RSB cache entries currently in use
Time delay to process the last block The time difference, measured in seconds, between when the replication agent last received a timestamped AI block and when it began processing the AI notes in the block.
Connect timeout The connect timeout of the replication agent. The replciation agent waits for this many seconds for the initial network connection request from the replication server before shutting itself down.
Listener port range

The range of ports that the replication agent may use as a TCP listening port.
Current listener port The TCP listening port of the replication agent.
Additional transition information Shows additional information related to replication transition.
Replication set Replication set enabled. Valid values are:
  • 0—Replication set not enabled
  • 1—Replication set enabled
Database role The role database takes after transition.

Valid values are:

  • Normal
  • Reverse
Transition to agents Transition to agents list.
Recovery transition to agents Recovery transition to agents list.
Restart after transition Specifies whether database broker is started after transition.
Valid values are:
  • 0—Database broker is not started after transition.
  • 1—Database broker is started after transition.
Automatically begin AI

Specifies whether after-imaging is automatically started during transition.

Valid values are:
  • 0—After-imaging is not automatically started during transition.
  • 1—After-imaging is automatically started during transition.

Displays ? when replication set is enabled.
Automatically add AI areas Specifies whether AI extents are automatically added during transition.
Valid values are:
  • 0—AI extents are not automatically added during transition.
  • 1—AI extents are automatically added during transition.
AI structure file Filename of structure file specifying AI extents to be added automatically during transition.

Displays as ? when not automatically adding AI extents during transition.
Backup method The database backup method used during transition. Valid values are:
  • Full-offline
  • Full-online
  • Mark
Transition end trigger
Specifies whether to run a custom defined script at the end of a transition. Valid values are:
  • 0—Do not run a custom defined script at the end of a transition.
  • 1—Run a custom defined script at the end of a transition.
AI Streaming enabled AI streaming enabled. Valid values are:
  • 0 — AI Streaming not enabled
  • 1 — AI Streaming enabled
Apply Streaming Data Specifies whether AI Streaming data in RSB cache is applied to target database prior to auto-transition.
  • 0 — Do not apply data
  • 1 — Apply data
Replication streaming block cache Shows information related to the RSB cache for AI streaming replication.
Cache size Total number of entries in the Replication Streaming Block cache in units of Replication Stream Blocks (RSB).

Displays N/A when AI Streaming is not enabled.
Free cache entries Free cache entries in the Replication Streaming Block cache in units of RSBs.

Displays N/A when AI Streaming is not enabled.
Used cache entries Used cache entries in the Replication Streaming Block cache in units of RSBs.

Displays N/A when AI Streaming is not enabled.
Cache high water mark

The maximum number of RSB cache entries that have been in use at any one point in the life cycle of the cache.

Displays N/A when AI Streaming is not enabled.
Number of times cache filled The number of times the RSB cache has filled.

Displays N/A when AI Streaming is not enabled.
If the replication agent is not running when the replication agent status monitor screen is displayed for the first time, the replication agent data is not displayed and replaced with the following message: 
Database is not running as a OpenEdge Replication target
If the replication agent is not running when the replication agent status monitor screen is refreshed, the replication agent data is not displayed and replaced with the following message: 
Cannot obtain agent information. Quitting.