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 #135)
September 2011

Other Issues

Highlights: Continuing Support Offering for Informix versions 7.31, 9.4 and 10

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

The IIUG board will have its next meeting at the IOD conference in Las Vegas 22-27 October. The IOD has always been a spectacular event. If you are attending we will be happy to meet you there. I will report from our board meeting and the conference in the October issue.

We are going to have the 2012 IIUG Informix conference in San Diego California. We are all excited about the new location. We hope the new location will attract new attendees. Don't miss our 2012 conference. As always we can assure unmatched content, quality, speakers and networking. Follow our conference corner and stay up to date with our conference news.

Please visit the conference site http://www.iiug.org/conf and stay tuned.

In Israel we are celebrating the Jewish New Year. I hope and believe it will be a great year for Informix and would like to wish you all a happy new year or as we say in Hebrew "Shana Tova".

Gary Ben-Israel
IIUG Insider Editor


Highlights Back to top

Continuing Support Offering for Informix versions 7.31, 9.4 and 10

Launching October 1, 2011 and available through September 30, 2013, IBM is offering the Continuing Support Program for clients running Informix versions 7.31, 9.4 and 10 to receive non-defect assistance. This offering is a continuation of the initial pilot program launched October 1, 2010. This flexible offering provides an affordable option for clients who are not yet ready to upgrade, as it is included with their Subscription and Support renewal. Continuing Support is an alternative to, but not a replacement of, our current Service Extension and Total Content Ownership options. The Continuing Support Program will end September 30, 2013.

Continuing Support provides our clients with access to pre-existing and available fixes and is designed to keep our clients running on Informix software until they are able to upgrade to the current version of Informix.

For detailed information to share with your clients, please visit the Informix Continuing Support briefing. If you have any questions, please contact your sales rep or send an email to askIFMX@us.ibm.com.

Technote: http://bit.ly/ContinuingSupportTech

Pradeep Kutty
Sr. Manager - WW Informix, Data Warehouse and Analytics Support
IBM Information Management Division


Conference corner Back to top

2012 IIUG Informix Conference San Diego, California

Call for Speakers - Submit a proposal to present at the 2012 International Informix Users Group (IIUG) Conference.

The IIUG Conference Planning Committee is ready to accept presentation proposals for the 2012 IIUG Conference which is to be held April 22 - 25, 2012 at the San Diego (CA) Marriott Mission Valley, USA.

Do you have experience with Informix or Informix related products? Do you have real-case studies related to Informix solutions? Have you discovered any Informix hints or tips? Are you interested in sharing your Informix knowledge and skills with the Informix User community? If the answer is yes to any of these questions the IIUG CPC invites you to submit a proposal to speak at the 2012 Conference.

The 2012 Conference will be comprised of more than 80 technical/user sessions, a series of hands-on-labs and 1 day of comprehensive tutorials intended to reinforce the power of Informix. Presentation proposals should be brief, but more than 250 words, highlighting the Informix technical solutions, real world experiences or trade tips you will include in your presentation. Multiple presentations are encouraged.

If sharing your knowledge is not enough, conference speakers (non IBM employees) are provided with a complimentary pass providing access to conference sessions, meals and conference related networking events. Use http://www.iiug.org/conf/speakers to register your proposal. The deadline for submitting 2012 IIUG Conference proposals is November 1, 2011. For your convenience, speaker logins have been retained for those who submitted a 2011 IIUG Conference proposal. Don't delay - submit your proposal and biography today for consideration.

See you in San Diego!

The 2012 IIUG Informix Conference Team
www.iiug.org/conf
conference@iiug.org

Have you registered for IOD 2011 Yet?

Hurry up - Just a few moreweeks left to go.

The 2011 IOD conference has a lot in store for the Informix user with many exclusive sessions focused around Informix. Here is a select list of session that (with the session ID's) which would be of interest to you during the conference:

IM Informix and Tools Informix Application Development

  • IDS-1546 Keynote - Smarter Data Management with IBMInformix
  • IDS-3782 Birds of a Feather - Informix ApplicationDevelopment
  • IDS-3784 Ask the Experts - Developing InformixApplications - Everything You Need to Know

IM Informix and Tools Informix for Energy Utilities Industry

  • IDS-1546 Keynote - Smarter Data Management with IBM Informix
  • IDS-3780 Birds of a Feather - Enabling TimeSeries. Spatial, and Geodetic Applications with Informix

IM Informix and Tools Informix General

  • IDS-1546 Keynote - Smarter Data Management with IBM Informix (Jerry Keesee presentation)

IM Informix and Tools Informix Warehouse

  • IDS-3779 : Birds of a Feather - Building Data Warehouses with Informix
  • IDS-3785 : Ask The Experts - Achieving Faster Business Intelligence with Informix Warehouse and Cognos

Registration for IOD 2011 today: http://www.ibm.com/software/data/2011-conference.


Education Back to top

IBM Webcasts

IBM Webcast: Data Management for a New Generation with IBM Informix & Exclusive Informix Offer!

Date: Oct 4, 2011
Time: 1:00 PM - 2:00 PM (Eastern Time)
Hosted By: Kristine Enes (IBM)
Presented By: Tom Rieger (IBM), Scott Whalen (IBM)

This session is designed for new and pre-existing version users to learn about why Informix still is the best solution from the most mundane of data needs all the way to your largest of systems. We will show examples where Informix is better than any other technology when you combine all of the capabilities around:

  • 'Always on' with dynamic reconfiguration, self tuning and the most flexible replication in the industry. This is about 100%uptime.
  • 'Always smart' with the ability to bring a large number of users into a database to ask the hard questions around data warehousing and analytical processing. Hundreds of concurrent users wanting Google like response times.
  • 'Always flexible' as Informix is the only enterprise database that can run and replicate between operating systems, tiers, versions and geographies. It can grab and return resources ondemand for your worst case scenarios.
  • 'Always fast' for transactional, warehousing and mixed environments. Do your users now expect those queries that took minutes before to run in seconds? Are you looking to bring your corporate data to more and more users - both inside and outside your organization? Oracle cannot do this. Microsoft doesn't know how. Teradata falls apart with too many concurrent users.
  • OH - did we mention you can do all this for a fraction of the cost? License cost, hardware cost, people costs. We know your accountants care about that.

Featuring live Q&A with: Tom Rieger & Scott Whalen, IBM Informix SWAT Team Leaders.

Join us to learn about how you can take advantage of a limited time exclusive Informix offer!!

Register today: http://bit.ly/mPKJFE

The 'Always Smart' Database & Exclusive Informix Offer!

Date: Oct 11, 2011
Time: 1:00 PM - 2:00 PM (Eastern Time)
Hosted By: Kristine Enes (IBM)
Presented By: Tom Rieger (IBM), Scott Whalen (IBM)

Terms like 'data warehousing', 'star schema' and 'OLAP' have been around for 20 years. Through that time, you would think it would have become easier and cheaper for organizations to get to where they want. Add space this session is designed to be a deeper discussion around the capabilities IBM brings to market around data warehousing and analytics. This session will discuss the need to:

  • Scale concurrent user counts into the 100s or 1000s (maybe this is how technical people represent but I just think writing the values hundreds or thousands looks more proper...I'm crazy though so...)
  • Manage a mixed workload - that need for transactional application users? and those 'ugly' queries to coexist and not effect each other's performance.
  • Google-like performance with your data. People do not want to wait for minutes or hours any longer.
  • Lowest total cost. Enable all this with the lowest required investment for hardware with "Always On"software requiring little to no attention.

Oracle cannot do this. Microsoft doesn't know how. Teradata falls apart after many concurrent users.

Featuring live Q&A with: Tom Rieger & Scott Whalen, IBM Informix SWAT Team Leaders.

Join us to learn about how you can take advantage of a limited time exclusive Informix offer!!

Register today: http://bit.ly/pkMQnL


Developer corner Back to top

New in DeveloperWorks

Informix Warehouse Accelerator: Create a data mart
http://www.ibm.com/developerworks/offers/lp/demos/summary/im-iwacreatedatamart.html
Learn how to use the administration interface to create a data mart definition, validate the data mart structure, deploy the data mart, and load data into the data mart.
07 Sep 2011

Informix Warehouse Accelerator: Explore the accelerator interface
http://www.ibm.com/developerworks/offers/lp/demos/summary/im-iwaexploreinterface.html
Become familiar with IBM Smart Analytics Optimizer Studio, the Eclipse-based administration interface for Informix Warehouse Accelerator. Learn how the different views and menus are used to interact with Informix Warehouse Accelerator.
07 Sep 2011

For more information go to DeveloperWorks - Informix: http://www.iiug.org/url/devworks.html

Modernize your Informix 4GL application now with Genero.

Your IBM Informix 4GL applications are fundamental to your business, but they need modernizing now. How? They are too important to disrupt, too costly to rewrite, and packaged applications simply don't cut it. The answer is simple - Genero. With Genero, your application can be modernized quickly, at low cost and no risk.

By modernizing your applications with Genero you will:

  • Run existing applications on the desktop, web or smartphone concurrently
  • Save time on needless re-development by preserving your existing code
  • Protect tens of man years of investment in domain specific development
  • Protect your domain knowledge resources and competitive edge
  • Be ready to adapt applications rapidly to changing market needs and business models (mobile, SaaS etc...)
  • Give users the state-of-the-art user interface they deserve
  • Improve developer productivity
  • Run apps indifferently between Unix, Linux, iMac or Windows without recompilation

See how easy it is by watching this short hands-on webinar demonstrating the modernization of the Informix Stores demo.

For more information contact us here: http://www.4js.com/en/contact

Four Js Development Tools


Informix news Back to top

PR

IBM Offers Database Solution to Enable Smart Meter DataCapture
Utility companies are expanding on their efforts to develop the smart grid through the use of smart meters. IBM suggests that to realize the full potential in smart meters, utility companies and their partners must leverage a data management solution that is designed specifically to reduce data load times, improve query performance and decrease thestorage capacity needs for time series data http://bit.ly/IBMSMA

MDM offers scalability to 100 million smart meters
http://www.metering.com/MDM/offers/scalability/100/million/smart/meters

IBM claims new performance benchmark in smart meter data management
http://bit.ly/nfmVMV

Case Study

An Informix success story
Böckmann Fahrzeugwerke Achieves 20 percent increase in productivity working with Adaptris and using Informix Genero. Read the complete story here http://bit.ly/InfCSBF

McLEOD RUSSEL INDIA LIMITED: Eliminating downtime in the tea trade with IBM Informix
http://bit.ly/ICSMRI

New Informix Video

Have you seen the new Informix video about Informix TimeSeries for Smart Meters? http://www.youtube.com/watch?v=q0sqYyG7Jqk

Informix Benchmark Report

New Informix Benchmark Demonstrates Unprecedented Performance & Scalability for Meter Data Management. Read the resultsshowing Ten Million Meters Scalable to One Hundred Million Meters for Five Billion Daily Meter Readings http://ibm.co/oEGWA6

IBM Offers Database Solution to Enable Smart Meter Data Capture

A recent IBM paper, Build Smart Metering Solutions with IBM Informix TimeSeries, explores how smart meters change how utility companies capture data, which creates new possibilities for the use of that data http://bit.ly/ISMDMW


Support corner Back to top

Bypassing Multi-Index Scan

Informix introduced several data warehousing features to its query processing operation in recent past. One of these warehousing features is Multi-Index Scan. A search path based on an access method that uses more than one index on the same table is called a multi-index scan.

Queries in earlier version of Informix typically use no more than one index to scan each table for qualifying rows. With multi-index scan feature the query optimizer can combine one or multiple B-tree indexes and the Boolean operations in the WHERE clause to fetch qualifying data rows. It provides better performance than full-table scans, both for OLTP queries and for data warehousing applications that query large tables. Now you can create up to sixteen indexes on a table and optimizer can search all indexes.

By default, the multi-index scan feature is enabled. However, in certain situation you may need to turn off multi-index scan feature; for example:

  • Comparing performance between other access methods
  • Unsatisfactory query performance while optimizer choosing MULTI INDEX PATH query path automatically

You can try one of following to turn off multi-index scan feature:

  • Use the +AVOID_MULTI_INDEX directive at query level.
  • Use **Undocumented** configuration parameter MULTI_INDEX_SCAN, set it to 0 in Informix configuration file to turn off system wide.

Please contact Informix Technical Support for additional assistance to resolve any issues with multi-index scan.

Sanjit Chakraborty


Informix resources Back to top

Informix blogs and things  
 
Calendar of events Back to top

October - 2011
Date Event Location Contact
4 IBM Webcast: Data Management for a New Generation with IBM Informix    
4-6 Informix 11.7 Performance Tuning Bootcamp Zagreb, Croatia Alfatec
5-7 Informix 11.7 Bootcamp Kenya, Nairobi  
7 Informix TimeSeries Bootcamp Zagreb, Croatia Alfatec
10-12 Informix 11.7 Bootcamp Kenya, Nairobi  
11 IBM Webcast: The 'Always Smart' Database    
11-13 Informix 11.7 Performance Tuning Bootcamp Zagreb, Croatia Alfatec
13 Toronto Area Informix User Group Meeting IBM, Toronto Canada  
17 Informix Performance Tuning Bootcamp Sao Paulo, Brazil  
18-20 Informix 11.7 Performance Tuning Bootcamp Sao Paulo, Brazil  
23-27 Informix on Demand 2011 Las Vegas, Nevada  
24-26 Informix Performance Tuning Bootcamp Shanghai, China  
26 Informix Warehouse Accelerator Bootcamp Shanghai, China  
 
November - 2011
Date Event Location Contact
1-3 Informix 11.7 Technical Bootcamp Kuala Lumpur, Malaysia IBM
8-10 Informix 11.7 Bootcamp Paris, France  
10 2011 Informix Community Event London, UK Sandra Rye
15 Informix Warehouse Accelerator Bootcamp Warsaw, Poland  
16 Informix TimeSeries Bootcamp Warsaw, Poland  
 

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

For comments, please send an email to gary@iiug.org.