Replication agent status

If you select the Replication agent status from the Startup menu of the DSRUTIL Monitor Utility, the Figure 1 is displayed.

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
    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 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 the 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 not 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—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 that no waiting is taking place
  • Schema lock request—Indicates that 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 that intervention is required to complete the transition of a target database to a normal OpenEdge database
  • Automatic—Indicates that 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 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 a source database failure.
Repl Server behind Source DB by Provides, in seconds, the difference between the Target Current As Of field and the timestamp of the last AI block flush on the source database, at the time when the last AI block was sent from the replication server to the replication agent.
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 was received.
Connect timeout Number of seconds during which the agent attempts to reconnect to the server.
Listener port range Range of ports for the 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, then this field represents the agent list for failover transition. If not set, then this line represents the agent list for both failover and recovery transition. If replication-set=1, then the first agent in this list is selected to become the new source.
Recovery transition to agents Displays the names of the agents for recovery transition.
Restart after transition Indicates whether a restart should occur after transition. Set to 1 for yes or 0 for no.
Automatically begin AI For the replication set only, indicates whether after-imaging should automatically be started on transition. Set to 1 to begin after-imaging, or 0 to not.

If the replication set is not enabled, set to the unknown value, "?"
Automatically add AI areas Indicates whether 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 or 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, then set to the unknown value, "?"
Backup method The backup method for the database during transition. Valid entries include:
  • Full offline
  • Full online
  • Mark
Transition end trigger Indicates whether a transition end trigger should run at the end of transition. Set to 1 to indicate that the trigger property is enabled, and set to 0 to indicate that there is no transition end trigger.
AI Streaming enabled Indicates whether Replication AI Streaming is enabled. 1 indicates enabled; 0 indicates not enabled.
Apply Streaming Data If Replication AI Streaming is enabled, then this field indicates how to treat data in the RSB cache during automatic 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 automatic 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 were 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 filled.
SSL Enabled
Specifies if SSL use is enabled for the replication database.
  • 0—SSL use is disabled. This is the default.
  • 1—SSL use is enabled.

The property affects all replication processes that can run against the replication database.
SSL No Host Verify

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

Supported SSL protocols are:
  • TLSv1.1
  • TLSv1.2
  • TLSv1.3
SSL Key Alias For an SSL server, the key-alias of the SSL key that will be used in OpenEdge Replication SSL.
SSL Key Alias Password For an SSL server, the key-alias-password of the SSL key that is used in OpenEdge Replication SSL. The value of this property is encrypted to avoid exposing the actual password to unauthorized viewers of the properties file. You can generate the encrypted form of the password using the genpassword utility.
SSL Key Store Path For an SSL server, the absolute path of the directory containing the SSL key and certificate for OpenEdge Replication SSL.
SSL Cert Store Path For an SSL client, the absolute path of the directory containing the SSL certificate for OpenEdge Replication SSL.
SSL Cipher Suites

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

Cipher suites are:
  • AES128-SHA256
  • AES256-SHA256
  • DHE-RSA-AES256-GCM-SHA384
SSL Protocols

A comma separated list of the SSL protocol versions that may be used for any OpenEdge Replication SSL network connections for the replication database.

Supported SSL protocols are:
  • TLSv1.1
  • TLSv1.2
  • TLSv1.3