The LTM configuration file

The SQL Anywhere and Adaptive Server Enterprise LTM configuration files are very similar. This section describes the entries in the SQL Anywhere LTM configuration file, and the differences from the Adaptive Server Enterprise LTM configuration file.

The configuration file that an LTM uses is specified using the -C option.

LTM configuration file parameters

The following table describes each of the configuration parameters that the LTM recognizes. Options that are used by the Adaptive Server Enterprise LTM but not by the SQL Anywhere LTM are included in this list, and marked as either ignored (in which case they may be present in the configuration file, but have no effect) or as unsupported (in which case they will cause an error if present in the configuration file).

Parameter Description
APC_pw The password for the APC_user login name. This entry is present only in SQL Anywhere LTM configuration files.
APC_user A user ID that is used when executing asynchronous procedures at the primary site. This user ID must have permissions appropriate for all asynchronous procedures at the primary site. This entry is present only in SQL Anywhere LTM configuration files.
backup_only By default, this is off. If it is set to on, the LTM replicates only backed-up transactions.
batch_ltl_cmds Set to on (the default) to use batch mode. Batch mode can increase overall throughput, but may lead to longer response times.
batch_ltl_sz The number of commands that are saved in the buffer before being sent to Replication Server, when batch_ltl_cmds is on. The default is 200.
batch_ltl_mem The amount of memory that the buffer can use before its contents are sent to Replication Server, when batch_ltl_cmds is on. The default is 256 KB.
Continuous By default, this is on. When set to off, the LTM automatically shuts down as soon as all committed data has been replicated.
LTM_admin_pw The password for the LTM_admin_user login name.
LTM_admin_user The system administrator LTM login name that is used to log in to the LTM. This parameter is required so that the LTM can check whether a user logging on to the LTM to shut it down has the correct login name.
LTM_charset The Open Client/Open Server character set for the LTM to use.
LTM_language The Open Client/Open Server language for the LTM to use.
LTM_sortorder

The Open Client/Open Server sort order for the LTM to use to compare user names. You can specify any Adaptive Server Enterprise-supported sort order that is compatible with the LTM's character set. All sort orders in your replication system should be the same.

The default sort order is a binary sort.

maint_cmds_to_skip Ignored.
qualify_table_owners Set to on for the LTM to send LTLs with table names and columns names, as well as table owners to Replication Server. The setting applies to all replicating tables, and the create replication definition statements must match this setting. The default is off.
rep_func Set to on to use asynchronous procedure calls (APCs). The default is off.
Retry The number of seconds to wait before retrying a failed connection to a SQL Anywhere database server or Replication Server. The default is 10 seconds.
RS The name of the Replication Server to which the LTM is transferring the log.
RS_pw The password for the RS_user login name.
RS_source_db The name of the database whose log the LTM transfers to the Replication Server. This name must match the name of the database as defined within the Replication Server connection definitions. Most configurations use the same setting for both RS_Source_db and SQL_database configuration options.
RS_source_ds The name of the server whose log the LTM transfers to the Replication Server. This name must match the name of the server as defined within the Replication Server connection definitions. Most configurations use the same setting for both RS_Source_ds and SQL_server configuration options.
RS_user A login name for the LTM to use to log in to the Replication Server. The login name must have been granted connect source permission in the Replication Server.
scan_retry The number of seconds that the LTM waits between scans of the transaction log. This parameter is somewhat different in meaning to that of the Adaptive Server Enterprise LTM. The SQL Anywhere server does not wake up and scan the log when records arrive in the log. For this reason, you may want to set the scan_retry value to a smaller number then that for an Adaptive Server Enterprise LTM.
skip_ltl_cmd_err This parameter tells Replication Agent to continue or shut down when LTL command errors occur. When skip_ltl_cmd_err=on is specified, Replication Agent displays the LTL commands that caused the errors and then skips the LTLs and continues replication. When this parameter is set to off, Replication Agent displays the LTL commands that caused the errors and then shuts down. By default, this parameter is set to off.
SQL_database The primary site database name on the server SQL_server to which the LTM connects. For Adaptive Server Enterprise during recovery, this is the temporary database whose logs the LTM will transfer to Replication Server. The SQL Anywhere LTM uses the SQL_log_files parameter to locate offline transaction logs.
SQL_log_files A directory that holds off-line transaction logs. The directory must exist when the LTM starts up. This entry is present only in SQL Anywhere LTM configuration files.
SQL_pw The password for the SQL_user user ID.
SQL_server The name of the primary site SQL Anywhere server to which the LTM connects. For Adaptive Server Enterprise during recovery, this is a data server with a temporary database whose logs the LTM will transfer to Replication Server. The LTM uses the SQL_log_files parameter to locate offline transaction logs.
SQL_user The login name that the LTM uses to connect to the database specified by RS_source_ds and RS_source_db.
Example configuration file

The following is a sample 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=PRIMEOS
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\backup
APC_user=sa
APC_pw=sysadmin