Table 1 contains the field descriptions of the OpenEdge Replication virtual system table (VST) _Repl-Agent.

Table 1. Virtual system table _Repl-Agent field descriptions
Field name Field number Data type Description
_ReplAgt-AgentID 2 INT64 The ROWID of the _Repl-Agent VST record.

Format ->>>>>>>>>9
_ReplAgt-AgentName 3 CHARACTER The name of the replication agent as configured in the repl.properties file.

Format X(32)
_ReplAgt-ConnectTime 4 CHARACTER The date and time when the replication server successfully connected to the replication agent.

Format X(24)
_ReplAgt-DBName 5 CHARACTER The fully qualified source database name that the replication agent is replicating from.

Format X(128)
_ReplAgt-ServerHost 6 CHARACTER The name of the host where the replication server is running.

Format X(128)
_ReplAgt-Port 7 INTEGER The TCP listening port of the replication agent.

Format ->>>>>>>>>9
_ReplAgt-BlocksReceived 8 INT64 The number of after-image (AI) blocks that the replication agent has received from the replication server.

Format ->>>>>>>>>9
_ReplAgt-BlocksProcessed 9 INT64 The number of AI blocks that the replication agent has applied to the target database.

Format >>>>>>>>>9
_ReplAgt-BlocksACK 10 INTEGER The number of AI block acknowledgements that the replication agent has sent to the replication server.

Format >>>>>>>>>9
_ReplAgt-NotesProcessed 11 INTEGER The number of AI notes that the replication agent has applied to the target database.

Format ->>>>>>>>>9
_ReplAgt-LastTRID 12 INTEGER Transaction ID (TRID) of the last transaction begin note that was applied to the target database by the replication agent.

Format ->>>>>>>>>9
_ReplAgt-Method 13 CHARACTER The type of replication that is being performed with the replication agent.
The valid value is A — Asynchronous.
Note: Asynchronous replication is the only supported replication method. Synchronous replication is no longer supported.

Format X(1)
_ReplAgt-Status 14 INTEGER

Current status of the replication agent.

A value from the Value column, as reported by the following command:
DSRUTIL -C status -detail

For more information, see DSRUTIL status qualifier.

Format >>>>>>>>>9
_ReplAgt-CommStatus 15 INTEGER The network communication status of the replication agent with the replication server. Valid values are:
  • 1 — Connected
  • 2 — Disconnected

Format >>>>>>>>>9
_ReplAgt-DatabaseRole16CHARACTERDatabase replication role. Valid values are:
  • Source
  • Target

Format X(8)

_ReplAgt-Critical17INTEGERCritical agent flag. Valid values are:
  • 1 — Critical
  • 0 — Not critical

Format >>>>>>>>>9

For more information, see Designate a critical agent.

_ReplAgt-MaxMsgSize18INT64Maximum number of bytes in a TCP message.

Format ->>>>>>>>>>>>>>>>>>9

_ReplAgt-MinDelayInterval19INTEGERMinimum message polling delay interval (in seconds).

Format >>>>>>>>>9

_ReplAgt-MaxDelayInterval20INTEGERMaximum message polling delay interval (in seconds).

Format >>>>>>>>>9

_ReplAgt-TransitionType21CHARACTER

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

  • Manual
  • Automatic

Format X(24)

_ReplAgt-TimeoutLimit22INTEGERThe time (in seconds) that the replication agent waits for reconnection with replication server, before automatically starting recovery transition.

Format >>>>>>>>>9

_ReplAgt-ConnectTimeout 23 INT64 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.

Format ->>>>>>>>>>>>>>>>>>>9
_ReplAgt-MinPort 24 INT64 Minimum TCP listener port number.

Format ->>>>>>>>>>>>>>>>>>>9
_ReplAgt-MaxPort 25 INT64 Maximum TCP listener port number.

Format ->>>>>>>>>>>>>>>>>>>9
_ReplAgt-ReplicationSet 26 INTEGER Replication set enabled. Valid values are:
  • 0—Replication set not enabled.
  • 1—Replication set enabled.

Format >>>9
_ReplAgt-TransDatabaseRole 27 CHARACTER The role database takes after transition. Valid values are:
  • Normal
  • Reverse

Format X(32)
_ReplAgt-TransitionToAgents 28 CHARACTER Transition to agents list.

Format X(100)
_ReplAgt-RestartAfterTrans 29 BOOLEAN Start database broker after transition?

Format yes/no
_ReplAgt-AutoBeginAI 30 BOOLEAN Automatically begin after-imaging during transition?

Format yes/no
_ReplAgt-AutoAddAI 31 BOOLEAN Automatically add AI extents during transition?

Format yes/no
_ReplAgt-AIFile 32 CHARACTER Filename of structure file specifying AI extents to be added automatically during transition.

Format X(256)
_ReplAgt-BackupMethod 33 CHARACTER The database backup method used during transition. Valid values are:
  • Full-offline
  • Full-online
  • Mark

Format X(32)
_ReplAgt-ReservedChar 34 CHARACTER Reserved for future use
_ReplAgt-ReservedInt 35 INTEGER Reserved for future use
_ReplAgt-TransEndTrigger 36 INTEGER Indicates whether a transition end trigger is to execute on transition. Valid values are:
  • 0 — Execute a transition end trigger
  • 1 — Do not execute a transition end trigger

Format >>>9
_ReplAgt-AIStreaming 37 BOOLEAN Indicates whether AI streaming is enabled.

Valid values are:

  • yes — AI Streaming enabled
  • no — AI Streaming not enabled

Format yes/no
_ReplAgt-DRTransitionToAgents 38 CHARACTER Recovery transition to agents list.

Format X(100)
_ReplAgt-ApplyStreamingData 39 BOOLEAN Apply AI Streaming data in RSB cache to target database prior to auto-transition?
  • yes — Apply data
  • no — Do not apply data

Format yes/no
_ReplAgt-SSLEnabled 40 BOOLEAN

OpenEdge Replication SSL use enabled?

Valid values are:

  • yes—OpenEdge Replication SSL enabled
  • no—OpenEdge Replication SSL not enabled
_ReplAgt-SSLKeyAlias 41 CHARACTER Key alias of the SSL key that is used with OpenEdge Replication SSL.
_ReplAgt-SSLKeyAliasPassword 42 CHARACTER Key alias password of the SSL key that is used with OpenEdge Replication SSL.
Note: The value of this field is encrypted to avoid exposing the actual password to unauthorized viewers of the VST.
_ReplAgt-SSLKeyStorePath 43 CHARACTER Absolute path of the directory containing the SSL key and the certificate for OpenEdge Replication SSL.
_ReplAgt-SSLCipherSuites 44 CHARACTER

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
_ReplAgt-SSLProtocols 45 CHARACTER

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

Note

  • If the replication agent is not running, the _replagent VST returns no records.