ASA Database Administration Guide
Replicating Data with Replication Server
Tutorial: Replicate data using Replication Server
Lesson 9: Set up Replication Server
For replication to take place, the Adaptive Server Anywhere LTM must be running against the primary site server. Before you start the Adaptive Server Anywhere LTM, make sure it is properly configured by editing an LTM configuration file.
Below is a sample configuration file for the primedb database. If you are following the examples, you should make a copy of this file as primeltm.cfg:
# # Configuration file for 'PRIMELTM' # SQL_server=PRIMEDB SQL_database=primedb SQL_user=sa SQL_pw=sysadmin RS_source_ds=PRIMEDB RS_source_db=primedb RS=your_rep_server_name_here RS_user=sa RS_pw=sysadmin LTM_admin_user=DBA LTM_admin_pw=SQL LTM_charset=cp850 scan_retry=2 APC_user=sa APC_pw=sysadmin SQL_log_files=C:\TUTORIAL
If you have changed the user ID and password in the rssetup.sql command file from sa and sysadmin, you should use the new user ID and password in this configuration.
To start the Adaptive Server Anywhere LTM running on the primary site server, enter the following command:
dbltm -S PRIMELTM -C primeltm.cfg
The connection information is in primeltm.cfg. In this command, PRIMELTM is the server name of the LTM.
You can find usage information about the Adaptive Server Anywhere LTM by typing the following statement:
dbltm -?
You can run the Adaptive Server Anywhere LTM as a Windows service. For information on running programs as services, see Running the server outside the current session.