IBM Informix 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.
Informix Advanced Developer offers warehouse developers a cost-effective alternative by licensing individual users.

Scope and functions

Informix Advanced Developer Edition is the same as Advanced Enterprise Edition.

Licensing

Authorized User (AU).
All users who in principle have access to the installations of the product are to be licensed. The addition Single Install is not required here; access to different installations by an Authorized User counts as one license.
The use of the Advanced Developer Edition is limited to development and test environments.

Informix 14.10 Editions - functions, features, limits

	Developer Edition	Innovator-C Edition	Express Edition	Workgroup Edition	Enterprise Edition	Advanced Developer	Advanced Enterprise

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.)

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

All Informix service and support offerings are now available through CURSOR Expert Solutions
XPS Data Suite for Informix – 12-month subscription, integrated DBMS included
Informix Monitoring and Support—with the Informix experts of CURSOR Expert Solutions

XPS Data Suite

XPS Admin-Scout

Service & Support

About Our Company

IBM Informix Advanced Developer Edition

A specially licensed Advanced Enterprise Edition for warehouse developers

Overview

Scope and functions

Licensing

Informix 14.10 Editions - functions, features, limits

Valid for version

Limits

Features

Free of charge Community Edition for Informix beginners or small applications

Overview

Scope and functions

Ready for IoT and Industry 4.0the database for ISVs and OEMs

Overview

Scope and functions

Free developer edition with all options for developers and system architects

Overview

Scope and functions

Simply powerfull - the database for medium-sized enterprises

Overview

Scope and functions

High-end database for workloads of large companies and international corporations

Overview

Scope and functions

A specially licensed Advanced Enterprise Edition for warehouse developers

Overview

Scope and functions

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

Overview

Scope and functions

Fastest data warehouse and online transaction processing

Overview

Scope and functions

Ready for IoT and Industry 4.0
the database for ISVs and OEMs