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 #50)
01 August 2004

Other Issues

Highlights: Special 50th Issue, Cloudscape now Open Source, Informix Connection, Great Product News, new Developer Corner & More...

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. Hot News - Cloudscape goes Open Source!
  3. Hot News - DB2 Magazine Launches Informix Connection
  4. Hot News - Announcing ICON, the Informix Connection Program
  5. IIUG - Forum News
  6. Event - RedBrick User Group to Meet in Milan, Italy (Sept. 27 & 28)
  7. Event - Free Workshop on WebSphere and IDS (Waltham, MA, USA, Aug. 24th to 26th)
  8. Event - Querix workshop during Oktoberfest (Munich, Germany, Sept. 27)
  9. Product News - Querix Hydra 4.1 now Available
  10. Product News - Awoma Launches DB Studio Version 2.2.0
  11. Product News - XPS 8.5 Announced
  12. Product News - XPS 8.5 in Gold Bundle
  13. Service Offerings - Upgrading from SE and OnLine
  14. Tech Experience - Configuring Page Cleaning
  15. Developer Corner - Calling for EGL Volunteers
  16. Developer Corner - IIUG to Host First Ever e-forum on EGL
  17. Developer Corner - EGL FAQ cont'ed
  18. Useful Links
  19. Closing and Credits


What an issue!

This is our 50th issue of the Insider. Our first issue was back in 17 May 2002. The headlines were "IBM Informix SE 7.25 Now Available for Free Download", "IBM Informix Product Portfolio White Paper v.3 - Get It Now!" (I have heard of rumors regarding a V5...), "IBM Steals the Database Crown from Oracle"... Our history of electronic publication comes from May 2000... Could we say "billions" served? Certainly not, but subscription is going up, and that's wonderful.

When it comes to finding some content for the Insider, it can be tough, and sometimes, we need to "recycle" old news. This is certainly not the case of the August 2004 issue. We have nearly 20 subjects, ranging from new events to product news. We even have a full user experience using IDS 9.40; I really want to thank Andrew Watson for that. Finally, we have debuted a Developer Corner, which will focus on EGL (in this issue, more topics to come).

The Insider is evolving, covering more topics, a wider range of subjects and is still highly concentrated on the Informix world.

Please, do not hesitate to send us feedback:, we love hearing from you!

Jean Georges Perrin Editor

Hot News - Cloudscape goes Open Source!

Here it goes: "Aug. 3, 2004 -- IBM and the Apache Software Foundation (ASF) today announced that IBM is contributing more than half-million lines of relational database code to the ASF." And we all recall that "Informix paid $85m for the database in 1999".

Nothing is available, yet from the web site, but we guess everything will be posted in:

Stay tuned for more information or subscribe to the IIUG Cloudscape forum!

Technical information from IBM developerWorks:

More information:

Press release: IBM Contributes Database Software to the Apache Software Foundation Derby day as IBM database goes open source

Reuters: IBM contributing database program to open source

The Register: IBM gives code to Apache open sourcerers

Hot News - DB2 Magazine Launches Informix Connection

This month, more than 10,000 Informix customers will receive a special edition of DB2 Magazine containing Informix-specific articles. Called Informix Connection: The Big Leagues, the insert covers the head-turning new release of IDS 9.4 and features an article by consultant and author Joe Lumbley on how Informix technology is carving out its own niche in the IBM realm. A note from Janet Perna, General Manager of IBM Information Solutions, sheds light on Informix's future at IBM. A second edition of Informix Connection is planned for Quarter 4.

Register to read INFORMIX CONNECTION: THE BIG LEAGUES in a portable e-book format.


With a head-turning new release (backed by the full power of IBM's software portfolio), Informix technology blazes onto center field. In this special e-book, you'll find out:

  • Innovative ways businesses are using the new release of Informix Dynamic Server
  • How Informix technology is finding its niche in the IBM world
  • Which integrated tools can help even non-Java programmers develop Informix applications
  • What IBM's Janet Perna says about the future of Informix technology
  • Details on IBM's donation of Cloudscape code to the Apache Software Foundation

Hot News - Announcing ICON, the Informix Connection Program

IBM has started a new program, dedicated to the Informix community. Here is the letter they requested us to share.

Keeping you connected to IBM and to the latest Informix-related News

Dear IIUG Member:

IBM has just created the Informix Connection Program, or "ICON" for short, and you're invited to join! ICON is designed to keep you informed about the latest Informix news and to help you get the very most from your Informix investment.

ICON membership will connect you with personalized information based upon your specific product and technology interests. You'll be connected with:

  • The latest updates on IBM Informix products
  • Ongoing opportunities to provide feedback directly to the IBM Informix product team
  • Easy access to important white papers, articles, documentation and technical guides about the Informix products
  • Questions and Answers - you asked; we answered
  • Upcoming events of interest to IBM Informix product users
  • Featured member success stories

Enrolling in ICON will take just a few minutes - we'll verify your contact information and your product environment, share some Informix product news, and provide links to information that may be of use to you. All of this will help us to send follow-up communications tailored to your specific needs and interests.

Click here to enroll in ICON today!

Note: Please feel free to forward this link to others who might benefit from the ICON program.

IIUG - Forum News

IIUG is proud to announce that it is hosting the first electronic forum on WebSphere EGL. To join, simply go to the membership area, login, click on the on "Subscribe to E-Mail lists", choose the lists you wish to subscribe to and click "Subscribe".

New lists are: EGL Development Forum (
This forum is entirely dedicated to WebSphere EGL (Enterprise Generation Language) and development using WebSphere EGL.

Java Development Forum (
This forum is entirely dedicated to Java: development using Java and the Informix engines, Java in the server, UDR, etc.

As you now all know that Cloudscape is open source, do not hesitate to subscribe to the Cloudscape forum and send e-mails to Check out for a complete list of all the IIUG forums and SIGs.

Event - RedBrick User Group to Meet in Milan, Italy (Sept. 27 & 28)

This agenda has been compiled by Cindy Fung, RedBrick Development Manager and it takes into account IIUG feedback given at the last meeting. Here is what IBM has asked us to say:

Cindy will present much of the material and will be present during the entire meeting, so this is a good opportunity to meet her.

You will see that we have two slots for Customer Presentations. This is your opportunity to hear how other businesses use RedBrick, so I need some volunteers from you to explain your usage. As many as possible please, this is usually the best part of a User Group meeting!!!

In addition we were thinking of trying to answer your specific questions/problems during the meeting. If you have any subjects you would like to see answered during the meeting, please send them to me and I will ensure Cindy sees them and prepares an answer.

Look forward to receiving, as soon as possible, your mail to let me know you plan to attend.

Day 1

13:30Welcome & Introduction
13:50Update on IBM's Roadmap for Red Brick Development
Coffee and discussion break
15:30Customer Stories
16:30Optimizing RedBrick Performance and System Tuning
18:30Dinner, sponsored by IBM

Day 2

09:15Red Brick Loader Performance
10:30Customer Story
Coffee and discussion break
11:30Query Performance monitor
13:30Best Practices - SQL / OLAP
Best Practices - Vista (creating aggregate tables and query)
Coffee and discussion break
15:45User Requirements/Discussion/Q&A
16:30Close Meeting

For more information, contact: Gill Dawson, e-mail:

Event - Free Workshop on WebSphere and IDS (Waltham, MA, USA, Aug. 24th to 26th)

IBM Informix Business Partners: Enroll Now for a Free Training Workshop in Waltham, MA - Using WebSphere With Your IBM Database.

Are you designing and developing applications running in WebSphere Application Server and have Informix Dynamic Server or DB2 Universal Database on UNIX(r) or Windows(r) as your database engine? Do you want an introduction to all aspects of integrating WebSphere with Informix or DB2 Universal Database? If so, this 3-day workshop will provide you with the information you need.

There is no charge to attend this workshop; but time is running fast, so enroll now for Aug 24 - 26 at!

Event - Querix workshop during Oktoberfest (Munich, Germany, Sept. 27)

Querix is organizing a 4GL Training and Workshop, based on Hydra 4.1 and the upcoming V5 P-Code Release on September 27th, in Munich, Germany. A wonderful occasion to visit the city!

For more details on Querix' planning, visit:

Product News - Querix Hydra 4.1 now Available

Hydra 4.1 with support for 18 platforms & all Informix RDBMS (4.1-9.4) available for download on the 30th August

The new Release for Hydra 4.1 with support for 18 platforms and all Informix RDBMS systems (from 4.1 to the latest 9.4) is available for download from 30th August. IIUG members can download a free 2-user License including 3 months technical support.

Product News - Awoma Launches DB Studio Version 2.2.0

Led by a team of Informix experts, Awoma provides a suite of development and database manipulation tools perfectly suited for IBM-Informix users. Awoma tools will enable users to adopt current IBM technology, such as WebSphere, DB2 or J2EE, while leveraging existing assets.

Awoma tools include ThinStructure, DevWorkshop, SysTools and DB Studio.

DB Studio 2.2.0 has just been released. It is the ultimate database manipulation tool. Integrated smoothly into Awoma's graphical IDE (based on Eclipse), DB Studio provides the following:

Easy connection:

  • Connect to any database via a wizard menu, in less than 10 seconds.
  • All the drivers are included.
  • All major databases are supported (Informix OnLine 5, IDS 7.x, IDS 9.x, IBM DB2 and others).
  • Intuitive Graphical interface.

Main features:

  • Connect to as many databases as you want. Concurrently. Any supported type.
  • View structure of database elements, such as the database structure, tables, view, system tables, columns, indexes, primary and foreign keys, constraints...
  • Query your database through an easy and efficient SQL editor.
  • Create batches of SQL statements.
  • Add, delete or modify your data efficiently.
  • Export you SQL results to text, CSV, HTML, or even unload to Informix format.

DB Studio is available as a stand-alone product, or as plug-in of IBM WebSphere Studio, Awoma DevWorkshop 2.2.0, Awoma ThinStructure 2.2.0 and Eclipse 2.1.x.

For more information, visit

Product News - XPS 8.5 Announced

IBM Announces Informix XPS V8.5 - Demonstrating Continued Informix Commitment!

IBM announced the release of IBM Informix Extended Parallel Server (XPS), V8.5 on July 27, 2004. This new software release will be available for electronic delivery on August 10, 2004 and media and documentation will available from August 27, 2004.

XPS V8.50 is designed for the largest, most demanding, and most complex data warehouse applications. By including comprehensive data warehousing features and using a sophisticated shared-nothing underlying architecture, XPS achieves industry-leading performance and flexibility. This enables you to make more profitable decisions from complex, query-intensive, analytical applications.

The following major new functionality is included in XPS V8.50.

New application development features

  • ISTAR/Distributed Query Coordinator

New DBA features

  • Table-level Point in Time Restore
  • Scrubbed Tables
  • Immutable Session Variables
  • Current and Client Time zone
  • ONSTAT Query Start Time
  • Mixed Restore

New ease of use features

  • DBAccess History
  • Roles Improvements

New performance features

  • Improved Fragmentation Elimination on Datetime Columns
  • Improved Optimization for Groupby with Expressions Using Implicit PDQ
  • Indexes on Non-logging Tables
  • OR Predicates Performance Improvement
  • OnBAR Thread Safe Library Support
  • Read-only Dbspaces

Detailed feature and ordering information

Please contact your IBM Sales Representative to acquire the latest XPS V8.50. If you need further information regarding XPS V8.50 or IBM's Business Intelligence / Data warehousing Strategy, please contact:

XPS Development Manager - James Troisi at a href=""> XPS Product Manager - Omkar Nimbalkar at

Product News - XPS 8.5 in Gold Bundle

New IBM Informix Extended Parallel Server and updated IBM Data Management Business Intelligence Gold Bundle offer Informix customers greater value and flexibility

IBM Informix Extended Parallel Server (XPS) V8.50 is designed for the largest, most demanding, and most complex data warehouse applications. By including comprehensive data warehousing features and using a sophisticated shared-nothing underlying architecture, XPS achieves industry-leading performance and flexibility. This enables you to make more profitable decisions from complex, query-intensive, analytical applications.

Announcement Letter - EMEA

Announcement Letter - Canada

Announcement Letter - USA

Service Offerings - Upgrading from SE and OnLine

IBM Informix Standard Engine (SE) and OnLine Extended Edition Passport Advantage trade up part numbers to IBM Informix Dynamic Server Workgroup Edition V9.x (IDS WG) and IBM Informix C-ISAM for Linux on eServer zSeries now available.

Customers upgrading to IDS WG have the ability to leverage their investment through integrated, cost effective and competitively-based offerings with other IBM Software Group products, leverage 4GL skills in a modern application development environment by using EGL and IBM WebSphere Studio going forward, and more.

IBM also announced additional Linux on zSeries platform support for C-ISAM (5724-C41) in order to take advantage of using C-ISAM with applications running in that environment. No new part numbers are needed. C-ISAM for Linux on zSeries is included on the current C-ISAM CD.

Partner Campaigns are also available such as:

One Point Solutions, a U.S. Informix-specialized partner, offering service packages to supplement your company's efforts to migrate your database to IDS V9 from Informix SE, OnLine or IDS V7. Access:

EMEA co-marketing partner offers are also available, contact Nicole Pelletier, EMEA SWG Sales Manager, DM SMB Channel at for more information.

Access the following for the entire announcement letter:
Access the following for additional Informix Product information:

Tech Experience - Configuring Page Cleaning

Real-world experiences of IDS 9.40 - Configuring Page Cleaning, by Andrew Watson of Ardenta Limited, UK:

Page cleaning is the process of updating index keys following changes to the underlying data to which the index refers to ensure the index remains an efficient representation of the actual data. When a row is deleted to improve the user response time the index item has its delete flag set to act as a marker that it needs to be cleaned.

Prior to IDS 9.40 a single threaded process called the Btcleaner handled page cleaning. A number of issues with the method used by this process led to the development of the more flexible and configurable Btscanner as its replacement. This enables the administrator to dynamically set the Btscanner's priority, the number of threads and the way in which it identifies the pages to be cleaned.

Through testing and experience on client sites migrated to IDS 9.40 the default setting of one, low priority Btscanner thread does not always appear to be optimal. This has proved to have a significant impact on key resource intensive processes and maintenance tasks such as data purging. Therefore during and after critical periods the resources allocated to the Btscanner are adjusted.

More detail on the differences between the Btcleaner and Btscanner; examples of settings and administration commands to configure and monitor the Btscanner can be found at:

Developer Corner - Calling for EGL Volunteers

The EGL momentum is growing. IIUG is looking for volunteers to animate the new forums, the download section on EGL, the FAQ, a web site...

Are you interested in doing so? Do not hesitate to contact the e-news team at

Developer Corner - IIUG to Host First Ever e-forum on EGL

IIUG is proud to announce that it is hosting the first electronic forum on EGL. To join, simply go to the membership area, login, click on the on "Subscribe to E-Mail lists", choose the lists you wish to subscribe to and click "Subscribe".

EGL Development Forum (
This forum is entirely dedicated to EGL (Enterprise Generation Language) and development using EGL.

Once you are subscribed, send e-mails to

Developer Corner - EGL FAQ cont'ed

Q:How can EGL be used to produce a portlet?
A:When you create a portal project you can specify that you want to use EGL. Specifically, when you create a portlet project you need to just add EGL support on the "Add Features" panel of the new project Wizard.

Answers are coming from IBM. IIUG should not be liable for inaccuracy.

You have an EGL question? Send a mail to, subject EGL.

Useful Links

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

Please visit the IBM Redbooks web site at for more details and up-to-the-minute technical information.

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 18,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
Ardenta Limited
IBM Corp.
The Register
Editors: Jean Georges Perrin
Fred Hubbard
Stuart Litel
Ron Flannery
Sam Gentsch
For comments, please send an email to