Understanding the SQL Remote Message Agent (dbremote)

The SQL Remote Message Agent (dbremote) is a key component in SQL Remote replication. It must be installed and run on the every database in the system. The SQL Remote Message Agent (dbremote) handles both sending and receiving messages.

It carries out the following functions:

  • SQL Remote Message Agent (dbremote) tasks when sending messages  

    • It scans the transaction log at each publisher database and translates the transaction log entries into messages for subscribers.

    • It sends the messages to subscribers.

    • When it receives a request to resend messages, the SQL Remote Message Agent (dbremote) resends the messages to the database that made the request.

    • It maintains message information in the system tables, and manages the Guaranteed Message Delivery System.

    See Sending message tasks.

  • SQL Remote Message Agent (dbremote) tasks when receiving messages  

    • It processes incoming messages, and applies them in the proper order to the database.

    • It requests that missing messages be resent.

    • It maintains the message information in the system tables, and manages the Guaranteed Message Delivery System.

    See Receiving message tasks.

 Connections

Choosing the SQL Remote Message Agent (dbremote) mode
Run the SQL Remote Message Agent (dbremote) in continuous mode
Run the SQL Remote Message Agent (dbremote) in batch mode
Run the SQL Remote Message Agent (dbremote) on Mac OS X
Run the SQL Remote Message Agent (dbremote) on Unix