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 Server Number

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

_ReplSrv-AgentCount 3 INTEGER Agents Count

Number of agents that the OpenEdge Replication server is controlling

Format >>>>>>>>>9

_ReplSrv-BlocksSent 4 INTEGER After-image(AI) Blocks Sent

Number of AI Blocks the OpenEdge Replication server has sent to connected OpenEdge Replication agents

Format >>>>>>>>>9

_ReplSrv-StartTime 5 CHARACTER Server Start Time

Date and time when the OpenEdge Replication server was started

Format X(24)

_ReplSrv-LastBlockSentAt 6 CHARACTER Last Block Sent At

Date and time when the OpenEdge Replication server was started

Format X(24)

ReplSrv-Database7CHARACTERDatabase file name

Format X(24)

ReplSrv-DatabaseRole8CHARACTERDatabase role. Valid values are:
  • Replication source
  • Replication target

Format X(8)

ReplSrv-ServerState9CHARACTERServer state. Valid values are:
  • Performing Initialization
  • Connecting to Agents
  • Configuring Connected Agents
  • Performing Failure Recovery
  • Performing Startup Synchronization
  • In Normal Processing
  • Unknown

Format X(36)

ReplSrv-DeferAgentConnUntil10CHARACTERDate and time that deferred agent connection attempts will cease

Format X(24)

ReplSrv-DeferAgentExpire 11 CHARACTER Time remaining until deferred agent startup expires

Format X(24)

ReplSrv-NextConnectIn12CHARACTERTime until next connection attempt

Format X(24)

ReplSrv-ConnectAttempts13INT64Number of connection attempts performed

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

ReplSrv-AgentsConnected14INTEGERNumber of agents currently connected

Format >>>>>>>>>9

ReplSrv-CurDelayInterval15INTEGERCurrent message delay interval (in seconds)

Format >>>>>>>>>9

ReplSrv-MinDelayInterval16INTEGERMinimum message delay interval (in seconds)

Format >>>>>>>>>9

ReplSrv-MaxDelayInterval17INTEGERMaximum message delay interval (in seconds)

Format >>>>>>>>>9

ReplSrv-RecoveryState18CHARACTERServer recovery state. Valid values are:
  • No Recovery
  • Just Entered Recovery
  • Server Attempting Connection
  • Initialize Synchronization with Agents
  • Synchronizing Agents
  • Recovery Complete

Format X(42)

ReplSrv-RecAgentsToRecover19INTEGERNumber of agents needing recovery

Format >>>>>>>>>9

ReplSrv-RecAgentsConnected20INTEGERNumber of agents connected and not needing recovery

Format >>>>>>>>>9

ReplSrv-AgentsInSync21 INTEGERNumber of agents in synchronization

Format >>>>>>>>>9

ReplSrv-TransitionType22CHARACTERTransition type. Valid values are:
  • Manual
  • Automatic

Format X(32)

ReplSrv-TransitionTimeout23INTEGERFor automatic transition, the maximum amount of time (in seconds) that the target database will wait until it transitions to a normal database.

Format >>>>>>>>>9

_ReplSrv-ReplicationSet 24 INTEGER 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 Restart after transition

Format yes/no

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

Format yes/no

_ReplSrv-AutoAddAI 29 BOOLEAN Automatically add after-imaging files during transition

Format yes/no

_ReplSrv-AIFile 30 CHARACTER AI structure filename for automatically adding after-imaging

Format X(256)

_ReplSrv-BackupMethod 31 CHARACTER Backup method during transition

Format X(32)

_ReplSrv-ConfiguredAgents 32 CHARACTER List of configured agents

Format X(68)

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

Format ->>>>9

_ReplSrv-SchemaLockAction 34 CHARACTER Method server uses to perform schema locking. Valid values include:
  • Force
  • Wait

Format X(32)

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

Format X(32)

_ReplSrv-ReservedChar 36 CHARACTER Reserved
_ReplSrv-ReservedInt 37 INTEGER Reserved
_ReplSrv-TransEndTrigger 38 INTEGER Indicates if a transition end trigger is to execute on transition. Valid values include:
  • 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

Remote Database Name

Fully qualified database name to which the OpenEdge Replication agent is connected.

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

Format X(128)

_ReplSrv-TransToDBHost 41 INTEGER

Remote Host Name

The hostname of the primary transition to target database identified by the _replserv-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

Connected to Agent on Port Number

The port number the primary transition to target database identified by the _replserv-TransToDBName field as specified by the -S startup parameter.

Format >>>>>>>>>9

Note

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