SQL Remote User's Guide
SQL Remote Administration
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.
On Windows operating systems, the Message Agent for Adaptive Server Enterprise is named ssremote.exe, and the Message Agent for Adaptive Server Anywhere is named dbremote.exe. On UNIX operating systems, the names are ssremote and dbremote, respectively.
The Message Agent for Adaptive Server Enterprise uses a stable queue to hold transactions until they are no longer needed. For more information on the stable queue, see How the Message Agent for Adaptive Server Enterprise works.
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