Thursday, May 10, 2012

Innovator-C: Approaching 400 Days of Up Time


IBM Informix Dynamic Server Version 11.70.FC2IE -- On-Line (Prim) -- Up 398 days 01:11:10 -- 2084080 Kbytes

Put into production over a year ago in April 2011, Innovator-C has just been cruising along with no problems and no signs of slowing down.

Just a single socket, quad core Intel machine with 2GB allocated to Informix and a couple of internal drives mirrored RAID1 using cooked chunks, Innovator-C is able to handle an average of 700,000 new session requests, 4 million commits, 900K rollbacks and 3.5 billion ISAM calls per day. This is just what our production load throws at it, I don't know what the actual limits are. Judging from CPU usage and current response times, Innovator-C running on this lower end hardware can handle much more.

Makes me question why someone would choose a different free or low cost engine for smaller installations, especially considering there is a well defined upgrade path to Growth and Ultimate as your need for speed increases. It definitely can't be because of technical reasons. Most likely they don't even know Innovator-C is a free for production option. Heck, there were people at IIUG2012 that didn't know Innovator-C was a free for production option and these are the Informix Fanatics!

You might have noticed the On-Line (Prim) in my 'onstat -' above, Innovator-C comes complete with full HDR Primary/Secondary support so even the smallest of systems can have enterprise class redundancy, even though I haven't had a need for it since the engine is so stable.

May 14, 2012 Update:

IBM Informix Dynamic Server Version 11.70.FC2IE -- On-Line (Prim) -- Up 402 days 00:41:51 -- 2084080 Kbytes

Made it past the 400 day mark during Mother's Day weekend, our busiest time of the year. Of course, Informix handled the 2x spike in volume without any problems. Yawn.

Tuesday, February 7, 2012

Informix Port Delivers Unlimited Database Scalability for Popular SaaS Application


Google Alerts has been depositing some interesting Informix news into my inbox lately, I thought this one was interesting. Glad to see open source applications being ported to Informix.

Informix Port Delivers Unlimited Database Scalability for Popular SaaS Application


Delivers enhanced ability to create and manage large SugarCRM databases without impacting performance even for extremely large users

London, UK (PRWEB UK) 7 February 2012
Oninit, the leading Informix services company, announces that SugarCRM, the world’s fastest-growing Customer Relationship Management (CRM) solution, has been ported onto IBM’s Informix, effectively eliminating some of the scalability concerns that can exist with this and many other Software as a Service (SaaS) applications. This brings together one of the world’s fastest and most flexible databases with a hugely popular open source application, and effectively demonstrates to application developers the suitability of Informix as a core database platform for SaaS applications.
SugarCRM, a leading open source CRM solution, is increasingly being used by larger enterprises and governments whose data management needs can increase exponentially as usage gathers momentum. With an Informix database in place SugarCRM users will be able to create and manage extremely heavily populated CRM systems without seeing a decrease in performance. Some databases which are traditionally used to build SaaS applications, or which are used as enterprise database servers to support such applications in-house, can struggle to maintain referential integrity and speeds of query response as the amount of information being stored and managed increases.
States John Baker, Managing Director of Oninit Group: “After several months of development in partnership with systems integrator i2Global, we are delighted to see SugarCRM running efficiently on Informix. With the demand for SaaS increasing, it made business sense to demonstrate Informix’s perfect suitability for the job. Delivering SugarCRM on Informix shows that it can easily power a major SaaS application. It offers unlimited growth, outstanding performance and is the ideal platform for creating and managing heavily populated databases.”
Using SugarCRM on Informix has also simplified and speeded up the data upload process. Recent tests by i2Global show that large amounts of records can be uploaded in minutes, as opposed to many hours as experienced with another often-used SQL database, representing significant user time savings.
Partnership of partners
The desire to prove Informix within large scale SaaS environments was stimulated in part by demand from China and other rapidly growing emerging markets which feature extremely large organisations supporting huge numbers of corporate users, for whom scalability is a real potential barrier.
The decision to port Sugar CRM onto Informix as the first implementation was validated by the groundbreaking partnership recently signed between Oninit and US IBM reseller, PreferredPartner, which is actively providing IBM-based information technology solutions to the Chinese market where there is high demand for efficient, extensible, and affordable CRM solutions based on world-class IBM database technologies, something that Sugar CRM on Informix uniquely provides.
Explains Craig Humphreys, Vice President of Technology, at PreferredPartner: “The opportunity in China for SugarCRM on Informix is quite substantial. With this ‘partnership of partners,’ combining our knowledge of the Chinese market, our development experience extending the capabilities of Sugar CRM, and Oninit’s network of Informix expertise such as i2Global, we have rapidly developed a solution to meet the demands of this massive emerging market. Within a short space of time, we are already conducting demonstrations in China, particularly in the financial services and distribution industries.”
SugarCRM is the leading Open Source CRM which users can deploy either in the cloud or on their own servers, and is becoming a highly popular platform for third party integration.
About Oninit
Oninit was founded in 1999 as a specialist Informix developer and consulting team, and since that time has grown into a leading Informix services company providing a range of Informix database and application development, support and training services to companies in the UK and across EMEA from its base in Cirencester, UK.
Informix is deeply embedded in the enterprise IT systems of many thousands of companies worldwide. Oninit provides the vital Informix technical support and development services which are required by these complex systems.
Oninit helps companies to develop new Informix applications as well as support, enhance, integrate and modernise applications running on older installations. It works with customers to upgrade and modernise these to take maximum advantage of the latest Informix technical enhancements and additions, ensuring a roadmap for their future IT or establishing an evolutionary path to more modern open or virtualised architectures.
More information can be found at http://www.oninitgroup.com
About PreferredPartner
Founded in 2000, PreferredPartner has a unique business model that has propelled the company into a top world-wide IBM Premier Business Partner. PreferredPartner provides full solutions in Passport Advantage and Application Specific Licensing models, as well as provisioning, implementation, and full-scale professional services. PreferredPartner provides end-to-end customer and ISV/Integrator solutions based on IBM Information Management, Tivoli, WebSphere, Lotus, and Rational, and Security software.
For more information visit http://www.PreferredPartner.com

Tuesday, November 22, 2011

IIUG 2012 - Registration Open and Conference Site is Live



The IIUG 2012 Conference Planning Committee announced today that registration is open and the conference website is live.

Join the IIUG  for the 2012 IIUG Informix Conference April 22-25, 2012 at their new sunny San Diego, CA location and be a part of the largest gathering of Informix fanatics in the world.
  • Take advantage of this one of a kind training and networking opportunity
  • Presentations by IBM Development and Support and Informix DBAs and Developers
  • FREE IBM Information Management Certification Testing
  • Reunite with old friends and colleagues
  • New content for all Informix versions and features
  • Optional Half and Full Day Tutorials to maximize your training dollars
  • Explore new technologies and services in the EXPO Hall
  • FREE Hands On Labs from IBM

The IIUG 2012 site is your one stop shop for everything you need to know about attending the conference including registration, keynote, session and tutorial information, how to become an IIUG 2012 sponsor, up to date news on latest conference details, conference hotel information, information for conference speakers and even non conference related activities in the San Diego area.

Be sure to follow IIUG 2012 on Facebook and Twitter @IIUG2012 for more information leading up to and during the conference.

Don't forget to take advantage of the IIUG 2012 Conference room rate at the San Diego Mission Valley Marriott to ensure you will be close to all the action during the conference.

Register before January 16, 2012 and receive $130 off the cost of regular registration and take advantage of the $100 IIUG Member discount. Not an IIUG member? No problem, membership is free and you can join before registering for the conference and claim your discount for a total savings of $230!

Friday, September 16, 2011

This Smart Meter Stuff is for Real


Yesterday IBM hosted a Smart Meter Summit in Austin. I attended not because I do anything with Smart Meters, but because I have seen and heard the IBM speak about Informix TimeSeries and how it is a perfect fit for Smart Meter data and wanted to hear more. I wanted to find out for myself if this was for real, to find out if there is there an opportunity for Informix to grow here or if it is just Smarter Planet marketing fluff.

It is for real.

The number of homes and businesses with a Smart Meter is growing with no sign of slowing down. What I found interesting was the reason for this growth. Before attending the Summit I imagined the push for these meters was because they give you a more granular view of your power usage giving the consumer the ability to see their power consumption in near real time instead of once per month so they can switch things off if they are using too much power. I was wrong. This is definitely one benefit of Smart Meters, but the real driving force behind the push for Smart Meters is something called a Truck Roll.


Thursday, September 1, 2011

Smart Metering Data Summit


Lots of activity surrounding Informix in my fair city of Austin lately. I like.

There was the IBM Informix sponsored booth at the Online Game Developer Conference last year, the 11.70 Informix Roadshow that came to Austin in July and now I see IBM is hosting a Smart Metering Data Summit (TimeSeries) on September 15th.

IBM Smart Metering Data Summit
Thursday, 15 September, 2011 8:00 AM - 3:00 PM
IBM Briefing Center - Austin, TX
11301 Burnet Road, Building 101, Austin, TX

Register for this Free Event Today

You Stay Classy San Diego


2012 IIUG Informix Conference dates and location announced today.

I love LAIP.

Friday, August 19, 2011

User Defined Aggregates


Until recently I had no use for User Defined Aggregates, that was until I was ridiculed by my MySQL counterparts over the fact that Informix does not have a group_concat aggregate function.

This will not stand, ya know, this aggression will not stand, man.

A quick search of the internets produced this Stack Overflow post which shows how to create a User Defined Aggregate in Informix that will duplicate the MySQL group_concat aggregate.


Thursday, July 14, 2011

Austin Informix 11.70 Roadshow - Day 2


The second day was just as informative as the first. I am bummed we are done but I needed to get back to work anyway.

Some interesting things from Day 2:

create | drop if [not] exists


Long time coming, IMO. Gives you the ability to write SQL like the following
create database if not exists db with log;

create table if not exists tab1 (
   field1 integer,
   field2 char(2)
);

drop table if exists tab2;
Index Extent Sizing


You can now specify the first and next extent sizes for your indexes instead of relying on the engine to guestimate what your index extent sizes should be based on index key size and table size.


Tuesday, July 12, 2011

Austin Informix 11.70 Roadshow - Day 1


We're just wrapping up day 1 of the 2 day Informix 11.70 Roadshow in Austin, TX and I am glad I was able to finally attend one of these things. I hope another will come to my area soon. We've got a full room of people from all over the great state of Texas wanting to hear more about new 11.70 features and get hands on experience with Flexible Grid and Automatic Storage Provisioning.

Carlton Doe is a great speaker and as the agenda promised he discussed Informix Marketing and the plans for the future, talked about the new 11.70 features that improve performance and ease of administration, got a look at the Informix Warehouse Accelerator and then went into an intense presentation over Informix Flexible Grid. We finished up the day with a Flexible Grid Hands On Lab.

I look forward to tomorrow and the topics of Application Development Enhancements, Backup to the Cloud, Instance Administration Features and Automatic Storage Provisioning Hands on Lab.

If one of these are coming to your area I highly recommend you attend if the class hasn't filled up yet.

I really want to get back to posting some technical stuff soon and I will, I promise. I've got a suggestion to write about Fragmentation/Partitioning and I want to do a post about User Defined Aggregates to duplicate the group_concat() functionality in MySQL.

Tuesday, June 21, 2011

North American Informix 11.7 Roadshow Schedule


Happy to see IBM scheduled 4 Informix Roadshows in my part of the world, especially the one for Austin, TX which will be walking distance from my house.

I've never been able to attend a Roadshow because it wasn't feasible for me to travel to San Jose or NYC but I've already reserved my spot for July 12 and 13. I hope to see some new faces and get a chance to talk about the greatness of this product with people getting to know Informix for the first time.

I hope there is one in your area that you can attend!


Montreal, Quebec, Canada
     July 7 & 8    9 am - 5 pm    
     IBM 1360, boulevard Reni-Livesque Ouest  Montrial, Quibec H3G 2W6  Room: 7th Floor, Room 629

Austin, TX
     July 12 & 13    9 am - 5 pm      NOTE: Registration closes July 7!!
     IBM 11301 Burnet Road, Bldg. 101  Austin, Tx 78758-3493   Walnut Room, 02-2J008

Seattle, WA
     July 26 & 27    9 am - 5 pm    
     IBM 1200 5th Ave  Seattle, WA 98101  Room 9-9020

Minneapolis, MN
     August 2 & 3    9 am - 5 pm    
     IBM 650 Third Avenue South, Minneapolis, MN 55402   Lake Superior Room A 04-429

Here are the details of the FREE 2 day technical deep dive and hands on labs

Day 1:
  • Introductions and logistics
  • Informix Marketing overview
  • New general database and Data Warehouse features
  • Informix Flexible Grid and Hands-on lab
Day 2:
  • Application development enhancements
  • Backup to Cloud
  • New Informix instance administration features
  • Informix Automatic Storage Provisioning and Hands-on lab


IBM will be providing a complimentary continental breakfast and lunch each day.