User's Manual

Chapter 13. Using SQL Remote with Replication Server
Message
Agent
Message system
Replication Server and
SQL Remote
SQL Remote allows two-way replication between the consolidated database
and remote databases. Replication Server is performing one-way replication
from the consolidated database to the SQL Remote Open Server. From
Replication Server’s perspective, transactions that originate in remote
SQL Remote databases appear as transactions originating in the consolidated
SQL Remote database.
SQL Remote system
tables
The SQL Remote Open Server requires information from the SQL Remote
system tables concerning publications and subscriptions. The Open Server
uses a connection to the Adaptive Server Enterprise database holding that
information to retrieve it when it starts.
If the SQL Remote system tables are updated while the Open Server is
running, the SQL Remote Open Server needs to receive this information at
the correct time. For this reason, some of the SQL Remote system tables
need to be marked for replication. This is described in “Setting up SQL
Remote Open Server” on page 282.
The SQL Remote Open
Server executable
The SQL Remote Open Server is the following executable:
♦ On Windows operating systems, the SQL Remote Open Server is
ssqueue.exe .
♦ On UNIX operating systems, the SQL Remote Open Server is ssqueue .
281