Turns ASE Replicator trace flags on or off, lists all ASE Replicator trace flags and their status.
sp_tracerep [flag|all_flags [, {true|false}]]
is the name of an ASE Replicator trace flag.
Table 4-36 lists all the ASE Replicator trace flags:
Flag |
Type |
Description |
|---|---|---|
BMGRTRACE |
TRACE |
Bean Management trace events. |
CONNTRC |
TRACE |
Traces ASE Replicator connection management. |
DDBLOGTRC |
TRACE |
Trace Distribution Database transaction log operations. |
DDBLRTRC |
TRACE |
Trace Distribution Database transaction log reader operations. |
DISTTRC |
TRACE |
Trace distribution activities. |
ERROR |
SYSTEM |
Serious error. Manual intervention may be required for recovery. |
FATAL |
SYSTEM |
Critical error. The system cannot function without manual intervention. |
INFORMATION |
SYSTEM |
Important information. No action required. |
LATRC |
TRACE |
Trace DDBAdmin events. |
LATRCSQL |
TRACE |
Trace DDBAdmin SQL execution. |
LOBTRACE |
TRACE |
Trace LOB Replication activities. |
LRTRACE |
TRACE |
Trace transaction log reader operations. |
LWTRACE |
TRACE |
Trace distribution log write operations. |
RACONTRC |
TRACE |
Traces connection and query execution. |
RACONTRCSQL |
TRACE |
Traces SQL statements to be executed. |
RPLTRC |
TRACE |
Provides general ASE Replicator trace information. |
STATTRC |
TRACE |
Trace statistics operation. |
SUBPROCTRC |
TRACE |
Trace subscription processor operations. |
WARNING |
SYSTEM |
The system has suffered a minor problem. Functionality is not affected or problem is recoverable. |
is a keyword that indicates that all trace flags should be turned on or off.
is a keyword that indicates that the trace flag should be turned on.
is a keyword that indicates that the trace flag should be turned off.
sp_tracerep LATRC
Returns information about the ASE Replicator LATRC trace flag.
sp_tracerep LATRC, true
Turns on tracing for the ASE Replicator LATRC trace flag.
sp_tracerep all_flags, true
Turns on tracing for all ASE Replicator trace flags.
When listing information about ASE Replicator trace flags, the following result set is returned:
Column |
Datatype |
Description |
|---|---|---|
trace_flag |
varchar(32) |
Name of the trace flag |
current_value |
varchar(5) |
Current value of the trace flag:
|
trace_file |
varchar(6) |
Type of flag and the output file:
|
description |
varchar(255) |
Description of the trace flag |
When sp_tracerep is invoked without specifying an ASE Replicator trace flag (flag), it returns information about all ASE Replicator trace flags.
When sp_tracerep is invoked with an ASE Replicator trace flag (flag), it returns information about the specified trace flag.
When sp_tracerep is invoked with an ASE Replicator trace flag (flag) and a keyword (true or false), it sets the specified trace flag to the value specified.
Trace flags listed in Table 4-36 as SYSTEM flags cannot be turned off.
When sp_tracerep changes the specified ASE Replicator trace flag setting, no results are returned.
When an error occurs, an error message is returned.
sp_helpqueue, sp_helpreperrors
