Enterprise Edition (EE)

SAP Sybase IQ Enterprise Edition requires a CPU license and supports several licensing options.

Enterprise Edition.
Orderable License Actual License Required Optional Description
CPU IQ_CORE  

Restricts the number of cores (not CPUs) that a server can use

LOMO IQ_LOB  

Allows you to create and use CLOB or LOB columns. The number of LOB licenses must match number of cores.

IQ_LOB license is included for customers who purchase an IQ_UDA license. An IQ_LOB license is also available as a separate purchase option.

VLDB MO IQ_VLDBMGMT  
Allows you to create multiple tablespaces and additional dbspaces beyond the defaults:
  • You are allowed one IQ_SYSTEM_TEMP dbspace, one IQ_SYSTEM_MAIN dbspace, one IQ_SHARED_TEMP, and one additional user defined main store dbspace.

  • Additional dbspaces require the IQ_VLDBMGMT license, which restricts the ability to create table partitions. An IQ_VLDBMGMT is required whenever an SAP Sybase IQ server creates or starts with two or more IQ user dbspaces.

Each VLDB license allows for 1 TB of storage. You will need to purchase one license for each additional TB of storage in the main store.
ASO IQ_SECURITY  

Allows you to use column encryption, ECC Kerberos and FIPS. The number of ASO licenses must match cores.

MPXO IQ_MPXNODE  

Allows you to start secondary multiplex nodes (readers/writers). The number of nodes must always be less than cores, as each multiplex server must have at least one core.

IDBA-PSO IQ_UDF  

Allows you to define and run high-performance scalar and aggregate user-defined functions.

This license is only available with approved third-party libraries.

IQ_IDA  

Allows you to build, deploy and run your own C/C++ V4 User-Defined Functions (UDF).

The IQ_IDA license will function as both the InDatabase Analytics Option and Partner Solutions license.

UDA IQ_UDA  

Allows you to use the IQ Text Search functionality, which lets SAP Sybase IQ search unstructured and semi-structured data. An IQ_UDA also includes an IQ_LOB license. This license applies to TEXT indexes.

Related concepts
Small Business Edition (SE)
Express Edition
Related reference
Evaluation Edition
Single Application Edition (SA)