Running the Message Agent

The SQL Remote Message Agent is a key component in SQL Remote replication. The Message Agent handles both the sending and receiving of messages. It carries out the following functions:

  • It processes incoming messages, and applies them in the proper order to the database.
  • It scans the transaction log or stable queue at each publisher database, and translates the log entries into messages for subscribers.
  • It parcels the log entries up into messages no larger than a fixed maximum size (50,000 bytes by default), and sends them to subscribers.
  • It maintains the message tracking information in the system tables, and manages the guaranteed transmission mechanism.
Executable names

On Windows operating systems, the Message Agent is named dbremote.exe. On Unix operating systems, the name is dbremote. On Mac OS X, you can also use SyncConsole to start the Message Agent.

See Starting the Message Agent on Mac OS X.

Message Agent batch and continuous modes
Connections used by the Message Agent
Replication system recovery procedures
Ensuring consistent Message Agent settings
The Message Agent and replication security
Troubleshooting errors at remote sites

Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0