You can set up the SQL Remote Message Agent (dbremote) to receive and process incoming messages, scan the transaction log, create and send outgoing messages, and then stop.
You must have the SYS_RUN_REPLICATION_ROLE system role. The maximum message length, as defined by the -l option, must be the same for all databases in the system.
Ensure that at least one remote user has neither a SEND AT nor a SEND EVERY option in their remote properties.
If all of your remote users have a SEND AT or a SEND EVERY clause defined, and you want to send and receive messages and then shut down, you must start the SQL Remote Message Agent (dbremote) using the -b option.
Start the SQL Remote Message Agent (dbremote).
On Windows, the SQL Remote Message Agent (dbremote) is named dbremote.exe. On Unix, the name is dbremote. On Mac OS X, you can also use SyncConsole to start the SQL Remote Message Agent (dbremote).
For example, the following command runs dbremote in batch mode on a database file named c:\mydata.db, connecting with user name ManagerSteve and password sql:
dbremote -c "UID=ManagerSteve;PWD=sql;DBF=c:\mydata.db"
The SQL Remote Message Agent (dbremote) receives and processes incoming messages, scans the transaction log once, creates and sends the outgoing messages, and then stops.
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|