IIUG Insider (Issue #145) July 2012

Highlights: Modifications to the Innovator-C Edition of Informix

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



Editorial Back to top

The world is focused on the 2012 Olympics in London. Unfortunately there is no competition for databases. If there was, Informix would gain more gold medals then the USA and China combined. Nevertheless, for all sport fans from all over the globe I wish well to you all.


Gary Ben-Israel
IIUG Insider Editor

Highlights Back to top

Modifications to the Innovator-C Edition of Informix

IBM has made modifications to the Innovator-C Edition of Informix. Many of the previous limits were too broad and were not sustainable for our business partners. Innovator-C continues to be a robust database requiring little or no administration for small-to-midsized applications, available at no-charge.

The revised 11.70 Innovator-C Edition includes the following capabilities and limits:

  • Limited to 1 core/1 CPU VP and 2GB of memory.
  • Unlimited data storage.
  • Includes some autonomic features that minimize system failures and improve performance
  • Offers automated backup and restore functions while eliminating many manual tasks
  • Allows a customized deployment footprint, and application control of the server via the administration API, making it even easier to develop integrated applications
  • Delivers easier use of location-based data in an SOA environment with the Web Feature Services API
  • Integrates through a full range of APIs, including Java and Microsoft .NET and supports a broad range of integrated development environments (IDEs), such as Eclipse, IBM Rational Application Developer and Visual Studio .NET
  • Operating systems supported: Linux, Windows, and MAC

To view more about the features and benefits of Innovator-C, review the following link:


Jerry Keesee
World Wide Director, Informix Software
IBM Data Management

Conference corner Back to top

Information on Demand 2012 updates

Information On Demand 2012 Sample agenda builder

Have you created your sample agenda using the Information on Demand 2012 sample agenda builder? This new IOD 2012 smart site enables you to start building your agenda. Once you build your agenda you will be able to download your sample agenda. This agenda builder is only for evaluation purposes. You must be registered for the conference to actually schedule and enroll in sessions. You may save or email a sample agenda as a pdf file.

Get more details here:


Save Big at Information On Demand 2012

Save $300 on your registration fee and save big on your hotel accommodation when you register by August 31. And another good news for our IIUG members : You can save $100 on your registration fees at IOD 2012 by registering using the following promotional codes:

  • If you are a customer please use the promotional code: D12CUG
  • If you are a business partner please use the promotional code: D12BPUG


Developer corner Back to top

New in DeveloperWorks

Evaluate: Informix 11.7
Download a trial version of Informix Ultimate Edition 11.7 or download one of the free editions: Informix Developer Edition 11.7 (for development use only) or Informix Innovator-C Edition 11.7 (for small production workloads.)
Also available in:
Portuguese: http://www.ibm.com/developerworks/br/downloads/im/informix/index.html

12 Jul 2012

Compare the Informix Version 11 editions
Get an introduction to the various editions of IBM Informix, and compare features, benefits, and licensing considerations in a side-by-side table. Regardless of which edition you choose, Informix brings you legendary ease-of-use, reliability, stability, and access to extensibility features.
Also available in:
Chinese: http://www.ibm.com/developerworks/cn/data/library/techarticles/dm-0801doe/index.html
Chinese: http://www.ibm.com/developerworks/cn/data/library/techarticle/dm-0801doe/index.html
Russian: http://www.ibm.com/developerworks/ru/library/dm-0801doe/index.html
Portuguese: http://www.ibm.com/developerworks/br/data/library/techarticle/dm-0801doe/index.html

5 Jul 2012

Oracle to IBM Informix porting guide
This article describes the differences between Oracle and Informix functionality and syntax. In addition to DDL, DML and overall SQL syntax, you’ll explore the differences between Oracle and Informix with regards to the use of large objects, user-defined types, user-defined routines, and table partitioning.

1 Jul 2012

Save this link to find about Informix on DeveloperWorks: /url/devworks.html

Sponsor corner Back to top

Advanced DataTools Informix Remote DBA/Support Offering

Remote Technical and DBA support from Advanced DataTools helps small, medium and enterprise installations maximize their IBM Informix database performance and uptime while minimizing costs and overhead. We can help resolve and/or prevent the worst technical problems you could imagine!

Advanced DataTools’ staff of highly experienced, certified IBM Informix consultants are well trained in all levels of database performance and optimization. This allows us to offer our customers IBM maintenance and support contracts on most versions of Informix Dynamic Server, on any platform/operating system.

Top experts in the field, Art Kagel and Lester Knutsen, manage and support our team of certified IBM Informix consultants. Art and Lester each have over 28 years of Informix DBA experience and both have received the IIUG Directors Award, and the Inaugural Data Champion award by IBM.

For more information: http://www.advancedatatools.com/Solutions/Support.html

Advanced Data Tools Training

September 10-13 2012 – Informix for Database Administrators
This course is for database administrators, programmers, and technical support personnel who will be setting up, managing, and tuning IBM Informix 11, 10 or 7 databases.

December 3-6 2012 – Advanced Informix Performance Tuning
This course is for database administrators and application developers who will be responsible for managing, optimizing, and tuning an Informix database server. The focus is on skills, procedures, and scripts to improve the performance of your database server. The course will provide a toolkit of scripts and utilities to start monitoring and optimizing your Informix database server.

All courses may be taken online on the web from your desk or at our training center in Virginia. All you need is a web browser and a SSH client (like Putty) to connect to the lab machines in our office.

The follow is a link to the courses on our web site:


Registration Information:

http://www.advancedatatools.com/Training/CourseRegistration.html or call 703-256-0267 x101 for more information and to Register

Informix news Back to top


Empowering Business Analysts with Faster Insights!
A DBTA article by Keshava Murthy (Senior Technical Staff Member at IBM Informix development working on query processing and data warehousing)

IBM Data Magazine
New Certification : With this new exam and certification role, the successful candidate will be able to:

  • Identify the files and applications necessary to install and configure Genero
  • Run and recompile in both text and graphic mode
  • Enhance applications with Genero features
  • Enable Genero for the web
  • Generate reports
  • Implement web services

The exam consists of 70 questions, which students will have 90 minutes to complete.

Support corner Back to top

Should I install my Informix tools in the same directory as my Informix Server?

When products are built with different versions of CSDK, or include a different version of CSDK, they must be installed in separate directories.

The Informix server 11.50 is shipped with a Client SDK (CSDK) whose version matches the server version. Informix 11.50.xC9 will ship with CSDK 3.50.xC9, where ‘x’ is F for 64 bit systems, and ‘x’ is either U,T or H for 32 bit systems.

Likewise, Informix server 11.70 is shipped with a Client SDK whose version matches the server version. Informix 11.70.xC5 will ship with CSDK 3.70.xC5, etc..

The tools such as the 4GL compiler, debugger, or rapid development system, or ISQL (and their respective runtimes) are also built with CSDK. The version of CSDK used will depend on the current release level of CSDK at that time, and whether it is intended to be used with Informix 11.50 or Informix 11.70.

Because of product architectural issues, 3.50.* and 3.70.* libraries cannot be mixed. Doing so will lead to application failure. Failure symptoms may include, but are not limited to blank form screens and core dumps. Application program failures do not appear to effect data in the database.

When you install tools in the same directory, you may overwrite the library of one product with the same library of the second product. This is not a problem as long as the products are built with the same version of CSDK, down to the minor release level. (e.g. 3.50.xC5 where C5 is the minor release). If the products are built with different versions of CSDK, it may cause problems which lead to application program failure.

If you have products which have been built with different versions of CSDK and installing them in the same directory has led to problems such as blank screens and core dumps, then segregate the products by CSDK build version. Set your PATH and LD_LIBRARY_PATH variables as appropriate for the users.

You can find the version of CSDK used to build a tool by untaring the product file, and checking the machine notes file under $INFORMIXDIR/release/, or by going on line to the Information Center for the appropriate Informix server and drilling down to Release Information, then Informix 4GL, then the particular release version, then Release Notes. In that file you will find the version of CSDK used to build the tool.

Note that the version of the tool and the version of CSDK used are not necessarily the same. For example, 4GL 7.50.xC6 was built with CSDK 3.70.xC4.

Jeffrey Cauhape

Informix corner Back to top

Withdrawal from marketing

Effective on the dates listed below, IBM. will withdraw from marketing, part numbers from the following product releases licensed under the IBM International Program License Agreement:

Program number VRM Withdrawal from
marketing date
Program release name
5725-B41 11.50.0 08/17/12 Informix Choice Edition V11.50.0
5724-C23 3.0.0 08/17/12 Informix Client SDK V3.0.0
5724-C23 3.50.0 08/17/12 Informix Client SDK V3.50.0
5724-C24 3.0.0 08/17/12 Informix Connect Runtime V3.0.0
5724-C24 3.50.0 08/17/12 Informix Connect Runtime V3.50.0
5724-L23 10/16/12 Informix Dynamic Server (IDS)
5724-C29 1.30.0 08/17/12 Informix Excalibur Text Search DataBlade. V1.30.0
5724-Z04 11.50.0 08/17/12 Informix Express. Edition V11.50.0
5724-C19 8.5.0 08/17/12 Informix Extended Parallel Server (XPS)V8.5.0
5724-C58 3.11.0 08/24/12 Informix Geodetic DataBlade V3.11.0
5725-A40 11.50.0 08/17/12 Informix Growth Edition V11.50.0
5724-C59 2.00.0 08/17/12 Informix Image Foundation DataBlade V2.00.0
5724-I35 3.1.0 08/17/12 Informix JDBC Driver/Embedded SQL V3.1.0
5724-I35 3.50.0 08/17/12 Informix JDBC Driver/Embedded SQL V3.50.0
5724-C27 1.6.0 08/17/12 Informix Server Administrator V1.X V1.6.0
5724-C61 8.2.1 08/17/12 Informix Spatial DataBlade V8.2.1
5724-C61 8.20.0 08/17/12 Informix Spatial DataBlade V8.20.0
5724-C62 4.01.0 08/17/12 Informix TimeSeries DataBlade V4.01.0
5724-C63 1.10.0 08/17/12 Informix TimeSeries Real Time Load Bundle V1.10.0
5725-A39 11.50.0 08/17/12 Informix Ultimate Edition V11.50.0
5724-C30 4.12.0 08/17/12 Informix Web DataBlade V4.12.0
5724-C30 4.13.0 08/17/12 Informix Web DataBlade V4.13.0
5724-D27 1.00.0 08/17/12 Informix Workgroup Datablade Bundle V1.00.0
5724-C43 7.25.x 08/17/12 Informix Standard Engine
5724-E93 7.25.x 08/17/12 Informix Standard Engine Runtime Edition
5724-D61 5.20.X 08/17/12 Informix Online Personal Edition
5724-E03 5.20.x 08/17/12 Informix Online Extended Edition for Linux
5724-D59 7.25.x 08/17/12 Informix SE Personal Edition


Informix bootcamps

Informix 11.7 Bootcamp

Date Country City Registration Information
Aug 6 – 8, 10, 2012 South Africa Johannesburg Register at http://www-304.ibm.com/events/idr/idrevents/register.action?meid=5614&ieid=3315
Class to be held on Aug 6, 7, 8, and 10th. Extended 4-day agenda to cover Informix Warehouse Accelerator module* on Aug 10th
For more details see http://www.ibm.com/developerworks/wikis/display/im/Informix+11.7+Bootcamp

Informix Performance Tuning Bootcamp

Date Country City Registration Information
Sep 19 – 21, 2012 China Shanghai Register at https://www.ibm.com/events/swgeer/swgeer06.nsf/signin?openform&seminar=kwockwn8venqj&lang=en
For more details see http://www.ibm.com/developerworks/wikis/display/im/Informix+Performance+Tuning+Bootcamp

* http://www.ibm.com/developerworks/wikis/display/im/Informix+Warehouse+Accelerator+Bootcamp

Discover Informix in Malaysia

A user group Event On August 2nd,2012
Be sure to be a part of the largest gathering of Informix users in Malaysia on August 2nd (Thursday) from 1: 30 PM to 7: 30 PM at Ballroom A, Level 10, DoubleTree Hotel, Kuala Lumpur, followed by Buka Puasa dinner that will commence from 7:30 PM onwards.

Get more details here:


Discover Informix in Thailand

A user group event on August 7th (Tuesday), 2012
If you are around Bangkok during the week of 7th (of August 2012), please join us to for this half a day event and be a part of the largest Informix users gathering Thailand. We will be having some of the members IBM Informix leadership team and Informix subject matter experts to be present for this event in person, and they will be most happy to spend time with you to discuss on how IBM could help better achieve your business goals with Informix.

Get more details here:


Informix resources Back to top

Informix blogs and things

Calendar of events Back to top

August – 2012
Date Event Location Contact
1 Informix Road Show – Actually using smart sensors and other time sensitive data with TimeSeries Dallas, Texas Carlton Doe – cdoe@us.ibm.com
8 Informix Road Show – Turning data into knowledge at the speed of thought Chicago, Illinois Carlton Doe – cdoe@us.ibm.com
9 Informix Road Show – Actually using smart sensors and other time sensitive data with TimeSeries Chicago, Illinois Carlton Doe – cdoe@us.ibm.com
14 Informix Road Show – Turning data into knowledge at the speed of thought Atlanta, Georgia Carlton Doe – cdoe@us.ibm.com
15 Informix Road Show – Actually using smart sensors and other time sensitive data with TimeSeries Atlanta, Georgia Carlton Doe – cdoe@us.ibm.com
October – 2012
Date Event Location Contact
21-25 Informix on Demand 2012 Las Vegas, Nevada


Useful links Back to top


Closing and credits Back to top

The International Informix Users Group (IIUG) is an organization designed to enhance communications between its worldwide user community and IBM. The 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
Rhonda Hackenburg

For comments, please send an email to gary@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.