Deprecated feature

In the next major release of SQL Anywhere Studio, SQL Remote for Adaptive Server Enterprise will not be present. MobiLink provides a more flexible and scalable solution for data synchronization between Adaptive Server Enterprise and Adaptive Server Anywhere databases.

 

You can also run the Message Agent from your own application by calling

 

into the DBTools library. For more information, see the file dbrmt.h in the h

 

subdirectory of your SQL Remote installation directory.

 

For Adaptive Server Anywhere, the user ID in the Message Agent command

 

must have either REMOTE DBA or DBA authority. For Adaptive Server

 

Enterprise, the user ID must have replication role.

 

The optional directory parameter specifies a directory in which old

 

transaction logs are held, so that the Message Agent has access to events

 

from before the current log was started.

 

The Message Agent uses a number of connections to the database. For a

 

listing, see “Connections used by the Message Agent” on page 224 .

 

For information on REMOTE DBA authority, see “The Message Agent

 

and replication security” on page 243 .

Option details

@data Use this option to read in options from the specified environment

 

variable or configuration file. If both exist with the same name, the

 

environment variable is used.

 

The environment variable may contain any set of options. For example, the

 

first of the following pair of statements sets an environment variable holding

 

a set of options for a database server that starts with a cache size of 4 Mb,

 

receives messages only, and connects to a database named field on a server

 

named myserver. The set statement should be entered all on one line:

 

set envvar=-m 4096 -r

 

-c "eng=myserver;dbn=field;uid=sa;pwd=sysadmin"

 

ssremote @envvar

 

The configuration file may contain line breaks, and may contain any set of

 

options. For example, the following command file holds a set of options for

 

a Message Agent that starts with a cache size of 4 Mb, sends messages only,

 

and connects to a database named field on a server named myserver:

 

-m 4096

 

-s

 

-c "eng=myserver;dbn=field;uid=sa;pwd=sysadmin"

 

If this configuration file is saved as c:\config.txt , it can be used in a

 

command as follows:

294

Page 312
Image 312
Sybase DC38133-01-0902-01 manual Listing, see Connections used by the Message Agent on, Replication security on