|
Field name
|
Field number
|
Data type
|
Description
|
|
_ReplAgtAct-AgentID
|
2
|
INT64
|
Agent number
Format ->>>>>>>>>>>>>>>>>>9
|
|
_ReplAgtAct-AgentName
|
3
|
CHARACTER
|
Agent name
Format X(32)
|
|
_ReplAgtAct-ConnectTime
|
4
|
CHARACTER
|
Date and time of replication agent/server connect
Format X(24)
|
|
_ReplAgtActBlocksReceived
|
5
|
INTEGER
|
The number of after-image (AI) blocks this agent has received
Format >>>>>>>>9
|
|
_ReplAgtAct-BlocksProcessed
|
6
|
INTEGER
|
The number of AI blocks this agent has processed
Format >>>>>>>>9
|
|
_ReplAgtAct-BlocksACK
|
7
|
INTEGER
|
The number of block acknowledgements this agent has sent to the server
Format >>>>>>>>9
|
|
_ReplAgtAct-NotesProcessed
|
8
|
INTEGER
|
The number of AI notes this agent has processed
Format >>>>>>>>9
|
|
_ReplAgtAct-LastTRID
|
9
|
INTEGER
|
The TRID of the last transaction on the target
Format >>>>>>>>9
|
|
_ReplAgtAct-Status
|
10
|
INTEGER
|
Current status of this replication agent
Format >>>>>>>>9
|
|
_ReplAgtAct-CommStatus
|
11
|
INTEGER
|
Current TCP communication status of this agent. Valid values are:
 1 — Connected
2 — Disconnected
Format >>>>>>>>9
|
|
_ReplAgtAct-State
|
12
|
CHARACTER
|
Agent state. Valid values are:
Terminating
In Normal Processing
In Synchronization Processing
In Forced Transition
In Pre-Transition
Ready For Manual Transition
Format X(48)
|
|
_ReplAgtAct-Ready
|
13
|
INTEGER
|
Agent ready status. Valid values are:
0 — no
1 — yes
Format >>>>>>>>9
|
|
_ReplAgtAct-WaitingFor
|
14
|
CHARACTER
|
What this agent is waiting for. Valid values include:
Nothing
Schema Lock Request
Encryption Objects
Schema Object state change
Format X(48)
|
|
_ReplAgtAct-CurDelayInterval
|
15
|
INTEGER
|
Current message delay interval (in seconds)
Format >>>>>>>>9
|
|
_ReplAgtAct-TimeToTransition
|
16
|
CHARACTER
|
Time remaining before transition
Format X(24)
|
|
_ReplAgtAct-LastBlockReceived
|
17
|
CHARACTER
|
Last block received on/at
Format X(24)
|
|
_ReplAgtAct-TransStarted
|
18
|
INT64
|
Number of transactions started
Format ->>>>>>>>>>>>>>>>>>9
|
|
_ReplAgtAct-TransEnded
|
19
|
INT64
|
Number of transactions ended
Format ->>>>>>>>>>>>>>>>>>9
|
|
_ReplAgtAct-SyncPoints
|
20
|
INT64
|
Number of synchronization points
Format ->>>>>>>>>>>>>>>>>>9
|
|
_ReplAgtAct-SrcRDBMSSeq
|
21
|
INT64
|
Source AI block sequence
-1 if not available
Format ->>>>>>>>>>>>>>>>>>9
|
|
_ReplAgtAct-SrcRDBMSBlock
|
22
|
INT64
|
Source AI block
-1 if not available
Format ->>>>>>>>>>>>>>>>>>9
|
|
_ReplAgtAct-LastBlockSeq
|
23
|
INT64
|
Last processed AI block sequence number
-1 if not available
Format ->>>>>>>>>>>>>>>>>>9
|
|
_ReplAgtAct-LastBlockBlock
|
24
|
INT64
|
Last processed AI block number
-1 if not available
Format ->>>>>>>>>>>>>>>>>>9
|
|
_ReplAgtAct-ServerLag
|
25
|
INTEGER
|
Seconds the replication server is behind the source database
-1 if not available
Format >>>>>>>>9
|
|
_ReplAgtAct-SourceTRID
|
26
|
INTEGER
|
Last TRID from the source database
-1 if not available
Format >>>>>>>>9
|
|
_ReplAgtAct-LastSyncTimeTgt
|
27
|
CHARACTER
|
Time that the target was last current
Format X(24)
|
|
_ReplAgtAct-LastSyncTimeSrc
|
28
|
CHARACTER
|
Time that the source was last current
Format X(24)
|
|
_ReplAgtAct-LastSyncDelta
|
29
|
CHARACTER
|
Delta in Source/Target Sync
Format X(24)
|