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

Informix DRDA Connections

One of our Virtual-DBA clients recently contacted me for assistance in setting up connections using the DRDA protocol.   They are moving from Java to .NET for their development work, and when they tried to connect via the .NET drivers, they received the...

Informix error -136: “no more extents”

Informix software has a hard limit of 16,777,134 for the number of data pages that can be used in a single table partition.  This is true for all versions of Informix software from 7.31 to 11.70.  Unfortunately, if you hit this limit, the message that is...