You can use the trace flags and configuration parameters described in this section to obtain additional information that is not normally presented by the Sybase Replication Agent.
Some performance impact usually occurs when you use
these trace flags and parameters. Before using it, you should review
the full description of a trace flag or parameter in the Sybase
Replication Agent Administration Guide.
Normal trace output is sent to the Replication Agent trace log file. You can use the log_trace_name command to find the name and path of the Replication Agent trace log file.
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 Sybase 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.
The settings of the following Sybase Replication Agent configuration parameters affect the trace information:
compress_ltl_syntax – provides more verbose description of LTL commands when set to false.
connect_to_rs – allows LTL to be generated without actual connection or sending information to Replication Server when set to false.
log_trace_verbose – provides more verbose description of traced components when set to true.
use_rssd – provides a complete generation of LTL commands without modification for replication definition information when set to false.
column_compression – sends complete column information (all columns in after images) in the generated LTL for update operations when set to false.
For a complete description of Sybase Replication Agent trace flags and configuration settings, refer to the Sybase Replication Agent Administration Guide.
