Informix News
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 #15)
29 November 2002

Other Issues

Highlights: 20% Discount for the Americas, Stuart Profiled, Webcast News and More...

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


  1. A Note from the Editor - David Smith, IIUG Board of Directors
  2. 20% Discount on IBM Data Management Tool Licenses for the Americas
  3. Profiling Stuart Litel, IIUG Board Member
  4. Informix Database Driver for Perl Version 1.04.PC1 Released
  5. Informix Local User Group News
  6. Informix Partners Get Help Through IIUG
  7. Informix & MS-SQLServer: A Performance Tuning Exercise
  8. Upcoming Webcast Events
  9. IIUG Webcast Replays: Good Only Through 11 Dec. 2002
  10. Useful Links
  11. Closing and Credits

A Note from the Editor - David Smith, IIUG Board of Directors

The Insider is a little early this week to allow some of our ENews team to enjoy the traditional USA holiday, Thanksgiving. This is a time set aside originally by proclamation of the first US President George Washington to commemorate a special meal of thanks held after a very difficult first year of settlement in what was then a colony of Great Britain. Only about half of the original Pilgrim colony had survived the first year. They were joined by their Native American "hosts" and one of the menu items, wild turkey, has led to turkey becoming one of the traditional fares for the annual feast.

The wild turkey was originally proposed by Benjamin Franklin as the new nation's national bird. The Bald Eagle was ultimately selected, however, if Benjamin Franklin had prevailed, we would be carving the States' national bird each Thanksgiving.

So, even though this holiday is purely a tradition in the USA, the theme of appreciation and thanks for survival can be appreciated by anyone, anywhere. We can also be thankful "Informix" survives and sup with our IBM hosts as we share hopefulness for a brighter future.

As an international users group, we can be thankful for international friendships and helpfulness that know no national borders or barriers in this virtual community. The "Thanksgiving" holiday may be purely a USA tradition, but the spirit of thankfulness for whatever is right with the World can be enjoyed everywhere.

20% Discount on IBM Data Management Tool Licenses for the Americas

IBM Data Management informed IIUG that it has launched a discount program for tool licenses, good through May 19, 2003, in all countries located in the Americas.

IBM's complete announcement can be found at


  • "For a limited time only, if you acquire a qualifying Informix Passport Advantage new or renewal software license, you can receive a 20% discount off the Passport Advantage Suggested Volume Prices (SVP) for eligible IBM Office Connect and DB2(r) Data Management tools."

Profiling Stuart Litel, IIUG Board Member

Who in the world is Stuart Litel? This URL shows you who Stuart is not: However, this URL shows him with IIUG Board members in attendance at WAIUG.s Forum 2002.

Stuart is the fourth IIUG Board member to be profiled by ENews. True to Stuart's style, his profile is wordy and folksy, so we have not been able to include it in its entirety. However, here is a set of excerpts and a link to the rest of the story:

Q: How do you use Informix in your "real" job (DBA, Consultant, Developer, etc.)?
A: I am a freelance Informix consultant specializing in applications (4GL, 4Js) and DBA work (5.X, 7.X and 9.x) for about the last 12 years.
Q: How long have you been using Informix products?
A: TOOOOO LONG.... for almost 19 years I have been using Informix products, including doing the beta test on the Informix products that included the very first versions of the SQL products, 4GL, RDS, Interactive Debugger, and the original version of OnLine which was then called Turbo. I have been using their products almost every work day for the last 19 years.
Q: What is your role on the IIUG Board?
A: I am responsible for the IIUG Server and have been overseeing the server, including developing the Member Area and getting much of the content for it. I think there needs to be some "genuine Informix" material available to members only.
Q: Why did you volunteer to be on the board?
A: I actually enjoy it. The biggest reason is to meet and work with Informix users around the world. In fact, I possibly communicate with more Informix users on a regular basis than anyone else given my responsibilities running the IIUG Server and as webmaster of The part I actually enjoy is meeting the people personally, so if I travel I try to meet the people I might know in the area I'll visit. Over the past years I have met thousands of Informix users and communicate with many of them still today. Just a few weeks ago, at Forum 2002, I ran into an Informix user I had not seen in about six years. Great talking about old times!

The complete profile may be found at:

Informix Database Driver for Perl Version 1.04.PC1 Released

This is another contribution from an esteemed IIUG Directors Award winner: the very famous Jonathan Leffler. His original posting was made in CDI, but we've taken the liberty to do a little copying and pasting:

IBM Informix Database Driver for Perl (also known as DBD::Informix) is the driver code that enables Perl 5.005 or later to access Informix databases via the DBI module. You will need the code for DBI version 1.14 or later as well. You should upgrade to - at least - version Perl 5.8.0. The code is available for download via:

  • When you successfully build Informix Database Driver for Perl, use the ItWorks (Perl) script to report your configuration to the maintenance team at either (yes, this is a change from the 1.00.PC2 release), and copy Jonathan Leffler. Note that ItWorks does not send email to anybody; you have to do that yourself.

New in release 1.04:

  • This release is supported by Jonathan Leffler. It isn't clear what IBM's official stance on the product is. However, they do support DBD::DB2 so there is likely to be minimal objection to this work.
  • This release provides support for INSERT cursors.
  • This release provides support for UPDATE of blobs (BYTE and TEXT).
  • This release provides semi-tested support for BEGIN WORK WITHOUT REPLICATION.
  • This release works with ClientSDK 2.80; the prior versions of DBD::Informix do not because the version string changed radically.
  • Has better support for non-standard Perl installations.
  • You can tell DBD::Informix to avoid testing smart blobs if you have IDS 9.x but no smart blob spaces. You can also say which smart blob space to use if you don't want to use 'sbspace'.
  • Fix up file locations so it works better with CPAN.

Release 1.03:

  • Functionally the same as 1.04, but with the wrong Announce file. It's amazing how you never spot these problems until too late.

As always, see the ChangeLog file for details about what has changed.

Jonathan Leffler (,

Thanks, Jonathan!

Informix Local User Group News

The last quarter of 2002 is full of Informix-themed events. With the InfoBahn road show in full swing and a bevy of local user group meetings, the Informix community will have ample opportunities to meet, learn and network.

Important highlights of the last month include user group meetings in Northern California, Southern California, Washington DC, Central Florida, and Germany. Typical of local user group topics of interest, the Northern Cal group's agenda included Mark Scranton's IDS Performance Tuning Foundations, case studies from our local members and an overview of what's new in IDS 9.4.

Most importantly, though, were the foundational meetings for future user groups in Seattle, Washington, and Toronto, Canada. Interest in both cities was very strong. We expect to see new user group meetings there soon!

For December, local user group meetings are scheduled at:

Dec. 4:Boston, Massachusetts -
Dec. 5:Philadelphia, Pennsylvania -
Dec. 6:New York City, New York -
Dec. 10:Chicago, Illinois -
Dec. 11:Brüttisellen, Switzerland -
Dec. 18:Phoenix, Arizona -

2003 will be upon us too soon. IIUG would like to encourage all local user groups to begin planning their first meeting of the year and let us know those dates to make sure you are in our calendar.

Informix Partners Get Help Through IIUG

IIUG's efforts to provide Informix partners a place to exchange valuable business and technical information continue. The Partners special interest discussion list now exceeds 100 members; IBM's representative to the list has begun sharing information and requesting suggestions. If you are an IBM Informix partner and want to participate, please visit the IIUG Member Area at, then click "Subscriptions" and select the appropriate SIG list.

Additionally, a new and open e-mail alias has been created to support Informix partners: The objectives of this new tool are:

  1. To supplement IBM's PartnerWorld Partnerline [] as a secondary resource for IBM Informix partners.
  2. To answer channel related topics when the legacy Informix partner doesn't know where else to go.
  3. To add IIUG into the IBM Informix partner resource mix.

Informix & MS-SQLServer: A Performance Tuning Exercise

IIUG member Rudy Fernandez recently published a very interesting note at, sharing a series of tests he ran to "get a feel of how well SQLServer/W2K used resources of a machine when compared to Informix/Linux" using the same hardware.

Good job, Rudy! And thanks so much for allowing us to refer your story.

Upcoming Webcast Events

Please take note of the following upcoming webcasts which IIUG considers of interest to the Informix community:

IIUG Webcast Replays: Good Only Through 11 Dec. 2002

Please note that IIUG's webcast replay facility will no longer be available after 11 December. We encourage you to visit our Webcast Corner at to review past events. Among them:

  • Getting the Best Performance from the IBM Informix API Products
  • Informix Future Visions: A Follow-up on the Informix User Conference and Latest Product Information
  • Using IBM Office Connect with the Informix Dynamic Server (IDS)
  • IBM Informix 4GL Modernization Interactive Webcast
  • The Websphere App Server and Informix Dynamic Servers
  • Best Practices for Informix Database Performance: A Field Study

Useful Links *** Newly Update by Popular Demand ***

IBM Informix Homepage:
IIUG Software Repository:
Informix Answers Online:
Informix Product Family News:
Informix Today - Subscription & Archive:
IBM Informix Support Site:
Informix Developer Zone:
Data Management Certification Program:
Informix Page Within IBM PartnerWorld for Developers:
Recent Data Management Product Announcements:
Upcoming IBM Conferences Worldwide:
Bad Press on Nasty Informix Competitors:

Closing and Credits

The International Informix Users Group (IIUG) is an organization designed to enhance communications between IBM and its worldwide user community. IIUG now exceeds 16,000 members 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
Editors:David Smith, IIUG Board of Directors
Jean Georges Perrin, IIUG Board of Directors
Fred Hubbard, IIUG Managing Director, and
Paul Etcheverry, IIUG Editor
For comments, please send an email to