IBM Informix Reviews & Product Details

That belongs to IBM and is a company behind the solution to provide support Review collected by and hosted on G2.com.

It is a database that requires a lot of administration compared to other competitors. Review collected by and hosted on G2.com.

The best thing about informix is its onstat commands to see database stats. This is real quick and gives you output direct from memory. This probably is one of the best utility when you are troubleshooting. Apart from that, setting up replication is super easy. One of the best database i have ever used Review collected by and hosted on G2.com.

there is nothing which i dislike about this product. Review collected by and hosted on G2.com.

The client is easy to use. Short keys and cross-database operations are very convenient. It is easy to write a shell to operate different databases. Review collected by and hosted on G2.com.

Its performance doesn't as good as Oracle's in massive data. So we have to divide the database into small databases. Review collected by and hosted on G2.com.

The best part of this tool is that it comes from the IBM family, which makes it easy to use, and it has great support from the IT team. I consolidated my three apps' data in one database, and it never failed. Review collected by and hosted on G2.com.

Its pricing is what makes it not that popular in the market and because of this sharing of database or hiring people makes it difficult. Creating databse is bit difficult. Review collected by and hosted on G2.com.

Ease of use in regards with relational database management system (RDBMS) Review collected by and hosted on G2.com.

Londer learning curve but this is not an actual issue, I believe nothing much is needed Review collected by and hosted on G2.com.

Informix look and feel is superb. Onstat's command will give you all the details of database. I have used other databases as well but no one can beat IBM Informix. It's fast, stable and secure. Review collected by and hosted on G2.com.

What i dislike is when it generates Assertion failure we have to log a case to know weather we have been hit by a defect or what could be the cause of this assertion. Although support team responds very quickly. Review collected by and hosted on G2.com.

Ability to provide SQL output in simple manner. Once DB is installed configured, it is very reliable and robust. Review collected by and hosted on G2.com.

Some of the drawbacks in Procedure handling, syntax issues. Unable detect exact issue easiliy. Review collected by and hosted on G2.com.

Its ability of integration of multiple databases including SQL and NoSQL Review collected by and hosted on G2.com.

Not being fully free. This is an absolute product and this will be best if we can have ability to have hands on it Review collected by and hosted on G2.com.

Perform metrics is out of the box.

IBM Support for Informix should be improved but overall okay. Review collected by and hosted on G2.com.

Less articles related with INFORMIX management Review collected by and hosted on G2.com.

Online indexing, real time replication, comprehensive query optimizer. Review collected by and hosted on G2.com.

Update statistics for all referenced tables/SPs for any structural change. Review collected by and hosted on G2.com.