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