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