The traceflags parameter enable the logging of certain events when they occur within the Full-Text Search engine. Each trace flag is uniquely identified by a number. Trace flags are described in Table 6-9.
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 Full-Text Search engine. |
3 |
Traces RPC events. |
4 |
Traces cursor events. Traces the SQL statement sent to the 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 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. Available only with Enhanced Full-Text Search Specialty Data Store. |
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 Full-Text Search engine.
To execute sp_traceon, use the following syntax:
textserver...sp_traceon 1,2,3,4
where textserver is the name of the Full-Text Search engine.
The traceflags will 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 config file or use the sp_text_configure command.
