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.
Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |