|End of Support Dates|
Highlights: Announcing the 2013 IIUG Informix Conference
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.
Once again we are preparing for the IIUG Informix conference. Once again it will take place in lovely San Diego.
The 2012 IIUG Informix conference was our best conference ever. So we are setting a very high bar for 2013. I am sure we will meet it. So save April 21-24 in your calendar and stay tuned to the IIUG announcements in our conference web page: http://www.iiug2013.org and in the IIUG Insider.
The IIUG Conference Planning Committee and the IIUG Board of Directors will do their best to make it an unforgettable event. We are hoping to present the ins and outs of the Informix new release that is coming up soon. We are urging you to take part in our efforts. In September we will issue a call for presentations. Please submit your abstracts. We need user speakers alongside with our great IBM speakers. As speakers you will receive a free conference pass as a thank you from the IIUG. But not less important you will contribute to the success of the conference the IIUG and Informix.
Remember the 2012 conference was sold out. Take no chances. Register early.
Looking forward to meeting you in San Diego.
Announcing the 2013 IIUG Informix Conference
The International Informix Users Group (http://www.iiug.org) is proud to announce its 2013 Annual Informix conference will be held once again at the San Diego (California, USA) Marriott Mission Valley from Sunday April 21 to Wednesday April 24, 2013. We are also pleased to announce two major changes in the format of this year's conference. First, the conference will begin on Sunday night with a Welcome Cocktail Reception and end on Wednesday afternoon as usual. The tutorial sessions previously held on Sunday will now take place on Thursday April 25th. The second change that should excite everyone is the tutorials will now be included for all paid attendees. We're really excited about this change and we hope that you will take advantage of this huge opportunity to expand your knowledge of Informix.
We will begin accepting abstracts in September and will notify you how you can submit your abstract to speak at IIUG. Our conference is driven by the user community and we would really like to have more users submit abstracts for sessions this year. I've never submitted an abstract before, but I'm doing it this year. So join me if you've been on the fence about speaking. All user/customer speakers who present a session will receive a FREE conference pass as a thank you from the IIUG. If you have an idea for a session the conference team is willing to help you develop that idea. Email me at email@example.com and either I or someone else from the conference team can help you develop your idea into a great presentation.
The conference team is also in the process of choosing a theme for the conference. This year we thought we would open up theme suggestions to you. If you have a suggestion, send it to us at firstname.lastname@example.org. Please submit your conference theme suggestion by September 30, 2012.
Lastly, we anticipate that the conference website will be up soon, and registration for the conference will open shortly after that. We are pleased to make the conference domain easier to find at http://www.iiug2013.org.
So for now, keep the A/C cranked up and the "sodas" on ice. Before you know it we'll smell the salty sea air and bask in the beautiful rays of the San Diego sun.
Information on Demand 2012 updates
Information On Demand 2012 Sample agenda builder
Information On Demand offers 100s of different sessions, hands on labs, and customer speakers. Planning your IOD experience can seem exciting and overwhelming! Learn how to best navigate your way through the conference with the IOD SmartSite. Crysta Anderson shares the new features, tips and a video that gives registered attendees an overview of the site:
Advanced DataTools Informix DBA Class
Our next Informix DBA Class is September 10-13, 2012, This course is definitely on and we have space for 2 more people. This course is for database administrators, programmers, and technical support personnel who will be setting up, managing, and tuning Informix 11 or 10 databases. All courses may be taken online from your desk or at our training center in Virginia. All you need is a web browser and a SSH client (like Putty) to connect to the Training lab.
Quote from a past participant: "I recently had the opportunity to attend (remotely via WebEx) a training course with Lester Knutsen for Informix. This was one of the best investments that we have spent on learning tips to tune and monitor a system. The course was very informative and enlightening. At first I was skeptical of attending a training session remotely but in the long run it was definitely the best way to have been trained. We were able to immediately make checks, changes, and adjustments to our current infrastructure as the course was being taught. Thanks for all your support and help!"
For more information please email email@example.com or visit our web site at http://www.advancedatatools.com/Training/InformixTraining.html.
How to use the ONCONFIG comparison tool onconfig_diff
There a new utility introduced in 11.70.xC4 that helps compare two Informix configuration (ONCONFIG) files and produce the differences. It is really helpful during upgrade process. You can use it for compare your current ONCONFIG to an ONCONFIG from a newer version.
The onconfig_diff is located in $INFORMIXDIR/bin. There are two ways to run onconfig_diff but this document focuses only on the direct comparison of two ONCONFIG files. Here are some ways you can use the utility:
The usage of onconfig_diff utility is as follows:
Here is an example of onconfig_diff:
Following is an output from the above command:
At present the onconfig_diff utility is not available on the Windows platform, but hopefully it will be soon.
- Grant Flender
I am a regular reader of the various Informix forums. I follow closely any commentary that suggests that Informix has no future in the IBM portfolio or the competitive database market. I've been a part of the Informix team since 1993 and have had the mission to lead the Informix business since the assets were acquired by IBM back in 2001. Our goal has been and continues to be to grow the Informix business. We are constantly evaluating the market and making decisions regarding where we believe we can best leverage the Informix portfolio. We align our investments so that we are best prepared to realize growth in these spaces.
Versions 11.50 and 11.70 have been widely adopted. Our Flexible Grid technology is proving to be an asset for both scale out as well as availability while dramatically simplifying administration and the In memory columnar Warehouse (Query) Accelerator adoption has grown rapidly.
I am happy to make either myself or another member of the team available to discuss the Informix commitment with you and your team.
I hope you are all enjoying the Olympics.
Become an IBM Certified Developer: IBM Informix Genero v1 (000-559)Discover Informix in Singapore
Discover Informix in Singapore on the 6th of September 2012 (Thursday) : After successfully conducting Discover Informix events in Malaysia and Thailand in August, we are now all set to visit Singapore on the 6th of September 2012 (Thursday). The event is scheduled to start from 9:00 AM to 12:30 PM at the Marina Bay Sands Convention center, 10 Bayfront Avenue, Singapore 018956.
For more details: http://www.iiug.org/url/singapore.htmlIBM Informix in hybrid workload environments
A White Paper by Bloor Research
An IBM Proof of Technology
Contact for information
IBM Informix Warehouse Accelerator (IWA) delivers superior performance for in-memory analytics processing.SQL OLAP Functions in Informix
Informix is adding a set of SQL OLAP functions in an upcoming release. The following write-up is to introduce the concept of such functions which may be new to Informix users. It is not meant to be a reference manual that lists the complete syntax and optional parameters. These analytic functions are valuable to users because they simplify the expression of complex but commonly used business questions and are efficient without resorting to subqueries or other calculations.
For the full article go to Fred Ho's blog: https://www.iiug.org/url/sqlolap.htmlFind the right information for your Informix version
If you use an external search engine to find Informix. documentation and get hits in information centers, make sure you go to the right information center. For example, often topics in the information center for Informix version 10 are listed before topics in the later information centers. That's because the version 10 information center has been around longer and had more hits. For example, if you search for "Informix create table" you'll get a couple of version 10 information center topics right at the top, but no topics from the version 11.70 information center on the first page of results.
For the full article go to the Documentation Team's blog: https://www.iiug.org/url/searching.htmlBoot Camps
Informix 11.7 Bootcamp
Informix Performance Tuning Bootcamp
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.