Chapter 6: System Administration

Setting trace flags

The traceflags parameter enables the logging of certain events when they occur within the Enhanced Full-Text Search engine. Each trace flag is uniquely identified by a number. Trace flags are described in Table 6-8.

**Table 6-8: Enhanced Full-Text Search engine trace flags**
Trace flag	Description
1	Traces connects, disconnects, and attention events from Adaptive Server .
2	Traces language events. Traces the SQL statement that Adaptive Server sent to the Enhanced Full-Text Search engine.
3	Traces RPC events.
4	Traces cursor events. Traces the SQL statement sent to the Enhanced Full-Text Search engine by Adaptive Server.
5	Writes the errors that display to the log.
6	Traces information about text indexes. Writes the search string being passed to Verity to the log, and writes the number of records that the search returns to the log.
7	Traces done packets.
8	Traces calls to the interface between the Enhanced Full-Text Search engine and the Verity API.
9	Traces SQL parsing.
10	Traces Verity processing.
11	Disables Verity collection optimization.
12	Disables sp_statistics from returning information.
13	Traces backup operations.
14	Logs Verity status and timing information.
15	Generates ngram index information for collections. ngrams increase the speed of wildcard searches. This trace flag is required for wildcard searches against data in Unicode format.
30	This traceflag enables the Verity MaxClean feature that removes out of date collection files. It should only be used during maintenance since it could take extra time and interfere with normal usage. It is enabled in conjuntion with sp_optimize_text_index.

You can enable and disable trace flags interactively, using the remote procedure calls (RPCs) sp_traceon and sp_traceoff in the Enhanced Full-Text Search engine.

To execute sp_traceon, use:

textserver...sp_traceon 1,2,3,4

where textserver is the name of the Enhanced Full-Text Search engine.

The traceflags stay active until the session is terminated or until the sp_traceoff RPC is executed using the specific traceflag. To set a traceflag permanently, either set it in the configuration file or use the sp_text_configure command.

View this book as PDF