Configure and start the SQL Anywhere LTM

For replication to take place, the SQL Anywhere LTM must be running against the primary site server. Before you start the SQL 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\PRIMEDB

If you have changed the user ID and password in the rssetup.sql command file for sa and sysadmin, you should use the new user ID and password in this configuration.

To start the SQL 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 SQL Anywhere LTM by typing the following statement:

dbltm -?

You can run the SQL Anywhere LTM as a Windows service.

For information about running programs as services, see Running the server outside the current session.