Optional features can be turned on or off using sp_configure parameters. Table 3-2 lists the parameters used to configure optional features.
Feature name |
License name |
Configuration parameter |
---|---|---|
Distributed Transaction Management |
ASE_DTM |
enable xact coordination enable DTM |
Java in Adaptive Server |
ASE_JAVA |
enable java |
Advanced Security Mechanisms |
ASE_ASM |
use security services |
Enhanced full-text search |
ASE_EFTS |
enable full-text search |
External file system |
ASE_XFS |
enable file access |
LDAP directory services |
ASE_DIRS |
n/a |
Adaptive 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.
For information about configuring Adaptive Server with Distributed Transaction, see Using Adaptive Server Distributed Transaction Management Features.
For information about configuring Adaptive Server Full Text Search capabilities, see Full Text Search Specialty Data Store User’s Guide.
For information about Java in Adaptive Server, see Java in Adaptive Server Enterprise.
For information about lightweight directory services, see the System Administration Guide.
For information about advanced security mechanisms, see the Component Integration Services User’s Guide.