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 #167)
May 2014

Other Issues

Highlights: Time Series Database Service Beta

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

Dear IIUG friends,

The polls are open for the 2014 IIUG Board of Directors election.

For me, serving on the IIUG Board is a challenge. I have several roles on the Board but the one you are probably familiar with is editing the IIUG Insider. This is my 99th issue. I hope you enjoy it. I certainly enjoy doing it. Editing the Insider is mainly searching for content. I would like to thank my loyal content providers for keeping the Insider going.

Informix is now part of the Internet Of Things and Cloud initiatives and hence is part of the IBM vision. The new NoSQL capabilities alongside with the enhancement of Time Series capabilities, reignites my hopes for Informix. The IIUG Board and the IIUG community have a major role making sure Informix remains an important part of the IBM software portfolio. So please vote for the people you would like to see on the 2014 Board. I hope I am one of them. I'd love to do my 100th IIUG Insider in June.

To vote go to the IIUG website, or directly to the ballot at

Gary Ben-Israel
IIUG Insider Editor

Highlights Back to top

Time Series Database Service Beta

IBM announces new beta in Bluemix for additional bigdata Analytics for timeseries and geospatial applications in the cloud. Rapidly develop web and mobile applications to provide new services to your customers in record time.

  • Accelerates time series analytics in the cloud
  • Supports multiple data types including time series, spatial, NoSQL & relational data
  • SQL and JSON interface
  • Rapid application development
  • It's Informix!

Get started with the Internet of things to harness the immense volume of data generated by connected devices, sensors and gateways. IBM recently announced a new beta service in Bluemix using TimeSeries in the Internet of Things Service.

  • Provides developers with a faster way to create new applications in the cloud
  • Includes tools needed for cloud-based applications servicing the millions of devices that comprise the Internet of Things
  • Informix is the database service for IOT!

Sign up for the free beta.

Conference corner Back to top

Register for IBM Insight 2014, the Big Data conference

This year, hear thought about the emerging Internet of Things and how it's transforming our lives and how we do business. Ubiquitous computing and the proliferation of connected devices and sensors is producing enormous amounts of data, as well as unprecedented opportunities for growth. Register today and look for sessions on Internet of Things to learn about new, innovative and intelligent solutions from Informix that can harness this data to meet the challenges of IoT and transform your business.

Informix news Back to top

Connected Devices for Smarter Home Environments

IBM Data Magazine: Connected Devices for Smarter Home Environments - Internet of Things data bolstered by Informix database embedding advances connected devices at home


Internet of Things - Introduction

Internet of Things with IBM Informix

IBM Internet of Things Video


Devices are talking in the era of big data: Are you ready?

Informix corner Back to top

Webcast: Internet of Things: Choose an Intelligent Database

June 5, 2014 | 1:00 p.m. Eastern / 10:00 a.m. Pacific
Speaker: Kevin Brown, STSM, CTO IBM Informix Database

The "Internet of Things" refers to the growing number of devices and sensors that communicate and interact via the Internet, offering businesses new customers and revenue opportunities. Harnessing data from billions of connected devices lies in the ability to store, access, and query SQL and NoSQL data together, seamlessly. Check out this upcoming eSeminar to learn how to bridge the gap between new computing technologies designed for big data, cloud, and mobile computing with the enterprise world of relational data in the "Internet of Things" era.

Tech Talk: Developing Internet-Connected and Mobile Applications using DB2 and Informix

June 4, 2014 | 12:30 PM Eastern

This webcast explains how Informix and DB2 can be used to bridge the gap between new computing technologies (Big Data, Cloud, Mobile) and enterprise relational data in the "Internet of Things" era. For example, SQL and NoSQL data used together seamlessly. Attend by clicking on the easy button below. This launches a new email widow with an invitation in it. You can personalize this message and add your client's email address and send.

IBM IoT and NoSQL Roadshow

Don't miss the new series of free one-day roadshows featuring Internet of Things and NoSQL solutions. IBM is offering both business and technical enablement sessions to present the latest technologies for harnessing your data and how to improve business outcomes.

Look for a city near you and register today.

Hildebrand Case Study

See how IBM client, Hildebrand, found a game-changing technology to provide energy monitoring services, process huge volumes of sensor data from devices on the edge and provide new services to their customers. Hildebrand recently used its Smart platform to launch a retail "footfall" tracking solution to use anonymized data from mobile devices to measure the approximate location of people over time. Across 25 UK shopping malls, the solution is currently collecting 250 million data points a day, delivering unprecedented insight to the mall operators.

Read the case study.

Informix 12.1 Bootcamp

Location: Gurgaon, India
Dates: June 11 - 13

Hurry - seats are limited and are closing out fast.

Support Corner Back to top

Achieving Consistent Meanings for DATETIME Values with JDBC

The best-fit Java class for an Informix DATETIME value is java.sql.Timestamp. Java.sql.Timestamp technically inherits from java.util.Date; although, there are some semantic differences which are not typical of inheritance relationships. All the constructors, getters, and setters which are not deprecated for Date and Timestamp use values based on Greenwich Mean Time (GMT). They are offsets in milliseconds from the epoch, January 1, 1970 00:00:00 GMT. So, it would be logically consistent for Timestamps to convert to DATETIMEs using the GMT reference frame by default. However, the JDBC Tutorial and Reference specifies that, when no Calendar is provided, Timestamp values are converted to the time zone of the JVM in which the application is running. The difficulties surrounding Timestamps and time zones are not limited to the scope of the Informix JDBC driver; they are generic to all of JDBC because that is the specification.

This model creates problems in a variety of ways. For distributed applications, the Date or Timestamp values might be streaming into the database from JDBC drivers located in different time zones. With multi-tier applications, you might find yourself contending with a user interface in time zone A, the JDBC driver in time zone B, and the database server in time zone C. The driver is the library where external types are converted to internal types; so, where it is running is where the local time zone comes into play. It can be difficult for either the front end or the database to know in what time zone the driver is operating. Dealing with the conversion from Timestamp in GMT to DATETIME in the JDBC driver locale has to be done in the application layer directly interfacing with the JDBC driver.

The conversion done by the driver applies in both directions, and this can lead to complications if anything other than the JDBC Timestamp class is used in conjunction with DATETIME values. If strings representing DATETIMEs or DATETIME literals are used anywhere in your application SQL (including CURRENT), the values will not be converted on the way in, but will be converted on the way out. Similarly, different APIs will not convert in either direction. If you insert new Timestamp(86400001) (January 2, 1970 00:00:00.001 GMT) through JDBC, and select it back from within the same JVM, you will get that same value back. So, you might expect that selecting the same row-column from, say, DBAcccess, would also give you the same value, but it will not because the value was converted to JVM time zone on the way in through JDBC, but not converted on the way out through ESQL/C. If you are in the U.S., you will get some time on January 1st, not even the same day. The reverse also applies, you may find yourself with values inserted through other APIs, which perform no conversion, that are converted to some other time zone when selected through JDBC.

DATETIMEs, of course, do not contain time zone information. There are basically two ways to deal with this, record the time zone information in another column along with the DATETIME or establish a convention that all the DATETIMES in the database are in the same time zone. Establishing a convention is the simpler approach both from an application implementation perspective, and in terms of being able to easily compare values in different rows, columns, or tables. If you know that every Java application which will ever access the data will operate in its own JVM, you can code your applications to set the default time zone of the JVM, but this is a problematic solution when more than one, independent application is running in the same JVM, such as servlets in a web server. It is unclear what would happen with different threads of execution changing the time zone for all other threads, but if they were actually able to do that, it would not be pretty.

At JDK 1.1 two things happened, all the getters and setters for java.util.Date where the meaning was ambiguous with respect to time zone were deprecated and the java.util.Calendar class was introduced. Along with the Calendar class itself, methods accepting a Calendar object were added to the JDBC interface, for example PreparedStatement.setTimestamp(int parameterIndex, Timestamp x, Calendar cal) and ResultSet.getTimestamp(int columnIndex, Calendar cal). In these methods, the Calendar object establishes the frame of reference used to convert from the GMT offset in the Timestamp object to or from a DATETIME value. If you create a constant Calendar object in your applications, and use it every time you read or write a Timestamp object to a DATETIME, the values DATETIME will remain consistent with each other, and the meaning of the value will not change dependent on the time zone of the JVM.

Using a GMT calendar would be efficient because it requires less operations to convert between the Java classes and the value in the database. Also, the value will not change if other APIs, like ODBC or ESQL/C, are used. Conceptually, what is stored in the database is January 1, 1970 00:00:00.000 GMT + tstamp.getTime() milliseconds.

Calendar cal = Calendar.getInstance(TimeZone.getTimeZone("GMT"));

Coordinated Universal Time (UTC) is a close relative to GMT and is just as viable. In this model, all date and time values in the database are on the same time line, and conversion to other time lines or calendar systems are handled at the user interface level. Using UTC or GMT for all DATETIME values provides a simple model to implement in applications. It also removes all the problems related to knowing the time zone of the JDBC driver runtime or if applications written in anything other than Java will ever be used to access the data.

- Chris Golledge

Calendar of events Back to top

June - 2014
Date Event Location Contact
3-4 IBM Informix Internet of Things/NoSQL Spring/Summer Roadshow Phoenix, Arizona  
16-17 IBM Informix Internet of Things/NoSQL Spring/Summer Roadshow Chicago, Illinois  
19-20 IBM Informix Internet of Things/NoSQL Spring/Summer Roadshow Dallas, Texas  
25-26 IBM Informix Internet of Things/NoSQL Spring/Summer Roadshow San Jose, California  
July - 2014
Date Event Location Contact
3 Informix and Industry 4.0 / Internet of Things Infobahn Event IBM HQ, Ehningen, Germany Monika Schneider
7-8 IBM Informix Internet of Things/NoSQL Spring/Summer Roadshow Toronto, Canada  
15-16 IBM Informix Internet of Things/NoSQL Spring/Summer Roadshow Montreal, Canada  
20-21 IBM Informix Internet of Things/NoSQL Spring/Summer Roadshow Atlanta, Georgia  
24-25 IBM Informix Internet of Things/NoSQL Spring/Summer Roadshow Washington DC  
30-31 IBM Informix Internet of Things/NoSQL Spring/Summer Roadshow Costa Mesa, California  
August - 2014
Date Event Location Contact
6-7 IBM Informix Internet of Things/NoSQL Spring/Summer Roadshow New York City  
11-12 IBM Informix Internet of Things/NoSQL Spring/Summer Roadshow Boston, Massachusetts  
14-15 IBM Informix Internet of Things/NoSQL Spring/Summer Roadshow Seattle, Washington  
October - 2014
Date Event Location Contact
26-30 IBM Insight 2014 Las Vegas, Nevada

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

There is now an Informix group on LinkedIn. The group is called "Informix Supporter", so anyone loving Informix can join, from current IBM employees, former Informix employees, to users. It will also be a good occasion to get in touch with others or long-time-no-seen friends. If you fancy showing the Informix logo on your profile, join.

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