IIUG Insider (Issue #59) May 2005

Highlights: IIUG Conference in, Denver CO, May 22 – 26, 2005

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.


  1. Editorial…
  2. Cover story: IIUG Conference
  3. Presidents Note on the Conference and more…
  4. IIUG Insider Logo contest
  5. www.iiug.org – The new look!
  6. Announcing IBM Informix Dynamic Server (IDS) Express
  7. IBM InfoBahns
  8. Infobahns in New Zealand and Australia
  9. Informix Chat with the Lab: IDS Replication
  10. Generating XML from IDS 9.x
  11. Calendar of events
  12. Developer corner
  13. Useful Links
  14. Closing and Credits


Our main event this month was definitely the conference in Denver. For those tired hearing about it I promise this is our cover story for the last time. You are off the hook until next year. The result made all the hard work worth while. For me, and I hope for anyone who attended, it was much more then an outstanding educational experience. This conference was a social event, recapturing the family, regaining faith in the future of Informix. I hope we will continue and am looking forward to meet you all next year.

Gary Ben-Israel
IIUG Insider Editor
IIUG Board of Directors

Cover story: IIUG Conference

From the welcoming banner at the Denver airport (above) and through the keynote speech by Janet Perna and the whole conference IBM management stated its commitment to IDS as IBM’s database of choice for OLTP embedded applications. IDS and DB2 UDB will continue as two separate products. The Educational seminars and the technical session where highly attended and the Informix / IIUG party and the IIUG Annual General meeting had over 100 attendees.

For the first time the IIUG selected the best overall presentation and the best user presentation. It was a tough choice but the best over all presentation was: on Exploring the Sysmaster by Lester Knutsen from Advanced Data Tools and the best user presentation was: Using PERL and DBI/DBD With Informix Databases, Darryl Priest, Piper Consulting. The best user presentation award is a free pass to next year’s conference in Tampa including airfare and hotel to deliver his winning presentation. For those who missed it you have one more reason to attend our 2006 conference.

The IIUG Board of Directors would like to send its greetings and gratitude to both of them. I have been to many conferences and this was by far the best. The quality of sessions, the atmosphere and the synergy with IDUG where outstanding. But don’t take my word for it. Read through the following letters or ask anyone who attended:

I just wanted to send you an email to say how much that I enjoyed the conference. The sessions were amazing. The thing that I liked about the sessions was that it was purely technical, and not marketing related. I learned more in the last week than I have in any other time in my Informix career. The conference was truly worthwhile from a learning perspective, and I had no problem justifying the cost of the conference to my bosses. There are only a couple of gripes about the conference, and none too great. First of all, at the table where they were selling books and merchandise, there was no Informix stuff. If there were any Informix books, I didn’t see them.

Second, I felt like if the new Informix features were mentioned more in the opening session by Janet, then we would have had more respect from the DB2 users. You and I, and all the other Informix users at the conference know that the product is not going away, but I’m not sure that everyone at the conference knew that. I know we already talked about marketing issues, but I think that if we as the user community were doing more to reach out and get new users that we would really be helping our cause. As I said earlier, I really enjoyed the conference and met a lot of great people, and I appreciate all of the hard work that you and all of the members on the board did to make it go smoothly. I will definitely be pushing my management to let me attend next year as well.


Matthew Elders
Hastings Entertainment
Database Administrator

I wanted to take the time to say “Thank You” to the entire team that put on the IIUG portion of the conference. I’ve told my boss that I learned so much new information as a DBA that I have more action and idea items to implement once I get back into the office tomorrow! I hope IIUG will continue to be involved at future IDUG events as I will see benefits to the growing Informix user community. With anticipated growth with new Web Sphere sales mixed with the OLTP running on Linux as IBM is now marketing IDS, I envision that at Next year’s conference there may be a new set of basic Linux IDS DBA classes that could be taught by the more experienced DBAs. I hope more of us our using 9.4 and/or 10.0 by that time and we can share again real world experiences with these newer releases of the product (like configurable page sizes).

Thank you again to you and all of the board members and IBM staff that made this IIUG conference wonderful!

Danny Santee
City of Aurora
IT Dept – Sr. Database Administrator

Um, I mean comments on the IDUG-IIUG Conference…

Well, I want to be one of the first to submit so I can get a shirt to wear at work as I continue to evangelize IDS at work. This was a great conference, it was really good to hear Mark Scranton on his soapbox. After my presentation, Carlton Doe and I were interviewed by a reporter from ComputerWorld. Carlton also took him to meet with other users. The reporter said he felt that what he just heard of Informix was a cover story. (He wandered into my session by chance – his goal was to write about DB2.) Informix is IBM’s best kept secret, and hopefully a cover story will help get the word out.

I thank you and the Board for all your hard work in making this conference so outstanding.

Kevyn Schneider, CCP, CBIP Master
Business Intelligence Architect

I think the organization and execution were top notch. I didn’t experience any glitches. It was great for me to meet some of the Informix “legends” that I hadn’t met face to face before. Not all of the topics/sessions were top notch, but many were. I had hoped for more Informix attendees. I was honored to be included in the closed door discussion of Informix’s future.

I had not heard about IBM’s “new” stance on Informix: trying to get new ISVs. Great to see they switched from “don’t build new applications on Informix.” Was pleasantly surprised by Janet’s frequent references to Informix. The technology is moving forward very nicely.

Sean Durity
CornerCap Investments
Atlanta, GA

Presidents Note on the Conference and more…

The IDUG / IIUG Conference marks a historic event for the IIUG. In the past, the IIUG has been a grass roots, E-based community that excels in every way shape and form as a true user group. With the addition of a conference, this year in North America, the IIUG has now, with the help of IDUG, branched out to offering truly technical conferences — all for the benefit of the Informix users.

This event was truly successful, and many people are due thanks for this event. First of all David Beulke, Sandy Smith, Bernie O’Connor and the entire Board of Directors of IDUG. Janet Perna, Paul Rivot, Jon Prial, Bruce Weed, Carolyn Woods, Bob Shoeberg, Tami Cannizzaro, Mike Swift, Mohan Natraj, Alan Grady, Jerry Keesee and Tom Christian of IBM. The entire IDUG Conference Planning Committee of IDUG and Jocelyn Kins and the IDUG Headquarters Staff and of course all the Informix speakers and exhibitors.

It is also my pleasure to announce the recipients of this year’s IIUG Board of Directors Awards for excellence and dedication to the Informix community. Past winners include: Walt Hultgren, Lester Knutsen, Jonathan Lefler, Art Kagel, Carlton Doe, Mark Scranton and Christine Shannon. This year’s winners are: Fred Hubbard, former IIUG President and Jerry Keesee, Director of Informix Development for IBM. Congratulations to Fred and Jerry! You are now members of a very exclusive club!

The IIUG Board of Directors is also announcing that we will be continuing our partnership with IDUG in 2006. We are pleased to inform our members that the official IIUG Conference will be with IDUG in Tampa, Florida, May 7 – 11, 2006. We are already seeking presentations for next year’s conference. For more information, continue to watch /conf. The Call for Presentations will be open until Sept 2005.

At this time, we are also working with IDUG for a possible European conference in late 2006 which will be announced at a later time. If we do participate, the event will be in the Fall of 2006 in Athens, Greece.

In other news, the IIUG is proud to show off our new front page. IIUG Board member Kate Tomchik introduced the new face of IIUG at the IIUG Annual General Meeting. The new front page on http://www.iiug.org features:

  • An IIUG Calendar
  • Scrolling News Section
  • The ability to mark only truly new articles as NEW for each and every user
  • And a Much cleaner look
  • And finally as Kate would say: Its Pretty!

Comments and/or suggestions on the new face of IIUG, please send them to Kate at kate@iiug.org.

Finally I would like to express my gratitude to a few individuals who made this event in Denver such a success. They are the four individuals from the IIUG who made this whole event: Former IIUG Board members Lester Knutsen and Walt Hultgren, and current IIUG Board Members Gary Ben-Israel and Cindy Lichtenauer. This entire event from the IIUG side was overseen by Cindy, and without her leadership, tireless effort and guidance, this event would have never happened.

For those that attended the event, I truly believe they think this was the best Informix technical event they have ever attended. So mark your calendar, tell the boss you are going, and I’ll see you in Tampa, Florida May 7 – 11, 2006 for the IDUG / IIUG Conference.

Stuart Litel

IIUG Insider Logo contest

Send us a logo for the IIUG Insider and win an IIUG polo shirt!

The IIUG is announcing a contest for a new logo for the Insider. The winning entry will receive credit for their entry in the Insider and an IIUG Polo Shirt. Submit your entry in JPG format to gary@iiug.org.

Note: You must be an IIUG member to enter the contest. All entries become the property of the IIUG.

www.iiug.org – The new look!

Check out our User Group web page. It has a whole new look. In an effort to act on LOTS of constructive feedback I’ve gotten on how to improve the site, it was unveiled at the yearly IIUG standard meeting at the IDUG conference on May 25. It not only looks good, it also has many new features. Check it out, and you will find the following:

  • An events calendar that allows you to click on a day and see what events are scheduled. This includes International events as well as local user group meetings. The calendar pulls from the existing IIUG Events calendar. Hold the mouse arrow on a date and a title box will appear with the name and location of the events for that day.
  • An IIUG Insider scroll down button on the left side of the page to allow you to easily access the latest insider as well as earlier editions.
  • The IIUG Mission statement has been moved to the “About” button, so we don’t lose valuable real estate on our main page.
  • “Scenic” backgrounds display throughout the year. If you don’t like the background, just select the button to toggle it off at the bottom right of the screen.
  • Limited number of announcements on the front page. All older announcements will be accessible from the “View Previous Announcements” item at the bottom left.
  • “New” will really mean NEW! The red “new” text will appear for all announcement items the first time a user visits the site from a particular computer. If the user clicks on any of the announcement links, the “new” text will not appear the next time that the user visits the home page. The user could also click the “Mark all announcements as read” radio button, then all the “new” tags will be gone the next visit to the home page. Of course as new announcements are added, the “new” text will appear for those items.
  • The dates of each item will be greyed out after an article, so it can be seen how long it has been on the site.

If you have any suggestions, please email me at kate@iiug.org.

Kate Tomchik
IIUG Board of Directors

Announcing IBM Informix Dynamic Server (IDS) Express

On April 26 IBM announced Informix(®) Dynamic Server (IDS) Express — the latest addition to the IBM Express Middleware portfolio of products and services and the IBM Informix product family. Designed with midmarket businesses in mind, IDS Express combines a self-managing database engine that provides the power, function, and reliability needed for on demand business with simplicity in packaging, installation and deployment at a minimal investment cost.

Developed in conjunction with IBM Business Partners, IDS Express integrates easily and transparently with your solutions, while delivering unprecedented value and functionality when compared to competitive offerings.

Ideal for implementing solutions that require a robust database with little or no administration, IDS Express supports a broad range of integrated development environments (IDEs) such as Eclipse and Microsoft Visual Studio .NET. For complete details on IDS Express, visit the Informix Web site.

IBM InfoBahns

What is an InfoBahn?

An Infobahn is a one-day information forum where Informix customers and Business Partners can learn first-hand about IBM’s newest technology releases. This forum offers a complete agenda of sessions–led by IBM executives and regional managers–designed for both decision makers and technology professionals. Event dates and agendas vary by location. For more information, contact your local IBM office or your authorized IBM Business Partner.

IBM has a new major release to showcase–IBM(®) Informix(®) Dynamic Server Version 10.0. And there’s even more on the way. Come to the 2005 Informix Infobahn event near you. To discover the full list of events and dates please go to:


We will publish the updated list in the IIUG Insider calendar of events and on the IIUG web site:


Infobahns in New Zealand and Australia

Short, sharp and “bloody good value” is the best description of Mark Scranton’s Infobahns in Australia and New Zealand. Unfortunately the weather didn’t help by forcing a cancellation of the Wellington event. Impenetrable fog, in the “windy city”, is a bit odd and not at all in keeping with it being the political and bureaucratic center of the country. In contrast, Mark’s sessions were fantastic. While short, they covered all the high points of the new IDS ver 10 features. And the presentation was anything but boring. Mark is a great presenter and super advocate for Informix. Technically orientated, the sessions covered the new IDS features by comparing “that is how we used to do it” to “this is how you can do it now” and all this with worked examples, proofs and code.

A very clear message from the meetings is that IBM is putting its money into Informix, into IDS and into the market. Not only is Mark touring the world with the IDS message but so are others from his group. One great takeout is that there is a plan to have Mark back to Australia and New Zealand to take, over a course of a week, some in-depth, deep dive sessions, into IDS. This level of commitment from IBM indicates to me that they a serious about IDS becoming the embedded database of choice for organisations who want very, very, very reliable data management systems.

David Fraser
IIUG Board of Directors
New Zealand

Informix Chat with the Lab: IDS Replication

Data Replication has become an increasingly important factor in data management, both for high availability reasons as well as a means of data integration. Madison Pruethas worked with the IBM Informix Server for several years, focusing on replication solutions used by IDS. This talk will discuss the two main techniques for data replication used by IDS (HDR and ER), emphasizing setup issues, configuration issues , and operational considerations. Additional time will be spent discussing the 10.x features. Our speakers are:

  • Jerry Keesee, Director of the Informix lab
  • Madison Pruet, Senior Consulting Engineer, Information Integration R&D
Wednesday, June 8, 2005
11 a.m. Eastern
10 a.m. Central
9 a.m. Mountain
8 a.m. Pacific
For 90 minutes

Business Partners, Customers and IBMers RSVP for this conference call via the Web:


Charts for the call will be available June 7th and can be downloaded from:


Save the date: Our next Chat will be Wednesday, July 13, 2005 on Upgrading to v10.

Replays of previous Chats may be found at:


Your comments and suggestions for this series are always welcome at: lspina@us.ibm.com

Generating XML from IDS 9.x

Jacques Roy
Member of IBM’s worldwide sales support organization,
IBM 25 Feb 2003

XML is becoming more and more important to the enterprise. Frequently users need to create XML documents from the contents of a relational database. This can be done in many ways, but the extensibility features of IBM® Informix Dynamic Server® version 9.x (IDS 9.x) give you the opportunity to create your own functions to generate XML output from your database.

The full article explains a simple approach to generating XML that can answer many needs and provide a building block for more elaborate solutions. It can be found at:


Calendar of events

Date Event Location
1 Informix Infobann Munich, Germany
2 Informix Infobann Frankfurt, Germany
7 Washington (DC) Area Informix User Group Meeting IBM Fair Lakes Office, Fairfax, Virginia
8 New England Informix User Group Meeting with Mark Scranton IBM Facilities, Lexington Mass.
9 Greater Philadelphia Informix User Group Meeting with Mark Scranton IBM, Philadelphia, Pennsylvania
10 New York User Group Meeting with Mark Scarnton IBM, New York City
15 Chicago Informix User Group Meeting with Mark Scranton IBM, Chicago
16 Kansas City Informix User Group Meeting with Mark Scranton IBM Facility, Lenexa, Kansas
17 St. Louis Informix User Group Meeting with Mark Scranton Fleishman-Hillard, St. Louis, Missouri
23 Informix Infobann Zurich, Switzerland
24 Informix User Group of Colorado Meeting with Mark Scranton Denver Colorado
29 Utah Informix User Group Salt Lake City, Utah
Date Event Location
14 Southeastern Informix User Group Meeting with Mark Scranton Home Depot – Atlanta, Georgia
15 Central Florida Informix User Group Meeting with Mark Scranton IBM, Tampa

Developer corner

Please visit our site for new, refreshed content:


Feature article:

Use Hibernate with WebSphere Information Integrator
Explore using a persistence framework with enterprise integration technology to provide an integrated object-based view of disparate corporate data.
websphere information integrator

Other new content:

A recipe for a healthy federated database system
Meet the challenges of maintaining semantic consistency in the federated database environment with WebSphere Information Integrator’s autonomic health monitoring capabilities.
websphere information integrator

DB2 UDB and Informix Dynamic Server distributed transactions using JTA
Learn how to handle distributed transactions in Java with Java Transaction API when using DB2 UDB and Informix Dynamic Server.
informix dynamic server, db2 universal database

Business Intelligence solutions architecture
Build a data warehouse solution using IBM technology.
db2 business intelligence

Using Master Replicates with Enterprise Replication
Explore the advantages that IDS master replicates have over classic replicates and why ER customers should use them.
informix dynamic server

More Informix related content can be found at: http://www.ibm.com/developerworks/db2/zones/informix/

Exploit the power of Linux with IDS 10.0
IDS 10 provides transparent optimization and exploitation of Linux environments to achieve improved scalability and parallelism.

Find IDS Version 10.0 information fast
Gain insight into the improved information retrieval in IDS Version 10.0 documentation

Programming with Informix .NET extensions
This document explains when and how you should use these data types included in the IBM Informix .NET provider: IfxBlob, IfxClob, IfxMonthSpan, IfxTimeSpan, IfxDateTime, and IfxDecimal.

New backup and restore features in IBM Informix Dynamic Server, Version 10.0
The new capabilities in the IDS backup utility bring new levels of high availability and versatility. Our author brings you all the details.

New features in IBM Informix Dynamic Server, Version 10.0
Explore some of the key features of IBM Informix Dynamic Server, Version 10.0, and gain insight into the general business problems they are intended to solve.

A quick introduction to the Next Generation Installer for IBM Informix Products
The new installer for IBM Informix Products provides a uniform look and feel across various UNIX and Linux platforms. See how changes to the installer for IBM Informix Dynamic Server, Version 10.0–in terms of product size, setup requirements, and error reporting–provides an insight into the advantages of this installer compared to the previous installers.

Create Informix tables and indexes more efficiently
Learn the performance considerations for creating tables and indexes in IDS, including issues around dbspaces, lock modes, and extents.

Use Informix 4GL with WebSphere MQ
Extend your IBM Informix 4GL applications to seamlessly communicate with IBM WebSphere MQ messaging system

New Informix Dynamic Server trial
IBM Informix Dynamic Server (IDS) offers outstanding online transaction processing (OLTP) database performance, while helping to simplify and automate many of the tasks associated with deploying enterprise databases.

Informix IDS 10 annnouncement and resources
The latest release of Informix Dynamic Server (IDS) Version 10.0 is IBM’s flagship database for industrial-strength, embedded computing. IBM IDS V10.0 delivers outstanding performance, reliability, scalability and manageability for enterprises and workgroups.

Announcing Informix Dynamic Server (IDS) Express for small- and mid-size businesses
IBM Informix(®) Dynamic Server (IDS) Express – designed with midmarket businesses in mind – combines a self-managing database engine that provides the power, function, and reliability needed for on demand business with simplicity in packaging, installation and deployment at a minimal investment cost. Developed in conjunction with IBM Business Partners, IDS Express integrates easily and transparently with their solutions, while delivering unprecedented value and functionality when compared to competitive offerings.

Informix Infobahn: Worldwide Seminar Series on IDS V10.0
IBM has a new major release to showcase–IBM Informix(®) Dynamic Server Version 10.0. And there’s even more on the way. Informix Dynamic Server version 10.0 is not only a key component in IBM’s overall software portfolio, but also it is at the center of IBM’s bold maneuvers in the embeddable database market. Come see Informix Dynamic Server version 10.0 featured together with EGL and the overall Informix portfolio product roadmap, as the Informix Infobahn highlights the flexibility and versatility of this latest major release. Register today.

Informix for Linux
The freedom of Linux. The power of Informix(®). Bring them together, and you have a flexible, scalable database solution that lets you get more done, faster than ever before.

Flexible Savings program: The IBM Education Pack – online account
Here’s an ideal way to train multiple employees on a limited budget.

Useful Links

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: /quicklinks.html

Closing and Credits

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./td>
Editors: Gary Ben-Israel
Stuart Litel
Jean Georges Perrin
For comments, please send an email to enews@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.