Replication Agent

You can use the trace flags and configuration parameters to obtain additional information that is not normally presented by the Replication Agent (for Microsoft SQL Server, Oracle, and UDB).

Note: Some performance impact usually occurs when you use these trace flags and parameters. Before using a flag or parameter, review its full description in the Replication Agent Administration Guide.

Trace Flags

Normal trace output is sent to the Replication Agent instance log file. However, output from the LTITRACELTL trace point is sent to a separate LTL output log file (LTITRACELTL.log).

The following trace flags are particularly useful for troubleshooting Replication Agent problems:

LRTRACE – traces general execution of the Log Reader component.
LTITRACE – traces general execution of the Log Transfer Interface component.
LTITRACELTL – enables LTL statement tracing in the LTITRACELTL.log file.
RACONTRC – traces connection and query execution.
RACONTRCSQL – traces SQL statements sent to the primary database.

Configuration Parameters

The settings of the following Replication Agent configuration parameters affect the trace information:

compress_ltl_syntax – when set to false, provides more verbose description of LTL commands.
connect_to_rs – when set to false, allows LTL to be generated without actual connection or sending information to Replication Server.
log_trace_verbose – when set to true, provides more verbose description of traced components.
use_rssd – when set to false, provides a complete generation of LTL commands without modification for replication definition information.
column_compression – when set to false, sends complete column information (all columns in after images) in the generated LTL for update operations.

For a complete description of Replication Agent trace flags and configuration settings, see the Replication Agent Administration Guide.