Starting Adaptive Server with optional features

Optional features can be turned on or off using sp_configure parameters. 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

Distributed Transaction Management


enable xact coordination enable DTM

Java in Adaptive Server


enable java

Advanced Security Mechanisms


use security services

Enhanced full-text search


enable full-text search

External file system


enable file access

LDAP directory services



NoteAdaptive Server’s support for distributed transaction management protocols: XA and Microsoft DTC protocols, requires configuration parameter enable DTM to be set and also a license to be available.

Distributed transaction management support through Adaptive Server Transaction Coordinator requires configuration parameter enable xact coordination to be set. However, this feature is available with no license requirements.

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 the Adaptive Server Configuration Guide.