Archive - Oct 2011
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.
Performance and scalability of Informix ultimate warehouse edtion on Intel Xeon 7500 and E7 processorsSubmitted by kmurthy on October 29, 2011 - 15:46
information provided applies to the Informix Server Version 11.70.xC2
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).
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)
“Getting to the top is optional. Getting down, mandatory” – Ed Viesturs, Mountain Climber
See you at the IBM Information OnDemand (IOD) Conference in Las Vegas this week – And yes, Big Data will be a hot topic!Submitted by bweed on October 21, 2011 - 22:06
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.