Informix News
18 Nov 13 - ZDNet - Top 20 mobile skills in demand... Read
09 Sep 13 - telecompaper - Shaspa and Tatung have shown a new smart home platform at Ifa in Berlin. Powered by the IBM Informix software... Read
06 Sep 13 - IBM data magazine - Mission Accomplished - Miami, Florida will be the backdrop for the 2014 IIUG Informix Conference... Read
01 Feb 13 - IBM Data Magazine - Are your database backups safe? Lester Knutsen (IBM Champion) writes about database back up safety using "archecker"... Read
14 Nov 12 - IBM - IBM's Big Data For Smart Grid Goes Live In Texas... Read
3 Oct 12 - The Financial - IBM and TransWorks Collaborate to Help Louisiana-Pacific Corporation Achieve Supply Chain Efficiency... Read
28 Aug 12 - techCLOUD9 - Splunk kicks up a SaaS Storm... Read
10 Aug 12 - businessCLOUD9 - Is this the other half of Cloud monitoring?... Read
3 Aug 12 - IBM data management - Supercharging the data warehouse while keeping costs down IBM Informix Warehouse Accelerator (IWA) delivers superior performance for in-memory analytics processing... Read
2 Aug 12 - channelbiz - Oninit Group launches Pay Per Pulse cloud-based service... Read
28 May 12 - Bloor - David Norfolk on the recent Informix benchmark "pretty impressive results"... Read
23 May 12 - DBTA - Informix Genero: A Way to Modernize Informix 4GL Applications... Read
9 Apr 12 - Mastering Data Management - Upping the Informix Ante: Advanced Data Tools... Read
22 Mar 12 - developerWorks - Optimizing Informix database access... Read
14 Mar 12 - - International Informix User Group set to meet in San Diego... Read
1 Mar 12 - IBM Data Management - IIUG Heads West for 2012 - Get ready for sun and sand in San Diego... Read
1 Mar 12 - IBM Data Management - Running Informix on Solid-State Drives.Speed Up Database Access... Read
26 Feb 12 - - Better results, lower cost for a broad set of new IBM clients and partners... Read
24 Feb 12 - developerWorks - Informix Warehouse Accelerator: Continuous Acceleration during Data Refresh... Read
6 Feb 12 - PRLOG - Informix port delivers unlimited database scalability for popular SaaS application ... Read
2 Feb 12 - developerWorks - Loading data with the IBM Informix TimeSeries Plug-in for Data Studio... Read
1 Feb 12 - developerWorks - 100 Tech Tips, #47: Log-in to Fix Central... Read
13 Jan 12 - MC Press online - Informix Dynamic Server Entices New Users with Free Production Edition ... Read
11 Jan 12 - Computerworld - Ecologic Analytics and Landis+Gyr -- Suitors Decide to Tie the Knot... Read
9 Jan 12 - - DNS impact on Informix / Impacto do DNS no Informix... Read
8 Sep 11 - - IBM Offers Database Solution to Enable Smart Meter Data Capture... Read
1 Aug 11 - IBM Data Management Magazine - IIUG user view: Happy 10th anniversary to IBM and Informix... Read
8 Jul 11 - Database Trends and Applications - Managing Time Series Data with Informix... Read
31 May 11 - Smart Grid - The meter data management pitfall utilities are overlooking... Read
27 May 11 - IBM Data Management Magazine - IIUG user view: Big data, big time ( Series data, warehouse acceleration, and 4GLs )... Read
16 May 11 - Business Wire - HiT Software Announces DBMoto for Enterprise Integration, Adds Informix. Log-based Change Data Capture... Read
21 Mar 11 - Yahoo! Finance - IBM and Cable&Wireless Worldwide Announce UK Smart Energy Cloud... Read
14 Mar 11 - MarketWatch - Fuzzy Logix and IBM Unveil In-Database Analytics for IBM Informix... Read
11 Mar 11 - InvestorPlace - It's Time to Give IBM Props: How many tech stocks are up 53% since the dot-com boom?... Read
9 Mar 11 - DBTA - Database Administration and the Goal of Diminishing Downtime... Read
2 Feb 11 - DBTAs - Informix 11.7 Flexible Grid Provides a Different Way of Looking at Database Servers... Read
27 Jan 11 - exactsolutions - Exact to Add Informix Support to Database Replay, SQL Monitoring Solutions... Read
25 Jan 11 - PR Newswire - Bank of China in the UK Works With IBM to Become a Smarter, Greener Bank... Read
12 Oct 10 - Database Trends and Applications - Informix 11.7: The Beginning of the Next Decade of IBM Informix... Read
20 Sep 10 - - ITG analyst paper: Cost/Benefit case for IBM Informix as compared to Microsoft SQL Server... Read
20 Jul 10 - IBM Announcements - IBM Informix Choice Edition V11.50 helps deploy low-cost scalable and reliable solutions for Apple Macintosh and Microsoft Windows... Read
20 Jul 10 - IBM Announcements - Software withdrawal: Elite Support for Informix Ultimate-C Edition... Read
24 May 10 - eWeek Europe - IBM Supplies Database Tech For EU Smart Grid... Read
23 May 10 - SiliconIndia - IBM's smart metering system allows wise use of energy... Read
21 May 10 - CNET - IBM to help people monitor energy use... Read
20 May 10 - ebiz - IBM Teams With Hildebrand To Bring Smart Metering To Homes Across Britain... Read
19 May 10 - The New Blog Times - Misurare il consumo energetico: DEHEMS è pronto... Read
19 May 10 - ZDNet - IBM software in your home? Pact enables five-city smart meter pilot in Europe... Read
17 March 10 - ZDNet (blog) David Morgenstern - TCO: New research finds Macs in the enterprise easier, cheaper to manage than... Read
17 March 2010 - Virtualization Review - ...key components of Big Blue's platform to the commercial cloud such as its WebSphere suite of application ser vers and its DB2 and Informix databases... Read
10 February 2010 - The Wall Street Journal - International Business Machines is expanding an initiative to win over students and professors on its products. How do they lure the college crowd?... Read

End of Support Dates

IIUG on Facebook IIUG on Twitter

IIUG Insider (Issue #164)
February 2014

Other Issues

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

For questions about this event, contact the host at:

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 '' 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 '' in the the /tmp directory:

$ onmode -wi /tmp/

   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/':
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! 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 or directly at:

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