User's Manual

Chapter 5. A Tutorial for Adaptive Server Enterprise Users
❖ To replicate the data from Adaptive Server Enterprise
1. Enter the following statement (on a single line) at the command line to
run the Message Agent against the consolidated database:
ssremote -c "eng=server-name;dbn=hq;uid=sa;pwd=sysadmin"
2. Click Shutdown on the Message Agent window to stop the Message
Agent when the messages have been sent.
Receive data at the remote database
To receive the insert statement at the remote database, you must run the
Message Agent, dbremote , at the remote database.
❖ To receive the data at Adaptive Server Anywhere
1. With the database server running, receive the data using the Message
Agent for Adaptive Server Anywhere:
dbremote -c "eng=field;dbn=field;uid=DBA;pwd=SQL"
☞ For more information on dbremote options, see “The Message
Agent” on page 292.
2. Click Shutdown on the Message Agent window to stop the Message
Agent when the messages have been processed.
The Message Agent window displays status information while running. This
information can be output to a log file for record keeping in a production
setup.
The Message Agent first receives a message from hq, and then sends a
message. This return message contains confirmation of successful receipt of
the replication update; such confirmations are part of the SQL Remote
message tracking system that ensures message delivery even in the event of
message system errors.
Verify that the data has
arrived
You should now connect to the remote field database using Interactive SQL,
and inspect the SalesRep and Customer tables, to see which rows have been
received.
❖ To verify that the data has arrived
1. Connect to the field database using Interactive SQL.
2. Inspect the SalesRep table by typing the following statement:
SELECT
*
FROM SalesRep
67