Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SAP Sybase SQL Anywhere 16.0 » SQL Remote » Managing SQL Remote systems » SQL Remote Message Agent (dbremote)

 

Running the SQL Remote Message Agent (dbremote) in continuous mode

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.

 Task
  1. Ensure that every REMOTE user either has a SEND AT or SEND EVERY frequency specified.

  2. 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

Results

The SQL Remote Message Agent (dbremote) is now set to run in continuous mode.

 See also
 Running the SQL Remote Message Agent (dbremote) as a service in continuous mode
 See also

Send frequency
Setting the send frequency for messages