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 |
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.
Send feedback about this page via email or DocCommentXchange | Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0 |