In continuous mode, the SQL Remote Message Agent (dbremote) sends messages at times specified by the SEND AT or SEND EVERY frequency in the properties of each remote user.
Prerequisites
You must have the SYS_RUN_REPLICATION_ROLE system role.
To run the SQL Remote Message Agent (dbremote) in continuous mode, for example on the consolidated database, you must ensure that every REMOTE user has a send frequency specified.
The maximum message length, as defined by the -l option, must be the same for all databases in the system.
Context and remarks
Typically, the consolidated database is run in continuous mode. In continuous mode, the SQL Remote Message Agent (dbremote) sends messages at the times specified with the SEND AT or SEND EVERY property.
Ensure that every REMOTE user either has a SEND AT or SEND EVERY frequency specified.
Start the SQL Remote Message Agent (dbremote) without the -b option.
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 continuous 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" -l 40000 |
Send frequency
Setting the send frequency for messages
![]() |
Discuss this page in DocCommentXchange.
|
Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0 |