Contents Index Create a replication definition Create a subscription for your replication

ASA Database Administration Guide
  Replicating Data with Replication Server
    Tutorial: Replicate data using Replication Server
      Lesson 9: Set up Replication Server

Configure and start the Adaptive Server Anywhere LTM

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.


Contents Index Create a replication definition Create a subscription for your replication