IBM Informix Reviews

• High performance on OTLP environment, but depends on application design.
• Data compression for enterprise version with data deduplication.
• Provides solutions for making data highly available, with data replication configuration (HDR, RS, and SD) and ER (Enterprise Replication) for different scenarios.
• The Informix Flexible Grid eliminates the administrative complexity of ER. Flexible Grid provides the ability to automatically create database objects, such as tables, indexes, and stored procedures on all nodes within the grid as a single operation.

Link: http://waiug.org/wp-content/uploads/2015/11/2015-Nov-waiug-ER-Grid.pdf

Initially, we had an ER configuration, then we moved to an HDR. In both cases, it allowed us to recover from a failure in the main server.

On the part of our development area, a feature that has another product with the SQL clause update from with several INNER JOIN.

To require an example, you confirm to send it.

I've used this solution for eight years approximately. When I took over as a DBA, we were with version 9 (named Informix Workgroup version).

No. So far, it has responded very well

No. We switched from licensing to enterprise because we grew in users and required more memory.

We are growing in data and it is easy to increase the storage space (DB spaces and chunks).

10 out of 10.

We had another platform which was centralized (nine years ago). Currently, the transactions are online.

The initial setup was done for the partner Informix, I would say half & half (half straightforward, half complex) because you must know certain commands of the operating system where it will be installed.

I have not managed the costs, but depending on the characteristics they wish to exploit and the number of users connected, they can opt for connection-based or server-based licensing if there are about 300 users evaluating license per server.

Informix Innovator-C Edition - Free

• Small and medium-sized enterprises (including replication and some clustering benefits).
• Limited to one core and 2GB of memory.

Informix Advanced Workgroup Edition - Payment

• Small and medium-sized enterprises
• This edition is limited to 16 cores with a maximum of 48GB of memory and does not support clustering features.
• Supports spatial data stores.

Informix Enterprise Edition - Payment

• It allows you to use an unlimited amount of data storage, processors, and memory.
• Informix Ultimate Edition includes cluster functions and IBM Informix Flexible Grid functionality.

Informix Advanced Enterprise Edition - Payment

The product has been available for approximately 19 years, since it is part of the system that the company bought.

The server must have the necessary memory, processing, and storage (depending on available infrastructure) in order to be scalable by users' consumption of resources.

If the bases are large, it is advisable to place them in separate dB spaces. If necessary, indices also separate them.

Have a disaster recovery plan.

Define if the information is critical: a high availability of the same (HDR, RS, and SS).

• I currently administer Informix for different clients.
• I have configured the HDR, RSS, SDSS and connection manager options with a cluster with optimal performance nodes.

The version of the Informix is 14.10 Enterprise Edition.

• OLTP processing capacity and the availability of information with high availability implementation have been significantly improved.
• The increase in the number of users has not prevented the proper performance of the engine.
• I've had the cluster configuration online for over a year.
• With Informix, I sleep peacefully.

• I have been administering Informix for 10 years, and it's a highly reliable product, robust, processes high volumes of information, etc.
• Its high availability characteristic is very stable and easy to configure and administer compared to Oracle to be performed higher than lower costs.
• I really think it's a robust database tool and an excellent support.

I am expecting the new version 14.1 that brings significant improvements to replication.

 With Informix, everything that's expected is met.

More than five years.

The solution is very stable!!! I have come to have instances of Informix with more than two years in the online state without losing its performance.

The DBMS Informix in scalability is optimal and never degraded your perfomance

The experience with technical support is excellent.

no, always informix.

The initial setup may be complex if no knowledge of the product is known.

Informix provides a basic setup that gets an initial configuration to operate.

The setting of the configuration requires knowledge of the product and its bonds.

Oracle and SQL SERVER

We use this solution to build and maintain databases. It is also used for backing up, restoring, and replicating Informix databases.

This solution has made financial reporting possible by allowing financial people the opportunity to set Informix to "Auto Pilot" so that they can attend other duties.

The most valuable features are its speed and ease of management.

This solution is in need of more current tools.

We use the product for analytics, security, and network processing features.

IBM Informix benefits users with high availability and good integration capabilities.

The platform has valuable features for data virtualization and operations. They have a separate system for analytics as well.

The support team could include local engineers to establish efficient communication. It will help us speed up the escalation process.

We have been using IBM Informix for seven years.

IBM Informix has good stability.

We have around 100 IBM Informix users in our organization. It is a scalable product, and we plan to increase the usage.

The technical support services do not require any improvements.

The initial setup is easy. It takes an hour to complete. The deployment involves assessment and design confirmation. It is deployed on the cloud and requires a team of three engineers to work on the process.

We take help from a consultant for implementation.

The product has reasonable pricing. We purchase its yearly license.

I rate IBM Informix an eight out of ten. I recommend it to customers looking for a solution with complex use cases.

We use Informix for the database, for replication and for backup. The solution is a repository for our clients' data. I'm the technical engineer manager and we are integrators. 

Replication is the most valuable feature and it's relatively easy to use. We can use both SQL and non-SQL connections in the one database. Informix can support huge quantities of data with less memory and less capacity. We don't need to expand capacity to compute a huge quantity of data.

I'd like to see more functionality in Informix HQ to facilitate the administration of products. It's currently based on the UNIX command line and we don't have a very graphical interface to administer the data. I'd like to see more development in the language we use for developing a third procedure. 

I've been using this solution for five years. 

The solution is very stable.

The solution can be customized to increase capacity.

The support is very good. If we report a level one incident, support can connect to the machine and resolve the incident remotely without a problem. 

The initial setup is straightforward if you know what's required. It can be installed with 10 command lines. It takes about an hour to install on a new machine. 

Informix is very sturdy, but the problem for us is the marketing action around Informix. IBM doesn't provide the roadmap of the product, at least here in Morocco. There's nowhere we can go to access information about product functionality. 

I rate this solution nine out of 10. 

I act as a consultant to my customers, who use the database for processing data. 

I like the solution's performance and facility. 

I would like to see backups from secondary servers. 

We have been using IBM Informix for five years. 

I have encountered no issues with the stability.

The scalability is very good, there existing a problem-free cluster for around ten months.

Thus far, the technical support has been very good. 

The initial setup is very simple.

It took me around 13 minutes to deploy the solution. 

Two people are sufficient for the deployment. 

I am not aware of the licensing costs or terms. 

I act as a partner.

The security is sufficiently good. 

There are around 2,000 people who are making use of the solution at present. 

I rate IBM Informix as a ten out of ten. 

The solution's stability, performance, enhanced functionality, and replication are all great features.

The solution doesn't include functionality like data anonymization. We have this functionality in other solutions like In SQL and Oracle but not in Informix. IBM has another product for anonymization, called InfoSphere Optim. Some clients want that anonymization in the engine, not in another product. Instead of making it a separate product, they should merge the two, or make anonymization available in this solution as well.

There should be more intelligence surrounding discovering data to be able to automatically create indexes.

I've been using the solution since 1995.

Unfortunately, we don't have local technical support in Morocco. We have only call support; we don't have access to on-site support. We must have someone that's remote try to take action on our machine if there are issues. 

The initial setup was easy.

The pricing is okay because we are able to negotiate costs. However, the solution should make an effort to adjust the pricing so that we can get the same pricing in Morocco as we would get in the United States.

We use all deployment models, including cloud and on-premises.

I'd recommend the solution; I'd rate it nine out of ten.

We develop software that works with Informix.

Every version is faster than the previous.

This solution is fast, easy to administer, supports HDR, and supports grid.

This solution would be improved with offline data export.

I really would love to have a QT plugin.