home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36

IBM Informix Advanced Workgroup Edition 12.10

The Informix Advanced Workgroup Edition was discontinued in spring 2019 with the introduction of Informix version 14.10 and is no longer available!
Overview
  • Decision making in seconds based on transaction data.
  • Informix Advanced Editions enables to build extremely fast data warehouse applications.
  • They combine transaction processing OLTP and in-memory warehouse analyses OLAP in one database system.
Scope and functions
  • Corresponds to the Informix Workgroup Edition and also includes the Informix Warehouse Accelerator (IWA) as a warehouse component.
  • For direct access to data warehouse applications, the Advanced Workgroup editions include IBM Cognos Business Intelligence licensing with 5 authorized users.
  • The edition is limited to 16 CPU cores and 16 GB memory for the Workgroup Edition and 1,600 PVU and 48 GB memory for the Warehouse Accelerator.
  • The Storage Optimization feature is not available.
Licensing
  • IBM Processor Value Units (PVU), licensing of processor cores, calculation depends on processor performance.
  • The Informix Advanced Editions are based on two installations: the OLTP Workgroup or Enterprise installation and the installation of the Informix Warehouse Accelerator for in-memory data processing.
    The PVUs of both installations must be calculated for licensing.lizenzinfo de blue 424x100
Informix 14.10 Editions - functions, features, limits
  Developer Edition Innovator-C Edition Express
Edition		 Workgroup
Edition		 Enterprise Edition Advanced Developer Advanced Enterprise
 
 ifx developer blue 400x100 ifx innovator blue 400x100 ifx express blue 400x100 ifx workgroup blue 400x100 ifx enterprise blue 400x100 ifx advanced blue 400x100 ifx advanced blue 400x100
Valid for version
 v14.10.xC1 |
| v14.10.xC2		 v14.10.xC1 |
| v14.10.xC2		 v14.10

 V14.10 V14.10 V14.10 V14.10
Limits
              
CPU VP / Cores max 1 | 4 1 | 2 4 24 unlimited unlimited unlimited
Memory maximal 1 GB | 16 GB 2 GB | 8 GB 8 GB 32 GB unlimited unlimited unlimited
Storage maximal 8 GB 8 GB | 50 GB unlimited unlimited unlimited unlimited unlimited
Features
              
TimeSeries / Sensor-Data yes yes yes yes yes yes yes
NoSQL Support yes yes yes yes yes yes yes
Encryption at rest yes yes yes yes yes yes yes
Label based access control yes no yes yes yes yes yes
High Availability Cluster (H/A) yes no one Sec. two Sec. yes yes yes
Secondarys maximal unlimited no Sec. one Sec. two Sec. unlimited unlimited unlimited
Updatable Secondary yes no yes yes yes yes yes
The ability to execute SQL or NoSQL DML operations (read, write, update, delete) on a H/A cluster secondary node. Note: If SQL or NoSQL DML operations are executed on a secondary instance, the secondary instance must be fully licensed
Continuous Log Restore yes no yes yes yes yes yes
CLR secondary is provided by the ontape and ON-Bar backup utilities
Enterprise Replication (ER) unlimited no Cluster limited total 2 root nodes unlimited unlimited unlimited unlimited
Distributed SQL/NoSQL yes no no no yes yes yes
The ability for a SQL/NoSQL session connected to a database in one instance to execute a DML operation using data from another database in a different instance
Parallel operations yes no no no yes yes yes
Parallel operations refers to the ability to execute SQL operations in parallel and includes parallel index build, high-performance loader, and ON-Bar parallel backup, and restore
Table fragmentation yes no no no yes yes yes
Partitioning refers to the ability to fragment a table or index based on logical rules to improve data access and parallel processing
Storage optimization yes no no no yes yes yes
Data Warehouse (IWA) no no no no no yes yes
 

(All information is non-binding and only for information purposes - there is no claim to completeness. The scope and features of the products are determined by IBM's publications, IBM license terms, IBM announcement letters, product documentation and additional publications of the manufacturer.)

konditionen de blue 1200x100

  • Informix Innovator-C Edition
    Free of charge Community Edition for Informix beginners or small applications
    Overview

    The Innovator-C is a free of charge edition for training and testing scenarios.
    Ideal for Informix beginners and low-cost projects, Innovator-C Edition can also be used for commercial applications.
    Direct download from the IBM website.

    Scope and functions

    Against the background of offering an edition for commercial use without license costs, the Innovator-C is limited to the use of two CPU core, a maximum of 8 GB memory and 50 GB data.

    Read more

  • Informix Express Edition
    Ready for IoT and Industry 4.0
    the database for ISVs and OEMs
    Overview

    Informix Express Edition is an entry-level solution for common applications with an embedded database.
    Reliability, self-configuration, minimal administration - NoSQL and sensor data functionality - make the Express Edition the preferred embedded data management platform for ISVs and OEMs.

    Scope and functions

    The Express Edition includes the maximum use of 4 CPU cores and 8 GB of main memory.
    Like all Informix editions, Express Edition has native TimeSeries / Sensor Data functionality.
    HDR, SDS and Enterprise Replication are possible with one or two nodes.

    Read more

  • Informix Developer Edition
    Free developer edition with all options for developers and system architects
    Overview

    The Informix Developer Edition has all the features of the Enterprise Edition. In addition, there is the optional Storage Optimization feature.
    For use in development and test environments, Informix Developer Edition is free of charge.
    Direct download from the IBM website.

    Scope and functions

    Exclusively intended for development and testing, the Developer Edition (v14.10.xC2) is limited to the use of four CPU cores, maximum 16 GB main memory and 8 GB data.

    Read more

  • Informix Workgroup Edition
    Simply powerfull - the database for medium-sized enterprises
    Overview

    Powerful and cost-effective - the database solution for mid-sized companies and branches.
    The Informix Workgroup Edition has been industry-proven for years and is preferred by manufacturing, commercial and shipping companies.
    Thanks to easy-to-build cluster solutions, the Workgroup Edition is the central building block for high-performance and secure data storage in companies.

    Scope and functions

    Cluster solutions with HDR or SDS are possible with a maximum of two secondary nodes. Enterprise Replication is available without restrictions.

    Maximum 24 CPU cores and 32 GB memory are the main difference between the Workgroup Edition and the Enterprise Edition.

    Read more

  • Informix Enterprise Edition
    High-end database for workloads of large companies and international corporations
    Overview

    When performance and resilience are first and foremost, leading companies in the world rely on Informix. The Enterprise Edition delivers high-end OLTP for global retail, energy suppliers or telecom providers.
    Easy to implement high availability through unlimited replication and cluster properties. Sub-data storage for branch offices through enterprise replication. Combinable and multi-client capable cloud scenarios.

    Scope and functions

    Aside from Data Warehouse, all Informix properties are available without limitation.
    Warehouse functionality is reserved for Informix Advanced Enterprise Edition.

    Read more

  • Advanced Developer Edition
    A specially licensed Advanced Enterprise Edition for warehouse developers
    Overview

    Warehouse and business analytics applications are memory and CPU intensive. In production environments, IBM Processor Value Units are used for licensing.
    For warehouse developers, Informix Advanced Developer offers a cost-effective alternative by licensing individual users.

    Scope and functions

    The Informix Advanced Developer Edition is the same as the Advanced Enterprise Edition and offers Authorized User (AU) licensing for individual users. Their use is limited to development and test environments.

    Read more

  • Advanced Workgroup Edition
    The Informix Advanced Workgroup Edition was discontinued in spring 2019 with the introduction of Informix version 14.10 and is no longer available!
    Overview

    Decision making in seconds based on transaction data.
    Informix Advanced Editions enables to build extremely fast data warehouse applications. They combine transaction processing OLTP and in-memory warehouse analyses OLAP in one database system.
    The Advanced Workgroup Editione includes five User IBM Cognos Business Intelligence licensing

    Scope and functions

    Corresponds to the Informix Workgroup Edition and also includes the Informix Warehouse Accelerator (IWA) as a warehouse component.
    The edition is limited to 16 CPU cores and 16 GB memory for the Workgroup Edition and 1,600 PVU and 48 GB memory for the Warehouse Accelerator.

    Read more

  • Advanced Enterprise Edition
    Fastest data warehouse and online transaction processing
    Overview

    Informix Advanced Enterprise Editions is the unlimited platform for applications with very high transaction volumes and simultaneous analysis - high-end OLTP and extremely fast data warehouse in one database.
    The included Storage Optimization feature increases performance and lowers storage costs, especially interesting for companies with high data volumes.

    Scope and functions

    Equivalent to Unlimited Informix Enterprise Edition. The Advanced Enterprise Edition also includes the Informix Warehouse Accelerator (IWA), as a warehouse component, and the Storage Optimization feature.

    The Informix Warehouse Accelarator prefers its own Linux-based machine.
    Licensing is exclusively via Processor Value Units (PVUs) or Virtual Processor Cores (VPCs).

    Read more

Informix EditionsInformix Editions
Informix Editions
DocumentationDocumentation
Documentation
IBM NewsletterIBM Newsletter
IBM Newsletter
Current BugsCurrent Bugs
Current Bugs
Bug ResearchBug Research
Bug Research
Bug FixlistsBug Fixlists
Bug Fixlists
Release NotesRelease Notes
Release Notes
Machine NotesMachine Notes
Machine Notes
Release NewsRelease News
Release News
Product LifecycleProduct Lifecycle
Lifecycle
Media DownloadMedia Download
Media Download