Save 
Join IIUG
 for   
 

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 - BernieSpang.com - 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 - BernieSpan.com - 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 - planetIDS.com - DNS impact on Informix / Impacto do DNS no Informix... Read
8 Sep 11 - TMCnet.com - 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 - planetIDS.com - 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
Insider

IIUG Insider (Issue #173)
November 2014

Other Issues

Highlights: Compare the Informix Version 12 editions

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.

Contents:

 

Editorial Back to top

I'm enjoying beautiful Belem do Para, Brazil. It has nothing to do with Informix. The reason I'm telling you about it is that it's my excuse for a short issue of the Insider. I hope you will still enjoy it and find some useful stuff.

Now that IBM Insight is behind us, it is time to prepare for the IIUG conference which is to be held Sunday April 26 - Thursday April 30, 2015 at The Marriott Mission Valley, San Diego, California, USA. Mark your calendars and make sure you attend. The insider will provide you all the information you need. Stay tuned.

Gary Ben-Israel


Highlights Back to top

Compare the Informix Version 12 editions

Learn the differences in features, functions, and pricing models.

Confused about the various editions of IBM Informix? Get an introduction to each edition 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.

Read all about it at at developerWorks.


Conference corner Back to top

IIUG 2015 Registration is now open!

As I am sure you know by now, IIUG 2015 is returning to San Diego, CA April 26-30, 2015 and the beautiful Marriott Mission Valley. We received a lot of positive feedback asking us to return to San Diego.

It has been a year since we were at the Marriott Mission Valley. There have been some recent renovations to the lobby and the guest rooms while we have been away. For those of you the have never been here, the hotel has a fantastic heated pool with whirlpool as well as a Fitness Center with cardio equipment and free weights. There is a great jogging and fitness trail for those who want to get away from the hotel and you are only steps from the Rio Vista Trolley with access to many of the top attractions in San Diego.

The Conference Planning Committee met in November to review and select the content and speakers for IIUG 2015. There were many great abstracts submitted. If you submitted a proposal, you will be hearing from a CPC member in the next week or so if you haven't been contacted already. As far as content goes, here is an idea of what you can expect:

  • Certification Testing Review
  • Troubleshooting and Performance Tuning
  • IWA
  • TimeSeries
  • Internet of Things
  • NoSQL/JSON
  • Development
  • Cloud (ER, HDR/SDS/RSS)
  • Security
  • Hands on Labs
  • Thursday Tutorials (Full and Half Day)

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

Very tentative schedule, similar to last year:

  • Sunday - Welcome Reception with food and open beer and wine bar
  • Monday - Breakfast and Lunch, AM Keynote, Conference Sessions including Certification Testing Review, Hands on Labs, PM Event/Party with food and open beer and wine bar
  • Tuesday - Breakfast and Lunch, AM Keynote, Conference Sessions, Hands on Labs, PM Event/Party with food and open beer and wine bar
  • Wednesday - Breakfast and Lunch, Conference Sessions, Hands on Labs, No PM Event
  • Thursday - Breakfast and Lunch, Tutorials

One more thing about IIUG 2015, the IIUG will be celebrating 20 years as an organization. We will be having some special activities and are looking forward to all our attendees to help us celebrate this momentous event.

Registration is now open at http://www.iiug2015.org/register.php. Register for IIUG 2015 by January 15, 2015 to receive a $250 discount over the Regular conference price. Don't forget that all IIUG members can save an additional $100 on registration through April 7, 2015. IIUG membership is free at www.iiug.org so become a member today.

We are looking forward to seeing many familiar faces and hopefully some new faces in April.

- IIUG 2015 Conference Planning Committee


Support corner Back to top

123 REST...

I had an opportunity recently to speak with Lance Feagan, one of the Informix Architects. I asked him - what exciting things are you working on with Informix? A lot of our conversation was technical, but I was impressed to see genuine excitement as he was telling me about CORS REST, also known as Cross-Origin Resource Sharing with the REST API. While the REST API has been present for a couple releases now, I was swept up into his excitement with the CORS part of the story.

CORS with REST means there is a handful of optional parameters that were added to the jsonListener.properties file which enable the developer to configure HTTP headers. These parameters provide access to JSON fields that are needed by synchronous JavaScript + XML (AJAX) applications in a web browser when these applications access the REST listener. A non-technical way to say this: using a browser interface, we can securely exchange data with just about any database vendor, with very little programming!

Many old-timers might recall the Informix product used to provide data exchange with database vendors other than Informix. It is called the 'Enterprise Gateway Manager'. EGM has quietly done its job for many years, and provided a way to hook up diverse database software vendors to Informix Dynamic Server. In other ways, while the EGM communication is functional, it has never been 'robust'. With the Cross Origin Resource Sharing and the Rest API, we can now directly connect applications or devices that communicate through the REST API to Informix. By configuring the wire listener for the REST API, you can use MongoDB and SQL queries against JSON and BSON document collections, traditional relational tables, and even time series data. The REST API uses MongoDB syntax and returns JSON documents. With very little extra syntax the JSON output can be structured and saved (or retrieved) into normal use Informix tables and databases.

For a deeper Introduction to JSON, BSON, REST, and things to do with it, visit the knowledge Center pages for Whats new with the IBM Informix 1210xC4.

- David Jay


Informix news Back to top

CNN Money, 6 Nov 14 - Datawatch Wins IBM Insight 2014 Hackathon with Innovative Internet of Things Visualization App

Datawatch Corporation (NASDAQ-CM: DWCH), a leading global provider of visual data discovery solutions, was the winner of a recent Internet of Things (IoT) Hackathon at the IBM Insight 2014 Conference last week in Las Vegas. The Hackathon was designed to foster new ways to develop cloud-based IoT solutions using Informix as the database repository for sensor data. IBM provided a store of real-time sensor data that could be used to create applications ranging from municipal water usage monitoring to truck fleet maintenance to analyzing the flow of people and traffic in retail stores.

InformationWeek, 10 Nov 2014 - HP extends benefits of ARM architecture into the data center with new servers

HP announced two ARM-based servers, including the first enterprise-class 64-bit ARM-based server, for customers that value choice in their compute strategy...Available today IBM Informix is the only commercially available database to run HP's new micro server architecture-ProLiant Moonshot. Informix offers a unique combination of flexible grid technology and efficient data architecture that can enable commercial grade workloads to take advantage of these new server architectures.

IBM Data Magazine, 23 Nov 2014 - Meeting the Fast-Growing Chinese Database Demand

Informix brings a high-performance business database platform to China.


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 for 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.

Check at this place.

New RFEs for November 2014

Apparently November FRE activity was weaker than last month, maybe a drop of energy with the fall.

Add tablename to -640 error
Error -640 demonstrate a sanity failure in the query plan( Never caught this one). The error message does not show any table name(s). Request to indicate the table name(s) in the error text.

CTAS (Create Table As)
Request to implement create table as in the DDL syntax. This functionality has already been implemented in 12.10 xC1

"dbschema" for replicate definitions.
With ER, recreating replicates and replicateset definintions is not a simple operation, and even worse when dealing with hundreds of replicates, or more... I like this one really. It would simplify enormously the ER administration. Request to implement the possibility to dump replicates and replicatesets definitions within the dbschema utility, just like dumping SPL or the storage space and logical logs definitions.

Include the regexp datablade into the Informix product
As of today, regular expressions are handled by a datablade developed by a Canadian university and reviewed by Chris Boch at Informix Software. (check here) This datablade should definitely be (first perform a QA then) implemented into the regular editions. Request to include regular expressions into Informix

Request to back port Informix internal RTC # 22663 to V11.7
Inforshpere Gardium allows auditing the IFMX traffic between server and clients. It cannot work when encryption is used. An Informix utility will be created to use the Guardium library, allowing auditing of the connection by the DBSA.

Command to recreate all the CDR DEFINE SERVER/REPLICATE commands from the syscdr database
This RFE is very similar to "dbschema for replicate definitions". The requirement is definitely the same, the requested implementation is different. One of both ways will have to be chosen. I personally prefer the dbschema one, which seems to be more versatile once you can pick what you want from the output. Request to implement an easy way to rebuild replicates and replicates set.

New feature to have FORCE_DDL_EXEC functionality for all DDL changes
12.10 implemented a new environment variable FORCE_DDL_EXEC that allows to force out current transactions/locks running on 'unidentified' tables in order to execute an ALTER FRAGMENT on TABLE operation. The idea of this request is to have a similar mechanism that could be used for schema modifications. This mechanism can be very handy when dealing with thousands of sessions, avoiding complex scripting to identify where are locks and which sessions are locking. Request to implement a mechanism to force out transactions before executing DDL operations.

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.

Eric Vercelletto


Informix corner Back to top

Washington Area Informix User Group meeting

Our next Washington Area Informix User Group meeting is coming up - Thursday, Dec 11, 8:30 AM — 12 Noon at the IBM office in Washington DC. I hope you will attend. Please register now.

This event will feature content rich presentations by leading Informix Users and experts that will most certainly touch on aspects of the Informix software features that you are using and may be interested in.

  • Art Kagel, Independent consultant and IIUG Board Member, will present on programming, concurrency, and tuning applications against Informix
  • Carlton Doe, IBM Informix Database Specialist, presenting on Informix Flexible Grid
  • Tom Beebe, Advanced Data Tools consultant and IIUG Board Member, will speak about running Informix on the ARM architecture

Date: Thursday, December 11, 8:30 — Noon
Location: IBM, 600 14th St NW, Washington DC

There are 2 metro train stations very close by. Metro Center is 2 blocks to the East and McPherson Square is 3 blocks to the North. There are also pay garage parking alternatives in the close vicinity.

The start time will be 8:30 (doors open at 8:00).

Please register at http://www.waiug.org.

London "Internet Of Things" Event

Event Title: Constructing the IoT solution: Creating real world sensor-to-business value Internet of Things applications

Event Details: With the emergence of Internet of Things (IoT) and the proliferation of connected devices, businesses of all types - manufacturers, servicing organizations, public utilities for electricity, gas, water, and heating are adopting the use of sensor technology to lower operating costs and increase business value. This is driving the need for instant access to information for speed-of-thought insight and the ability to deliver new services in record time.

IBM and Hildebrand are holding a special event at the IBM Executive Briefing Center at Southbank, London on December 10. This half-day event will feature a real world solution using IBM Cloud TimeSeries technology with Hildebrand data collection and analytics solutions. Participants can learn how real world solutions can be implemented now and take the opportunity to meet the IBM team supporting IoT industry solutions in the UK.

Is your business ready for the Internet of Things?

Download this one-pager that explains the challenges faced by organizations that are already developing plans and experimenting with IoT solutions to hone their competitive edge. Get a feel of IBM Informix, the Intelligent Database for IoT.

View the one-page here.


Calendar of events Back to top

December - 2014
Date Event Location Contact
11 Washington Area Informix User Group Meeting IBM Office, Washington DC James Edmiston
April - 2015
Date Event Location Contact
26-30 2015 IIUG Informix Conference San Diego, CA Cindy Lichtenauer
 

Informix resources Back to top

IBM Informix home page

http://www.informix.com or directly at: http://www-01.ibm.com/software/data/informix/

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

http://www.iiug.org/quicklinks.html


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.