Returns current trace flag settings or changes logging trace settings for Replication Agent.
trace [flag|all, switch]
The name of the trace flag to change the setting for.
A keyword that allows you to apply a switch value to all trace flags.
A boolean (true or false) value that enables or disables tracing for the trace point specified in the flag option.
The trace command is intended for use by Sybase Technical Support engineers and when troubleshooting Replication Agent.
When trace is invoked with no options specified, it returns the current settings for all the Replication Agent trace flags.
When trace is invoked with the flag and switch options, it changes the setting of the trace point specified in the flag option and returns the current (new) setting for the specified trace point.
When trace is invoked with the all keyword and a switch option, it sets all trace points to the value specified in the switch option and returns the current (new) setting for all trace points.
Changes made with the trace command take effect immediately.
When set to “true,” tracing is enabled for the trace point identified by the specified trace flag. When set to “false,” tracing is disabled for the trace point.
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).
Trace points identified as “system” flags cannot be changed with the trace command. Output from “system” flags is sent to the Replication Agent system log file and trace log file. You can use the log_system_name command to find the name and path of the Replication Agent system log file.
Table 4-3 lists Replication Agent trace flags:
Trace Flag Name |
Trace File |
Description |
|---|---|---|
BMGRTRACE |
TRACE |
When set to “true,” this flag enables Bean Management event tracing. |
ERROR |
SYSTEM |
A serious error has occurred, manual intervention may be required for recovery. |
FATAL |
SYSTEM |
A critical error has occurred, the application cannot function without manual intervention and will probably shut down. |
INFORMATION |
SYSTEM |
Important information, no action required. |
LATRC |
TRACE |
When set to “true,” this flag traces general Log Administrator operations. |
LATRCSQL |
TRACE |
When set to “true,” this flag traces SQL conversations between Log Administrator and the primary database. |
LRTRACE |
TRACE |
When set to “true,” this flag traces general execution of the Log Reader component. |
LTITRACE |
TRACE |
When set to “true,” this trace flag enables tracing operations of the Log Transfer Interface component. |
LTITRACELTL |
TRACE |
When set to “true,” this trace flag enables LTL statement tracing in the LTITRACELTL.log file. |
LTMCI |
TRACE |
When set to “true,” causes tracing of LTM component interface invocations and LTM invocations of other components' interfaces. |
LTMHL |
TRACE |
When set to “true,” causes highlights in the LTM execution path to be noted. |
LTMSC |
TRACE |
When set to “true,” causes tracing of all Replication Agent state changes. |
LTTRNC |
TRACE |
When set to “true,” causes tracing of transaction log truncation operations. |
RACONTRC |
TRACE |
When set to “true,” causes tracing of connection and query execution. |
RACONTRCSQL |
TRACE |
When set to “true,” causes tracing of SQL statements to be executed. |
RATRACE |
TRACE |
When set to “true,” causes tracing of Replication Agent events. |
STMTRACE |
TRACE |
When set to “true,” causes tracing of LTM state monitor events. |
WARNING |
SYSTEM |
The system has suffered a minor problem; functionality is not affected, or the problem is recoverable. |
The trace command is valid when the Replication Agent instance is in either Admin or Replicating state.
Output from the LTITRACELTL trace point flag shows the
LTL exactly as it is sent from Replication Agent to the primary Replication Server.
If you want to view the LTITRACELTL output, make sure your viewer
is capable of handling very long lines.
log_system_name, log_trace_name
