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

SQL Anywhere 11.0.1 » SQL Remote » SQL Remote Deployment and Administration » SQL Remote Administration » Understanding the Message Agent (dbremote)


Run the Message Agent (dbremote) in continuous mode

Typically, the consolidated database is run in continuous mode. For information about continuous mode and its alternative, batch mode, see Understanding the Message Agent (dbremote).

To run the Message Agent (dbremote) in continuous mode
  1. Ensure that every user with REMOTE authority either has a SEND AT or SEND EVERY frequency specified.

    In continuous mode, the Message Agent (dbremote) sends messages at times specified by the SEND AT or SEND EVERY frequency in the properties of each remote user. See Setting the send frequency.

  2. Start the Message Agent (dbremote) without the -b option.

    On Windows, the 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 Message Agent (dbremote). See Run the Message Agent (dbremote) on Mac OS X and Run the Message Agent (dbremote) on Unix.

    For example, the following statement 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

    The user name, ManagerSteve, must have either REMOTE DBA authority or DBA authority. The maximum message length, as defined by the -l option, must be the same for all databases in the system. See Message Agent (dbremote) requirements.

    For a complete list of dbremote options you can specify, see Message Agent (dbremote).

Running the Message Agent (dbremote) as a service in continuous mode

When you run the Message Agent (dbremote) in continuous mode, you can choose to keep the Message Agent (dbremote) running whenever the database server is running. You can do this by running the Message Agent (dbremote) as a Windows service. A service can be configured to keep running even when the current user logs out and to start when the operating system is started.

For a full description of running programs as services, see Service utility (dbsvc) for Windows.

Setting the send frequency