Skip to Content
avatar image
Former Member

Sybase IQ license approach

Hi all,

Sybase IQ  licensed by Cores and additional options. In 2014 standard physical processor will include 12-14 cores. In 2015  maybe  20, and so on.

In big IQ installation you also will pay for partitioning ⚠️,  each node in MultiPlex, and ability to use BLOB and CLOB fields.

Are you ready to pay for this?

SAP HANA licensed  by  data volumes. Partitioning, nodes, BLOBs, CLOBs - all include in licenses.

What do you think about?

Product Editions

SAP Sybase IQ is available in several product editions.

Edition Description

Enterprise Edition

Supports all options and features.

Optional features require additional licenses that are purchased separately.

Small Business Edition

Supports most of the functionality available in the Enterprise Edition, but does not support multiplex or any optional features.

Single Application Server

Provides the same functionality as the Small Business Edition, but is restricted to use in a one- or two-machine environment.

Evaluation Edition

Supports all options and features available in the Enterprise Edition for a 30-day evaluation period.

Express Edition

Supports all options and features available in the Evaluation Edition.

Unlike the Evaluation Edition, the Express Edition does not expire, but does restrict the size of all IQ main dbspaces, permit other incremental license options, and cannot be deployed in a production environment.

Optional Features

SAP Sybase IQ provides significantly faster query performance than traditional database environments. Additional product options extend the power of SAP Sybase IQ to meet specific performance, scalability, security, availability, and manageability requirements.

  • Unstructured Data Analytics
    The Unstructured Data Analytics option (IQ_UDA) supports binary large object (BLOB) and character large object (CLOB) storage and retrieval.  - By Cores.
  • Advanced Security
    The Advanced Security Option (IQ_SECURITY) protects your environment against unauthorized access.
  • Multiplex Grid
    The Multiplex Grid Option lets you add nodes to a multiplex environment, enabling a highly scalable shared disk grid technology that allows. - By nodes.
  • Very Large Database Management
    The Very Large Database Management Option (IQ_VLDBMGMT) lets you logically partition very large data sets into smaller subsets. - By TBs.
  • In-Database Analytics—Partner Solution Options
    This option provides a versatile, high performance C++ Application Programming Interface (API) that allows users to extend the analytical capabilities of SAP Sybase IQ by plugging in externally built C++ functions. These external C++ functions operate in proximity to the data stored in SAP Sybase IQ and are often executed in a highly parallelized fashion, thereby providing high efficiencies in performance, usability, and total cost of ownership.

  • InDatabase Analytics Option
    The InDatabase Analytics Option is a new license type that enables customers to build, deploy and run their own C/C++ User-Defined Functions (UDF). Unlike previous releases, this option is available to all SAP Sybase IQ customers and no longer requires SAP Sybase certification.
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Dec 18, 2013 at 05:23 AM


    Vertica is licensed by the raw TB.

    No limitation for CPU Cores, Nodes, etc.


    HANA is licensed by the RAM.

    No limitation for CPU Cores, Nodes, etc.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 21, 2013 at 11:18 AM

    So if you want to use IQ - you must pay for:

    When want to using - BLOB, CLOB - fields. For every CPU Core.

    When want to adding node(-e) in cluster - option MultiPlex. For every node.

    When want to using tables partitioning - option VLDB. For every TB.

    Very expensive approach for XLDB.

    Is there any plans to remove this strange limitations in IQ?

    Add comment
    10|10000 characters needed characters exceeded