Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.1 » SQL Anywhere Server - Database Administration » Administering Your Database » Database administration utilities

 

Log Transfer Manager utility (dbltm)

Reads a database transaction log and sends committed changes to Replication Server.

Syntax
dbltm [ options ]
Option Description
@data

Reads in options from the specified environment variable or configuration file. See Using configuration files.

If you want to protect passwords or other information in the configuration file, you can use the File Hiding utility to obfuscate the contents of the configuration file. See File Hiding utility (dbfhide).

-A Prevents filtering of updates. By default, all changes made by the maintenance user are not replicated. If the -A option is set, these changes are replicated. This may be useful in non-hierarchical Replication Server installations, where a database acts as both a replicate site and as a primary site.
-C config-file

Uses the configuration file config-file to determine the LTM settings. The default configuration file is dbltm.cfg. See The LTM configuration file.

-I interface-file (Uppercase I.) Uses the named interfaces file. The interfaces file is the file created by DSEDIT and holds the connection information for Open Servers. The default interfaces file is SQL.ini in the ini subdirectory of your Sybase directory.
-M Initiates recovery actions. The LTM starts reading logs from the earliest available position. If the offline directory is specified in the configuration file, the LTM reads from the oldest offline log file.
-S LTM-name Provides the server name for this LTM. The default LTM name is DBLTM_LTM. The LTM name must correspond to the Open Server name for the LTM that was entered in DSEDIT.
-dl Displays all messages in the LTM window or at a command prompt, and in the log file (if specified).
-ek key Specifies the encryption key for strongly encrypted databases directly in the command. If you have a strongly encrypted database, you must provide the encryption key to use the database or transaction log in any way, including offline transaction logs. For strongly encrypted databases, you must specify either -ek or -ep, but not both. The command fails if you do not specify a key for a strongly encrypted database.
-ep Specifies that you want to be prompted for the encryption key. This option causes a window to appear, in which you enter the encryption key. It provides an extra measure of security by never allowing the encryption key to be seen in clear text. For strongly encrypted databases, you must specify either -ek or -ep, but not both. The command fails if you do not specify a key for a strongly encrypted database.
-o filename Uses a log file different from the default (dbltm.log). Output messages from log transfer operations are written to this file.
-os size Specifies the maximum size of the output file, in bytes. The minimum value is 10000 (ten thousand). If the log file grows to the point where it would exceed this limit, it is renamed to yymmddxx.ltm. The value of xx in yymmddxx.ltm is incremented for each file created on a given day.
-ot file Uses a log file different from the default (dbltm.log), and truncates the log file (all existing content is deleted) when the LTM starts. Output messages from log transfer operations are sent to this file for later review.
-q Minimizes the window when the LTM is started.
-s Logs all LTL commands that are generated by the LTM. This should be used only to diagnose problems, and is not recommended in a production environment. It carries a significant performance penalty.
-ud Runs the LTM as a daemon on Unix operating systems. If you run in this manner, output is logged to the log file.
-ux Opens the Log Transfer Manager window if dbltm can find a usable display on Unix operating systems. If it cannot find one, for example because the DISPLAY environment variable is not set or because the X window server is not running, dbltm fails to start. On Microsoft Windows, the dbltm window appears automatically.
-v Displays messages, other than LTL messages, for debugging purposes.
Remarks

The Log Transfer Manager (LTM) is also known as a replication agent. The LTM is required for any SQL Anywhere database that participates in a Replication Server installation as a primary site.

The SQL Anywhere LTM reads a database transaction log and sends committed changes to Replication Server. The LTM is not required at replicate sites.

The LTM sends committed changes to Replication Server in a language named Log Transfer Language (LTL).

By default, the LTM uses a log file named DBLTM.LOG to hold status and other messages. You can use options to change the name of this file and to change the volume and type of messages that are sent to it.

Exit codes are 0 (success) or non-zero (failure). See Software component exit codes.


The LTM configuration file