invispix 10x10

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.xC1 |
| v14.10.xC2
V14.10 V14.10 V14.10 V14.10
Limits
             
CPU VP / Cores max 1 | 4 1 | 2 4 | 8 24 unlimited unlimited unlimited
Memory maximal 1 GB | 16 GB 2 GB | 8 GB 8 GB | 16 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 yes yes 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) yes no one Sec. two Sec. yes yes yes
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

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

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 8 CPU cores and 16 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

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

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

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

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

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

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 for purchasers

Product linesProduct lines

Product lines

CalculationCalculation

Calculation

Price filesPrice files

Price files

License textsLicense texts

License texts

AnnouncedAnnounced

Announced

Placing ordersPlacing orders

Placing orders

invispix 10x10
OEM/ESA licensingOEM/ESA licensing

IBM OEM licensing

Informix for purchaserInformix for purchaser

Informix for purchasers

IBM Db2 for purchasersIBM Db2 for purchasers

IBM Db2 for purchasers

Cognos for purchasersCognos for purchasers

Cognos for purchasers

This site uses cookies to make it easier for us to provide you with our services. By using our site you agree to the use of cookies.
More information Ok