Highlights: IIUG Announces 2014 IIUG 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.
- Conference corner
- Developer corner
- Informix news
- Informix corner
- Support Corner
- Calendar of events
- Informix resources
- Useful links
- Closing and credits
|Editorial||Back to top|
Between now and May 2014 the IIUG conference will be at the center stage of the Insider. The IIUG conference team will keep you updated with the greatest and latest conference news. We hope moving to Miami will be an advantage to EMEA and Latin America attendees. Shorter and cheaper flights and a smaller time difference.
Miami is a great location. The JW Marriott is a beautiful hotel and it is going to be a fabulous conference. Take my advice and register early to ensure you get a room at the hotel. We hope the number of attendees will exceed the hotel capacity so make sure you are at the conference hotel and save yourself the daily travel.
Between now and our conference there is the major IBM Data Management event of the year. The IBM Information On Demand conference will take place in Las Vegas November 3-7. If you are attending don’t miss the Informix party on Sunday November 3.
September 5 is the Jewish New Year. When you will receive this issue it will be 5774 according to our count. I would like to wish you all a happy new year or as we say in Hebrew, Shana Tova.
IIUG Insider Editor
|Highlights||Back to top|
The International Informix Users Group (IIUG) would like to announce the 2014 IIUG Informix conference, which will be held April 27- May 1, 2014 at the JW Marriott, Brickell Ave, Miami, FL, USA. This year’s conference hopes to follow the 2013 conference schedule, with a kick off welcome reception Sunday evening April 27 at the hotel. The opening session will begin on Monday morning April 28. The conference will continue through Wednesday late afternoon and offer the complimentary conference tutorials to all paid attendees on Thursday May 1. We have purposely given you Wednesday evening off so that if you are staying for the tutorials you can visit famous South Beach or enjoy the Latin flare and fun Miami offerings.
This year’s conference team is excited to move to the east coast of the USA. We expect the conference will be completely sold out. Miami is an airport hub to South America, a major airport hub to Europe for American Airlines and for One World airline alliance.
The JW Marriott Hotel Miami has received numerous recognitions including, Best Design Award by Marriott International, Overall Guest Satisfaction Award, Connoisseur’s Choice by Resorts & Great Hotels, and the Wine Spectator Award 2007-2010. Being selected One of the World’s Best Business Hotels by Travel & Leisure Magazine is one of the most recent accolades. The JW Marriott Hotel Miami offers a one-of-a-kind experience that allows you to enjoy the comforts of home during your stay. This award-winning downtown Miami hotel blends the features of a premier conference and meeting facility with timeless elegance, thoughtful amenities and award-winning service. Elegantly furnished guest rooms and suites offer the finest details, including marble tubs, high-speed Internet and flat-screen televisions. Relaxation is as close as the luxurious spa and the unique stainless steel pool.
For more information, visit the official conference web site at http://www.iiug2014.org or read all about it in the monthly IIUG Insider newsletter.
See you in Miami, FL, USA
April 27 – May 1, 2014
|Conference corner||Back to top|
Winning in the era of smart with game-changing innovations from IBM Business Analytics
Les Rechan, General Manager, IBM Business Analytics
Information Management with Speed, Simplicity and Confidence
Bob Picciano, General Manager, IBM Information Management
Enterprise Content Management
Smarter content. New insights. Better outcomes.
Doug Hunt, Enterprise Content Management Business Leader
The Forward Thinker: Creating Value through Big Data & Analytics
Moe Trebuchon , Partner – North America BAO Service Line Leader
To register and to know more details, click here.
Early Bird Registration for Information On Demand 2013
Register with the Early Bird discount for the best savings between now and September 13. Register today.
Conference hotel accommodations are limited and are on a first-come, first-served basis. Please arrange your accommodations on-line as part of the registration process.
|Developer corner||Back to top|
|Topic:||Combining Structured and Unstructured Data for Powerful, Big Data Enterprise Applications
|Date:||Tuesday September 24th, 8:30 AM Pacific, 10:30 AM Central, 11:30 AM Eastern, 4:30 PM London, 5:30 PM Paris|
|Time:||10:30 am – 12:00 pm (Central Time)|
|Presented by:||Jerry Keesee – Director, IBM Informix Database Development (IBM)
John Miller III – Informix Architect (IBM)
NoSQL databases are known for their ability to store rich, unstructured document data for ready access by burgeoning web and mobile applications, but their lack of support for relational database concepts limits their use in mission-critical, enterprise applications.
Now, developers of web and mobile applications no longer have to sacrifice reliability and transactional integrity when dealing with semi-structured and unstructured data. They can instead build compelling Web and mobile applications utilizing NoSQL storage and query concepts along with traditional SQL.
Attend this webcast to hear how enterprises, large and small, can develop applications that bridge the gap etween new computing technologies designed for big data, cloud, and mobile computing, with their enterprise world of relational data.
Register for this event here.
For questions about this event, contact the host at email@example.com.
|Informix news||Back to top|
Publications for the IBM Informix 12.10 family of products: This document contains links to publications, including online information, PDF files, release notes, and more, for the IBM) Informix) 12.10 family of products, including client products and Informix DataBlade) modules. To know more, click here.
Publications for IBM Informix Enterprise Hypervisor Edition 12.10: This document contains links to English publications, including online information, release notes, and PDF files, for IBM Informix Enterprise Hypervisor Edition 12.10. To know more, click here.
Solution to a technical issue: IDS install returns: lax.nl.message.vm.not.loaded = The installer either could not find a Java VM, or the Java VM on this system is too old. To know more, click here.
onpload ipload HPL onpladm data looks corrupted and will not load : You used onpload, ipload, HPL, or onpladm to unload data from a table. You try to load it into your target table but no rows are loaded. You look at the file and see that it is not all readable, ASCII data but has control characters and is not very readable. To know about the solution, click here.
Proof of Technology: Introduction to Informix: This Proof of Technology will introduce the student to the basic architecture and functionality of the Informix database engine. Concepts such as logical and physical design will be discussed along with best practices for implementation, monitoring, backup and recovery and other basic day-to-day operations. To know more, click here.
Big Data and the Internet of Everything: A brave new world of possibilities. See more here.
Three Data Categories Likely Missing in Your Data Warehouse : Both data warehouse managers and data scientists should jointly evaluate these potential sources of useful predictors. See more here.
Ten Years Later, Does IT Matter? Taking a look back on Nicholas Carr’s seminal article from 2003. See more here.
IBM was the biggest Big Data vendor in 2012 by revenues, with $1.3 billion from Big Data-related products and services, according to a recent Wikibon report. Offerings include server and storage hardware, database software, analytics applications, and associated services. Best known products are the DB2, Informix and InfoSphere database platforms, and Cognos and SPSS analytics applications. IBM also supports the Hadoop open source data analytics platform.
View the article.
Power outages have been an on-going problem in Texas, especially during the overheated summer months. Damage to equipment, from thunder storms, cause the bulk of the outages; increased consumer demand, on an already overtaxed grid, are also a large contributing factor.
The system uses IBM?s Informix database software, which can load meter data 20 times faster than the current system. The upgrade will not only provide faster data access, but because it uses a time-series structured data management system, it will reduce data storage needs by 70%.
View the article.
|Informix corner||Back to top|
IBM CIO Forum and Executive Infobahn is coming to a city near you! Register today for this Free workshop – Select a date and city that works best for you.
To know more click here
|09/04/2013||Quito, Ecuador||Learn more|
|09/05/2013||Caracas, Venezuela||Learn more|
|09/10/2013||Stockholm, Sweden||Register here|
Be sure to register for one of the no-charge technical events designed to give you insight into IBM Informix 12.1 technology that solves some of the toughest business problems in the world today. Register today!
Seattle: September 16 & 17
Atlanta: September 19 & 20
Montreal: September 25 & 26
Phoenix: October 3 & 4
To register, click here.
|Support corner||Back to top|
After an upgrade query running slow
You have upgraded to Informix 11.70.xC3 or higher version. After upgrade encountered some of your queries running slow. The common observation, a query was using index path prior to upgrade and running faster. After an upgrade the same query is doing a sequential scan. Using an index directive the query uses the index and runs much faster than the sequential scan. However, the index path has a higher estimated cost associated with it than the sequential scan.
Also, after an upgrade it could be seen that the optimizer chooses a different index in the newer version of Informix than it did in the prior version and causing the query to run slower.
A newer costing functionality was added in 11.70.FC3 and higher in the 11.70 family. This functionality was added to account for the seek time required to traverse an index (especially large indexes). There were situations where queries using an index would take longer to return than a sequential scan because of all the I/O involved.
You can control the new costing functionality using the OPT_SEEK_FACTOR configuration parameter. This parameter allows to set the “weight” of an I/O seek cost. The range is 0 to 25 and default is 6. Making it lower causes the seek cost to be lower which lowers the estimated cost of using an index path.
You can revert to the old costing method by setting OPT_SEEK_FACTOR to 0 in the ONCONFIG file.
– Grant Flander
|Calendar of events||Back to top|
|September – 2013|
|4||Colorado Informix User Group Meeting||Denver, Colorado|
|4||Informix User Group Meeting||Quito, Ecuador||Louis Cherian|
|5||IBM Informix Infobahn||Piscataway, New Jersey||Anita McKeithen|
|5||Informix User Group Meeting||Caracas, Venezuela||Louis Cherian|
|10||Swedish Informix User Group Meeting||Stockhom, Sweden|
|12||French Informix User Group Meeting||IBM, Paris, France||Khaled Bentebal|
|12||IBM Informix Infobahn||Los Angeles, California||Anita McKeithen|
|16-17||2013 Informix 12.10 Technical Roadshow||Seattle, Washington||Carlton Doe|
|19-20||2013 Informix 12.10 Technical Roadshow||Atlanta, Georgia||Carlton Doe|
|24||Informix User Group Meeting||Sofia, Bulgaria|
|25-26||2013 Informix 12.10 Technical Roadshow||Montreal, Canada||Carlton Doe|
|12-13||2013 Informix Technical Roadshow||London, England||Scott Pickett|
|17-18||2013 Informix Technical Roadshow||Paris, France||Scott Pickett|
|October – 2013|
|3-4||2013 Informix Technical Roadshow||Phoenix, Arizona||Carlton Doe|
|November – 2013|
|3-7||IBM Information on Demand 2013||Las Vegas, Nevada|
|5||IBM Informix Infobahn||Dallas, Texas||Anita McKeithen|
|12||IBM Informix Infobahn||Chicago, Illinois||Anita McKeithen|
|Informix resources||Back to top|
I am trying something new on this section. I will first mention the blogs and wikis that have been updated during the last month. Blogs and wikis that have not been updated for over 6 months will be removed.
Blogs and Wikis that have been updated during the last month
- PlanetIDS: Blogs, Videos, News and more *** Up to date feeds from many blogs ***
- Fernando Nunes
- IDS Experts blog
More Blogs and Wikis
- Informix documentation team
- John Miller
- Roger Powell
- Louis T. Cherian
- Eric Vercelletto (In French)
- Keshava Murthy
- Jacques Roy
- Andrew Ford
- Art Kagel
- Gary Proctor
- Eric Vercelletto’s English Website
- The IIUG forums
- Informix Marketing channel on YouTube
- IBM data magazine
- Credentials, the IBM Certification Newsletter
- The Informix Zone
There is now an Informix group on LinkedIn. The group is called “Informix Supporter”, so anyone loving Informix can join, from current IBM employees, former Informix employees, to users. It will also be a good occasion to get in touch with others or long-time-no-seen friends. If you fancy showing the Informix logo on your profile, join.
|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
For comments, please send an email to firstname.lastname@example.org.