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|
Highlights: New Informix Packaging
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.
In May IBM came out with a new pricing and new editions for Informix. Two months later there is a modification to the new offerings. The Ultimate-C free version no longer exists. The Innovator-C edition is now the only free deployable edition available on Mac and Windows. A new low price entry level edition called Choice was added to Windows and Mac. It is tempting to say the first pricing module was poorly planned and the new one is just a hysteric reaction.
I don't think this is the case. The May announcement was carefully planned. The main target was the SMB space the fastest growing market segment. After the May pricing model IBM kept a close watch and talked to many partners and customers. The model was reevaluated and revised. I think it is the right course of action. Please read the highlights section for detailed information.
IBM has a clear road map for Informix, offers a new production free edition, is aggressively promoting Informix in the SMB market place and recruiting new solutions partners. I regard it as a big step forward. Informix always had a technological advantage now it is offered in a competitive price.
New Informix Packaging
New Informix Editions - Creating Growth Opportunities for Clients and Partners
Greater values on new for purchase editions on Informix V11.50xC7
IDS Workgroup to Informix Growth Edition
IDS Enterprise to Informix Ultimate Edition
Informix Editions Summary
Informix Offering Mapping — Old to New Editions
License Entitlement Migration for IBM Passport Advantage Customers
Competitive Pricing and Packaging
Informix Training - Online, Onsite or in Our Classroom
Advanced Informix Performance Tuning Course by Lester Knutsen and Art Kagel.
Do you want to learn how to be the FASTEST Informix DBA? This is the course our Fastest Informix DBA contest was developed from and will increase your database performance tuning skills.
This 4-day course focuses on techniques for optimizing an Informix Database. Labs will demonstrate more than 100% performance improvement. Each student will have a 4-core Linux server with IDS 11 and a large dataset for benchmark exercises and labs. Attend the class in person or online via our Web Training Center. Both Art Kagel and Lester Knutsen will be teaching the Advanced Classes together.
This course is for database administrators and application developers who will be responsible for managing, optimizing, and tuning an IDS database server. The focus is on skills, procedures, and scripts to improve the performance of your database server. The course will provide a toolkit of scripts and utilities to start monitoring and optimizing your IDS database server. (Cost $2,000 USD)
Class times are 9:00 AM to 5:00 PM; dress is casual.
For directions and hotels near Advanced DataTools' Office see:
For more information visit http://www.advancedatatools.com/Training/InformixTraining.html or call 703-256-0267 Ext. 101 for more information and to register.IBM
US only, All IM
Register now to get your software skills, and a complimentary netbook, too!
Learn more! http://www.ibm.com/training/us/swgnetbook5
US only, All IM
Time is running out! Redeem your Assess and Save voucher now!
For more information visit http://www-01.ibm.com/software/data/education/voucher.html?ca=july2010nl
Informix Chat with the Lab
Thursday, August 26
Informix Post End of Service Support Options and Upgrade Best practices
Al Martin - Director; WW Data Management Support; IBM
Available for Informix versions 7.3, 9.4 and 10, these options will provide you with access to expert IBM Support professionals and will help you maintain business continuity until you upgrade to the latest version of Informix. We will also cover best practices when upgrading from Informix 10 to Informix 11.50; including upgrading standalone and replicated environments.
Presentation material will be available at http://www.ibm.com/informix/labchats prior to the event.
Questions, comments: firstname.lastname@example.org
To register for this event, use the following link:
For webinar-specific questions, contact the moderator. For technical support, contact UnyteSupport@us.ibm.com.Using Estimated Rollback Time Feature of 11.50.xC6
It was a beautiful morning on July 4, 2010. I had taken a long weekend to enjoy the lake with some friends and celebrate my wife's birthday. Birds were chirping, fish were jumping, coffee was brewing, bacon was sizzling, the kids were spending some quality time with the grandparents and I was enjoying a rare treat, sleeping in. When the phone rang and I saw the number I knew it wasn't a good phone call.
You see, I'm the only Informix DBA where I work, which means I'm always on call. I'm OK with this and so is my employer. This setup rarely causes either of us problems because Informix is so darn stable and if I'm completely unavailable I do have a backup with a good bit of Informix know-how.
I answer the phone and get a description of "the database is running slow and new connections are failing, can you join the outage bridge?"
At about this time the alarms that are sent to my phone start rolling in. "Dynamically allocated new virtual shared memory segment", "DR: ping timeout" and "DR: Turned off on primary server". Well crap, any hopes of this being a false alarm are DOA and I fire up the laptop and wireless internet card and join the bridge.
To my disappointment I am unable to acquire an internet connection at the lake (it worked earlier when I tested it) and am now in the unfortunate position of asking my backup to run onstat commands and look at the online logs and telling me what he sees. I don't know how the Informix Support people do this day in and day out, it is totally frustrating. My hat goes off to them.
10 minutes into the outage I'm in the car driving into town in search of civilization and internet and after a lengthy back and forth between me and my Eyes that went something like this:
Me: Run onstat -g act and tell me what you see.
(Phonetic Alphabet Tables can be found here: http://www.osric.com/chris/phonetic.html)
We finally determine that a huge delete took place, ran for some time, was aborted by the user and the rollback is causing all kinds of havoc with locks being dynamically added, dynamically allocated virtual segments, memory swapping and general server unhappiness. Eventually the rollback completes and the engine is bounced to free the allocated locks and things are back to normal. We are lucky that our bread and butter application does not depend too heavily on this server to function, so the damage to our bottom line was minimal.
When things like this happen we have a follow up meeting after the dust settles to discuss what happened and how to prevent it from happening again. Pretty standard, really.
In this case my initial suggestion of "Don't accidentally attempt to delete 11.5 million rows from a table with row level locking in a single transaction on a holiday" was met with little enthusiasm. While it is a good policy, accidents do happen, and we need to identify potential long transactions before they become a problem.
A new feature in 11.50.xC6 that allows you to view the estimated rollback time of a transaction gave us the information we needed.
A new column, est. rb_time, has been added to onstat -x. We can continuously monitor this column via a light weight script run by cron (or whatever you like) and send an alarm if we find a potentially long transaction. This gives us the ability to log in, identify what is going on, determine if this is a legitimate transaction or a bad one that will cause problems and kill the session before the rollback time gets out of hand.
Is this a perfect solution for everyone? Nah, but it works well for my OLTP environment where our transactions are teeny tiny and a rollback time of more than 30 seconds should raise an eyebrow and a rollback time of more than 60 seconds is cause for alarm.
Migrating from Microsoft SQL Server to IBM Informix
Compare the Informix Version 11 editions
Get started with direct file I/O support in IBM Informix 4GL
For more information go to DeveloperWorks - Informix:
Announcing the Continuing Support Pilot for Informix versions 9.4 and 10
IBM is pleased to introduce the Continuing Support offering, a pilot program for Informix versions 9.4x and 10.x that will provide you with continued access to the same knowledgeable Informix global Support team you are working with today. This assistance, included with your active Informix Subscription and Support renewal, will help keep your business running on Informix software until you are able to upgrade to take advantage of new features available in the latest Informix version. The Continuing Support Pilot begins October 1, 2010 and ends September 30, 2011.
This exciting offering allows you to enjoy many of the Subscription and Support benefits that you have told us matter most to you, including:
The Continuing Support offering does not include:
Pilot Program Participation
On or before the September 30, 2010 End of Service date for IBM Informix version 10, you only need to complete your annual Informix Subscription and Support renewal to receive Continuing Support assistance for a period of one year.
To get more information the Continuing Support Informix Pilot Program, email email@example.com.
Message from the Director
As many of you know, in late May we introduced new Informix packaging and pricing to deliver greater value to our clients and partners with what we believed would enable growth opportunities at a lower cost. We received a lot of positive feedback, but also some suggestions to add a more attractive mid-market offering.
We took this feedback and decided to make changes to the new offerings. On July 20, we are launching a new Informix Choice Edition for Mac OS X and Windows. This is a low-cost, feature-rich Informix edition that offers enterprise-class functionality at a very attractive price point with high-availability for the mid-market. It will replace the Informix Ultimate-C Edition introduced in May, which is now withdrawn. Further, the Informix Growth Edition introduced in May now supports Windows and Mac OS X environments, in addition to UNIX and Linux.
Complete details of all Informix editions and entitlements are available on the IIUG website:
We recognize that major changes such as this need to be communicated as widely as possible, and we'll continue to strive to do a better job of that. I hope this newsletter is a step in that direction.
JerryMigrating from Microsoft SQL Server to IBM Informix
An IBM Redbooks publication
In this IBM Redbooks publication, we discuss considerations, and describe a methodology, for transitioning from Microsoft SQL Server 2008 to the Informix Dynamic Server. We focus on the topic areas of data, applications, and administration, providing information about the differences in features and functionality, including the data types, data manipulation language, data definition language, and stored procedures. Understanding the features and functionality of the two products assists you in developing a migration plan.
We provide a conversion methodology and discuss the processes for migrating the database objects and data from SQL Server to Informix using various methods. We show the SQL differences between SQL Server and Informix and illustrate, with examples, how to convert tables, views, stored procedures, functions, and triggers. We provide script conversion samples for data loading. We describe application programming and conversion considerations. In addition, we discuss the Informix configuration, as well as the administration features and functions Informix provides to help DBAs manage the Informix database server after it is migrated.
With this information, you can develop your required transition methodology, and you can plan and execute the conversion activities in an orderly and cost-effective manner.New Informix Choice Edition announcement
Withdrawal of Ultimate-C Edition announcement
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.