IIUG Insider (Issue #165) March 2014

Highlights: Informix 12.10.xC3 is available!

Welcome to the International Informix Users Group (IIUG) Insider! Designed for IIUG members and Informix user group leaders, this publication contains timely and relevant information for the IBM Informix community.


Editorial Back to top

The IIUG Conference is less than a month away. If you haven’t registered yet do it as soon as possible. There are so many reasons to attend this event; unmatched content, networking with colleagues, meeting IBM executives and developers.

You all know these advantages. This is why so many of you attended this conference during the years. But let me add one more reason. You are all Informix users and enthusiasts. Attending the conference is a demonstration of the power for Informix. We need it now more than ever.

So if you are hesitating, don’t just come by yourself but convince your friends to do the same. On March 21 I decided to run at the Jerusalem Marathon. I did not do the full Marathon only the 10 KM (6.2 Miles) track. Like working with Informix it is not always easy but it is a lot of fun and I would like to keep doing it.

Gary Ben-Israel
IIUG Insider Editor

Highlights Back to top

Informix 12.10.xC3 is available!

What’s new IBM Informix version 12.10.xC3


  • Server changes
  • JSON compatibility pre- and post-migration requirements
  • New reversion requirements


Server configuration

  • Automatically configure the server during installation



  • Automatic resource tuning for performance
  • Automatic location and fragmentation


  • Control the size of private memory caches
  • Virtual shared memory segment size doubling


  • Retrying connections

Application development

JSON compatibility

  • Use the Mongo API to access relational data
  • Improved JSON compatibility

Foreign-key constraints

  • Temporarily prevent constraint validation
  • Faster creation of foreign-key constraints


  • Find the quarter of the calendar year for dates

High-availability clusters and Enterprise Replication

Connection Manager

  • Improvements to Connection Manager


  • View log-staging information on RS secondary servers


  • Easier configuration and cloning of a server for replication


  • Shard data across Enterprise Replication servers

Spatial data

  • Enhancements for handling spatial data

Time series data


  • Efficient storage for hertz and numeric time series data


  • Control the destroy behavior for rolling window containers
  • Monitor groups of containers with wildcard characters

Faster queries

  • Faster queries by running time series routines in parallel
  • Faster queries with IN conditions through virtual tables


Additional types of data

  • Accelerate warehouse queries in-memory using data from multiple sources

– Inge Halilvoic

Conference corner Back to top

IIUG 2014 is Less Than One Month Away

WOW! It is hard to believe the IIUG 2014 is less than one month away.

The conference committee is working hard to finalize all the details for this year’s conference. The latest item finalized is the confirmation of our keynote speakers. You will want to make certain you attend the Monday morning keynote to meet Beth Smith, the NEW General Manager of Information Management Software as she shares the state of information management. Jerry Keesee, Director of Informix Database Development, will join us Wednesday morning to share his Informix insights. Check out the IIUG 2014 website to learn more about this year’s keynote speakers.

You will also want to review our tutorial list offered on May 1st. Here is a partial list of the tutorials:

  • Application of NoSql databases and managing hybrid databases – John Miller III
  • Implementation of a Multi-Site Connection Manager strategy – Gustavo Castro
  • Deploy and optimize IBM Cognos BI with IBM Informix and IWA Acceleration – Veronica Gomes
  • Rolling Upgrades Hands-On Lab – Ron Privett
  • Informix NoSQL: Technical deep dive – Keshava Murthy
  • Migrating Informix 4GL to Informix Genero and Web enabling your applications – Shawn Moe
  • Certification Preparation – Informix 12.10 System Administrator – Sanjit Chakraborty
  • Working with PHP and Informix – Tom Beebe

Remember these tutorials are included for all paid conference registrants. Speakers and conference sponsors are also invited to attend tutorials at $75 for a half-day tutorial or $125 for two half-day tutorials or a full-day tutorial when purchased prior to April 20, 2014. The onsite price will be $25 more or $100 half day and $150 for Full day.

This is a partial list of the IBM Hands On Labs that will be offered at IIUG2014. All IBM Hands On Labs and instructors are subject to change. You can keep up with this list on the Hands On Labs section of the website.

  • Web Services using Genero – It is easy!!! – Thomas Palmer
  • How does data compression impact applications? – Andreas Legner
  • Hands on with NoSQL inside Informix – Carlton Doe
  • Informix Hypervisor Edition under PureApplication Environment – Nagaraju Inturi
  • Configure the Open Source Zabbix with IDS 12.10 – Laurent Revel
  • Experience OAT to Administer Informix – Sumanth Rajagopal
  • Experience NoSQL & Sharding with Informix – Nicholas Geib
  • Deploy a fully functional end-to-end Informix Warehouse Accelerator demo – Veronica Gome
  • Informix and Pi- database meets technology – Pradeep Natarajan
  • Migrate from SAP/Oracle to SAP/Informix – Radomir Hulka

All of our sessions have been confirmed and we are in the process of finalizing the session schedule. We will send you an email as soon as the schedule is ready so you can begin planning your conference schedule.

Online conference registration ends on April 20, 2014 EST. You will still be able to register onsite the day of the conference. Don’t forget you have until April 7th to take advantage of the IIUG membership savings of $100 on your conference registration. We would enjoy seeing you at IIUG 2014 so register today.

Please visit the conference website for more information about IIUG 2014 or if you can’t find the information you are looking for you can email the IIUG 2014 Conference team at conference@iiug.org.

TAKE NOTE: Online conference registration ends on April 20, 2014 EST. You will still be able to register onsite the day of the conference. Don’t forget though you only have until APRIL 7TH to take advantage of the IIUG membership savings of on your conference registration. The conference hotel guarantee room rate expires on April 4, 2014. After that we cannot guarantee the special conference rate. The hotels in the area are almost twice as much as this special rate, so don’t miss out.

We look forward to seeing you April 27 – May 1.

Contact us if you have any questions concerning this year’s conference.

Informix news Back to top

Warm Sun and a Hot AgendaThe time is ripe to learn about the Internet of Things and more at the 2014 IIUG Informix Conference in Miami.
Read the article in IBM Data Magazine.

Ready for Some Sun?The 2014 IIUG Informix Conference in Miami, Florida is shaping up to host its biggest turnout ever.
Read the article in IBM Data Magazine.

The Internet of ThingsNow on YouTube: The Internet of things and how Informix fits in.

Internet of Things – Introduction

Internet of Things with IBM Informix

Informix corner Back to top

Sunsetting Older Informix Information CentersThe following Informix information centers will be sunset in the near future:

  • Informix 11.10 information center
  • Informix 10 information center
  • Informix products information center

After these information centers are sunset, links to them will be redirected automatically to the resources listed below. You can download final versions of the product documentation, which are being provided as-is, from these resources:

Information centers for current Informix releases will be replaced by the new IBM Knowledge Center, which is currently in Beta. Links from the current information centers will be redirected automatically to the new IBM Knowledge Center.

Consider updating your bookmarks now, and explore the IBM Knowledge Center, especially the Informix collections:

To learn more about the IBM Knowledge Center strategy, follow the IBM Technical Content blog.

– Randy House

Calendar of events Back to top

April – 2014
Date Event Location Contact
27 2014 IIUG Informix Conference Miami, Florida Cindy Lichtenauer
October – 2014
Date Event Location Contact
26-30 IBM Insight 2014 Las Vegas, Nevada

Informix resources Back to top

IBM Informix home pagehttp://www.informix.com or directly at: http://www-01.ibm.com/software/data/informix/

Informix blogs and wikisBlogs and Wikis that have been updated during the last month

More Blogs and Wikis

Forums, groups, videos, and magazines

There is now an Informix group on LinkedIn. The group is called “Informix Supporter”, so anyone loving Informix can join, from current IBM employees, former Informix employees, to users. It will also be a good occasion to get in touch with others or long-time-no-seen friends. If you fancy showing the Informix logo on your profile, join.

Useful links Back to top


Closing and credits Back to top

The International Informix Users Group (IIUG) is an organization designed to enhance communications between its worldwide user community and IBM. The IIUG’s membership database now exceeds 25,000 entries and enjoys the support and commitment of IBM’s Data Management division. Key programs include local user groups and special interest groups, which we promote and assist from launch through growth.

Sources: IIUG Board of Directors
IBM Corp.
Editors: Gary Ben-Israel
Rhonda Hackenburg

For comments, please send an email to gary@iiug.org.

Categorized as Insider

By Vicente Salvador

Board member since 2014, a user since 1989 and Informix fan. I'am software architect which allow me to combine technical and business skills.