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 #67)
January 2006

Other Issues

Highlights: IDS 10 - IBM's flagship database for pure OLTP and Industrial-strength, embedded computing

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. IDS 10 - IBM's flagship database for pure OLTP and Industrial-strength, embedded computing
  3. IIUG/IDUG European conference survey
  4. IIUG 2005 Survey
  5. Conference corner
  6. Information on Demand Live! Informix Acceleration Webcast for Business Partners
  7. Chat with the Lab
  8. Translated versions of IDS v10.0 Manuals
  9. ATTENTION Informix PeopleSoft user
  10. MySQL, once more...
  11. Sun Warms Up To IBM Open-Source Database
  12. Date processing in Informix Dynamic Server
  13. Migrate Now! - IBM Migration Toolkit
  14. Promoting Customer References Simplified for IBM Business Partners
  15. Calendar of Events
  16. Useful links
  17. Closing and credits


This is the first Insider for 2006 and the first Insider of the new Board of Directors. For me this is my 12th issue -- actually the 11th, as JGP was in charge of the October issue.

Our first board meeting will be held in February. We will continue to provide our traditional services: The IIUG Insider, The IIUG Web page, The IIUG SIGs (Special Interest Groups), The IIUG/IDUG conference and support for our local user groups. The February issue will include a report from our board meeting.

We need your feedback, your participation and your help. If you have requests or suggestions please let us know. If there is any content you would like to read in the Insider please let me know.

The December Insider was the first sent from the IIUG's new SUN Server. The new server is a great improvement in hardware but some of the software has implementation problems. Some of you received a corrupted issue of the Insider. It depends on your email program. We are working hard to fix all problems. If you receive a corrupted issue please let me know what the problem was and which email program you are using. You can always read the Web version in our home page.

I wish you all a wonderful year.

Gary Ben-Israel
IIUG Insider Editor
IIUG Board of Directors

IDS 10 - IBM's flagship database for pure OLTP and Industrial-strength, embedded computing

We have been hearing it from IBM management in conferences and Informix Infobahns. Now you can read it in the IBM Web site:

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

IDS V10.0 offers the lowest total cost of ownership - providing high performance with low overhead while delivering a robust database platform for on demand businesses. IDS now supports rolling application upgrades when built using our industry-leading Enterprise Replication technology.

With a full-featured relational database management system (RDBMS) platform, IDS offers extensive capabilities to meet unique business requirements with the speed of native database functions.

IIUG/IDUG European conference survey

This is a one question Survey.

Would you attend the IIUG/IDUG conference in Rome October 9 - 13 2006?

Click the link next to your answer:

Your input will help us make the right decision. Please spare a moment of your time give it to us.

IIUG 2005 Survey


The 2005 member survey was conducted during October and November 2005. The survey was web-based. While a fully open survey, publication of its existence was only advertised to IIUG members. At close 1070 responses were received.

Purpose of the survey

The purpose of the survey is to provide a comprehensive understanding of Informix users intentions with Informix and their relationship with IBM.

A web-based data collection method was chosen so as to:

  • Make it possible for all IIUG members to participate
  • Reduce the cost of implementing the survey


The survey was designed during mid 2005. Testing was completed in September and it went live in October. The survey was closed on the last day of November 2005.

IIUG members were notified about the survey's existence in the IIUG publication "Insider". Members were also reminded in a series of email blasts leading up to the close of the survey.

No attempt was made to validate that the respondent was an IIUG member.

The responses can not be considered as a random sample as no sampling method was implemented.


There were 1070 responses to the survey of which 93% of responses came from IIUG members. 5% of responses were from people who are not members of IIUG and 2% did not know their membership status.


Following are some of the survey results. The full report can be found on the IIUG Web page.

Your Physical LocationTotal
North America44%
Europe, Middle East and Africa (EMEA)38%
Mexico/Central America/South America7%
Total number of employees in your companyTotal
5000 or more24%
Not Applicable1%
Your primary role in the company isTotal
Executive with other IT related roles3%
General Information Systems roles9%
Information Systems Management13%
IS management with other IS roles6.5%
Programmer and or DBA51.5%
Programmer / DBA with other roles5%
Sales and Marketing1.5%
What is your company's relationship with IBMTotal
End user64%
Business Partner15%
Both Business Partner and End User11%
Not Applicable5%
What do your company's decision-makers believe IBM will do with the Informix Dynamic Server product lineTotal
Support it and enhance indefinitely as publicly stated by IBM36%
Support it for 5 or less years24%
Support it for 2 or less years10%
I don't know26%
Not Applicable5%
What is your company's primary Informix database productTotal
IDS 9/1064%
IDS 723%
I don't know2%
OnLine 51%
Not Applicable4%
How satisfied is your company with the product announcements, marketing and additional attention given to IDS in the last 12 monthsTotal
Not very16%
Not aware of any activity17%
Not Applicable12%
How aware is your company of the following IBM Informix programs announced in the last 12 months:
IDS 10.0 product announcementTotal
Not at all18%
Not Applicable10%
InfoBahn roadshow eventsTotal
Not at all37%
Not Applicable16%

Conference corner

IDUG 2006 - North America
May 7-11, 2006
Tampa, Florida, USA

Go Further...with Informix at IDUG 2006

This will be year 2 of the IIUG participation in the IDUG conference. IDUG is the DB2 user group that has put on DB2 user conferences for many years. IDUG has partnered with IIUG to include an Informix user conference agenda managed by the conference planning committee (CPC). The CPC is comprised of volunteers who have been working hard determining the Informix presentations and speakers that will be the IIUG/Informix part. We have added a fourth track (last year in Denver there were 3 tracks) to the conference agenda to accommodate the over 50 technical sessions spread over 4 days.

Additionally, there are 6 half day tutorials scheduled for May 7. These sessions (a.k.a. Educational Seminars or Ed Sems) are like mini training classes and cover a wide variety of Informix topics. There is an additional cost to attend the Ed Sems, but consider it money well spent for training.

The conference is all of this and so much more - special interest groups, networking opportunities, vendor presentations and exhibits, expert panel discussions and keynote presentations by IBM executives.

Start making your plans now to attend - May is only a few months away! For all of the conference details, visit and follow the link to the IDUG conference web pages. Be sure to check out the conference agenda, including an interactive schedule viewer and personal itinerary planner, to see the list of topics and presenters already lined up. The registration is live and the negotiated rates for the conference hotels are available on a first come, first served basis so don't wait too long!

We are looking forward to seeing you there.

Registration is now open. Register online or download a print-friendly version of the registration form.

Once you register for IDUG 2006 - North America, volunteer to moderate a session through the Personal Itinerary Builder.

Attention Vendors. Booth space is now being sold. Last years conference had the most Informix vendors of any conference event in years. For only about $3500 you get a 10' X 10' booth space to meet with the most Informix users in years at a major conference. For more information, contact and she can direct you to Exhibit Hall. The IUGLC is back by popular demand!!

The Informix User Group Leadership Council has not met for a couple of years due to lack of interest. However, we are going to revive it and have a IUGLC Meeting at the IDUG/IIUG NA Conference in Tampa, in May. More details to come in the next Insider. The IUGLC is a group of Local User Group leaders from around the world. So if you are a Local User Group Leader or interested in being one or interested in starting a Local user Group, please contact Cindy.

If you have any questions or suggestions, please email Cindy Lichtenauer at

Conference Links:

Online Registration:

Printable Registration form:

2006 Schedule of Presentations:

Information on Demand Live! Informix Acceleration Webcast for Business Partners

Our customers continue to demand solutions that optimize their information technology investments by taking advantage of existing infrastructure and in-house skills to boost productivity and reduce costs.

Join us on Tuesday morning, February 7, 2006 to learn how you can take advantage of the latest marketing and sales offers designed to help the IBM Informix Business Partner community succeed in delivering this requirement to customers. Sign up today and discover how you can drive additional revenue and lower cost with Informix and IBM in 2006.

This webcast will cover:

  • Business value and up-sell opportunities with Informix Dynamic Server (IDS) V10.0
  • Key cross-selling opportunities within IBM Software Group
  • PartnerWorld Industry Networks end-to-end marketing offer
  • New Informix Loyalty sales plays
  • Informix OEM contract terms & conditions

Featured speakers:

  • Ambuj Goyal, General Manager, Information Management Software
  • Bruce Weed, Informix Program Director
  • Michael Cohn, Informix Marketing Manager
  • Brett Hansen, Program Director, ISV & Developer Relations
  • Manuel Corniel, OEM Channel Sales Leader
  • Syed Kamal, President & CEO, Gillani

Date and time:

  • Tuesday, February 7, 2006
  • 11:00 am to 12:00 pm (ET)

Register Today!

If you're unable to attend the live broadcast but are interested in the content, take a moment to register and we'll send you the link to the replay as soon as it's available.

This online event is open to IBM Informix Business Partners only. If you are not a member of IBM PartnerWorld but wish to attend the webcast, please email Michael Cohn at

Chat with the Lab

Our February Chat with the Lab will be Wednesday, February 8th at 11 AM Eastern Standard Time.

The IDS Spatial DataBlade will be covered by Robert Uleman

The Informix Spatial DataBlade brings all the significant features and benefits of IDS to location-based data. Many key business decisions involve location and proximity. The Spatial Datablade enables organizations to transform both traditional and location-based data into important information to help gain a competitive advantage. We will also cover the Geodetic DataBlade which enables customers to manage geospatial information referenced by latitude-longitude components.

Please RSVP to:

Translated versions of IDS v10.0 Manuals

The IDS v10.0 Information Center now contains translated versions of many manuals.

Translated languages include Simplified Chinese, Traditional Chinese, Czech, French, German, Japanese, Korean, Polish, Russian, Slovakian and Spanish.

To view the list of translated publications, and for instructions on configuring your browser for non-English languages, go to:

...or view the "Translated Documentation" topic under the first topic entitled "Informix Dynamic Server v10.0."

ATTENTION Informix PeopleSoft user

This is just a follow up to let the Peoplesoft/Informix community in on why I'm searching for current customers. I have recently requested certification for Tools 8.47 with IDS 10 FC3 through Oracle.

The response was that there were no plans to certify PeopleSoft 8.47 with IDS 10 but may certify 8.49. 8.49 is not available and probably will not GA for another year. This does us no good since in the newer version of the application there are many tables that will exceed a 2k page row size. I had hopes of utilizing the new configurable page size in 10 to keep my disk usage from blowing through the roof.

So this is a request to all PeopleSoft/Informix customers that would like to keep running on Informix that has upgrade plans to please let me know. Of course if your intentions are to upgrade. Please, take a few moments and submit a certification request with Oracle for IDS 10. With numbers there could be a chance.

Remember there is power in numbers, so please contact me. The IIUG has setup a special e-mail address where I can be reached at

If we get enough respondents we will also setup a special e-mail list courtesy of the IIUG for all to take part in and be informed.

Please contact me and I will coordinate our efforts.


Darren Jacobs
Carmax Inc

MySQL, once more...

I did get some feedback from my previous article on MySQL in the November Insider ( and I must admit some clarification may be required. There were mainly 2 sets of questions.

Do you think MySQL tools are better than ServerStudio?

No! ServerStudio is superior to most of the database tools I have seen so far. My statement was that "both (MySQL) tools are far beyond what one can find in excellent AGS ServerStudio"; please understand that beyond should really be behind, at the back, in the rear... I used "beyond" in a sarcastic way. ServerStudio ( has incredible features which provide excellent benefits to the user, the user being either a developer or a DBA. The new features of 6.0 include a graphical navigation in the database, à la hypertext, which is really great.

I do not want to hurt anyone (anymore?); I use ServerStudio as a developer, not as a DBA. DBAs may also want to give a try to IIUG sponsor CobraSonic's tools (

Why do you use MySQL?

I use MySQL with coordination of a CMS package called Joomla ( Joomla is a fantastic piece of Open Source software, which unfortunately runs only on MySQL. However, now that a PHP driver for IDS is getting really close to shipment (, I am calling for volunteers to update the PHP database code for Joomla to support IDS. Bringing Joomla to IDS will create a very neat way of combining two very powerful products. If you are interested, send me an e-mail at (IBMers having spare time are also welcome and we will protect their anonymity).

Have a great and fantastic 2006!

Jean Georges Perrin

Sun Warms Up To IBM Open-Source Database

Sun goes looking for an open-source database to use with JES -- and finds itself on Big Blue's doorstep.

By Charles Babcock
Courtesy of InformationWeek

Sun Microsystems has always been dismissive of IBM's open-source initiatives. But finding itself in need of a database to add to its Java Enterprise System software lineup, Sun has swallowed its pride and said it will adopt an open-source database with IBM roots.

Sun last week said it will offer Derby, a lightweight Java relational database, to Java developers to embed in applications so they can capture data and keep it readily accessible without relying on an outside database. Key parts of the Java Enterprise System, such as Directory Server and Identity Manager, would benefit from an embedded database. Sun will get Derby from the Apache Software Foundation, but it's based on the Cloudscape database, which IBM donated to the foundation for open-source use. IBM acquired Cloudscape in 2001 when it bought Informix Software.

Sun's move isn't as surprising as it appears. The company has supported Derby's development alongside IBM as an Apache open-source project, and it counts 30 contributors to Derby from within its developer ranks. Derby "is a great fit for Java developers," says John Loiacono, Sun's senior VP for software. Sun is making all elements of the Java Enterprise System available as open-source software.

Derby history

Cloudscape Inc, an Oakland, California start-up, was founded in 1996 to develop Java database technology. The first release of the database engine, then called JBMS, was in 1997. Subsequently the product was renamed Cloudscape and releases were made about every six months. In 1999 Informix Software, Inc., acquired Cloudscape, Inc. In 2001 IBM acquired the database assets of Informix Software, including Cloudscape. The database engine was re-branded to IBM Cloudscape and releases continued, mainly focussing on embedded use with IBM's Java products and middleware. In August 2004 IBM contributed the code to the Apache Software Foundation as Derby, an incubator project sponsored by the Apache DB project. In July 2005 Derby graduated from the Incubator into the Apache DB project.

Date processing in Informix Dynamic Server

13 Oct 2005 Updated 22 Dec 2005

IBM® Informix® Dynamic Server has several functions that manipulate date and datetime types. You can exploit these functions to provide better processing and analysis of your business data. You can also add new functions that will simplify the solution of some date-based business problems. This updated version reflects some date processing related to the ISO 8601 standard. The standard-compliant functions were originally written by Jonathan Leffler as stored procedures. Their conversion to functions was a trivial task.


A date is a complex piece of information. It represents a specific day of the year. You can group dates together by day of the week, month, quarter, and so on. The grouping allows you to compare results for specific periods from year to year. Informix Dynamic Server (IDS) provides some facilities to process dates. This article reviews the current functions and provides additional functions that can be useful.

Jacques Roy (, Technical Lead, IBM

For the full article go to:

Migrate Now! - IBM Migration Toolkit

Migrate Now! - IBM Migration Toolkit

You need to be able to access all of your information wherever it resides. IBM Information Management Software protects your current database investment and delivers information on demand to ensure your information is integrated, comprehensive, uniform, analyzable and accessible all the time across all platforms. See how you can migrate your data from Oracle versions 8i, 9i, & 10g or Sybase SQL Anywhere version 9 using the IBM Migration Toolkit MTK 1.4

For the full article go to:

Promoting Customer References Simplified for IBM Business Partners

Customer references are crucial tools in all aspects of the sales cycle. They can help create product awareness, generate sales leads, close business and enhance customer loyalty. IBM has drastically simplified the process for IBM Business Partners to feature and promote their businesses through customer references.

In January 2006, IBM debuted the first phase of the new IBM Business Partner Client Reference submission form for IBM PartnerWorld members. This singular form will be used by all IBM Business Partners to submit references into the IBM Worldwide customer reference database (CRDB). It replaces forms previously used by SWG, Global PartnerWorld, PartnerWorld Industry Networks, IGS and Systems and Technology Group.

The newly designed form is significantly easier to use. No more retyping Business Partner contact information. No more offline questionnaires to complete. Convenient pop up windows to define IBM terminology. Ability to save drafts and resume later. This process was made available by IBM Developer Relations and Global PartnerWorld.

When you are ready to begin uploading your end user success stories via the new form, log in to:

...using your IBM PartnerWorld ID and passcode. Complete the new customer reference form on the Global PartnerWorld site. An e-mail is generated and sent to your IBM channel sales representative or another designated IBMer as a recipient. An IBM contact then will copy and paste the client reference information into the WW CRDB. A third party vendor, Leopard Communications, may contact submitters to gather additional details before promoting BP references to the WW CRDB.

Calendar of events

February - 2006
8 Ontario Informix User Group Meeting
Markham, Ontario
9 Seattle Informix User Group Meeting
IBM, Seattle Washington
March - 2006
2 Chicago Informix User Group Meeting
IBM Facility, Schaumburg IL
April - 2006
5 Washington (DC) Area Informix User Group Meeting
IBM Facility, Fairfax VA
May - 2006
7-11 IDUG/IIUG North America Conference
Tampa, Florida

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:

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.
Editors:  Gary Ben Israel
Stuart Litel
Jean Georges Perrin

For comments, please send an email to