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 #81)
March 2007

Other Issues

Highlights: IIUG Server upgraded to IDS 10

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

Dear friends,

This is my last issue as editor of the IIUG Insider. After two years and 26 issues I am moving to another assignment. I would like to thank you all for your support and encouragement. Editing the Insider is a very demanding job. I hope you enjoyed it and found it useful. I am sure David Fraser my successor will have fresh ideas and energy that will improve our newsletter. But to make our Insider really better, David will need your help and participation. If you have technical articles, success stories, requests or even complaints, send them to This is our newsletter and the editor just compiles the content. Now that I am a reader like the rest of you I promise to follow my preaching and provide content to the Insider.

So long,

Gary Ben-Israel
IIUG Insider Editor
IIUG Board of Directors

President's Note:

I am taking the Presidential liberty of editing this issue of the Insider after Gary has submitted it for publication, so he has not seen in advance what I am writing. Personally, I am amazed at the job Gary has done as the Editor of the Insider for over two years. It is not easy to put this newsletter together each and every month. But like clockwork, Gary has done it 26 times, with each issue better than the previous one.

Gary is not leaving the IIUG Board, but rather will be passing the Insider torch. Gary is the only most recent of perhaps only four or five editors who have kept this great tradition of the Insider going over the 12 years of the IIUG. His run has been oustanding.

I would like to introduce you all to David Fraser, now an IIUG Board member in his third year, who will be taking over as Editor. David is from way down under, where the sheep roam in New Zealand. To reach David with any suggestions for the Insider, please e-mail him at

Once again, Gary thanks for a great 26 issues!

Stuart Litel

Highlights Back to top

IIUG Server upgraded to IDS 10

A long time coming... IIUG Server upgraded to IDS 10.V

Almost eight or nine years ago, when I was first elected to the IIUG Board of Directors, I was late for my first board meeting by a few hours. When I walked into the meeting, the board had already decided who would do which assignments for the coming board year. Being late, I got stuck with the job that no one wanted: I became the person who was in charge of the IIUG Server.

I came to find out that the server was constantly going down, that it was being used by a few hackers as a warehouse for illegal software downloads, and that we were the victim of people using our server to bounce their spam mailings. To top it off, no backup had been done in months.

My first act was to unplug the server, pack it up, and ship it off to the offices of long time IIUG supporter and founder of Advanced DataTools, Lester Knutsen. We immediately re-built the entire server from scratch, removed all the illegal software, put a halt to the unauthorized activities, installed auditing, set up a daily backup, put in a new firewall, and of course set it up on a new ISP line. Since that time, I am happy to say the server has had an uptime of almost 100% in the last two years and over 95% in the last eight years. The only major outage was when the mid-Atlantic states of the United States got hit by a major storm. That storm caused much of the area to lose power for days.

That original server was replaced almost a year ago with a generous and gracious donation from Sun Corporation. There was only one thing we had never done and that was to upgrade the Informix database. Now how could the IIUG not have the latest and greatest version of IDS running? The answer was simple. We all know how rock solid IDS 7.31 was. There was no need to change or upgrade the server.

Well this has all changed. Thru the gracious donation of IBM, the IIUG server is now running the latest and greatest IDS. IDS 10 has been installed and we will soon be using more features of IDS 10 for more offerings to the membership. Watch for these.

On a personal note, I would like to thank Cindy Fung, WorldWide IDS Product Manager of IDS for getting us the new IDS software. Also many thanks go to the IIUG great operations staff of Pete Perez, Walt Hultgren, Tom Beebe, Lester Knutsen, June Hunt, and of course all the people of Advanced DataTools for watching over this most valuable asset of the IIUG. Of course when Cheetah comes out, we will immediately switch to Cheetah!

Run Cheetah Run!

Stuart Litel

Conference corner Back to top

Mark your calendar!! For May 6-10, 2007

Mark your calendar for the first week of May next year, and plan on attending the IDUG/IIUG North American Conference in San Jose California.

This will be the BEST technical conference ever offered to Informix users by the IIUG. We will be hosting FOUR full tracks of the latest and greatest INFORMIX ONLY technical content. These sessions will be given by Informix users, Business Partners, IBM Developers, and IBM Advanced Support.

Here are just a few samples from more than 55 technical sessions on the schedule:

  • Exploiting Role Separation in IDS - Jonathan Leffler, IBM
  • Put yourself on the map with Google Maps API, DB2/Informix, and PHP on Linux- Martin Lurie of IBM and Aron Lurie
  • Using the Onpladm Tool for Informix High-Performance Loader- John Carlson, Home Depot
  • Performance Tuning IDS In-Depth: The Next Generation- Art Kagel, Bloomberg LP
  • IDS Installations, Upgrades and Maintenance: Best Practices- Thomas Girsch, Hilton

In addition to these great technical sessions, we will also be offering 6 half-day Educational Seminars given by some of the best Informix technical experts around.

Here are a few examples:

  • Introduction to Java Development with IDS, by Jean-Georges Perrin
  • Speed and Performance in IDS, by John Miller III of IBM
  • Using PERL, CGI and DBI with Databases, by Darryl Priest of Piper Rudnick

Go Further! Share your experiences. Learn from what others have experienced first hand at the many networking opportunities available throughout the conference. Mingle with exhibitors in the exhibit hall. Benefit from extended face-to-face time with conference presenters and developers during the Speaker and IBM Developer Reception. Throughout the week you will be provided with many peer-to-peer networking opportunities.

One great example of networking with your peers would be the Special Interest Groups.

We are offering the following for Informix:

  • Informix for Data Warehousing and Business Intelligence
  • Informix on Linux
  • Informix Best Practices

Registration for this event is now open! Take advantage of the special early bird registration and attend IDUG/IIUG North America 2007 for only $1650.

Cindy Lichtenauer
IIUG Board of Directors
IIUG Conference Planning Committee

Information Management Technical Conference, Düsseldorf, Germany, May 21-25

Mark your calendar now - this is your chance to contribute and participate in the primary technical exchange and skill-building event for Information Management in Europe.

Of special interest to Informix participants:

The EMEA technical conference is delivering an expanded program of Informix sessions and activities this year. Conference sessions will include Informix topics scheduled Monday through Wednesday, and the German Informix User Group is planning additional activities on Thursday and Friday. The 2007 conference will have a full week of content for the Informix audience - just in time to learn more about the upcoming IDS 'Cheetah' release!

Please spread the word about this opportunity by forwarding this email to your teams, communicating on your websites, syndicating in your newsletters and including this in other communications to your teams.

Find out more at:

Audience: Available to Clients, Business Partners and IBMers

Technical Sessions

The event is hosted over 4.5 days and includes a total of 208 technical sessions.

Technical sessions are 1 hour in length.

Each attendee will have the opportunity to attend a total of 26 technical sessions throughout the week.

  • IDS (Informix Dynamic Server)/Cheetah
  • Architecting the On Demand Enterprise
  • DB2 for z/OS & DB2 Tools
  • DB2 Application Development
  • DB2 for Linux, Unix, Windows & Tools
  • IMS & IMS Tools
  • Content Management
  • Information Integration
  • Information Warehouse (BI)
  • Information Analysis
  • Master Data Management

We hope you take advantage of this incredible opportunity to participate at the Information Management Technical Conference this spring.


Cathy Elliott
Marketing Manager
IBM Information Management

Save the date for Information On Demand 2007 Global Conference

Save the Date! IBM Information On Demand 2007, October 14-19, 2007, Mandalay Bay Resort, Las Vegas, NV. The premier information management event for business and IT executives, managers, professionals, DBA's, developers, and business partners.

Early bird discount registration is available through May 31st.

Discount Pricing

Note: Prices are subject to change
Audience Type2007 Conference Prices
Full Price Customer & BP$1995
Early Early Bird
01 March - 31 May
Early Bird
01 June - 15 August
Alumni discount$1595 thru 31 May
$1695 thru 15 August
User Group discount (use promo code LVUFMX)
01 March - 31 May
User Group discount (use promo code LVUFMX)
01 June - 15 August
Business Partner Day$350
IBM Attendees$1895

Call for Speakers Open April 5-29

Dear IIUG Member,

Nominate an education session for IBM Information On Demand 2007. IBM's Information On Demand 2006 global conference was an overwhelming success, with over 5,000 people from all parts of the globe in attendance. This year's event promises to be just as exciting, with over 600 education sessions and more than 7,000 attendees expected.

Being a speaker at this premier Information On Demand event covering all data servers and tools products, enterprise content management solutions and information platform and solutions, you get a privileged opportunity to share your experience and wisdom with your peers. Whether you choose to present as part of the Business Leadership or Technical Skill Building programs, conference organizers will be selecting session nominations that feature real-world examples of how to expand your business opportunities by harnessing information.

Conference organizers are also searching for IBM customers to lead or co-lead sessions to illustrate how to reduce costs, increase productivity, grow market share and truly deliver information on demand. Sessions that illustrate examples from the banking, government, healthcare, insurance, life sciences, retail or telecommunications industries are strongly encouraged.

Session abstracts from user groups, IBM employees, customers and Business Partners are all welcome. Session abstracts will be accepted until April 29, 2007. Presenters will be informed of session selections in June. Conference presentations will be due by July 31, 2007.

Review the Business Leadership, Technical Skill Building or Business Partner Business Development Day program overviews for specific session topics being sought. Go to between April 5 and April 29 to submit your session proposal.

Education Back to top

IBM Redbooks - a great tool for building skills

IBM Redbooks offer a great way to grow your technical skills. They provide product positioning and value guidance, installation and implementation experiences, typical solution scenarios, step-by-step "how-to" guidelines, while often including sample code and other supporting materials. Redbooks are developed and published by the IBM International Technical Support Organization, ITSO.

Content is available in the domains of application development, IBM System i, p, storage, x, z, Information Management software, Infrastructure solutions, Linux, Lotus, Rational, Tivoli, and WebSphere. In each domain you can find a list of the most popular Redbooks, a list of the most recent Drafts, Redpapers (short technical documents written to reflect working experiences on a specific topic), Workshops (for highly experienced professionals on complex technical topics), Residencies (where Redbooks are developed over a 2 to 8 week process) and much more.

IBM Informix Education from IBM

Come to IBM to get all the latest information about the Informix product family. With courses grouped as Foundation (Basic), Level 1 (Intermediate), Level II (Advanced) and Master Series Workshop (Expert), you are certain to find the right level of Informix training to meet your needs. They are delivered in the classroom, some via e-learning and can also be customized to meet your needs. Get a window into some great skill building and certification opportunities by visiting our visit our Informix curriculum view.

Training: The Key to Retaining Your most Important Asset

Today's IT environment demands a workforce that can adapt to fast-changing requirements. Training reduces the risks involved in new technology rollouts, while shortening the learning curve needed to realize return on investment. Providing employees with skills-development opportunities helps attract and retain an agile IT staff. Training from IBM enables companies to maintain a highly skilled workforce through comprehensive training paths plus education to prepare for certification testing.

Developer corner Back to top

New on DeveloperWorks

Non-blocking checkpoints in Informix Dynamic Server

22 Mar 2007

Tune Informix Dynamic Server to take advantage of non-blocking checkpoints and RTO_SERVER_RESTART in an online transaction processing environment.

UDR enhancements in IBM Informix Dynamic Server V10

08 Mar 2007

IDS support for OUT/INOUT parameters and Named Return parameters

Using Perl with the Informix Dynamic Server

01 Mar 2007

Develop powerful applications for IDS

Informix news Back to top

WorldWinner delivers twice as many games each day with IBM Informix Dynamic Server

Published on: 01 Mar 2007

"Informix Dynamic Server has helped make us the predominant site on the Internet for skill-based game tournaments. We're seeing such extreme performance improvements that our speeds are now serving as a benchmark in the industry." - Joe Bai, Chief Information Officer, WorldWinner

Read the article

IIUG Board Back to top

IIUG Board of Directors meeting in Boca Raton, Florida

The first board meeting of the year took place at Boca Raton Florida on March 25-27. We met Alyse Passarelli - Director, WW Data Server Sales, Jerry Keesee - Director, Informix Products and Cathy Elliott - IDS Market Strategy. The board heard about IBM's plans for 2007 and about the Cheetah launch. The discussions were very good and I am confident that the positive turn Informix has taken will continue. The board has set new goals and assignments. We are going to continue to improve our existing services and are looking at ways to grow our user communities especially in EMEA, South America and Asia Pacific.

Michael Segel Profiled

Here it is again -- time for a new board and new profiles... Let's discover together board member Michael Segel.

Q: How do you use Informix in your "real" job (DBA, Consultant, Developer, etc.)?
A: As a consultant, my role is determined on a project by project basis. In those projects where I have the ability to recommend a database, my first choice is almost always Informix. When doing proof of concepts, I try to use Informix as much as possible. Its stable, reliable and lets me focus on the solution.
Q: How long have you been using Informix products?
A: Since June 1989. (That was my original start date with Informix.)
Q: What is your role on the IIUG Board?
A: I am in charge of the IIUG sponsor program and Business directory and am participating in the LUG team.
Q: Why did you volunteer to be on the board?
A: I believe that Informix IDS is the best product on the market and I want to make a difference, helping to grow the Informix Community. Informix users have long had a strong passion for the product. Under the umbrella of the IBM Software Group's Information Management pillar, it is important to help IBM to understand why such a passion exists and to help promote the brand. I also think that as members of the Informix Community, we should step up and take some of the burden and responsibility of keeping the IIUG running.
Q: What do you want to accomplish this year on the Board?
A: That's a good and tough question. When I ran for the board, I didn't have a set agenda. As a new board member, I thought it best to fill the gaps and to do what I can. Since being on the board these past couple of months, I'd like to focus on the issues that protect and promote the IIUG brand and to find out what we need to do to increase our membership and provide value to the community.
Q: Where are you from?
A: Originally Cleveland, Ohio, but I've lived in Chicago since '89.
Q: Best Informix story?
A: Wow. There's a couple of them. I'd have to say my most memorable was when Informix had their first User Group conference in Chicago. Hosting a C.D.I party and then the after party at a small place called Iggys. And yes, it was my fault that we kept Nils out past his bed time. ;-)
Also when I attended the first User Group event, I got a chance to meet and talk with Roger Sippl.
Q: Worst Informix nightmare.
A: Unfortunately there's a couple of them...
Many moons ago, I got a call from a Sun Microsystems sales rep. He had a client who ran Informix on a small Sun Sparc 5 box. Apparently they had a hard disk crash and needed to restore their engine. Only they didn't back up the engine. So we tried to recover what we could from the disk drive and rebuild what we could from that and from a paper trail. Its never fun breaking the bad news to a client.
Watching a couple former CEOs of Informix make some seriously bad mistakes. You have to remember that Informix is probably the best designed database currently on the market. Great engineers, not so great leadership.
Watching companies switch from IDS to another brand because their application provider has dropped support for IDS.
Q: Can you tell us about your family and hobbies outside of IIUG?
A: Married, no kids but 4 dogs and two cats. It's a full house. Hobbies? Besides walking the dogs? I enjoy digital photography, being a techie and an entrepreneur. I'm willing to try anything once, twice maybe, if its fun. ;-)

Calendar of events Back to top

April - 2007
Date Event Location Contact
27 New England Informix User Group Meeting IBM Facility, Waltham, MA June Hunt
May - 2007
Date Event Location Contact
6-10 IIUG/IDUG 2007 - North America San Jose, CA Cindy Lichtenauer
21-25 Information Management Technical Conference Düsseldorf, Germany
23 Informix User Group of France Paris, France Jean-Georges Perrin
October - 2007
Date Event Location Contact
14-19 IBM Information On Demand 2007 Las Vegas, NV

Useful links Back to top

In response to your input, we have created a page on the IIUG web site containing all the links we used to include. Please find it at:

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. 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
Stuart Litel
Jean Georges Perrin

For comments, please send an email to