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