IIUG Insider (Issue #164) February 2014

Highlights: Elections for IIUG board of directors

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

We had a very good board meeting this February. Many new ideas. We are working on new ways of communication with our membership , especially the IIUG website and the IIUG Insider, so stay tuned.

Our conference is less the two months away. If you haven’t registered yet hurry up.

Looking forward to meeting you in Miami.

Gary Ben-Israel
IIUG Insider Editor

Highlights Back to top

Elections for IIUG Board of Directors

Nominations closed on February 24, and the IIUG board is reviewing the candidates. The membership will be informed soon about the candidates and the election time table.

Stay tuned.

Conference corner Back to top

IIUG2014 Confirmed Sessions Posted!

Late Registration has begun, but you can still save on your registration by applying your $100 IIUG Membership Discount for a total cost of $1075 USD. Register today and join us for the Sixth Annual IIUG Conference at our new location in Miami.

Not an IIUG member? It’s fast! It’s easy! It’s free! Become a member to save on your conference registration and gain access to downloads of the latest IBM Informix products, Informix DBA Utilities and Online Forums.

Please remember, this hotel is smaller than we are used to and rooms are booking quickly. It’s very possible we will have more conference attendees than we have rooms. If you know you will be attending IIUG2014 you should register ASAP to guarantee a room. We do NOT have an overflow hotel and other hotels in the area are at least $50 more per night.

This year’s conference follows the same format as last year. IIUG2014 opens Sunday evening with a Welcome reception where you can catchup with old friends and make new contacts. Three full-days of technical sessions, hands-on labs and keynotes fill the agenda Monday thru Wednesday. A multitude of invaluable topics for Informix users and administrators will cover popular Informix features, engine and application performance tuning, troubleshooting and much more. We will also have receptions on Monday and Tuesday evenings. The conference will conclude on Thursday with a full day of tutorials. We will also have several sponsors who are waiting to talk with you.

Remember, your IIUG2014 conference registration guarantees you entrance to the May 1st tutorials at NO ADDITIONAL CHARGE for all paid attendees. This is a great opportunity to extend your training budget.

Speakers are starting to submit their presentations for IIUG2014. As these sessions are submitted we will continue to add them to the conference website. The speakers at IIUG2014 are the best the Informix community has to offer. New speakers and familiar faces are eager to share their knowledge and expertise while presenting interesting and relevant topics that can be used to reinforce your professional skills.

Here’s a partial list of this year’s sessions:

  • Running NoSQL Cloud Applications in Informix
  • Informix Replication Technologies
  • Deploy IBM Cognos with IBM Informix and IWA Acceleration
  • Getting Performance Out of Your Application in a Secured Environment
  • Globalization and Your Database
  • TimeSeries Performance Tuning
  • Informix Benchmarks
  • Monitoring the Health of Your Database
  • Business Analyticsv
  • Genero
  • And much, much more

The list of sessions will be updated weekly as sessions are submitted, so visit the IIUG2014 website regularly to see the full list of submitted sessions.

Use our Justification Document if you are still having problems convincing your boss this is a valuable way to spend your training dollars.

See you at the Conference!
Apr 27 – May 1, 2014
J.W. Marriott Brickell Ave. Miami, Florida

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

Developer corner Back to top

Informix Chat with the Lab

Topic: IBM Informix Enterprise Data Management for the Internet-of-Things
Date: Tuesday, March 25, 2014
Time: 8:30 – 10:00 AM Pacific
10:30 AM – 12:00 PM Central
11:30 AM – 1 PM Eastern
4:30 – 6:00 PM London
5:30 – 7:00 PM Paris

Presented by: Jerry Keesee – Director, IBM Informix Database Development (IBM), Darin Tracy – Sr. Software Engineer – CTE Informix Competitive Technical Enablement (IBM)

Hosted by: Anita McKeithen (IBM)

Why IBM Informix is best suited for the Internet-of-Things. From its embed capabilities with its small footprint and ease of use and administration, to its use in the cloud as a fully operational database with warehouse and analytic capabilities. IBM Informix is a single database that provides solutions from end to end in the Internet-of-Things.


For technical questions, contact support at support@collabserv.com

For questions about this event, contact the host at: mckeithe@us.ibm.com

Webcast : How to Bridge New Computing Technologies By Combining SQL and NoSQL data for Powerful BigData, Cloud, and Mobile Enterprise Applications

Date: March 5th, 2014

Time: 12:00PM ET, 9:00AM PT

Attend this webcast to hear how enterprises, large and small, can develop applications that bridge the gap between new computing technologies designed for big data, cloud, and mobile computing, with their enterprise world of relational data.


Informix news Back to top

SOAPBox Release 1.5 Now Supports IBM Informix

Feeling Your Informix OAT’s – Part 2: Apply the Open Admin Tool (OAT) environment to advanced Informix database administration.

The Bus Anomaly in Test Data Management

Article: The first two databases to be supported are SQL Server and Informix.

Case Studies

Kaifa captures new markets with innovative smart metering solutions — Kaifa entered into a three-way partnership with #IBM and AMT-SYBEX, building an innovative and efficient smart metering solution based on Affinity Meterflow and #IBM #Informix software.

New video case study — Advanced Data Tools, IBM Informix, and IBM BladeCenter.

Recap of Informix Chat with the Lab

Recap: Speed-of-thought query response with Informix Warehouse Accelerator and new SQL enhancements in Informix 12.1

Recap of NoSQL TweetChat

Thanks to all who participated in the February 20th TweetChat Why NoSQL and Why Informix NoSQL. It was well attended discussion answering several questions on factors driving NoSQL.

Support corner Back to top

How to change multiple configuration parameters at once?

At present most of the Informix configuration parameters can be modified dynamically. Typically, users run ‘onmode -wf’ or ‘onmode -wm’ command to dynamically change a specific configuration parameter. But there may be a situation when you need to modify multiple parameters at once. For example, you have ten Informix instance and want to tune some of SQL statement cache configuration parameters on all the Informix instances.

Now, you can import a configuration file using onmode command to change multiple configuration parameter at once. Importing a configuration file is often faster and more convenient than changing one configuration parameter at a time. You can use the ‘onmode -wi’ command to import a file that contains new values for multiple configuration parameters. If the parameters are dynamically tunable, the database server applies the new values. The import operation ignores the configuration parameters in the file that are not dynamically tunable and if the new parameter values same as the existing value.

However, you need to keep a note hare that an import operation changes the values of configuration parameters only in the memory. It does not modify the values in the ONCONFIG file on disk.

Let’s take the same example as before, modify some of SQL statement cache configuration parameters using import operation. Currently, you have following settings:

STMT_CACHE         0

You create a ‘onconfig.new’ file under ‘/tmp’ directory with following values to modify the configuration parameters:

STMT_CACHE         1

Next, you run the following command to import configuration values from file named ‘onconfig.new’ in the the /tmp directory:

$ onmode -wi /tmp/onconfig.new

   3 parameters successfully modified. See online log for more info.

The above command generates appropriate messages on screen and the message log. Following is an excerpt of the message log:

14:50:42  Importing configuration from '/tmp/onconfig.new':
14:50:42  Value of STMT_CACHE has been changed to 1.
14:50:42  Value of STMT_CACHE_NOLIMIT has been changed to 1.
14:50:42  Value of STMT_CACHE_HITS has been changed to 1.
14:50:42  Config Import Complete. 3 tunable parameters processed.
          3 modified, 0 unchanged, 0 could not be tuned.

You can notice only three out of the five parameters has been changed because either those are not dynamically tunable or using same existing value.

As the ‘onmode -wi’ command import a configuration file, you can also export configuration parameters from memory to a file using ‘onmode -we’ command.

– Sanjit Chakraborty

Informix corner Back to top

IBM Technical Content

The IBM Knowledge Center Open Beta is available!

We’re happy to announce the availability of our open IBM Knowledge Center Beta, live on ibm.com! The Beta ended February 28, 2014.

IBM Knowledge Center is our new framework for bringing together millions of pages of IBM product publications in a single location. In IBM Knowledge Center, you can search, filter, and even customize your content experience.

You can try out IBM Knowledge Center for yourself here::


Improving your technical content experience

IBM Knowledge Center brings IBM’s technical publications together in a single location, and will replace over 800 individual IBM Information Centers.

For this release, we simplified the user experience, improved search, and refined the overall experience with many other enhancements. As always, you can get help on IBM Knowledge Center from the information icon in the upper right corner of the pane (also linked here):


Send us your feedback!

After you’ve worked with IBM Knowledge Center, sign in with your IBM ID and take a few moments to complete the survey on IBM Knowledge Center.

Known Beta limitations

We are still:

  • Fine tuning IBM Knowledge Center, so you might experience some minor functional issues
  • Configuring and adding content to IBM Knowledge Center, so the content you see might not be exactly what you expect
  • Configuring and indexing content for search, so search results might not be exactly what you expect, or might not be in all the languages you expect

On behalf of the entire IBM Knowledge Center team and all our content providers, we want to thank you very much in advance for your time and for helping us make IBM Knowledge Center a better information experience!

Informix 12.1 Bootcamp

This bootcamp is for IBM Business Partners. IBM Informix is the database software which has been voted twice as number #1 in customer satisfaction. Clients love Informix because it is reliable, low cost, and administration free. Solution providers choose Informix for its best-of-breed embeddability. Available on Windows, Linux, Unix, and MAC, this technical workshop provides training on IBM Informix 12 in a classroom setting.

Mar 3 – 5, 2014 Mexico City, Mexico
Mar 3 – 7, 2014 Jakarta, Indonesia


Calendar of events Back to top

March – 2014
Date Event Location Contact
3-5 IBM Informix Bootcamp Mexico City, Mexico Registration
21 Washington DC Area Informix Users Group Meeting and Hands on Workshop Tysons’ Corner, Virginia James Edmiston
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 page

http://www.informix.com or directly at: http://www-01.ibm.com/software/data/informix/

Informix blogs and wikis

Blogs 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.