The table below contains the field descriptions of the OpenEdge Replication 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-MaxMsgSize18INT64The maximum number of bytes in a TCP message.

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

_ReplAgt-MinDelayInterval19INTEGERThe minimum message polling delay interval (in seconds).

Format >>>>>>>>>9

_ReplAgt-MaxDelayInterval20INTEGERThe maximum 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 furture 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 if 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

Note

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