Progress Fathom Replication
User’s Guide


Virtual system table field descriptions

This section describes the field descriptions for the Fathom Replication virtual system tables. Table 3–11 shows the field descriptions for _Repl-Server.

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

Table 3–12 shows the field descriptions for _Repl-AgentControl.

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

Table 3–13 shows the field descriptions for _Repl-Agent.

Table 3–13: 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 Fathom Replication agent.
_ReplAgt-AgentName 
3
CHRFLD
Agent Name
Format X(32)
Name of the Fathom Replication agent as configured in the repl.properties file.
_ReplAgt-StartTime 
4
CHRFLD
Agent Start Time
Format X(24)
Date and time when the Fathom Replication agent was started.
_ReplAgt-ConnectTime 
5
CHRFLD
Agent Connect Time
Format X(24)
Date and time when the Fathom Replication server successfully connected to the Fathom Replication agent.
_ReplAgt-DBName 
6
CHRFLD
Database Name
Format X(128)
Fully qualified database name that the Fathom Replication agent is connected to.
_ReplAgt-ServerHost 
7
CHRFLD
Server Host Name
Format X(128)
Name of the host where the Fathom Replication server is running.
_ReplAgt-Port 
8
INTFLD
The agent is connected to this port number
Format ->>>>>>>>>9
The Fathom Replication server is connected to the Fathom Replication agent on this port number.
_ReplAgt-BlocksReceived 
9
INTFLD
Number of blocks received
Format ->>>>>>>>>9
The number of AI blocks this Fathom Replication server has received.
_ReplAgt-BlocksProcessed 
10
INTFLD
Number of blocks processed
The number of AI blocks this Fathom Replication agent has processed.
_ReplAgt-BlocksACK 
11
INTFLD
Number of block acknowledgements sent by this agent
Format ->>>>>>>>>9
The number of block acknowledgements this Fathom Replication agent has sent to the Fathom Replication server.
_ReplAgt-NotesProcessed 
12
INTFLD
Number of Notes Processed
Format ->>>>>>>>>9
The number of AI notes this Fathom Replication agent has processed.
_ReplAgt-LastTBGN 
13
INDFLD
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 Fathom Replication agent:
  • A — Asynchronous
  • S — Synchronous
_ReplAgt-Status 
16
INTFLD
Agent’s Status
Format ->>>>>>>>>9
The Fathom Replication agent’s status:
  • 1 — Normal (processing as expected)
  • 2 — Recovery (This Fathom Replication agent is in failure recovery mode)
_ReplAgt-CommonStatus 
17
INTFLD
Agent’s Communication Status
The Fathom Replication agent’s TCP communication status:
  • 1 — Connected
  • 2 — Disconnected


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095