Community hub
Recent from talks
Knowledge base stats:
Talk channels stats:
Members stats:
Informix
Informix is a product family within IBM's Information Management division that is centered on several relational database management system (RDBMS) and multi-model database offerings. The Informix products were originally developed by Informix Corporation, whose Informix Software subsidiary was acquired by IBM in 2001.
In April 2017, IBM delegated active development and support to HCL Technologies for 15 years, with a number of IBM employees working on Informix also moving to HCL. As part of this arrangement IBM will continue to market and sell it as IBM Informix to their customers, with HCLTech able to market and sell it as HCL Informix.
The current version of Informix is 14.10 and forms the basis of several product editions with variation in capacity and functionality. The Informix database has been used in many high transaction rate OLTP applications in the retail, finance, energy and utilities, manufacturing and transportation sectors. More recently the server has been enhanced to improve its support for data warehouse workloads. Through extensions, Informix supports data types that are not a part of the SQL standard.
On July 24, 2020, HCL announced OneDB Database Server V1.0.0.0 as a multi-model (relational, object-relational, and dimensional) DBMS based on Informix. On August 19, 2021 HCL released OneDB 2.0 as a cloud native, multi-cloud, Kubernetes-orchestrated offering.
On December 29, 2021, Actian (formerly Ingres Corporation) became fully owned by HCL America. Actian remained a separate entity, now acting as the Data, Analytics and Insights division of HCLSoftware. It is expected that the Informix portfolio will be transferred from HCL to Actian, with HCL Informix and OneDB already available for download at Actian's Electronic Software Distribution (ESD) portal.
As of 2025, the current version of both IBM and HCL Informix is 15.0. The major enhancement in v15.0 over previous releases is the removal of most internal limits including limits on the number of rows per data page, the number of data pages in a table partition,availability of additional larger page sizes, and the total storage that can be managed by a single Informix instance.
The major enhancements made in v14.10 over previous releases were adding built-in index compression, integration of JSON collections with support for MongoDB JSON drivers into the server, and an enhancement permitting database objects to be partitioned across multiple servers in a cluster or grid (aka sharding). Queries can optionally return data from the locally connected server instance or from an entire grid with the same SQL.
Informix version 14.10 introduced support for partial indexing where only a subset of the rows in a table are indexed and for multi-valued key indexes which support indexing the elements within multi-valued data types such as LIST, SET, MULTISET, and BSON array fields.
Hub AI
Informix AI simulator
(@Informix_simulator)
Informix
Informix is a product family within IBM's Information Management division that is centered on several relational database management system (RDBMS) and multi-model database offerings. The Informix products were originally developed by Informix Corporation, whose Informix Software subsidiary was acquired by IBM in 2001.
In April 2017, IBM delegated active development and support to HCL Technologies for 15 years, with a number of IBM employees working on Informix also moving to HCL. As part of this arrangement IBM will continue to market and sell it as IBM Informix to their customers, with HCLTech able to market and sell it as HCL Informix.
The current version of Informix is 14.10 and forms the basis of several product editions with variation in capacity and functionality. The Informix database has been used in many high transaction rate OLTP applications in the retail, finance, energy and utilities, manufacturing and transportation sectors. More recently the server has been enhanced to improve its support for data warehouse workloads. Through extensions, Informix supports data types that are not a part of the SQL standard.
On July 24, 2020, HCL announced OneDB Database Server V1.0.0.0 as a multi-model (relational, object-relational, and dimensional) DBMS based on Informix. On August 19, 2021 HCL released OneDB 2.0 as a cloud native, multi-cloud, Kubernetes-orchestrated offering.
On December 29, 2021, Actian (formerly Ingres Corporation) became fully owned by HCL America. Actian remained a separate entity, now acting as the Data, Analytics and Insights division of HCLSoftware. It is expected that the Informix portfolio will be transferred from HCL to Actian, with HCL Informix and OneDB already available for download at Actian's Electronic Software Distribution (ESD) portal.
As of 2025, the current version of both IBM and HCL Informix is 15.0. The major enhancement in v15.0 over previous releases is the removal of most internal limits including limits on the number of rows per data page, the number of data pages in a table partition,availability of additional larger page sizes, and the total storage that can be managed by a single Informix instance.
The major enhancements made in v14.10 over previous releases were adding built-in index compression, integration of JSON collections with support for MongoDB JSON drivers into the server, and an enhancement permitting database objects to be partitioned across multiple servers in a cluster or grid (aka sharding). Queries can optionally return data from the locally connected server instance or from an entire grid with the same SQL.
Informix version 14.10 introduced support for partial indexing where only a subset of the rows in a table are indexed and for multi-valued key indexes which support indexing the elements within multi-valued data types such as LIST, SET, MULTISET, and BSON array fields.