The IBM Informix utility onmode -F has the following claims made about it in the IBM documentation:

When you execute onmode -F, the memory manager examines each memory pool for unused memory. When the memory manager locates blocks of unused memory, it immediately frees the memory. After the memory manager checks each memory pool, it begins checking memory segments and frees any that the database server no longer needs.

Blog Content/Topics List

The
information provided applies to the Informix Server Version 11.70.xC2
and later.

(german content)

Informix Workshops der IBM

Die IBM bietet im November zwei kostenlose Workshops zum Thema Informix an. Der 1. Workshop geht über zwei Tage und behandelt das Thema Informix Ultimate Warehouse Edition sowie Informix Warehouse Accelerator.

Der 2. Workshop umfasst einen Tag und beleuchtet die Informix Zeitreihen-Datenbanktechnologie (Informix Timeseries).

(german content)

Auf den Webseiten der Deutschen Informix User Group stehen Fotos und Präsentationen vom 58. IUG Workshop (Hamburg) zum Ansehen bzw. zum Download bereit:

To enable the "Expandable Chunk" Feature we must set the following ONCONFIG Parameters:

$ onmode -wf SP_AUTOEXPAND=1        # 1 = The automatic creation or extension of chunks is enabled.

$ onmode -wf SP_THRESHOLD=131072    # set the minimum amount of free kilobytes that can exist in a storage space
                                    # before Informix automatically runs a task to expand the space, either by

Update statistics has under gone many changes through out the years and this will take a high level look at these changes.

Version 4.0 Statistics only

Version 6.0 included distributions (update statistics medium and high)

Version 7.31 Significant performance improvement

• Update statistics low runs in parallel on fragmented indexes
• Update distributions can utilize more memory to run multiple columns in parallel

Version 11.10  Auto update statistics

Click on the link below to access the Success Stories (PDF)

ibm-big-data-success

“Getting to the top is optional. Getting down, mandatory” – Ed Viesturs, Mountain Climber

It is that time of year again; our IBM IOD conference is upon us.  I hope to see many of you there in attendance.  With over 10,000 people attending and some great sessions planned, it should be a valuable experience for everyone (Business Partners, Customers and IBMers).    

What is my predicted buzz at the conference this year?  What else, Big Data.  I mean what else could be bigger then Big Data, since it already has Big in its name.