Discover Informix - The data server with the most flexible cluster and replication technology on the market and the lowest TCO

bweed's picture

Space Apps Challenge in NYC (April 11-12)

We have an exciting weekend coming up in NYC.  It is time for the NYC Space Apps Challenge!  IBM is a sponsor of this event in NYC and a supporter worldwide.  This event fits directly into our wheelhouse of focusing on developers and start-ups in NYC and around the world.

What is the Space Apps Challenge

eherber's picture

Informix Newsletter März 2015

(german content)

Neue Ausgabe des IBM/Informix Newsletters

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

Inhaltsverzeichnis der Ausgabe:

Temporary tables

Again, this is another blog post about nothing new at all but an attempt to put down my understanding of temporary tables down in a way that will help me when I refer back to it and hopefully be of more wider use.

When looking at things like this a test system is always essential for checking things and finding some surprising results. If you don’t have one you can soon set one up with VMWare or Virtual Box and a copy of Informix Developer Edition. For this post I am going to set up a simple test instance with four specific dbspaces:

mholzbauer's picture

Are your statistics (distributions) are really up to date ? - PART II


So what we know in Part I  is that "Statistics updated." does not always mean that your statistics are up to date.
Sometimes it means: "Statistics are up to date and not changed - STATLEVEL threshold is not reached".

mholzbauer's picture

Are your statistics (distributions) are really up to date ? - PART I

or: Some more Secrets of "UPDATE STATISTICS"...
 

Did you sometimes wonder why a "UPDATE STATISTICS" Statement
is so faster in newer Informix version on greater tables ?

Or you wonder why the query is not faster after executed some
"update statistics medium/high" statements ?

akagel's picture

News from the IIUG

Here's a link to an announcement from the IIUG Board of Directors talking about this year's IIUG 2015 Conference celebrating the 20th Anniversary Year of the IIUG:

IIUG News March 20, 2015

Informix Warehouse Accelerator: Trickle Feed and NONEXCLTRIG

eherber's picture

Informix Newsletter Februar 2015

(german content)

Neue Ausgabe des IBM/Informix Newsletters

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

Inhaltsverzeichnis der Ausgabe:

fnunes's picture

IIUG Conference 2015 / Conferência IIUG 2015

Have you registered for the IIUG 2015 conference? (original version http://informix-technology.blogspot.com/2015/02/iiug-conference-2015-conferencia-iiug.html )

English version
IIUG is organizing its usual annual user conference. This year it will take place in the Mission Valley Marriott in San Diego, between 26-29 April.

aford's picture

Resolving In Place Alters - Part 4, The Slot Table

By the end of Resolving In Place Alters, Part 3 I was able to read the raw data pages that belong to the table with pending IPAs, but I wasn't able to see if a data page had a pending IPA or not. In this installment I will show you how I solved that problem using what I know about the Informix Data Page structure and the structure of my table before and after the in place alter was performed.

Anatomy of the Informix Data Page