Table 5–15: Virtual system table_Repl-AgentControl field description
Field name
|
Field number
|
Data type
|
Description
|
|
2
|
INTFLD
|
Agents Count
Format ->>>>>>>>>9
Number of agents that the Fathom Replication server is controlling.
|
|
3
|
INTFLD
|
AI Blocks Sent
Format ->>>>>>>>>9
Number of AI Blocks the Fathom Replication server has sent to connected Fathom Replication agents.
|
|
4
|
CHRFLD
|
Server Start Time
Format X(24)
Date and time when the Fathom Replication server was started.
|
|
5
|
CHRFLD
|
Last Block Sent At
Format X(24)
Date and time when the Fathom Replication server was started.
|
|
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 server successfully connected to the Fathom Replication agent.
|
|
5
|
CHRFLD
|
Remote Database Name
Format X(256)
Fully qualified database name to which the Fathom Replication agent is connected.
|
|
6
|
CHRFLD
|
Remote Host Name
Format X(128)
Name of the host where the Fathom Replication agent is running.
|
|
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.
|
|
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.
|
|
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.
|
|
10
|
CHRFLD
|
Last Block Sent At
Format X(24)
The data and time the last block was sent to this Fathom Replication agent.
|
|
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 )
|
|
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.)
|
|
13
|
INTFLD
|
Agent’s Communication Status
Format ->>>>>>>>>9
The Fathom Replication agent’s TCP communication status:
- 1 — Connected.
- 2 — Disconnected.
|