Installation guide

Determining the Edition You Have
If you already use Adaptive Server, use the sp_lmconfig system procedure to identify the
version.
Enter:
sp_lmconfig 'edition'
Adaptive Server returns a value of EE, SE, or DE based on the edition that is currently running.
See the Reference Manual for more information about sp_lmconfig.
Adaptive Server Options
Sybase offers various optional features for Adaptive Server, such as data compression,
partitions, and encrypted columns.
Option Description
Data compression Enables compression for regular and large object data, which uses less storage
space for the same amount of data, reduces cache memory consumption, and
improves performance due to lower I/O demands.
Security and direc-
tory services
Provides lightweight directory services and network-based authentication and
encryption using SSL and Kerberos.
Partitions Enables semantic partitioning for table row data.
Encrypted col-
umns
Increases security parameters and allows for addition of datatypes.
Tivoli Storage
Manager
Enables the database to back up and restore operations to IBM Tivoli Storage
Manager.
In-memory data-
base
Provides zero-disk-footprint in-memory database support that is fully integra-
ted with Adaptive Server for high-performance transactional applications.
Provides performance enhancements to disk-resident databases with relaxed
durability properties.
Adaptive Server editions and optional features are unlocked by SySAM licenses. See the
Sybase Software Asset Management Users Guide .
Managing Adaptive Server Enterprise with Sybase Control
Center
Sybase Control Center provides a single, comprehensive, Web-administration console for
real-time performance, status, and availability monitoring of large-scale Sybase enterprise
servers. Sybase Control Center combines a modular architecture, a rich client administrative
CHAPTER 3: Adaptive Server Components
6 Adaptive Server Enterprise