You can use sp_configure parameters to turn on or off optional features. Table 11-3 lists the parameters used to configure optional features.
Feature name |
License name |
Configuration parameter |
|---|---|---|
High availability |
ASE_HA |
enable HA |
Distributed transaction management |
ASE_DTM |
enable DTM |
Java in Adaptive Server |
ASE_JAVA |
enable java |
Advanced security mechanisms |
ASE_ASM |
use security services enable ssl |
Enterprise JavaBean 32-bit platforms only |
ASE_EJB |
enable enterprise java beans |
LDAP directory services |
ASE_DIRS |
n/a |
Enhanced full-text search |
ASE_EFTS |
enable full-text search |
External file system |
ASE_XFS |
enable file access |
Web Services |
ASE_SEBSERVICES |
enable web services |
XML support |
ASE_XML |
enable xml services |
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, if directed to do so.
