The table below contains the field descriptions of the OpenEdge Replication virtual system table, _Repl-Server.

Table 1. Virtual system table _Repl-Server field description
Field name Field number Data type Description
_ReplSrv-id 2 INT64 The ROWID of the _Repl-Server VST record.

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

_ReplSrv-AgentCount 3 INTEGER

The number of replication agents that the replication server has been configured to run with.

Format >>>>>>>>>9

_ReplSrv-BlocksSent 4 INTEGER

The number of after-image (AI) Blocks the replication server has sent to all connected replication agents.

Format >>>>>>>>>9

_ReplSrv-StartTime 5 CHARACTER

The date and time when the replication server was started.

Format X(24)

_ReplSrv-LastBlockSentAt 6 CHARACTER

The date and time when the last AI block was sent with a request for acknowledgment to any connected replication agent.

Format X(24)

_ReplSrv-Database7CHARACTERThe name of the replication source database as configured in the repl.properties file.

Format X(24)

_ReplSrv-DatabaseRole8CHARACTERDatabase replication role. Valid values are:
  • Source
  • Target

Format X(8)

_ReplSrv-ServerState9CHARACTERReplication server state. Valid values are:
  • Performing Initialization
  • Connecting to Agents
  • Configuring Connected Agents
  • Performing Failure Recovery
  • Performing Startup Synchronization
  • Initiating Agent to Agent Connections
  • In Normal Processing
  • Unknown

Format X(36)

_ReplSrv-DeferAgentConnUntil10CHARACTERThe date and time that deferred agent connection attempts will cease.

Format X(24)

_ReplSrv-DeferAgentExpire 11 CHARACTER

The time remaining until deferred agent connection attempts will cease.

Format X(24)

_ReplSrv-NextConnectIn12CHARACTERThe time remaining until the next deferred agent connection attempt.

Format X(24)

_ReplSrv-ConnectAttempts13INT64The number of attempts to connect to all configured replication agents at replication server startup.

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

_ReplSrv-AgentsConnected14INTEGERThe number of replication agents that are currently connected to the replication server.

Format >>>>>>>>>9

_ReplSrv-CurDelayInterval15INTEGERCurrent message polling delay interval (in seconds).

Format >>>>>>>>>9

_ReplSrv-MinDelayInterval16INTEGERMinimum message polling delay interval (in seconds).

Format >>>>>>>>>9

_ReplSrv-MaxDelayInterval17INTEGERMaximum message polling delay interval (in seconds).

Format >>>>>>>>>9

_ReplSrv-RecoveryState18CHARACTERReplication server recovery state. Valid values are:
  • No Recovery Being Performed
  • Just Entered Recovery
  • Server Attempting Connection
  • Initialize Synchronization with Agents
  • Synchronizing Agents
  • Recovery Complete
  • Recovering agent to agent connections
  • Unknown State

Format X(42)

_ReplSrv-RecAgentsToRecover19INTEGERThe number of configured replication agents that are in recovery processing.

Format >>>>>>>>>9

_ReplSrv-RecAgentsConnected20INTEGERThe number of replication agents that are in recovery processing and are connected to the replication server.

Format >>>>>>>>>9

_ReplSrv-AgentsInSync21 INTEGERThe number of replication agents that are in recovery processing and are either ready for or have started recovery synchronization with the source database.

Format >>>>>>>>>9

_ReplSrv-TransitionType22CHARACTERSpecifies whether connected replication agents will perform recovery transition automatically, or with manual intervention. Valid values are:
  • Manual
  • Automatic

Format X(32)

_ReplSrv-TransitionTimeout23INTEGER

For automatic transition, the maximum amount of time (in seconds) the priority replication agent will wait for reconnection from the replication server until automatically transitioning the target database to its new role.

Format >>>>>>>>>9

_ReplSrv-ReplicationSet 24 INTEGER Replication set enabled. Valid values are:
  • 0—Replication set not enabled
  • 1—Replication set enabled

Format >>>9

_ReplSrv-TransDatabaseRole 25 CHARACTER Role the database takes after transition. Valid values are:
  • Normal
  • Reverse

Format X(32)

_ReplSrv-TransitionToAgents 26 CHARACTER Transition to agents list.

Format X(100)

_ReplSrv-RestartAfterTrans 27 BOOLEAN Start database broker after transition?

Format yes/no

_ReplSrv-AutoBeginAI 28 BOOLEAN Automatically begin after-imaging during transition?

Format yes/no

_ReplSrv-AutoAddAI 29 BOOLEAN Automatically add AI extents during transition?

Format yes/no

_ReplSrv-AIFile 30 CHARACTER Filename of structure file specifiying AI extents to automatically add during transition.

Format X(256)

_ReplSrv-BackupMethod 31 CHARACTER The database backup method used during transition.
Valid values are:
  • Full-online
  • Full-offline
  • Mark

Format X(32)

_ReplSrv-ConfiguredAgents 32 CHARACTER List of configured replication agents.

Format X(68)

_ReplSrv-ReplKeepAlive 33 INT64 Replication keep alive property value (in seconds).

Format ->>>>9

_ReplSrv-SchemaLockAction 34 CHARACTER The method that the connected replication agents will use to obtain an exclusive schema lock on the target database. Valid values are:
  • Force
  • Wait

Format X(32)

_ReplSrv-AgentShutdownAction 35 CHARACTER Action replication agent takes if connection to replication server is lost. Valid values are:
  • Normal
  • Recovery

Format X(32)

_ReplSrv-ReservedChar 36 CHARACTER Reserved for future use
_ReplSrv-ReservedInt 37 INTEGER Reserved for future use
_ReplSrv-TransEndTrigger 38 INTEGER Indicates if 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

_ReplSrv-DRTransitionToAgents 39 CHARACTER Recovery transition to agents list.

Format X(100)

_ReplSrv-TransToDBName 40 CHARACTER

Target database for the primary transition-to-agent in the event of a failover transition.

Format X(128)

_ReplSrv-TransToDBHost 41 CHARACTER

The hostname of the primary transition-to-target database identified by the _ReplSrv-TransToDBName field.

Format X(128)

Note: The hostname is the IP address instead of the hostname specified in repl properties or the startup (-H) on the target.
_ReplSrv-TransToDBPort 42 INTEGER The port number the primary transition-to-target database identified by the _ReplSrv-TransToDBName field as specified by the -S startup parameter.

Format >>>>>>>>>9

_ReplSrv-SSLEnabled 43 BOOLEAN

OpenEdge Replication SSL use enabled?

Valid values are:
  • no—OpenEdge Replication SSL not enabled
  • yes— OpenEdge Replication SSL enabled
_ReplSrv-SSLNoHostVerify 44 BOOLEAN

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
_ReplSrv-SSLCertStorePath 45 CHARACTER Absolute path of the directory containing the SSL certificate for OpenEdge Replication SSL.
_ReplSrv-SSLCipherSuites 46 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
_ReplSrv-SSLProtocols 47 CHARACTER

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

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

Note

  • If the replication server is not running, the _replsrv VST returns no records.