OpenEdge Replication Monitor Page 1
Database: C:\OE117WRK\repl2 Database is enabled as OpenEdge Replication: Target Agent: Name: agent1 ID: 1 Host name: 127.0.0.1 State: Normal Processing Ready: Yes Critical: No Method: Synchronous Agent is waiting for: Nothing Maximum bytes in TCP/IP message: 8512 Server/Agent connection time: Tue Jan 31 10:14:15 2017 Delay Interval (current / min / max): 265 / 5 / 500 Transition information: Type: Manual The last block received at: Tue Jan 31 10:14:18 2017 Activity information: Blocks received: 497 Blocks processed: 497 Blocks acknowledged: 495 Notes processed: 30317 Transactions started: 1 Transactions ended: 1 Synchronization points: 8 AI Block Information: Source RDBMS Block (Seq / Block): 3 / 313 Last Processed Block (Seq / Block): 3 / 313 Latency Information: Repl Server behind Source DB by: 0 second(s) Current Source Database Transaction: 53 Last Transaction Applied to Target: 53 Target Current as of (Target, Source): Fri Jan 27 10:57:55 2017, Fri Ja 27 10:57:55 2017 with delta of 000:00:00 Connect timeout: 1800 Listener port range: 1025-65500 Current listener port: 1025 Additional transition information: Replication set: 1 Database role: Reverse Transition to agents: agent1,agent2 Restart after transition: 1 Automatically begin AI: 1 Automatically add AI areas: 1 AI structure file: addai.st Backup method: Full-offline |
Field
|
Description
|
Database is enabled as OpenEdge Replication
|
Indicates whether the database is enabled as a replication source or a target.
|
Agent
|
Lists basic remote agent information.
|
Name
|
Lists the name of the remote agent.
|
ID
|
Lists the remote agent identification number.
|
Host name
|
Lists the host on which the target database associated with the remote agent resides.
|
State
|
Shows agent processing information:
Normal processing — The server and the agent are performing normal processing.
Initial connection — The agent is waiting for initial connection from server.
Startup synchronization — The server and the agent are synchronizing.
Initialization — The agent is being initialized by the server.
Initial connection failed — The server could never connect to an agent.
Invalid target database configuration — Something in the target database does not match the source.
Agent terminated — The target database shut down or the agent terminated using Terminate agent.
Online backup of Target Database — An online target database backup is being performed.
Recovery synchronization — Recovery synchronization is being performed.
Recovery failed — Failure recovery was unsuccessful.
Unknown — The agent is in an unknown state.
|
Critical
|
Shows whether the remote agent is a critical agent (Yes) or is not (No).
|
Method
|
Lists the replication method: asynchronous or synchronous.
|
Agent is waiting for
|
Shows why the agent might be waiting. The field value might be one of the following:
Nothing — Indicates no waiting is taking place
Schema lock request — Indicates the server is waiting for the agent to acquire the schema lock so the database schema can be changed
Encryption objects — For an encrypted database, the agent's wait status, or what the agent is waiting for
|
Maximum bytes in TCP/IP message
|
Shows the maximum number of bytes used for the TCP/IP communication messages.
|
Server/Agent connection time
|
Shows the date and time at which the server and agent connected.
|
Delay Interval (current / min / max)
|
Shows the amount of time, in milliseconds, the agent will wait between polling the TCP/IP connection for information to be replicated. Current is the current value, min is the minimum value, and max is the maximum value. Polling is used to increase the performance of the server, and the wait is used to limit the amount of overhead when no data is available to be replicated.
|
Transition information
|
Shows a group of remote agent-related transition information.
|
Type
|
Shows the type of transition to be performed:
Manual — Indicates intervention is required to complete the transition of a target database to a normal OpenEdge database
Automatic — Indicates a transition from a target database to a normal OpenEdge database will take place without intervention
|
The last block received at
|
Shows the date and time the last block was sent to the agent.
|
Activity information
|
Shows a selection of activity information.
|
Blocks received
|
Shows the number of blocks received from the server.
|
Blocks processed
|
Shows the number of blocks processed.
|
Blocks acknowledged
|
Shows the number of blocks acknowledged.
|
Notes processed
|
Shows the number of AI transaction notes processed by the agent.
|
Transactions started
|
Shows the number of transactions started on the agent.
|
Transactions ended
|
Shows the number of transactions completed on the agent.
|
Synchronization points
|
Shows the number of synchronization points that have occurred.
|
AI Block Information
|
Identifies the current AI block that is being written by the source database and provides the last AI block that was sent by Replication.
|
Source RDBMS Block (Seq / Block)
|
Provides the current source database block that the OpenEdge Replication agent is processing.
|
Last Processed Block (Seq / Block)
|
Provides the last source database block that the OpenEdge Replication agent processed.
|
Latency Information
|
Provides latency information that shows how far behind OpenEdge Replication is in updating the target database. This is important if the target database is transitioned due to source database failure.
|
Repl Server behind Source DB by
|
Provides the number of seconds the OpenEdge Replication server is behind the source database.
|
Current Source Database Transaction
|
Provides the current source database transaction that the OpenEdge Replication agent is processing.
|
Last Transaction Applied to Target
|
Provides the last source database transaction that was applied to the target database.
|
Target Current As Of
|
Provides the date of the last transaction applied to the target database by the OpenEdge Replication agent based on source database time.
|
Connect timeout
|
Number of seconds during which agent attempts to reconnect to server.
|
Listener port range
|
Range of ports for agent
|
Current listener port
|
Current port in use
|
Replication set
|
Set to 1 if Replication set is enabled, 0 otherwise.
|
Database role
|
Role of agent database in transition
|
Transition to agents
|
List of agents to transition to
|
Restart after transition
|
Indicates if restart should occur after transition. Set to 1 for yes, 0 for no.
|
Automatically begin AI
|
For replication set only, indicates if after-imaging should automatically be started on transition. Set to 1 to begin after-imaging, 0 to not.
If replication set is not enabled, set to the unknown value, "?"
|
Automatically add AI areas
|
Indicates if after-image areas should be automatically added to the target database that is transitioning to a source. Set to 1 to add after-image areas, 0 not to add AI.
|
AI structure file
|
The name of the structure file to use if automatically adding AI areas.
If Automatically add AI is not enabled, set to the unknown value, "?"
|
Backup method
|
The backup method for database during transition. Valid entries include:
Full-offline
Full-online
Mark
|