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 #176)
February 2015

Other Issues

Highlights: Electing the 2015 IIUG board of directors

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

February was, as it always is in the northern hemisphere, cold. Jerusalem even had 10 inches of snow. I hope the weather will be warming up soon.

It will definitely warm up for the IIUG. We will be electing the new IIUG board in March and we will have IIUG2015 in April. The elections are your chance to influence the direction of the IIUG by standing for elections or by voting. The 2015 board will be presented at IIUG2015 in San Diego.

Don't miss our event. It is the largest Informix gathering in the world. There are many outstanding sessions, leading Informix developers and support engineers, friends, colleagues, parties and more. San Diego is a great location. I know I have said it many times. As a matter of fact, I repeat myself every year hoping to convince those who never came and those who did but are not planning to attend this year.

See you in San Diego.

Gary Ben-Israel

Highlights Back to top

Electing the 2015 IIUG Board of Directors

Elections for IIUG Board of Directors

Each year the membership of the International Informix Users Group elects its Board of Directors. Anyone who became an IIUG member at least a month prior to the election is eligible to vote via online ballot at This year the new Board of Directors will be installed on May 1, 2015.

The election is a democratic process whereby the candidates who get the most votes and confirm their interest to serve in a timely manner after being contacted with the results will be confirmed as elected. To avoid potential conflicts of interest, votes are automatically tallied and manually validated by the members of the IIUG Nominating Committee who are not standing for election.

The IIUG Board of Directors election is overseen by a Nominating Committee that supervises both the nomination process and the election. The members of Nominating Committee are appointed by the current Board of Directors.

2015 Election Timeline

2 Mar 2015Nominations Open
16 Mar 2015Nominations Close
23 Mar 2015Election Announced
30 Mar 2015Start of Election
13 Apr 2015End of Election
27 Apr 2015Election Result Officially Declared

Notes to the above

  1. Nominations must be made by email to the Election Commissioner at the email address The email must state the following:
    • Applicant's name.
    • Applicant's parent organization and role in that organization.
    • Applicant's IIUG membership number.
    • A brief description about why the applicant would be a good candidate for the role on the IIUG Board.
    • A brief description about the attributes that the applicant has and can apply to the work of the IIUG Board.
    • A statement acknowledging that the applicant has the time commitment to devote to the work of the IIUG Board that will include, amongst other things, a daily commitment to email correspondence, a monthly commitment to conference calls and at least two Board meetings (normally 3 days plus travel) and attendance and assistance to the IIUG Informix conference in North America (normally 5 days plus travel). For all the events, attendance is compulsory.
    • The IIUG Board may, at its discretion, reject any nomination for any reason without disclosing such reason.
    • Nominations received after 5pm US Eastern Standard Time on the 16th of March 2015 will not be eligible.
    • You may nominate yourself. If nomination is for another person, that person must acknowledge their acceptance of the nomination in a separate email to the Election Commissioner at
  2. An election will only occur if there are more nominations than Board positions.
  3. The election will run over a two week period.
  4. Following the election, the successful nominees will be required to confirm their availability. This will be by way of written correspondence with the Election Commissioner.
  5. The election result will be officially declared by the Election Commissioner on the 27th of April 2015 and announced via the Insider eNewsletter, IIUG Website or email blast to members.
  6. The new IIUG Board will take up their responsibilities from the close of the IIUG2015 in San Diego, California. There is no specific requirement that new Board members attend the San Diego conference.

The Candidates

Candidates for the IIUG Board of Directors are selected by the IIUG Nominating Committee who try to find nominees that represent a wide geographical membership as well as a mix of product utilization, and who can meet the many and varied challenges and functions of the Board.

Candidate Selection Process

IIUG members who are interested in running for a seat on the IIUG Board of Directors should submit the completed Nominee Questionnaire below to prior to the close of the announced deadline for nominations. The resulting nominees are announced prior to the election and candidate statements are posted on the IIUG Website and on the ballot as well.

All currently elected board members are REQUIRED to attend at least two board meetings that could be held anywhere in the world and the annual IIUG2015 Conference. Failure to do so will result in removal from the board. Expenses will be covered as part of being a member of the IIUG Board. Also a one hour conference call is held each month (during business hours). All Board members are expected to be part of this call. Failure to do so, could also result in removal from the IIUG Board. Interested candidates for IIUG Board should clear this with their employer prior to submitting their name as a candidate.

IIUG Board Members Duties

Serving on the IIUG Board of Directors is a minimum one-year commitment. It requires travel to meetings, monthly conference calls, and regular e-mail communication with other Board members as described above. The Board meets formally for two to four days up to three times a year, whenever possible during weekends.

In addition to representing and serving Informix users worldwide, Board members are expected to think strategically about the future of the Informix community and their relationship with IBM. Fringe benefits of serving on the IIUG Board include expenses-paid attendance to the IIUG Informix User Conference and all other required meetings, direct contact with IBM executives, early access to product and service news, visibility and leadership development.

To learn more about what it is like to be a member of the IIUG Board of Directors, please see Being an IIUG Board Member. A personal view, by Neil Truby.

Conference corner Back to top

Hurry! Regular Registration extended to March 2nd

There is less than 1 week left before the Late Registration price increase for IIUG2015 takes effect. You have until midnight (EST) Monday, March 2, 2015 to register for IIUG2015 in San Diego.

Register now to receive the Standard Registration rate and apply your $100 IIUG Membership Discount for a total cost of $1050 USD. This year we will also be celebrating the 20th Birthday of the IIUG. Join us for IIUG2015, the Seventh Annual IIUG event.

Remember, your IIUG2015 registration guarantees you entrance to the April 30th tutorials at NO ADDITIONAL CHARGE for all paid attendees. We will also offer the ever popular hands-on labs. This is a great opportunity to extend your training budget.

We are still finalizing our hands-on labs and tutorial topics. Here is a list of potential topics for this year:

Hands-On Labs

  • Acceleration Queries and Analytics with IWA Across Multiple Data Types
  • Using TimeSeries Data and NoSQL Together
  • Introduction to Enterprise Replication
  • Take a REST With Your Data
  • Build Your First TimeSeries Application on Bluemix


  • Application Development Using a Hybrid Database
  • Plan, Configure and Deploy your Informix Warehouse Accelerator Environment
  • IoT Gateway in a Box
  • John & Scott's Performance Tutorial
  • Replication Within The Grid
  • Exploring New Features in Informix Using Bluemix
  • IBM Internet of Things Foundation SaaS Offering
  • Creating and Using Tenant Databases
  • Build Your First Genero Mobile Application

...And much, much more

Speakers are continuing to submit their presentations for IIUG2015. As these sessions are submitted we will continue to add them to the conference website. The speakers at IIUG2015 are the best the Informix community has to offer. New speakers and familiar faces are eager to share their knowledge and expertise while presenting interesting and relevant topics that can be used to reinforce your professional skills.

We are finalizing out keynotes for this year and are pleased to announce Jeff Jonas as one of our keynote speakers. Jeff's work has received wide media attention from the Wall Street Journal, The Washington Post, Fortune Magazine, MSNBC and National Public Radio. A highly sought after speaker, Jeff travels the globe discussing innovation, national security, and privacy with government leaders, industry executives, and leading global think tanks. He is on the boards of the US Geospatial Intelligence Foundation (USGIF) and the Electronic Privacy Information Center (EPIC), a Senior Associate at the Center for Strategic and International Studies (CSIS), and a Distinguished Engineer of Information Systems (adjunct) at Singapore Management University (SMU).

Use our Justification Document if you are still having problems convincing your boss this is a valuable way to spend your training budget.

We look forward to seeing you!

Apr 26 — April 30, 2015

Marriott Mission Valley, San Diego CA

Rhonda Hackenburg

Support corner Back to top

No Leap day, just a Leap Second

Our 2015 calendar year has no leap day in February, but we will have a Leap Second addition on June 30th 2015, at 23:59:60. This will provide a correction to keep the International atomic clock aligned with the earth's rotation. A leap second announcement can be a challenge for computing at the Operating System level, especially when the system is tied to the atomic clock (UTC timing) interval. Understandably, a DBA could become very worried about the impact when a one second adjustment is not handled well.

For Informix products, a leap second has occurred 10 times between 1990 and 2015, and the product quietly keeps doing what it needs to do. Informix datetime seconds can span the range of 0 to 61 seconds in the datetime format. As long as the client-side application does not limit the number of seconds solely to the range of 0 to 59, the server side datetime seconds value will be able to handle up to 2 leap seconds. The environment variable GL_DATETIME provides additional formatting options.

- David Jay

Informix corner Back to top

IBM Internet of Things Architecture and Capabilities

Informix is Uniquely Positioned for Sensor Analytics

The IIUG 2015 Promo video

Video is live right here:

RFE Corner Back to top

Just in case you are not aware, some time ago IBM created a public website to collect the requests for new features directly from users. The RFE (Requests For Enhancements) website is included in developerWorks. You can access it here.

Once you logged in with your usual IBM ID, choose "Information Management" in the Brand dropdown box and "Informix Servers" or "Client Products" in the Products dropdown box.

The interesting thing is that any request, including your request, if you place one, are submitted to be voted on. This means the RFEs that receive more votes have a greater chance to be considered by the architecture and development teams for further consideration. In other words, this IS the opportunity to provide enhancement ideas even if you are not the biggest IBM customer on the planet Earth.

Some RFEs will be of great interest, others will not seem useful to you. This is why your opinion is important. Do not hesitate to vote and place comments!

The idea of the RFE corner is to provide a digest on new Informix RFEs and make those RFEs more visible and accessible for the community, so that you can vote for them in a faster and easier way. By participating actively in this website, IBM will have solid and useful elements from the customer base to introduce new functionality to Informix product.

Also in the area of IBM website, a new functionality has been released: MyNotifications. You will want to register this webpage in order to receive the notifications of your choice (new product defects, new patch release, new versions etc..., on the frequency of your choice (daily, weekly). I have registered and will definitely keep registered, due to the value of the information delivered.

Register here.

New RFEs for February 2015

Provide mechanism to convert suitable expression-based fragmentation storage schemas to interval-based

We have a large about approaching 1 Tb in data only which has an expression-based fragmentation storage schema.

When we created the table FRAGMENT BY INTERVAL was not available but the table has an expression-based schema compatible with interval partitioning.

One major problem we have is that the expression-based schema is by date and the last partition ends on Sept 30th 2015.

We are looking at options for this table. If it were created again today doubtlessly we would look at interval-based fragmentation.

We would like to request a mechanism whereby suitable expression-based fragmentation can be converted to interval-based. This would ideally include the indices on the table but if, not we could take an extended outage to rebuild them.

Use spatial datatypes and functions from another database

Using spatial functions is limited to the database in which it is defined. If you have to combine a spatial function with spatial data in 2 different databases you first need to convert 1 datatype to varchar. This is slowing down the performance.

Rename database with spatial datablade

When you migrate a database from the production environment to test or development, you have to drop the database on test/development, before you can import the production database. This because you can.t rename a database with spatial information.

If it's possible to rename this database, you can fist execute the import in a different database, if the import is ok, rename the old database and put the newly imported database in place.

Existing chunk can be re-used

Currently if we try to add an existing chunk to the dbspace it does not give any error that chunk is already in use. The server crashes if a chunk is re-used and the only way is to restore it back from backup.

Study informix

Our team uses product informix for our project.

The Red Brick SQL use large IN list problem addition to error message

Red Brick Ver6.30.xC15
Windows Server 2012

The customer enhancement request function addition to output error message indicating the cause of SELECT statements that use large IN lists caused the Red Brick 10410 and 10410 error occurred. The customer can't judge the cause of this error. It error mean is connection error message below.

** FATAL ** (10410) Could not receive from the server. OS error: No error (0).
** FATAL ** (10442) The server has unexpectedly closed the socket. It may have stopped running.

The PMR#27774,999,760 happened to the customer add a function to output the following messages.

For example error message:
RBA00000E: Session terminated; Too many in list on SQL statement.

This issue summary Red Brick error message ** FATAL ** (10410), could not receive from the server when running query with large IN LIST.
There is not the error message indicating the cause of the error then. The error message is only information of could not receive form the server.
It message out putted now, the customer can't identify problem cause of the error.

The following fixed case to be the origin of this error.
* CSL #27625,999,760
SELECT statements that use large IN lists caused the Red Brick service to stop

Gary Ben-Israel

Calendar of events Back to top

March - 2015
Date Event Location Contact
4 Colorado Informix User Group Meeting Bureau of Land Management, Lakewood, CO Mike Walker
April - 2015
Date Event Location Contact
26-30 IIUG2015 San Diego, CA Cindy Lichtenauer

Informix resources Back to top

IBM Informix home page or directly at:

Informix blogs and wikis

Blogs and Wikis that have been updated during the last month

More Blogs and Wikis

Forums, groups, videos, and magazines
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