Table 3–13: Virtual system table _Repl-Agent field descriptions
Field name
|
Field number
|
Data type
|
Description
|
|
2
|
INTFLD
|
Agent ID
Format ->>>>>>>>>9
The ID of the Fathom Replication agent.
|
|
3
|
CHRFLD
|
Agent Name
Format X(32)
Name of the Fathom Replication agent as configured in the repl.properties file.
|
|
4
|
CHRFLD
|
Agent Start Time
Format X(24)
Date and time when the Fathom Replication agent was started.
|
|
5
|
CHRFLD
|
Agent Connect Time
Format X(24)
Date and time when the Fathom Replication server successfully connected to the Fathom Replication agent.
|
|
6
|
CHRFLD
|
Database Name
Format X(128)
Fully qualified database name that the Fathom Replication agent is connected to.
|
|
7
|
CHRFLD
|
Server Host Name
Format X(128)
Name of the host where the Fathom Replication server is running.
|
|
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.
|
|
9
|
INTFLD
|
Number of blocks received
Format ->>>>>>>>>9
The number of AI blocks this Fathom Replication server has received.
|
|
10
|
INTFLD
|
Number of blocks processed
The number of AI blocks this Fathom Replication agent has processed.
|
|
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.
|
|
12
|
INTFLD
|
Number of Notes Processed
Format ->>>>>>>>>9
The number of AI notes this Fathom Replication agent has processed.
|
|
13
|
INDFLD
|
Transaction ID of Last Transaction began
Format ->>>>>>>>>9
The Transaction ID of the last Transaction Begin encountered.
|
|
14
|
INDFLD
|
Transaction ID of last Transaction End
Format ->>>>>>>>>9
The Transaction ID of the last Transaction End encountered.
|
|
15
|
CHRFLD
|
Replication Method
Format X(1)
The type of replication that is being performed with this Fathom Replication agent:
- A — Asynchronous
- S — Synchronous
|
|
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)
|
|
17
|
INTFLD
|
Agent’s Communication Status
The Fathom Replication agent’s TCP communication status:
- 1 — Connected
- 2 — Disconnected
|