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 #185)
November 2015

Other Issues

Highlights: Ardenta wins Analytics award at IBM Insight

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

For those that celebrated Thanksgiving I hope you had a great one. Where I live we are way passed our holiday season and things are pretty calm. Relying on Informix at my company does means life is very calm at work as well. At least from the database perspective.

So I took my time searching for some new Informix stuff.

I was disappointed to see that there is nothing new in Developerworks since October 2014. It used to be a great source let's hope it will be again in the future. For old articles you can still here

Gary Ben-Israel

Highlights Back to top

Ardenta wins Analytics award at IBM Insight

IT service provider demonstrates value-add to enterprises in a data-powered culture.

The UK-based provider of Informix expertise Ardenta have been awarded the esteemed Informix Business Partner of the Year award by IBM at the annual Insight summit held in Las Vegas on 25th October. Each year at Insight, IBM acknowledges those business partners who stand out because of their outstanding growth and performance, marketing activities, solutions and deep expertise. Of the 17 companies who were awarded for their respective areas of expertise in IBM Analytics solutions, 3 were UK-based, supporting the UK's reputation as exporting world-class technical skills.

As members of the International Informix User Group (IIUG), Ardenta has competed and won on their technical skills, so to receive the Informix business Partner of the Year award is a great achievement not only for the technical teams but for the entire business. The business remains focused on and committed to ensuring that Informix clients realize the outcomes and efficiencies which the software solution brings to the enterprise. Ardenta's customers span diverse industries, each with their individual business challenges but with a shared requirement for high performance business-critical functions at all times. The dedication to Informix is clear: Ardenta has some of the most skilled Informix specialists in the world in its team of experts, and finds innovative ways to add value as resellers. Their unique offer of Informix in the cloud, adds a further layer of convenience, speed-to-market and efficiency.

Ardenta has an Informix client portfolio which includes major online entertainment operators such as Ladbrokes, Gala Coral, Betfair and William Hill, as well as major media companies such as BBC, ITV, Local World and Trinity Mirror.

"I'm honored that Ardenta has achieved this endorsement from IBM, and thrilled that our growth as Informix resellers has again been recognized worldwide," says Neil Truby, MD of Ardenta. "Although our technical expertise has developed alongside every new version, we have really cemented our Informix base in the past year, and delivered significant business results for our clients," he reveals.

What does the future hold for a key Informix partner, and for its clients?

"As data emerges as the new currency, being capable of quickly translating this into insights and actions without huge costs and time constraints is going to be fundamental to the future of every business, but especially those whose business-critical operations take place online. Future-proofing your technology investment critically means ensuring that you have ready access to specialists who can support you. I would urge anyone who uses Informix to reach out to us for introductions, as it is rare for us not to be able to unlock performance and hidden value in our clients' infrastructures," Truby challenges. "What matters most to us is continuing to serve our customers and helping them to use Informix to see through business challenges", he concludes.

Conference corner Back to top

IIUG 2016 Registration is Open

IIUG 2016 will be held in a new location this year, at a place we have never been before. Join us May 4 — May 8 at the Sawgrass Marriott Golf Resort & Spa, at Ponte Vedra Beach. Florida. This resort is an oasis with golf, surf and sunshine galore. Sprawling over 65 acres, the resort combines contemporary accommodations and an amazing selection of dining options with a spa, meeting space and 99 holes of championship golf.

As a guest of the resort, you can enjoy access to the Stadium Course at TPC Sawgrass, one of the PGA Tour's most venerable courses. You can rent kayaks, paddleboards or enjoy other ocean activities at the Cabana Beach Club, take a break at the resort-style swimming pools, spend time at the fitness center, there are bike rentals, a volleyball court, jogging/fitness trail and a miniature golf course on-site. Click here to learn more about our new venue.

The IIUG 2016 Planning Committee will be meeting in December to review and select the content and speakers for this exclusive Informix event. We have received many great abstracts to choose from. If you submitted a proposal, you will be hearing from a CPC member by the end of December. As far as content goes, here is an idea of what you can expect:

  • Troubleshooting and Performance Tuning
  • IWA
  • TimeSeries
  • Internet of Things
  • Cloud (ER, HDR/SDS/RSS)
  • Security
  • IBM Bluemix
  • Sensor Data
  • Developer Topics
  • Hands on Labs
  • Sunday Tutorials (Full and Half Day)

Once we receive confirmation from our speakers we will start to list the sessions on for you to start making plans.

Tentative schedule, please note the change in days that you are accustom to from previous IIUG events:

  • Wednesday - Welcome Reception
  • Thursday - Breakfast and Lunch, AM Keynote, Conference Sessions including Certification Testing Review, Hands on Labs, PM Event/Party
  • Friday - Breakfast and Lunch, AM Keynote, Conference Sessions, Hands on Labs, PM Event/Party
  • Saturday - Breakfast and Lunch, Conference Sessions, Hands on Labs, No PM Event for you to enjoy the area
  • Sunday - Breakfast and Lunch, Tutorials (for paid attendees)

Registration is now open at Register for IIUG 2016 by February 4, 2016 to receive a $275 discount over the Regular conference price. Don't forget that all IIUG members can save an additional $100 on registration through May 5. 2016. IIUG membership is free at Join IIUG, so become a member today. Being a member of the IIUG also provides access the monthly Insider newsletter, members only pages for free downloads and other benefits reserved for IIUG members only. We hope to see you all in May.

IIUG 2016 Planning Committee

Call for Speakers IIUG 2016 — Deadline for Submission Extended to December 10, 2015

PLEASE NOTE: we have many great topics to choose from for IIUG 2016, but we wanted to ensure everyone who wants to submit their topic has an opportunity to get it to us. We have extended the call for speakers through December 10, 2015 for those of you who have not yet had the opportunity to submit your proposal.

Speaker guidelines can be found at: if you need additional information.

All selected speakers will receive a complimentary pass to IIUG 2016. This pass will include: the Wednesday night Welcome Reception, access to all sessions from Thursday through Saturday, the receptions on Thursday and Friday nights, and access to the Exhibit area. The pass does not include the Sunday tutorials, however, they can be purchased for a nominal fee. For your convenience speaker logins have been retained for those who submitted a presentation proposal for IIUG 2015. Please submit your presentation proposal and biography today for consideration for IIUG 2016. Submit your proposal using

If you are still unsure about speaking at IIUG 2016 or you don't have a topic you want to present, submit your request for assistance at

IIUG 2016 Planning Committee

Support corner Back to top

What's new

Just a few days ago, IBM released a new version of Informix Dynamic Server. It has a lot of new features and improvements, and you can learn more details about what is available in this release here.

The one of interesting things that can help a lot of people relates to Auto Update Statistics. By default all databases have a medium priority. Now, you can assign specific databases a high or a low priority to ensure that statistics for your most important databases are updated first. Statistics for low priority databases are updated after high and medium priority databases, if time and resources permit. For example, if you have a system with a production and a test database, you can assign the production database a high priority and the test database a low priority. You can also disable AUS for a database. These AUS priorities can be set in the IBM OpenAdmin Tool (OAT) for Informix or by adding rows to the ph_threshold table in the sysadmin database.

If AUS is not of interest, check out the improvements in JSON compatibility, multi-tenancy, security, time series data, and more. Even the installation routines received a much needed overhaul to improve how things work.

- David Jay

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.

Please also note that now on we can see the last comments of the IBM Lab about each RFE, and its status now appears clearly.

Register here

(Login at DeveloperWorks to see the RFEs.)

New RFEs for November 2015

The activity has been rather low this month. We can see that the Backup from RSS or HDR server is again progressing. Some other interesting features are also requested. To be followed next month.

Headline Status Votes
oncheck should check the Timeseries data associated with a table Submitted 5

Top 15 RFEs (By number of votes)

Headline Status Votes
In-Place Alter for varchar, lvarchar and boolean Under Consideration 37
Backup from RSS or HDR Secondaries using ontape, onunload, onbar, dbexport Under Consideration 32
SQL interface to obtain the temporary space usage (tables, hash, sorts...) Submitted 24
Implementation of regular expressions (adding to LIKE/MATCHES functions) Under Consideration 20
Request to track and save a time stamp for last time an index was used. Nee... Submitted 18
Obtain the query plan of a running query Submitted 17
ALTER owner of database objects after creation Submitted 12
Backup Individual database, not entire instance Submitted 11
Include the regexp datablade into the Informix product Submitted 9
Enable defined limits on sqltrace Submitted 8
Enable HDR Secondary to perform archives Submitted 7
Clone a database Submitted 6
oncheck should check the Timeseries data associated with a table Submitted 5
Remove limitation on TEXT and CLOB datatype to have the same functionality ... Submitted 3

Do not forget to vote for one or several of those RFE's if they fit your requirements. The more vote, the more chances that the Dev Team will seriously consider the request.

You can access each RFE by clicking on the above links. At the bottom of each RFE page you will find a hyperlink to vote for it. You will see the Request stats, including number of votes for this request, on the right side of the request page. The more votes, the greater the chance an enhancement will be addressed by the Development Team, taking into consideration the general interest.

Take some time to examine the full list and vote for the enhancements you would like to see implemented.

Gary Ben-Israel

Informix corner Back to top


Learn about Parallel Sharding on IBM Informix

Eurotech's IoT gateway embeds Informix

Iot Informix Demo Series

Informix Storage and RAID5 - Doing Storage the Right Way!


High availability best practices for IBM Informix

Developing hybrid applications using IBM Informix


Raspberry Pi 2 + IoT Foundation + Bluemix + Informix

Informix IoT event at Seattle

Join IBM and its Key Partners for a special event at the IBM Briefing Center in Seattle on 13th December. This half-day event will feature real world solutions using the latest IoT, cloud and analytics technologies. Come and learn how leading edge solutions can be implemented now and take the opportunity to meet the IBM and Key Partner teams supporting IoT industry solutions. Register for the event here.

Informix News Back to top

Lifehacker: Three Things IT Pros Need To Know About The Internet Of Things

Talkin'Cloud: What IT Professionals Need to Know About the Internet of Things

Calendar of events Back to top

May - 2016
Date Event Location Contact
4-8 IIUG 2016 Sawgrass Marriott Golf Resort & Spa, at Ponte Vedra Beach. Florida

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.
Editor:  Gary Ben-Israel

For comments, please send an email to


IIUG Insider sponsored by: