invispix 10x10

Informix Product Lines and Editions

informix12-simplyThe IBM Informix product lines contain a staged portfolio of editions, composed for any number of operational areas and requirements. Here you can find a short overview over the available editions and their features.

For beginner and developer - get in touch with Informix:
IBM Informix Developer Edition

The Developer Edition is a free from license cost edition which is used for the development and trial of database based applications. Concerning this background almost the complete function volume of Informix Enterprise Edition is provided, including the opportunity of creating and testing various cluster scenarios for high availability.

To save the character of testing and developing, some data clusters are restricted in this edition, maximum use of one socket, 1 CPU-VP, 1GB Shared Memory and 8 GB of data. The use of this edition is only in trial and development situations allowed.

Comparison tablec181License textsc181

 

InformixInformix

IBM Informix Innovator-C Edition

The Innovator-C is also a free from license edition, especially introduced for the productive use in small applications with minor database requirements.

This edition supports small applications on Linux, UNIX, Windows and Mac OS X platforms and is restricted to 1 CPU-VP, 2 GB Shared Memory and 8 GB data.

Furthermore apply restrictions for features and cluster scenarios which are described in the comparison table, respectively bindingly in the license texts.

Comparison tablec181 / License textsc181

 

InformixInformix

 

For small and embedded applications:
IBM Informix Express Edition

The IBM Informix Express Edition is an entrance solution for small and embedded applications, available for Windows and Linux platforms and under Informix 12.1 now also for UNIX and Mac-OS. The used hardware is restricted to maximum 4 cores and 8 GB Shared Memory. A data limit is not existent.

A licensing can occur on an (AU), (PVU) or (LUV) basis.

The restrictions for features and cluster scenarios which are described in the comparison table, respectively bindingly in the license texts apply.

Comparison tablec181License textsc181Price calculationc181

 

InformixInformix

IBM Informix Choice Edition (Not offered any more)

With the introduction of Informix 12.1, Informix Choice Edition is not offered any more. Customers who are licensed on this product line have in the course of maintenance the opportunity to migrate (with costs) to Informix Workgroup Edition.

(AU) or (LUS) licensing

License textsc181

 

InformixInformix

 

For the common use in medium-sized businesses:
IBM Informix Workgroup Edition

The Informix Workgroup Edition (formerly Growth) is the product of choice for comprehensive solutions in a medium-sized business environment. Like the Informix Enterprise Edition the Workgroup Edition is ported for the most common platforms (UNIX, Linux, Windows, Mac-OS). The limit is reasonable oriented on the actual server standards and allows a high performance with minimal response time and a high information flow-rate (maximum 4 sockets (LUS), 16 cores and 16 GB Shared Memory).
For the installation of cluster and high availability solutions HDR, SDS and RSS concepts are supported, yet restricted on two secondary notes. Enterprise Replication is unlimited available.

The licensing can occur on an (AU), (PVU) or (LUS) basis.

Comparison tablec181License textsc181Price calculationc181

 

InformixInformix

IBM Informix Advanced Workgroup Edition

After the successful introduction of Informix Warehouse Accelerator this special technology was in fall 2011 also made available for the Informix Growth Edition and now transferred into the Advanced Workgroup Edition. The Informix Advanced Workgroup Edition creates for medium-sized installations (200 to 250 GB original data) the opportunity to implement extremely fast Data Warehouse applications. The ideal addition for Business Analytics analyses is the together with Informix 12.1 introduced product expansion Cognos BI 10.2.

In contrary to the Advanced Enterprise Edition the Advanced Workgroup Edition contains no Informix Storage Optimization Feature and the accelerator's maximum usage of physical memory is restricted to 48 GB. Portings occur for UNIX and Linux platforms, the accelerator expansion requires an Intel/Linux platform.

Licensing for server and accelerator occurs only on (PVU) basis.

Comparison tablec181License textsc181Price calculationc181

 

InformixInformix

 

High-end scaling for enterprise solutions:
IBM Informix Enterprise Edition

The Informix Enterprise Edition is the solution for big, divided, high performing and high available applications in a higher enterprise environment. In addition to optional expansions all functions of the Informix database technology are available without a limit.
The Informix Enterprise Edition is ported for common UNIX, Linux, Windows and Mac OS platforms and supports all Informix functions for developing, implementing and distributing with unrestricted scalability. It offers unrestricted data memory, processor and memory possibilities. The Informix Enterprise Edition contains the whole scope of performance of IBM Informix Flexible Grid for the simplified replication configuration and the support of high availabilty clusters.

The licensing cann occur on an (AU) or (PVU) basis.

Comparison tablec181License textsc181Price calculationc181

 

InformixInformix

IBM Informix Advanced Enterprise Edition

The Informix Advanced Enterprise Edition upgrades the Enterprise Edition for extremely fast Data Warehouse analyses.

Besides the Enterprise Edition two additional components are used:

To reduce the occupation of disk storage and improve the efficiency the Informix Storage Optimization comes with Deep Compression technology.

The separately installed IBM Informix Warehouse Accelerator works on an in-memory technology and enables in contrast to classic Warehouse applications an up to 100 times faster evaluation.

In order to meet the Warehouse applications' Business Analytics and Business Intelligence backgrounds the Informix 12.1 Advanced Enterprise Editions have been upgraded with Cognos BI 10.2 and SPSS licenses. These products are now additionally contained in the Advanced Enterprise Edition's basic scope.

Portings occur for UNIX and Linux platforms, the accelerator upgrade requires an Intel/Linux platform.

Licensing for server and accelerator occur only on (PVU) basis.

Comparison tablec181License textsc181Price calculationc181

 

InformixInformix

 



Informix 12.1 Product lines comparison table

 

  Informix Advanced Enterprise Edition Informix Enterprise Edition Informix Advanced Workgroup Edition Informix Workgroup Edition Informix Express Edition Informix Inno- vator-C Edition Informix Devel- oper Edition
License models available PVU
PVU
AU
PVU
PVU
LUS max. 4
AU
PVU
LUV
AU
NON
NOD
max. socket count unlimited unlimited unlimited unlimited / at LUS max. 4 sockets unlimited unlimited unlimited
max. cores count unlimited unlimited 16 16 4 1 1
max. count of PVU-values     1600        
max. memory unlimited unlimited 16GB Informix, 48GB Warehouse 16GB 8GB 2GB 1GB
max. storage unlimited unlimited unlimited, Tables in the warehouse by the memory limit approx. 250 GB unlimited unlimited 8GB 8GB
DML, DDL, SQL access to other instances yes yes no no no no no
Fragmen- tation allowed yes yes no no no no yes
Parallel operations allowed yes yes no no no no yes
Data- Warehouse available yes no yes no no no no
Timeseries and Spatial DataBlade available is included is included is included is included is included is included is included
OpenAdmin Tool available yes yes yes yes yes yes yes
Storage- Optimization available is included option no no no no is included
HDR available unlimited unlimited maximum is 2 secondary servers maximum is 2 secondary servers maximum is 1 secondary servers no unlimited
Enterprise Replication available unlimited unlimited unlimited unlimited limited - only a 2-Node Cluster allowed no unlimited
Shared Disk Secondary available yes yes maximum is 2 secondary servers maximum is 2 secondary servers maximum is 1 secondary servers no yes
Secondary writeable available is included is included is included is included is included no is included
multiple secondarys available unlimited, usage-based additional costs per secondary server unlimited, usage-based additional costs per secondary server maximum 2 Secondary Nodes maximum 2 Secondary Nodes maximum 1 Secondary Node no unlimited, usage-based additional costs per secondary server
Label Based Access Control available yes yes yes yes yes no yes

features in the license not included

Informix Advanced Enterprise Edition

  • The Informix Warehouse Accelerator is available only on Linux x86-64Bit
  • Licensing is only possible by using the licensing metric PVU and AU!
  • The Informix Advanced Enterprise Edition consists of separate installations for the Informix Advanced Enterprise and Informix Warehouse Accelerator.
    • The PVU-value of the license is calculated based on the sum of available CPU cores that are available for the Informix Advanced Enterprise Edition and the Informix Warehouse Accelerator available CPU cores.
    • All existing CPU cores (full capacity) or a system approved by the IBM virtualization technology made available CPU cores (Sub-Capacity) have to be lincensed.
    • Please note possible different PVU-values per core on machines with different hardware for Informix Advanced Enterprise Database and Warehouse Accelerator. For a correct calculation in the calculator, please select a CPU configuration, which represents the sum of the two installations. We will be glad to assist.
  • Tips for the Informix Advanced Enterprise Edition

    This edition includes:

    • IBM Cognos Business Intelligence - 5 Authorized User
    • IBM SPSS Modeler - 1 Authorized User
    • IBM SPSS Statistics - 1 Authorized User

Informix Enterprise Edition

  • nothing

Informix Advanced Workgroup Edition

  • The Informix Warehouse Accelerator is available only on Linux x86-64Bit
  • Licensing is only possible by using the licensing metric PVU!
  • The PVU value of the server may not exceed 1600.
  • Cluster features such as HDR, RSS, ER and SDS are restricted to 2 nodes total!
  • It is a storage limit through the memory limit of Warehouse accelerators
      of about 250 GB for the sum of all the tables, which find use in the warehouse!
  • The Informix Advanced Workgroup Edition consists of separate installations for the Informix Advanced Workgroup and Informix Warehouse Accelerator.
    • The PVU-value of the license is calculated based on the sum of available CPU cores that are available for the Informix Advanced Workgroup Edition and the Informix Warehouse Accelerator available CPU cores.
    • All existing CPU cores (full capacity) or a system approved by the IBM virtualization technology made available CPU cores (Sub-Capacity) have to be lincensed.
    • Please note possible different PVU-values per core on machines with different hardware for Informix Advanced Workgroup Database and Warehouse Accelerator. For a correct calculation in the calculator, please select a CPU configuration, which represents the sum of the two installations. We will be glad to assist.
  • Private memory cache for CPU VPs - onconfig - VP_MEMORY_CACHE_KB
  • Parallel index build / Parallel query
  • High Performance Loader
  • OnBar parallel backup/restore
  • Partitioning (fragmentation)
  • Compression (e.g., the Storage Optimization Feature)
  • distributed Querys - The ability for a SQL session connected to a database to execute a DML operation on a remote database.
  • Tips for the Informix Advanced Workgroup Edition

    This edition includes:

    • IBM Cognos Business Intelligence - 5 Authorized User

Informix Workgroup Edition

  • Private memory cache for CPU VPs - onconfig - VP_MEMORY_CACHE_KB
  • Parallel index build / Parallel query
  • High Performance Loader
  • OnBar parallel backup/restore
  • Partitioning (fragmentation)
  • Compression (e.g., the Storage Optimization Feature)
  • distributed Querys - The ability for a SQL session connected to a database to execute a DML operation on a remote database.

Informix Express Edition

  • Only on Windows and Linux, Only 32bit-versions are available.
  • OnBar Parallel backup/restore
  • Parallel-Feature
  • Partitioning (fragmentation)
  • Compression Tabellen, Indexe and Blobs
  • Private memory cache for CPU VPs - onconfig - VP_MEMORY_CACHE_KB
  • High-Performance Loader
  • distributed Querys - The ability for a SQL session connected to a database to execute a DML operation on a remote database.

Informix Innovator-C Edition

  • Recovery Time Objective - onconfig - RTO_SERVER_RESTART
  • Private memory cache for CPU VPs - onconfig - VP_MEMORY_CACHE_KB
  • Direct I/O - onconfig - DIRECT_IO
  • Parallel index build / Parallel query
  • High Performance Loader
  • OnBar Parallel backup/restore
  • Partitioning (fragmentation)
  • Column level encryption
  • Compression (e.g., the Storage Optimization Feature)
  • Advanced Access Control (Label Based Access Control)
  • Last committed isolation qualifier - onconfig - USELASTCOMMITTED
  • Multiple triggers
  • Web-Feature-Service
  • Point-in-time table restore - (archecker tool)
  • SQL-Warehouse-Feature
  • Shared-Disk-Secondary (SDS)
  • HDR, RSS und ER - all Mach11 Features are forbidden since version 11.70.xC5
  • distributed Querys - The ability for a SQL session connected to a database to execute a DML operation on a remote database.

Informix Developer Edition

  • Compression (e.g., the Storage Optimization Feature) - Optional feature

 

An overview of the Informix product group and more information on the pages of the IBM find here ibm-logo-16

  • IBM Informix Advanced Enterprise Edition
  • IBM Informix Enterprise Edition
  • IBM Informix Hypervisor Edition for AIX and Linux
  • IBM Informix Advanced Workgroup Edition 
  • IBM Informix Workgroup Edition 
  • IBM Informix Express
  • IBM Informix Innovator-C
  • IBM Informix XPS
  • IBM Informix Online
  • IBM Informix SE
  • Informix 4 GL
  • Informix C-ISAM
  • Informix CSDK / Connect / JDBC
  • Informix Data Director for Web
  • Informix Enterprise Gateway
  • Informix ESQL
  • Informix Excalibur Text Datablade
  • Informix Geodetic Datablade
  • Informix Spatial Datablade
  • Informix Timeseries Datablade
  • Informix I-Spy
  • Informix Image Foundation Datablade
  • Informix Video Foundation Datablade
  • Informix Max Connect
  • Informix Office Connect
  • Informix Red Brick
  • Informix Server Administrator 
  • Informix SQL
invispix 10x10