Informix Twitter chat: Why NoSql and why Informix NoSql?


Do you want to share your views or know more about the following questions : 

  1. What is #NoSQL?
  2. What are the Industry #trends that are driving #NoSQL adoption? 
  3. What challenges are companies currently embracing #NoSQL database models facing? 
  4. How does #NoSQL help in providing enterprise-class capabilities and support?
  5. How can customers leverage new business patterns with hybrid #SQL /#NoSQL applications? 
  6. How critical is lowering time-to-value and rapid application development with #NoSQL for customers?
  7. How important is leveraging skills to lower development costs and application development flexibility with #NoSQL? 
  8. How you can leverage #relational and #non-relational data from a single application? 
  9. How does the #NoSQL capability help in #analytics with existing #data and new data? 

Here is great opportunity for you, as we at IBM Informix are organizing a Twitter chat, with James Kobielus (Senior Program Director, Product Marketing, Big Data Analytics solutions), Keshav Murthy (Senior architect for IBM Informix NoSQL & SQL) and Art Kagel (Informix Database consulting and training partner) on the topic of “Why NoSQL and Why IBM Informix NOSQL.”

Get more details here

Hoping that you will join us for this twitter chat and share your views!

Until next time, 



Webcast on Combining SQL and NoSQL Data for Powerful, Big Data Enterprise Applications

These days, many organizations are flooded with data coming from multiple sources, locations and devices. And in the process, in order to maintain efficiency, the adoption of NOSQL database model takes front seat, which enable the organizations to manage their unstructured data and existing structured data.

Keeping this requirement in mind, our engineers at IBM Informix have been working on improving the NOSQL capability of Informix and to a level where you combine the two technologies in a smart way. In simple words, helping our customers bring NoSQL to SQL database.

With IBM Informix you can leverage relational and non-relational type of data from a single application using familiar methodologies and APIs. IBM Informix is also optimized for embedded data management, including support for ARM processors, to support the growing trend of mobile computing, machine-to-machine applications and the “Internet of Things”.

With this background, we are happy to invite you to join our webcast titled “Combining SQL and NoSQL Data for Powerful, Big Data Enterprise Applications”.

Date/Time : Wednesday, March 05, 2014, 12:00PM ET / 9:00AM PT

Register today :


Until Next Time,


IBM Informix 12.10.UC2 on ARM processors


This blog post summarizes my conversation with Mr. Sandor Szabo (who manages the IBM Informix Development team in Munich) about the role of IBM Informix 12.10.UC2 in ARM processors

In conversation with Sandor Szabo, manager of the IBM Informix Development team in Munich.

Can you please explain more about ARM Processor and the role of Informix?

ARM Processors have reduced costs, heat and power usage compared to more complex chip designs, traits which makes it desirable for light, portable, battery-powered devices like smartphones, laptops, tablet, and notepad computers  and other embedded systems. Alternatively the use of a simpler design allows more efficient multi-core CPUs and higher core counts at lower cost, allowing higher levels of processing power and improved energy efficiency. You can also read more here

The role of Informix:

Informix 12.10 is an industrial strength, relational SQL99-based database with features that is ideal for deep embedded applications. Here is a list of features that make Informix an ideal choice:

  • self tuning
  • self monitoring
  • self healing capabilities built-in,
  • small disk footprint configurations are supported, Data/Index-compression built-in
  • low memory operations are supported
  • remote monitoring, tuning and configuration
  • proven track record for deep embedded applications
  • built-in industry leading high performance support for Time Series based Sensor Data
  • to top it all, Informix FlexibleGrid technology can support thousands of Informix servers in heterogeneous cluster topologies with built-in flexible data replication

So, in a nut shell, the role of Informix is primarily to store and retrieve sensor data, 24/7 in a very efficient and autonomous manner, without the presence even a single DBA.

Can you talk about the technical details of this ARM Processor?

  • Minimum Informix 12.10.uc2 on Linux  ARM System Requirements
  • ARMv7 CPU  (v7l)  with Hardware Floating point support
  • 512 MB RAM (for Linux and Informix)
  • Storage space for the database files (e.g. SSD, SD, microSD etc.)
  • Minimum product deployment diskspace (w/o database files, customizable): < 100 MB
  • One of the following supported Linux distributions for ARM Debian 7.1, Ubuntu 12.1
  • Support for other Linux distributions upon request

Hardware Specifications :

  • A20ïŒ ARM  Cortex-A7 Dual-Core ARM
  • 1GB DDR3 @480M
  • 3.4GB internal NAND flash, up to 64GB on SD slot, up to 2T on 2.5 SATA disk
  • 1x 10/100 ethernet, support usb wifi
  • For more details please visit :

What benefits will the consumer of this device get?

Super value for money, along with Informix Database which has industry’s widest sets of options for keeping data available at all times including:

  • zero downtime for maintenance
  • continuous local collection and processing of critical vehicle monitoring parameters (e.g. engine parameters, environmental parameters)
  • Informix 12.10 time series data capabilities
  • continuous local recording of positional data (e.g. the current vehicle position)
  • Informix 12.10 geospatial data capabilities
  • on-board data analytics on the collected time series based data and generation of alerts, either constant replication of those kind of data to a central instance (if a network connection is available) or local storage until a network is in reach

What is the future plan with this device (Upgrade, market etc)?

With the latest release of Informix 12.10.UC2 to our OEM partners, we hope to find many new partners who are looking for a new platform where all the attributes above are important. And for any further information on this topic please do not hesitate to contact us!

Sandor Szabo, a short Bio:

Sandor Szabo,  manages the IBM Informix Development team in Munich. He has been developing Informix products since 1987. Sandor’s main focus areas are Informix Warehouse Accelerator (BLU Acceleration for Informix), IBM Informix Dynamic Server under Linux and now the ARM port of Informix.

Until Next Time,


IIUG Conference 2013 : A huge success

IIUG 2013 was yet again a successful IIUG conference. This year’s conference had the General Manager of IBM Information Management Mr. Bob Picciano deliver an excellent key note to the Informix community, which reinforced IBM’s vision with Informix in the coming years. The other highlight was Jerry Keesee’s (IBM Informix Director) keynote which was focused on the latest version of Informix – V12.1. 

The launch of Informix in March made the IIUG Conference more exciting as there were a lot of sessions focused on the new enhancements in V12.1. With over 100 sessions in 3 days 2013 IIUG Conference was one of the most successful Informix events conducted and we look forward to an even more exciting 2014 IIUG Conference.

Here is an article by Stuart Litel (President IIUG) summarizing the conference.Hope that you enjoy reading it.

Until next time,



IBM Informix Round-Up : February 2013 is out!

Did you check out the February edition of the “IBM Informix Round-Up” newsletter?

The newsletter is designed to keep Informix Business Partners up to date on all of the latest Informix news.

This highlight of this edition of the newsletter is the upcoming webcast of the new Informix. Aren’t we all excited about it?
Read the newsletter to know more :



Upping the Informix Ante: Advanced Data Tools

PS: Kindly note that this is a republished blogpost from Mastering Data Management

Upping the Informix Ante: Advanced Data Tools

A few weeks ago, when we spoke to IBM Champion for Informix Lester Knutsen, we realized that his company – Advanced Data Tools – is home to three Champions with a combined 82 years of Informix experience.

Cindy Lichtenauer has been working with Informix since she was at Southwestern Bell in 1988, and she also worked for Informix for 12 years. Art Kagel began his career as a developer and “found” Informix in 1983 when he was challenged to discover a new developmental environment and database. And Lester is a founding member of IIUG and one of our inaugural IBM Champions. Be sure to check out our full interview with Lester.

All three are very active in the International Informix Users Group (IIUG) – in fact, that’s how they met. So we talked to the trio about the value of user groups and the upcoming IIUG conference.

Lester’s user group experience dates to 1983. That’s when he attended his first user group meeting and came away with a “badly Xeroxed” copy of a program that became PC-Talk. But the people he met that night helped him overcome the bad handout and learn RS-232 communications, which inspired him to become a regular participant in user groups.

Each cites different reasons for investing time in IIUG. For Cindy, it’s about “making life-long connections and friends, and sharing knowledge and learning.” She found her last two jobs through IIUG contacts, and is active on the IIUG Conference planning committee.

Art sees access to IBM Informix executives and developers as a key reason to remain involved, as the group affects the direction of the product. “As individuals,” he explained, “we only have so much influence. As a group, we have power.” Through IIUG, Art says, users can help keep IBM focused on their needs while giving feedback on how well the software meets those needs. He also sees it as a way to “pay back” everything he gets from the community. “I type fast,” he joked when Lester noted how much time Art spends on the forums.

For Lester, IIUG’s value is in finding questions that he may not have considered otherwise. Sharing best practices and getting answers keeps him coming back for more. “You show up and participate… and you’ll find people faced with the same technical challenges you faced, who have solved them in interesting ways that you can learn from,” he explained.

All this learning comes together each April at the annual IIUG conference. As Stuart Litel told us recently, and Cindy confirmed, the conference has grown for 2012. Two new tracks will focus on development and how other IBM products work with Informix. In addition to the 80 planned sessions, full day tutorials and hands-on labs will give attendees plenty of knowledge and tools to take back to their work. This year’s registration is ahead of last year’s, with lots of new people planning to attend.

The team ups the ante on applying all that knowledge with their annual Fastest Informix DBA contest. Each year, about 30 attendees compete for bragging rights (and an iPad) to solve a real-world Informix problem. The contest has created quite the rivalry, and the time constraints – an hour to complete the challenge – keep it intense. Last year’s challenge sought who could get the most transactions in ten minutes on a 1000 user OLTP benchmark, using a very small machine.

Head to the IIUG Conference (April 22-25 in San Diego) to meet Art, Cindy and Lester and see if you have what it takes to be the Fastest Informix DBA. And listen to the podcast for more of our interview.

Inspiring “Aha” Data Moments: Lester Knutsen

PS: This is a republished blogpost from Mastering Data Management

One of our inaugural IBM Champions, Lester Knutsen, summed up his Informix work in a single sentence: “I like building databases.” While working at Aberdeen Proving Ground in 1983, one of the first Unix boxes arrived, bundled with Informix – and Lester marveled at how quickly he could get into it.

This passion drives everything he does. Lester is president of Advanced DataTools, an Advanced IBM Partner that focuses on Informix consulting, training, support and software. Lester is also a founding member of IIUG (the International Informix Users Group), president of the Washington, DC area Informix Users Group and an IBM Gold Consultant.

Lester and his Advanced DataTools team engage users in every step of the data warehouse process. Lester explains, “End users don’t really know what they want until they see it. Anybody who thinks you can just design a project on paper and then go implement it, unchanged, is dead wrong. You’ve got to have user involvement – and that’s the key part of agile development.”

Starting with user requirements, the team loads the data and builds a prototype that lets clients “kick the tires” and see how their data actually works within the warehouse. Clients are often surprised at what they find in the prototype. For the first time, they can identify their biggest customers or find missing transactions.

Even more important, though, is the ability to change direction as clients have “aha” moments about their data. Sometimes, seeing the prototype in action inspires an even better idea.

Besides building databases, Lester and his team spend a lot of time helping clients navigate an ever-changing regulatory environment. While regulations are important, Lester has noticed that some very large organizations use them as “an excuse not to get things done.” These organizations often lack a truly cooperative team or a clear mission.

In contrast, Lester is proud of his team, noting he’s built, “the best pool of Informix talent in the world, outside of IBM.” The team includes two additional IBM Champions, Cindy Lichtenauer and Art Kagel, with whom we did a follow-up interview. (Stay tuned.) Lester firmly believes that, “Good people attract good people,” and he’s committed to developing talent. Advanced DataTools has a unique internship program for high school seniors and college students who show promise in technology. Several participants have come to work for Advanced DataTools after graduation.

Through it all, Lester tries to foster an environment that’s “fun, interesting and challenging.” His team works hard, but they also list their passions on the company’s website. In Lester’s case, he travels extensively to scuba dive and take underwater photos and videos. You can view his incredible collection at Currently, he’s using his database skills to organize his growing video library before heading to Indonesia this summer.

Listen to our interview for more from Lester, and be sure to watch this space for our follow-up conversation with the trio of Champions from Advanced DataTools. You can also follow Lester on Twitter @LesterKnutsen.