|
Field name
|
Field number
|
Data type
|
Description
|
|
_ReplAgtCtlAct-AgentID
|
2
|
INT64
|
Agent number
Format ->>>>>>>>>>>>>>>>>>9
|
|
_ReplAgtCtlAct-AgentName
|
3
|
CHARACTER
|
Agent name
Format X(32)
|
|
_ReplAgtCtlAct-ConnectTime
|
4
|
CHARACTER
|
Date and time of replication agent/server connect
Format X(24)
|
|
_ReplAgtCtlAct-BlocksSent
|
5
|
INTEGER
|
The number of after-image (AI) blocks the server has sent
Format >>>>>>>>>9
|
|
_ReplAgtCtlAct-BlocksACK
|
6
|
INTEGER
|
The number of AI blocks the agent has processed
Format >>>>>>>>>9
|
|
_ReplAgtCtlAct-LastBlockSentAt
|
7
|
CHARACTER
|
Time that the last block was received
Format X(24)
|
|
_ReplAgtCtlAct-Status
|
8
|
INTEGER
|
Current status of the agent. Valid values are:
 1 = Normal
2 = In Recovery Mode
Format >>>>>>>>>9
|
|
_ReplAgtCtlAct-CommStatus
|
9
|
INTEGER
|
Current TCP communication status of the agent. Valid values are:
1 = Connected
2 = Disconnected
Format >>>>>>>>>9
|
|
_ReplAgtCtlAct-State
|
10
|
CHARACTER
|
Current state of the agent
Format X(48)
|
|
_ReplAgtCtlAct-WaitingFor
|
11
|
CHARACTER
|
What this agent is waiting for. Valid values are:
Nothing
Schema Lock Request
Format X(24)
|
|
_ReplAgtCtlAct-RecoveryState
|
12
|
CHARACTER
|
Recovery state of this agent. Valid values are:
Failed for the Agent
No Recovery Being Performed
Just Entered Recovery
Server Attempting to Connect to Agent
Initialize Synchronization
Synchronizing
Recovery Complete
Format X(48)
|
|
_ReplAgtCtlAct-SyncPoints
|
13
|
INT64
|
Number of synchronization points
Format ->>>>>>>>>>>>>>>>>>9
|
|
_ReplAgtCtlAct-CurRDBMSSeq
|
14
|
INT64
|
Current AI Block Sequence
-1 if not available
Format ->>>>>>>>>>>>>>>>>>9
|
|
_ReplAgtCtlAct-CurRDBMSBlock
|
15
|
INT64
|
Current AI Block
-1 if not available
Format ->>>>>>>>>>>>>>>>>>9
|
|
_ReplAgtCtlAct-LastBlockSeq
|
16
|
INT64
|
Last sent AI Block Sequence
-1 if not available
Format ->>>>>>>>>>>>>>>>>>9
|
|
_ReplAgtCtlAct-LastBlockBlock
|
17
|
INT64
|
Last sent AI Block
-1 if not available
Format ->>>>>>>>>>>>>>>>>>9
|
|
_ReplAgtCtlAct-LoadInterval
|
18
|
INTEGER
|
Server to agent load check interval (in blocks)
Format >>>>>>>>>9
|
|
_ReplAgtCtlAct-LoadChkInt
|
19
|
DECIMAL
|
Time between server and agent load checks (in seconds)
Format >>>>>>>>>9.999
|
|
_ReplAgtCtlAct-LoadChkResp
|
20
|
DECIMAL
|
Time taken to respond to load checks (in seconds)
Format >>>>>>>>>9.999
|
|
_ReplAgtCtlAct-LastMsgRecv
|
21
|
CHARACTER
|
Time the last message was received from the remote agent
Format X(24)
|