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