Modifying the Configuration Parameters

Each Full-Text Search engine has configuration parameters with default values, as shown in Table 6-3.

Table 6-3: Configuration parameters

Parameter

Description

Default Value

batch_size

Determines the size of the batches sent to the Full-Text Search engine.

500

batch_blocksize

When enabled, the text server reads data in smaller chunks. This parameter instructs the text server to retrieve n number of rows at a time. Should be set to 0 (disabled) to 65535.

0

max_indexes

The maximum number of text indexes that will be created in the Full-Text Search engine.

126

max_stacksize

Size (in kilobytes) of the stack allocated for client threads.

34,816

max_threads

Maximum number of threads available for the Full-Text Search engine.

50

max_packetsize

Packet size sent between the Full-Text Search engine and the Adaptive Server.

2048

max_sessions

Maximum number of sessions for the Full-Text Search engine.

100

min_sessions

Minimum number of sessions for the Full-Text Search engine.

10

language

Language used by the Full-Text Search engine.

us_english

charset

Character set used by the Full-Text Search engine.

iso_1

vdkCharset

Character set used by Verity search engine.

850

vdkLanguage

Language used by Verity search engine.

english

vdkHome

Verity directory.

UNIX:

$SYBASE/$SYBASE_FTS/verity

Windows NT:

%SYBASE%\%SYBASE_FTS%\verity

collDir

Storage location of the Full-Text Search engine’s collection.

UNIX:

$SYBASE/$SYBASE_FTS/collections

Windows NT:

%SYBASE%\%SYBASE_FTS%\collections

defaultDb

Name of the Full-Text Search engine database that stores text index metadata.

text_db

interfaces

Full path to the directory in which the interfaces file used by the Full-Text Search engine is located.

UNIX:

$SYBASE/interfaces

Windows NT:

%SYBASE%\ini\sql.ini

sort_order

Default sort order.

0

errorLog

Full path name to the error log file.

The directory in which you start Full-Text Search engine

traceflags

String containing numeric identifiers used to generate diagnostic information.

0

srv_traceflags

String containing numeric flag identifiers used to generate Open Server diagnostic information.

0

The Enhanced Full-Text Search engine has additional configuration parameters as shown in Table 6-4:

Table 6-4: Configuration parameters for Enhanced version only

Parameter

Description

Default Value

cluster_style

Clustering style to use.

Fixed

cluster_max

Maximum number of clusters to generate when cluster_style is set to Fixed.

0

cluster_effort

Amount of effort the Full-Text Search engine should expend on finding a good cluster.

Default

cluster_order

The order to return clusters and rows within a cluster.

0

auto_online

Specifies whether to bring indexes online automatically when the Full-Text Search engine is started. 0 indicates online is not automatic; 1 indicates automatic.

0

backDir

The default location for the placement of text index backup files.

UNIX:

$SYBASE/$SYBASE_FTS/backup

Windows NT:

%SYBASE%\%SYBASE_FTS%\backup

knowledge_base

The location of a knowledge base map for implementing the Verity topics feature.

null

nocase

Sets the case-sensitivity of the Full-Text Search engine. If you are using a case-sensitive sort order in Adaptive Server, set to 0. If you are using a case-insensitive sort order, set to 1.

0

A sample configuration file that includes all of these parameters is copied to your installation directory during installation. The sample configuration file is named textsvr.cfg. The entire sample configuration file is listed in Appendix B, “Sample Files.”