Release 10.1C: OpenEdge Replication:
User Guide


Virtual system table field descriptions

This section describes the field descriptions for the OpenEdge Replication virtual system tables. Table 5–14 shows the field descriptions for _Repl-Server.

Table 5–14: Virtual system table _Repl-Server field description
Field name
Field number
Data type
Description
_ReplSrv-AgentCount 
2
INTFLD
Agents Count
Format ->>>>>>>>>9
Number of agents that the OpenEdge Replication server is controlling
_ReplSrv-BlocksSent 
3
INTFLD
AI Blocks Sent
Format ->>>>>>>>>9
Number of AI Blocks the OpenEdge Replication server has sent to connected OpenEdge Replication agents
_ReplSrv-StartTime 
4
CHRFLD
Server Start Time
Format X(24)
Date and time when the OpenEdge Replication server was started
_ReplSrv-LastBlockSentAt 
5
CHRFLD
Last Block Sent At
Format X(24)
Date and time when the OpenEdge Replication server was started

Table 5–15 shows the field descriptions for _Repl-AgentControl.

Table 5–15: Virtual system table _Repl-AgentControl field description
Field name
Field number
Data type
Description
_ReplAgtCtl-AgentID 
2
INTFLD
Agent ID
Format ->>>>>>>>>9
The ID of the OpenEdge Replication agent
_ReplAgtCtl-AgentName 
3
CHRFLD
Agent Name
Format X(32)
Name of the OpenEdge Replication agent as configured in the repl.properties file
_ReplAgtCtl-ConnectTime 
4
CHRFLD
Agent Start Time
Format X(24)
Date and time when the OpenEdge Replication server successfully connected to the OpenEdge Replication agent
_ReplAgtCtl-RemoteDBName 
5
CHRFLD
Remote Database Name
Format X(256)
Fully qualified database name to which the OpenEdge Replication agent is connected
_ReplAgtCtl-RemoteHost 
6
CHRFLD
Remote Host Name
Format X(128)
Name of the host where the OpenEdge Replication agent is running
_ReplAgtCtl-Port 
7
INTFLD
Connected to Agent on Port Number
Format ->>>>>>>>>9
The port number the OpenEdge Replication server uses to connect to this OpenEdge Replication agent
_ReplAgtCtl-BlockSent 
8
INDFLD
Blocks Sent to this Agent
Format ->>>>>>>>>9
The number of AI blocks the OpenEdge Replication server has sent to this OpenEdge Replication agent
_ReplAgtClt-BlocksACK 
9
INTFLD
Number of block acknowledgments received for this agent
Format ->>>>>>>>>9
The number of block acknowledgements this OpenEdge Replication agent has received from its remote counterpart
_ReplAgtCtl-LastBlockSentAt 
10
CHRFLD
Last Block Sent At
Format X(24)
The data and time the last block was sent to this OpenEdge Replication agent
_ReplAgtCtl-Method 
11
CHRFLD
Replication Method
Format X(1)
The type of replication that is being performed with this OpenEdge Replication agent:
  • A — Asynchronous (mode & RP_MODE_
    ASYNC
    )
  • S — Synchronous (mode & RP_MODE_SYNC)
_ReplAgtCtl-Status 
12
INTFLD
Agent’s Status
Format ->>>>>>>>>9
The OpenEdge Replication agent’s status:
  • 1 — Normal (Processing as expected)
  • 2 — Recovery (This OpenEdge Replication agent is in recovery mode)
_ReplAgtCtl-CommStatus 
13
INTFLD
Agent’s Communication Status
Format ->>>>>>>>>9
The OpenEdge Replication agent’s TCP communication status:
  • 1 — Connected
  • 2 — Disconnected

Table 5–16 shows the field descriptions for _Repl-Agent.

Table 5–16: Virtual system table _Repl-Agent field descriptions
Field name
Field number
Data type
Description
_ReplAgt-AgentID 
2
INTFLD
Agent ID
Format ->>>>>>>>>9
The ID of the OpenEdge Replication agent
_ReplAgt-AgentName 
3
CHRFLD
Agent Name
Format X(32)
Name of the OpenEdge Replication agent as configured in the repl.properties file
_ReplAgt-StartTime 
4
CHRFLD
Agent Start Time
Format X(24)
Date and time when the OpenEdge Replication agent was started
_ReplAgt-ConnectTime 
5
CHRFLD
Agent Connect Time
Format X(24)
Date and time when the OpenEdge Replication server successfully connected to the OpenEdge Replication agent
_ReplAgt-DBName 
6
CHRFLD
Database Name
Format X(128)
Fully qualified database name that the OpenEdge Replication agent is connected to
_ReplAgt-ServerHost 
7
CHRFLD
Server Host Name
Format X(128)
Name of the host where the OpenEdge Replication server is running
_ReplAgt-Port 
8
INTFLD
The agent is connected to this port number
Format ->>>>>>>>>9
The port number the OpenEdge Replication server uses to connect to this OpenEdge Replication agent
_ReplAgt-BlocksReceived 
9
INTFLD
Number of blocks received
Format ->>>>>>>>>9
The number of AI blocks this OpenEdge Replication server has received
_ReplAgt-BlocksProcessed 
10
INTFLD
Number of blocks processed.
The number of AI blocks this OpenEdge Replication agent has processed
_ReplAgt-BlocksACK 
11
INTFLD
Number of block acknowledgements sent by this agent
Format ->>>>>>>>>9
The number of block acknowledgements this OpenEdge Replication agent has sent to the OpenEdge Replication server
_ReplAgt-NotesProcessed 
12
INTFLD
Number of Notes Processed
Format ->>>>>>>>>9
The number of AI notes this OpenEdge Replication agent has processed
_ReplAgt-LastTRID 
13
INTFLD
Transaction ID of Last Transaction began
Format ->>>>>>>>>9
The Transaction ID of the last Transaction Begin encountered
_ReplAgt-LastEND 
14
INDFLD
Transaction ID of last Transaction End
Format ->>>>>>>>>9
The Transaction ID of the last Transaction End encountered
_ReplAgt-Method 
15
CHRFLD
Replication Method
Format X(1)
The type of replication that is being performed with this OpenEdge Replication agent:
  • A — Asynchronous
  • S — Synchronous
_ReplAgt-Status 
16
INTFLD
Agent’s Status
Format ->>>>>>>>>9
The OpenEdge Replication agent’s status:
  • 1 — Normal (Processing as expected)
  • 2 — Recovery (This OpenEdge Replication agent is in failure recover mode)
_ReplAgt-CommStatus 
17
INTFLD
Agent’s Communication Status
The OpenEdge Replication agent’s TCP communication status:
  • 1 — Connected
  • 2 — Disconnected


Copyright © 2008 Progress Software Corporation
www.progress.com