This article is written in English and Portuguese
Este artigo está escrito em Inglês e Português

English version:

When upgrading to version 11.70, it’s good to review the list of new features you can take advantage of. IBM has helpfully produced a technical white paper for this purpose. One of these features is huge (or large) pages on Linux, of benefit if your system has a large amount of memory allocated to Informix.

I needed a way to extract the individual words from a sentence stored in a single character field. After some failed google searches and no desire to install a Datablade or write a C UDR for something that doesn't need to have killer performance, I decided to write my own quick and dirty SPL function.

my_strtok(str, delim, token_num) will take a string, break it into individual tokens based the delimiter and return the Nth token of the string.

Running this:

execute function my_strtok("How now brown cow", " ", 3)

(german content)

Neue Ausgabe des IBM/Informix Newsletters

Im Newsletter-Archiv befindet sich die neueste Ausgabe des INFORMIX-Newsletters.

Inhaltsverzeichnis der Ausgabe:

Where did I find this picture, can you identify anyone in this picture and what is the guy on the left looking at on the ground?

John Adamski posted a question to the IIUG SIGs about how to identify a session that caused the long transaction that eventually put his system in a Blocked:LONGTX state.

If you are wondering why there has not been any new post in this blog for a long time, I have a very good excuse! We have been working hard to bring you the newest version of Informix. This latest version, code named Centaurus, is faster, smarter, and easier to use. I can already feel your next questions - When is it coming out? What is new in it?

This article is written in English and Portuguese
Este artigo está escrito em Inglês e Português

English version:

"Holy Cow, two blog posts in one day!" - Harry Caray

Informix Engine Defies Laws of the Universe


I recently inherited an Informix engine from another department as part of a server migration and upgrade to Innovator-C. In my life long pursuit of finding unattended Informix engines with ridiculously long up times I did an 'onstat -' to see how many days this engine had been running.

[informix]$ onstat -

IBM Informix Dynamic Server Version 10.00.UC3R1   -- On-Line (Prim) -- Up 869 days 12:02:13 -- 2423888 Kbytes