by Barrie Shaw | Aug 4, 2014 | Blog, Databases
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...
by Barrie Shaw | Feb 11, 2014 | Blog, Databases
During my 14+ years of providing Informix services and support for XTIVIA’s Virtual-DBA remote database administration service, this is one of the more common errors that I am asked to address. I want to share three possible fixes for this problem....
by Barrie Shaw | Apr 17, 2013 | Blog, Databases
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...
by Barrie Shaw | Dec 20, 2012 | Blog, Databases
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...
by Barrie Shaw | Aug 10, 2011 | Blog, Databases
One of our clients was experiencing an issue with their production Informix Online 5.05.UC11 databases running on SCO Unix 3.24 and we had the opportunity to help them a couple of weeks ago. It is surprising how many old installations of Informix you find still...
