Configuring the LTM

You control LTM behavior by modifying the LTM configuration file, which is a plain text file created and edited using a text editor. The LTM configuration file contains information the LTM needs, such as the SQL Anywhere server it transfers a log from, the Replication Server it transfers the log to. You need a valid configuration file to run the LTM.

Creating a configuration file

You must create a configuration file, using a text editor, before you can run the LTM. The -C LTM command specifies the name of the configuration file to use, and has a default of dbltm.cfg.

Configuration file format

The LTM configuration file shares the same format as the Replication Server configuration file described in your Replication Server Administration Guide. In summary:

  • The configuration file contains one entry per line.

  • An entry consists of a parameter, followed by the = character, followed by the value:

    Entry=value

  • Lines beginning with a # character are comments ignored by the LTM.

  • The configuration file cannot contain leading blanks.

  • Entries are case sensitive.

For the full list of available configuration file parameters, see The LTM configuration file.

Example configuration file

  • The following is a sample SQL Anywhere LTM configuration file.

    # This is a comment line
# Names are case sensitive.
SQL_user=sa
SQL_pw=sysadmin
SQL_server=PRIMESV
SQL_database=primedb
RS_source_ds=PRIMESV
RS_source_db=primedb
RS=MY_REPSERVER
RS_user=sa
RS_pw=sysadmin
LTM_admin_user=DBA
LTM_admin_pw=sql
LTM_charset=cp850
scan_retry=2
SQL_log_files=e:\logs\old_logs
APC_user=sa
APC_pw=sysadmin

Replicating transactions in batches

Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1