onconfig_diff comparison tool for Informix onconfig files

onconfig_diff comparison tool for Informix onconfig files

How to run diff on Informix configuration (onconfig) files IBM introduced a new tool in Informix 11.70.xC4 called “onconfig_diff”, located under the $INFORMIXDIR/bin directory.  This tool will show you the difference between two onconfig files in an easily readable...
Informix onclean – Rescue command for Informix DBAs

Informix onclean – Rescue command for Informix DBAs

The Informix “onclean” command was introduced in Informix 11.  I am sure that most Informix DBAs have occasionally faced a situation where the Informix instance won’t come online due to an improper shutdown, killed process, interrupted restore, or an instance crash....
Informix Extents: Sizing and Performance

Informix Extents: Sizing and Performance

When tuning performance for an IBM Informix instance, one important issue to look for is the presence of tables and indexes containing a large number of extents.  Today’s high speed disks and SSD drives can mask some of the performance hit, making this an area that is...

What’s new with Informix Update Statistics

Anyone who has worked with an Informix database knows that the moment you run into a query performance issue, you start with update statistics on that table.  This was always what we were taught in support and talking with big names at IIUG, it’s still the best...