Informix Enterprise Replication is a powerful way to replicate data assets across distributed installations and keep them consistent.
Customized use of the Admin-Scout thanks to the new role concept
With the ONCONFIG Explorer, Admin-Scout 3.2 offers a completely new module for managing ONCONFIG variables.
The entire storage administration clearly arranged in one module!
Admin Scout 3.2 offers a long-awaited feature: easy comparison of the databases' structures in different instances.
Version 3.1 continues the journey to new functions for developers and administrators.
Admin-Scout 3.0 offers a completely revised design and up to 60% faster evaluations.
A security warning was issued on October 8, 2020 (CVE-2020-4799) for IBM Informix Dynamic Server.
Informix Release 14.10.xC2 of September 2019 
Many applications based on Informix have two things in common: existential importance for the company and exceptionally long periods of use. It is not surprising that many long-established solutions are available as 32-bit versions.
We asked the question, which areas of an Informix database system have to be administered manually and where is it possible to set up an automated administration? The goal is to achieve increasing automation and independent optimization of the system through an interaction of sensors and tasks.
Already in the last versions many improvements were introduced for the security of the Admin Scout. It was very important for us that during a login no more passwords are transferred between Admin-Scout and the browser.
With the release of Informix 14.10, IBM offers a new licensing option. Except for special licensing models for ASL/ESA resellers, Informix installations are usually licensed by user or processor power. Many sales partners criticize the licensing according to Processor Value Unit calculation (PVU licensing), as too complicated and too little comparable in their calculations. In software projects, the target platform is often still uncertain in the offer phase. PVU licensing cannot be offered to potential customers because the basis for a calculation is not known at this point.
Important features for cluster configuration and better analysis of instances in a group
The Admins-Scout Dashboard is an extremely powerful and informative tool that gives you an overview of the state of your Informix servers
An Admin-Scout feature for fast analysis of DBSpaces
IIUG Konferenz 2015
With the Version 12.10.xC2 IBM created the opportunity to access the Informix database with MongoDB-clients and to use the Informix NoSQL functionality.
Informix go’s NoSQL
IBM Informix NoSQL (2013-09)
Powerful and simple have always been watchwords for the IBM Informix database server and version 12.10 continues in that vein with enhancements to five key feature areas.
As a provider of solutions for energy and utilities companies across Europe, AMT-SYBEX is constantly looking to develop new products and services that help its customers meet the challenges of an ever-changing industry. When the UK government announced that the introduction of smart metering technologies to all homes would be a top priority, AMT-SYBEX immediately recognised that the proposed rollout presented both a challenge and an opportunity that would soon be repeated in other global energy markets.
Hildebrand provides creative and technology consulting for service organisations. The company’s technology team specialises in combining innovative technology with real-world experience, turning complex problems into a source of competitive advantage. Hildebrand’s consultants became fascinated by the challenges posed by smart monitoring of home electricity usage, and began a project funded by the Seventh Framework Programme for EU Research (FP7) ...Informix Editions - Tabular Comparison
Informix v14.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 | 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 | two Sec. | yes | 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.)