The table below contains the field descriptions of the OpenEdge Replication VST, _ReplAgentActivity.

Table 1. Virtual system table _ReplAgentActivity field description
Field name Field number Data type Description
_ReplAgtAct-AgentID 2 INT64 Agent number

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

_ReplAgtAct-AgentName 3 CHARACTER Agent name

Format X(32)

_ReplAgtAct-ConnectTime 4 CHARACTER Date and time of replication agent/server connect

Format X(24)

_ReplAgtActBlocksReceived 5 INT64 The number of after-image (AI) blocks this agent has received

Format >>>>>>>>9

_ReplAgtAct-BlocksProcessed6INT64The number of AI blocks this agent has processed

Format >>>>>>>>9

_ReplAgtAct-BlocksACK7INTEGERThe number of block acknowledgments this agent has sent to the server

Format >>>>>>>>9

_ReplAgtAct-NotesProcessed8INTEGERThe number of AI notes this agent has processed

Format >>>>>>>>9

_ReplAgtAct-LastTRID9INTEGERThe TRID of the last transaction on the target

Format >>>>>>>>9

_ReplAgtAct-Status10INTEGERCurrent status of this replication agent

Format >>>>>>>>9

_ReplAgtAct-CommStatus 11INTEGER Current TCP communication status of this agent. Valid values are:
  • 1 — Connected
  • 2 — Disconnected

Format >>>>>>>>9

_ReplAgtAct-State 12 CHARACTER Agent state. Valid values are:
  • Terminating
  • In Normal Processing
  • In Synchronization Processing
  • In Forced Transition
  • In Pre-Transition
  • Ready For Manual Transition

Format X(48)

_ReplAgtAct-Ready 13 INTEGER Agent ready status. Valid values are:
  • 0 — no
  • 1 — yes

Format >>>>>>>>9

_ReplAgtAct-WaitingFor 14 CHARACTER What this agent is waiting for. Valid values include:
  • Nothing
  • Schema Lock Request
  • Encryption Objects
  • Schema Object state change

Format X(48)

_ReplAgtAct-CurDelayInterval 15INTEGERCurrent message delay interval (in seconds)

Format >>>>>>>>9

_ReplAgtAct-TimeToTransition 16 CHARACTERTime remaining before transition

Format X(24)

_ReplAgtAct-LastBlockReceived 17 CHARACTER Last block received on/at

Format X(24)

_ReplAgtAct-TransStarted 18 INT64 Number of transactions started

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

_ReplAgtAct-TransEnded 19 INT64 Number of transactions ended

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

_ReplAgtAct-SyncPoints 20 INT64 Number of synchronization points

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

_ReplAgtAct-SrcRDBMSSeq 21 INT64 The AI sequence number of the most recent AI block on the source database.

-1 if not available

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

_ReplAgtAct-SrcRDBMSBlock 22 INT64 The AI block number of the most recent AI block on the source database.

-1 if not available

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

_ReplAgtAct-LastRecvBlockSeq 23 INT64 The AI sequence number of the last received AI block on the target database.

-1 if not available

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

_ReplAgtAct-LastRecvBlockBlock 24 INT64 The AI block number of the last received AI block on the target database.

-1 if not available

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

_ReplAgtAct-LastBlockSeq 25 INT64 Last processed AI block sequence number

-1 if not available

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

_ReplAgtAct-LastBlockBlock 26 INT64 Last processed AI block

-1 if not available

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

_ReplAgtAct-ServerLag 27 INTEGER Seconds the replication server is behind the source database

-1 if not available

Format >>>>>>>>9

_ReplAgtAct-SourceTRID 28 INTEGERLast TRID from the source database

-1 if not available

Format >>>>>>>>9

_ReplAgtAct-LastSyncTimeTgt 29 CHARACTER Time that the target was last current

Format X(24)

_ReplAgtAct-LastSyncTimeSrc 30 CHARACTER Time that the source was last current

Format X(24)

_ReplAgtAct-LastSyncDelta 31 CHARACTER Delta in Source/Target Sync

Format X(24)

_ReplAgtAct-ServerBlocksToSend 32 INTEGER Number of AI Blocks in the Replication server's PICA queue at time of the last AIBLOCK message

Format >>>>>>>>9

_ReplAgtAct-LastBlockCountTime 33 CHARACTER Date/time the Replication server last sent the PICA queue information to the replication agent

Format X(24)

_ReplAgtAct-BlockProcDelay 34 INTEGER The elapsed time between when the last timestamped block was received by the Replication agent, and when it was applied to the target database

Format >>>>>>>>9

_ReplAgtAct-ReservedChar 35 CHARACTER Reserved for future use
_ReplAgtAct-ReservedInt 36 INTEGER Reserved for future use