sp_tracerep

Description

Turns ASE Replicator trace flags on or off, and lists all ASE Replicator trace flags and their status.

Syntax

sp_tracerep [flag|all_flags [, {true|false}]]

Parameters

flag

The name of an ASE Replicator trace flag.

Table 4-34 lists all the ASE Replicator trace flags:

Table 4-34: 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.

all_flags

The keyword that indicates that all trace flags should be turned on or off.

true

The keyword that indicates that the trace flag should be turned on.

false

The keyword that indicates that the trace flag should be turned off.

Examples

Example 1

sp_tracerep LATRC

Returns information about the ASE Replicator LATRC trace flag.

Example 2

sp_tracerep LATRC, true

Turns on tracing for the ASE Replicator LATRC trace flag.

Example 3

sp_tracerep all_flags, true

Turns on tracing for all ASE Replicator trace flags.

Usage

• When listing information about ASE Replicator trace flags, the following result set is returned:

  Table 4-35: ASE Replicator trace flag information

  Column	Datatype	Description
  trace_flag	varchar(32)	Name of the trace flag
  current_value	varchar(5)	Current value of the trace flag: true - flag is on false - flag is off
  trace_file	varchar(6)	Type of flag and the output file: system trace debug
  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-34 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.

See also

sp_helpqueue, sp_helpreperrors

Copyright © 2005. Sybase Inc. All rights reserved.

View this book as PDF