The table below contains the field descriptions of the OpenEdge Replication VST, _Repl-AgentControlActivity.

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

Format ->>>>>>>>>>>>>>>>>>9
_ReplAgtCtlAct-AgentName 3 CHARACTER

The name of the replication agent as configured in repl.properties file.

Format X(32)
_ReplAgtCtlAct-ConnectTime 4 CHARACTER

The date and time when the replication server successfully connected to the replication agent.

Format X(24)
_ReplAgtCtlAct-BlocksSent 5 INTEGER

The number of after-image (AI) blocks the replication server has sent to the replication agent.

Format >>>>>>>>>9
_ReplAgtCtlAct-BlocksACK 6 INTEGER

The number of AI block acknowledgments that the replication server has received from the replication agent.

Format >>>>>>>>>9
_ReplAgtCtlAct-LastBlockSentAt 7 CHARACTER The date and time the last AI block was sent to the replication agent.

Format X(24)
_ReplAgtCtlAct-Status 8 INTEGER Current status of the replication agent. A value from the Value column in Table 2, as reported by the following command:
DSRUTIL -C status [agent-name] -detail

Format >>>>>>>>>9
_ReplAgtCtlAct-CommStatus 9 INTEGER

The network communication status of the replication server with the replication agent. Valid values are:

  • 1 = Connected
  • 2 = Disconnected

Format >>>>>>>>>9
_ReplAgtCtlAct-State 10 CHARACTER The current operational state of the replication agent.
Valid values are:

  • Unknown

  • Initializing

  • Initial Connection

  • Initial Connection Failed

  • Invalid Target Database Configuration

  • Startup Syncrhonization

  • Recovery Synchronization

  • Recovery Failed

  • Normal Processing

  • Target Database in Quiet Point

  • Target Database in BI Stall

  • Target Database in AI Stall

  • Online backup of Target Database

  • Being Transitioned

  • Agent is Terminated

Format X(48)
_ReplAgtCtlAct-WaitingFor 11 CHARACTER Specifies what the replication agent is waiting for. Valid values are:
  • Nothing
  • Schema Lock Request
  • Unknown

Format X(24)
_ReplAgtCtlAct-RecoveryState 12 CHARACTER The recovery state of the replication agent. Valid values are:
  • Failed for the Agent
  • No Recovery Being Performed
  • Just Entered Recovery
  • Server Attempting to Connect to Agent
  • Initialize Synchronization
  • Synchronizing
  • Recovery Complete

Format X(48)
_ReplAgtCtlAct-SyncPoints 13 INT64 The number of synchronization points 1 established by the replication agent.

Format ->>>>>>>>>>>>>>>>>>9
_ReplAgtCtlAct-CurRDBMSSeq 14 INT64 The sequence number of AI extent containing the AI block that is currently being written to the source database.

-1 if not available

Format ->>>>>>>>>>>>>>>>>>9
_ReplAgtCtlAct-CurRDBMSBlock 15 INT64 The AI block number that is currently being written to the source database.

-1 if not available

Format ->>>>>>>>>>>>>>>>>>9
_ReplAgtCtlAct-LastBlockSeq 16 INT64 The sequence number of AI extent containing the last AI block that was sent to the replication agent.

-1 if not available

Format ->>>>>>>>>>>>>>>>>>9
_ReplAgtCtlAct-LastBlockBlock 17 INT64 The block number of last AI block that was sent to the replication agent.

-1 if not available

Format ->>>>>>>>>>>>>>>>>>9
_ReplAgtCtlAct-LoadInterval 18 INTEGER Specifies the request-agent-ack-interval value for this [control-agent] in the repl.properties file.

Format >>>>>>>>>9
_ReplAgtCtlAct-LoadChkInt 19 DECIMAL The average time, measured in seconds, between AI block messages sent to the replication agent with a request for acknowledgment.

This only applies when the control agent in consideration has request-agent-ack enabled.

Format >>>>>>>>>9.999
_ReplAgtCtlAct-LoadChkResp 20 DECIMAL The average time, measured in seconds, between when the replication server sends the replication agent an AIBLOCK message with request for acknowledgment and when the remote agent responds with acknowledgment.

This only applies when the control agent in consideration has request-agent-ack enabled.

Format >>>>>>>>>9.999
_ReplAgtCtlAct-LastMsgRecv 21 CHARACTER The date and time when the last message was received from the replication agent.

Format X(24)
1 Synchronization points are a collection of replication-related information (such as the last AI extent applied, the AI block number processed, the offset within an AI, and so on) that can be used as the starting point during synchronization in the event of the replication process being interrupted. After the synchronization points are applied to the target, the AI and BI are synced to the disc, and the server gets notified about these special points. During a restart, the server can use this information to start the synchronization process. If an AI block gets processed on the target but does not have synchronization point information in it, the block may or may not materialize on the disc. So, during a restart, the server has to start from the last synchronization point and retry the AI blocks after it. The server skips a block if it has been applied before; otherwise, the server applies the block. Therefore, you can see blocks being sent to target1 even if they are in sync with the source. The synchronization point information is available in both the .recovery file and the DSRUTIL monitor tool.