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:               Thu May 30 18:08:41 2024
    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:                 Thu May 30 18:16:40 2024
    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):  Thu May 30 18:15:58 2024, 
Thu May 30 18:15:58 2024 with delta of 000:00:00
        Number of blocks to send on Source:     0 as of Thu May 30 18:16:40 2024
        Number of blocks to process on Target:  0 as of Tue May 30 18:16:40 2024
        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
    SSL properties:
        SSL Enabled:                                Yes
        SSL No Host Verify:                         Yes
        SSL Key Alias:                              repltest
        SSL Key Alias Password:                     12345f6d23456789
        SSL Key Store Path:                         /bigdisk/jlopez/REPLSETUP_1TARG/keys
        SSL Cert Store Path:                        /bigdisk/jlopez/REPLSETUP-1TARG/certs
        SSL Cipher Suites:                          AES128-SHA256,AES256-SHA256,
DHE-RSA-AES256-GCM-SHA384
        SSL Protocols:                              TLSv1.1,TLSv1.2,TLSv1.3

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. The 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 include:
  • 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.
  • Newest Encryption Keystore—For an encrypted target database, this value indicates that the replication agent is waiting for the newest keystore to materialize on disk. The source database generates the new keystore using the following operations:

    • Enable HSM feature

    • Disable HSM feature

    • Disable TDE DB Policy Management feature

    • Epolicy manage dbpolicy rekey

    • Epolicy manage dbpolicy rekey pending

    • Epolicy manage dbpolicy activate
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.
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.

For more information, see Understand automatic transition with AI Streaming .
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 The 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.
SSL properties Shows SSL properties for the replication agent.
SSL Enabled

OpenEdge Replication SSL use enabled.

Valid values are:

  • Yes—OpenEdge Replication SSL enabled
  • No—OpenEdge Replication SSL not enabled
SSL No Host Verify

OpenEdge Replication SSL no-host-verification enabled.

Valid values are:

  • No— OpenEdge Replication SSL no-host-verification not enabled
  • Yes—OpenEdge Replication SSL no-host-verification enabled
SSL Key Alias Key alias of the SSL key that is used with OpenEdge Replication SSL.

Displays ? if the key-alias property is not set in the repl.properties file.
SSL Key Alias Password Key alias password of the SSL key that is used with OpenEdge Replication SSL.

Displays ? if the key-store-password property is not set in the repl.properties file.

Note: The value of this field is encrypted to avoid exposing the actual password to unauthorized viewers of the VST.
SSL Key Store Path Absolute path of the directory containing the SSL key and the certificate for OpenEdge Replication SSL.

Displays ? if the key-store-path property is not set in the repl.properties file.
SSL Cert Store Path For an SSL client, the absolute path of the directory containing the SSL certificate for OpenEdge replication SSL.

Displays ? if the cert-store-path property is not set in the repl.properties file.
SSL Cipher Suites

A comma-separated list of the SSL cipher suites that can be used for any OpenEdge Replication SSL network connections for the replication database.

Valid values are:
  • AES128-SHA256
  • AES256-SHA256
  • DHE-RSA-AES256-GCM-SHA384

Displays ? if the cipher-suites property is not set in the repl.properties file.
SSL Protocols

A comma-separated list of the SSL protocol versions that are compatible with any OpenEdge Replication SSL network connections for the replication database.

Valid values are:
  • TLSv1.1
  • TLSv1.2
  • TLSv1.3

Displays ? if the ssl-protocols property is not set in the repl.properties file.
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.