Available Configuration Parameters

The following table provides a list of available configuration parameters with valid limits:

Table 6-5: Limits to Configuration parameters

Parameter

Values

Static/Dynamic

batch_size

0 - MAX_INT

Dynamic

batch_blocksize

0 - 65535

Dynamic

max_indexes

0 - MAX_INT

Static

max_stacksize

0 - MAX_INT

Static

max_threads

0 - MAX_INT

Static

max_packetsize

0 - MAX_INT

Static

max_sessions

0 - MAX_INT

Static

min_sessions

0 - max_sessions

Static

language

french, spanish german, us_english

Static

charset

ascii_8, cp037, cp1047, cp437, cp500, cp850, deckanji, eucjis, iso_1, mac, roman8, sjis, utf8

Static

vdkCharset

850, 437, 1252, mac1 (Just the ones listed in the manual)

Static

vdkLanguage

frenchx, spanishx, germanx, english, englishx, bokmalx, dutchx, finnishx, nynorskx, swedishx, portugx, italianx, danishx

Static

vdkHome

A string < 255 chars

Static

collDir

A string < 255 chars

Static

default_Db

A string < 32 chars

Static

interfaces

A string < 255 chars

Static

sort_order

0, 1, 2, 3

Dynamic

errorLog

A string < 255 chars

Static

traceflags

A string with comma delimited numbers ranging anywhere from 1 to 15.

Static

srv_traceflags

A string with comma delimited numbers ranging anywhere from 1 to 8

Static

cluster_style

Coarse, Medium, Fine, Fixed

Dynamic

cluster_max

0 - MAX_INT

Dynamic

cluster_effort

Low, Medium, High, Default

Dynamic

cluster_order

0 or 1

Dynamic

auto_online

0 or 1

Static

backCmd

A string < 255 chars

Dynamic

restoreCmd

A string < 255 chars

Dynamic

backDir

A string < 255 chars

Static

knowledge_base

A string < 255 chars

Static

nocase

0 or 1

Dynamic