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

License restricts the number of cores (not CPUs) which an IQ 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.

This license is required for 12.6 or 12.7 customers who already have a LOB license (IQ_LOB).

VLDB MO

IQ_VLDBMGMT

Allows you to create multiple tablespaces and additional IQ dbspaces beyond the defaults allowed.

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.

To create any additional IQ dbspace requires the IQ_VLDBMGMT license. This license restricts the ability to create table partitions. An IQ_VLDBMGMT is required whenever an 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

This license is required for 12.6 or 12.7 customers who already have encryption (IQ_ENC).

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.

This license is required for 12.6 or 12.7 customers who are already running multiplex. This is a new license requirement.

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 IQ TEXT indexes.

Note: SySAM verifies optional feature licensing at various times. See Troubleshooting SySAM > License Checkout and Verification for a table that describes the events that determine when SySAM checks out different licenses.
Related concepts
Small Business Edition (SE)
Express Edition
Related reference
Evaluation Edition
Single Application Edition (SA)