by Brad Patterson | Nov 8, 2017 | Blog, Data Management
I often use the Informix Developer Edition for ARM on my Raspberry Pi for quick prototyping and proof-of-concept (POC) experiments as the Informix Developer Edition has all of the features of the full Enterprise Edition, including native JSON and Time Series...
by XTIVIA | Sep 22, 2015 | Blog, Databases
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...
by XTIVIA | May 7, 2015 | Blog, Databases
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...
by XTIVIA | Aug 28, 2014 | Blog, Databases
Environment: Informix 11.50 FC3 / AIX 6.1 Genero BDL 2.11.03 / Genero GDC 2.02 / License Manager 5.15. Error: Listener-thread: err = -408: oserr = 0: errstr = : Invalid message type received from the sqlexec process. One of our Virtual-DBA clients...
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 XTIVIA | May 9, 2014 | Blog, Databases
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...
by Paul Anderson | May 6, 2014 | Blog, Databases
Informix provides the functionality to restore a single table or a subset of a table to a point in time or to the last archive. This functionality was originally released in IDS v10 and is provided through the archecker software which is included with the...
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 XTIVIA | Jan 31, 2014 | Blog, Databases
I have been working with Informix for just over 15 years. This has caused me to stop, pause and think about all the changes in the industry that have happened in that time. Back when I started, databases were still small. Databases were maintained to...
by Brad Patterson | Aug 20, 2013 | Blog, Databases
XTIVIA has a client who runs an old Informix database product, Standard Engine (SE) version 5.01.UD3, on SCO UNIX version 5.0.5. Both have been running well for at least twenty years without much in the way of outages. Over the years XTIVIA has assisted...
