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.
There is usually some performance impact when you use
these trace flags and parameters. You should review the full description
of a trace flag or parameter in the Sybase Replication Agent Administration
Guide before using it.
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.
