Starting Adaptive Server with optional features

You can use sp_configure parameters to turn on or off optional features. Table 3-2 lists the parameters used to configure optional features.

Table 3-2: Configuration parameters for optional features

Feature name

License name

Configuration parameter

Java in Adaptive Server


enable java

Advanced security mechanisms


use security services

LDAP directory services



Enhanced full-text search


enable full-text search

External file system


enable file access

By default, the configuration parameters for optional features are set to 0 (off). To enable an optional feature, use sp_configure to set its configuration parameter to 1, and restart Adaptive Server.

Some features require additional preparation before you can use them. For more information, see Table 3-2 and Configuring Adaptive Server Enterprise.