|End of Support Dates|
Highlights: IBM Informix Early Validation Program
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.
The greatest Informix event of the year is just around the corner. If you don't plan to attend the IIUG Informix conference, please reconsider. I know some of you would love to come but cannot get your managements to approve. It is the best value for your money if you are planning on Informix education. The variety of topics, the quality of speakers, the opportunity to establish relationships with managers, developers and colleagues is unmatched. This year's conference offers more than that. This is the best place to discover all the new 11.7 features and to learn about the Warehouse Accelerator and Genero. We would like to see as many of you as possible.
See you in Kansas!
IBM Informix Early Validation Program
The IBM Informix Early Access Program provides our clients and partners with early exposure to the next release of IBM Informix, As a beta program participant, you will be able to evaluate and provide feedback on new features and capabilities in Informix before its general availability.
Getting started with the beta program:
To participate in the Informix beta program, please email: email@example.com
Anita McKeithen, PMP
2011 IIUG Informix Conference
Keynotes, Sessions, Sponsors, Tutorials, Hands on Labs, Certification, Food and Drink, Oh My!
The speakers are putting the final touches on their presentations, the hotel is preparing for our arrival and the CPC is fine tuning our game plan for the 2011 IIUG Informix Conference that will kick off in a few weeks.
Have you been waiting eagerly since you registered early in January? Are you staring longingly at your airline tickets in an attempt to make the middle of May get here already? Did you start packing your suitcase already because the excitement is just too much to bear and you need something to distract you? Well, hang in there for just a few more days because the conference is just around the corner and the CPC has been working hard to bring you the best conference for the best price.
We've got keynotes from Top IBM Executives and IBM innovators like Dr. Arvind Krishna, GM for IBM Information Management and Dr. David A. Ferrucci, Principal Investigator for the Watson/Jeopardy project (as seen on TV).
We've got just under 100 technical sessions over 3 full days covering a multitude of topics that makes this the best Informix training event that money can buy.
We've got the best Informix Vendors and Sponsors in the world in the main Exhibit Hall for you to meet with and talk about how they can help you.
We've got a full day of Sunday Tutorials over a wide range of topics to further enhance your training experience.
We've got Hands on Labs by IBM to get you some real world experience with the latest Informix features.
We've got the whole suite of IBM Information Management Certification Tests available to you for FREE!
Finally, we've got enough great food and drink to fill your gullet and wet your whistle.
Did I forget anything? Probably. There is a lot going on, but these are the highlights.
Did you forget anything? OMG! Did you forget to register? Don't worry, it is NEVER too late to register at http://www.iiug.org/conf
Now, if you forget to pack enough underwear and socks, well we can't help you there.
See you in KC,
Andrew Ford and the 2011 Conference Planning Committee
Pentaho Open Source Business Intelligence for Informix
Pentaho is the open source business intelligence leader and Advanced DataTools will show you how to integrate Pentaho with Informix.
Thousands of organizations globally depend on Pentaho to make faster and better business decisions that positively impact their bottom lines. Advanced DataTools is a certified partner and we can help you implement an open source business intelligence solution. The Pentaho BI Suite provides a full spectrum of data integration and business intelligence (BI) capabilities including ETL, OLAP, query and reporting, interactive analysis, dashboards, data mining and a BI platform that has made it the world's most popular open source BI suite.
Pentaho's platform also provides broad enterprise data services including integration with Hadoop for Big Data analytics and support for the company's Agile BI initiative, which enables organizations to build BI applications more quickly, respond to business changes more easily and expedite time-to-value for up to 90% less cost than traditional BI vendors.
For more information visit our exhibit at the 2011 IIUG Informix User conference in Kansas City or visit http://www.advancedatatools.com.Fastest Informix DBA Contest IV at the 2011 IIUG Informix User Conference
Once again Advanced DataTools will be conducting the Fastest Informix DBA Contest at the 2011 IIUG Informix User Conference. The challenge this time will be to optimize an Informix Server to support 1,000 OLTP users. The grand prize an iPad 2! For more information and the results of lasts year's contest, visit:Fred Ho answers questions from Combining OLTP and Extreme Data Warehouse Webcast
The webcast - Combining OLTP and Extreme Data Warehouse, that was presented by Information Week on April 14, featuring Fred Ho, Program Director, Informix, IBM, and Lester Knutsen, President and Owner, Advanced DataTools Corporation, was an unprecedented success with nearly 400 registrants and 300 attendees. The Webcast witnessed very active participation by the audience and a lot of interesting questions came up during the webcast, which have been answered by Fred Ho in his Blog. Please get the complete list of questions and responses from this link:
Discover Informix TimeSeries Event
Discover Informix TimeSeries event is a one day free learning session focusing on the business value delivered by Informix TimeSeries solution.
This free deep-dive technical event provides hands-on experience with the latest IBM Informix release. It is designed to help you gain fresh, innovative ideas for optimizing your business performance and creative competitive advantage. In the hands-on lab, you gain first hand experience in using the Informix TimeSeries server extension to enhance and manage huge quantities of time stamped stream data to get maximum performance and storage saving compared to other solutions. This technology forms the basis of the smart metering solution offered by IBM-Informix. This event will be hosted in Leawood, KS following the closing of the International Users Group Conference.
Register for this event at:
For questions about this event, contact firstname.lastname@example.org.
Anita McKeithen, PMP
Take advantage of fragment-level statistics and smarter statistics in IBM Informix
Compare the Informix Version 11 editions
Also available in:
The Informix Detective Game
Tune your Informix database for top performance, Part 1: Tuning the data model and the application
Evaluate: IBM Informix Developer Edition
Also available in:
For more information go to DeveloperWorks - Informix: http://www.iiug.org/url/devworks.html
Informix Business Partner Newsletter, April, 2011
At the end of March, IBM released the Informix Ultimate Warehouse Edition and Informix Genero - continuing to provide new investment, innovation, and opportunities on the tail of the major Informix 11.7 release last October. These offerings have generated a lot of interest and excitement from all the customers and business partners that I have talked to and they present an amazing opportunity for you to generate new business this year. If you haven't looked into these new offerings yet, I highly encourage you to immediately. You can start by reading Jerry's column below, and then listening to the replays of the enablement webcasts we held a couple of weeks ago. The webcast replay information can be found here:
The IBM team has also been busy preparing for the upcoming Informix users group conference. I hope that you take advantage of this tremendous opportunity to build your Informix skills, as well as broaden your professional network. If you're coming to the conference, I invite you to join us us for our regular Business Partner Council Meeting on May 18th. Let us know if you can attend.
Finally, Informix has been making a lot of noise in the Energy & Utilities industry, specifically around the management of the massive amounts of data being generated from smart meter technology. Informix TimeSeries capabilities reduce the storage costs of this meter data while significantly boosting performance (for example, read the article below about the UK Smart Energy Cloud). To that end, we will be holding a special Informix TimeSeries deep dive workshop exclusively for business partners in the days immediately following the IIUG conference. This class is being offered for free, so I highly encourage you to attend if you want to learn more about this hot area. Space is limited, so please let us know immediately if you can attend!
Ted J. Wasserman
Message from the Informix Development Director
On March 29th, IBM announced new offerings that will reinvigorate your 4GL application development and make your warehousing queries run faster than ever. With IBM Informix Genero, you will be able to develop 4GL for a new generation of mobile and cloud-based applications. Informix Genero includes a reusable framework for developing applications faster than before, sometimes 5 to 10 times faster. With the easy-to-use, graphical integrated development environment you can develop source code once and then deploy it on multiple platforms, web browsers, and ASCII devices.
Gone are the days of "green screen" 4GL applications. Informix Genero provides a cost-effective and time-saving way to modernize your existing 4GL applications without rewriting them in other programming languages such as Java or .NET. Most of the 4GL language keywords are common between Informix Genero and Informix 4GL, and a simple recompilation of your existing 4GL source code is all that is needed. You can even preserve your ASCII deployments and quickly take advantage of Informix Genero web services API.
Additionally, Informix Genero provides capabilities such as customizable user interfaces, report writer, form designer, web services, business logic, and other features that enable you to develop Web 2.0 applications.
For more information about the IBM Informix Genero offering you can visit: http://tinyurl.com/4lxv3r6.
The excitement does not stop there; IBM also announced a new warehouse offering, IBM Informix Ultimate Warehouse Edition, which includes ground-breaking technology for warehouse acceleration, called IBM Informix Warehouse Accelerator. This technology was jointly developed with IBM Research. The accelerator uses extreme compression and hybrid columnar technology to produce highly predictable response times. Customers participating in our Early Validation Program reported query performance improvements that were on an average of 100 times faster when queries were run against the accelerator. One of our beta customers was able to reduce the time to run their analytics workload from over 9 hours to less than 30 minutes,. Now, imagine the competitive advantage of being able to make informed decisions 9 hours earlier than your competitor!
The Informix Warehouse Accelerator is a no knob accelerator! There is no query tuning. There is no administrative overhead, it does not require indexes or MOLAP cube maintenance, and it plugs into your existing Informix environment. It does not require changes in the business intelligence or data warehouse applications or to the application framework running in an existing Informix environment. The Informix engine automatically offloads specific queries to the accelerator. If you're excited about the idea of reducing your analytics queries from tens of minutes to a matter of seconds, you should try out the accelerator and see the performance improvements for yourself.
For more information about the IBM Informix Ultimate Warehouse Edition and IBM Informix Warehouse Accelerator you can visit: http://tinyurl.com/5ty9oyn.
We are also gearing up for the next International Informix User Group Conference, to be held on May 15th - 18th in Overland Park, Kansas — just down the road from the Lenexa Research and Development Lab. The IIUG has developed an excellent program for the conference, with a wide variety of technical content from well-known experts in the Informix Community. Participants at the conference will also have a number of opportunities to hear from IBM executives at Keynote sessions, including Dr. Arvind Krishna, General Manager of IBM Information Management and has responsibility for WW development for Information Management Software within IBM Software Group, and Rob Thomas is Vice President of Business Development in IBM's Information Management Software Division. As you may know, this year marks a major milestone for IBM as it celebrates its Centennial. 100 years brings rich heritage of knowledge and innovation. On Monday's session, Dr. David Ferrucci, lead researcher and Principal Investigator for the Watson/Jeopardy! Project, will talk about his Jeopardy! Challenge to create a computer system that can rival human champions at the game of Jeopardy!. It is an exciting year for IBM and Informix and I hope to see you there so you can experience first-hand the buzz around the new IBM Informix offerings.
Today I will recapitulate an undocumented but very useful feature, which can come exceptionally handy during regular DBA operation. This is not a new feature, it available with Informix for a long time and many of you may already know about it.
I am sure you encountered situation when Informix marked storage space or chunk offline to prevent data inconsistencies. But have you thought how can you mark a storage space or chunk offline by yourself? Let me give an example, you want to perform a warm restore of a non-critical storage space for some reason. But you cannot do a warm restore unless the storage space is offline. You may take different approach to mark a storage space offline but safest way is to use of the ARCHIVE_TEST environment variable. Best part of this feature you can mark a storage space offline without bouncing the Informix instance. As user informix, perform following steps to mark a storage space offline:
You need to consider the ONDBSPACEDOWN configuration settings while marking a storage space offline.
Announcing North San Jose Informix Tech Day 2011 - Please RSVP!
I'm pleased to announce the 2011 Informix Tech Day, to be held in the North San Jose IBM office on May 24. We do hope to see you all there for this event, details as below:
Lunch courtesy of IBM
Please RSVP me at email@example.com so I can get the headcount for the lunch order.
Whether you're new to Informix, or are one of our many loyal clients or business partners, we invite you to spend half a day with us to discover the next decade of Informix at IBM. Learn what's new (we think you'll be impressed); and find out why IBM Informix was voted number one in customer satisfaction for two consecutive years.
Discover Informix Roadshow - UK
For more details contact firstname.lastname@example.org.
Discover Informix Roadshow led by Business Partner - UbCOIT
For more details contact email@example.com.Informix Bootcamps
Informix Performance Tuning Bootcamp for IBM Business Partners.
This Bootcamp provides training in a classroom setting on Monitoring, Tuning, and Troubleshooting techniques for IBM Informix. Detailed presentations and hands-on labs are included where attendees will gain in-depth knowledge of tools and techniques.
For more information or to register for this no-charge workshop, visit:
Informix 11.7 Bootcamp
Informix 11.7 Bootcamp is for clients, Business Partners, and consultants interested in learning more about Informix and how it can enhance the value of solutions and extend market opportunities.
For more information including a detailed agenda, or to register for this no-charge workshop, visit:
Informix blogs and things
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.
For comments, please send an email to firstname.lastname@example.org.