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...
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...

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...