Green: good for the environment and your wallet

Jacques Roy, an IBMer which also maintains a blog, participated in an internet radio show organized by the Information Management magazine. The topic of the show was how you can save money by going green. In other words, how you can make your company carbon footprint as light as possible and at the same time save money in energy and hardware costs.

Several people from different companies and areas joined the show, and each one provided his view on the subject. As you can imagine, Jacques talked about the subject from a database perspective, pointing out several aspects of Informix that can help you in the going green task.

The debate was very interesting covering topics like virtualization, multi tier storage, information lifecycle management etc.

Please find more details in Jacques's blog.

Informix event in Lisbon

This post will be written in Portuguese due to it's local nature. It's purpose is just to inform about a local half-day session covering several recent news and announcements about Informix.

A Companhia IBM Portuguesa vai realizar uma sessão de meio-dia, no dia 24 de Março, no IBM Forum Lisboa, localizado nas instalações da IBM. Esta sessão servirá para dar a conhecer aos clientes e parceiros as últimas novidades e próximos passos no que diz respeito ao Informix.

Os temas cobertos incluirão o recente anúncio sobre o Informix Warehouse Feature, bem como as próximas novidades a incluir na versão 11.50.xC4. Para além dos aspectos mais técnicos serão abordados também aspectos de integração com outros componentes do portfolio da IBM, nomeadamente Cognos e Optim.

A sessão contará com a presença de oradores internacionais, membros da equipa de Information Management da IBM.

Pode aceder à agenda e descrição do evento, bem como efectuar o registo online acedendo a: http://www.ibm.com/events/pt/pt/

Para além do evento dedicado ao Informix serão realizados durante o mês de Março outras sessões sobre Lotus, Rational e Maximo (asset management). A informação e registo destes eventos encontra-se na mesma página.
Pode obter mais informações sobre o IBM Forum Lisboa (localização, como chegar etc.) em http://www.ibm.com/pt/ibmforum/

Se utiliza Informix ou se quer saber mais sobre esta base de dados da IBM não deixe de comparecer. Obterá informação sobre o que está a ser disponibilizado e planeado e terá oportunidade de contactar e trocar impressões com a equipa IBM local e da região, com parceiros e outros clientes.

Informix Warehouse feature

IBM has announced today the availability of Informix Warehouse Feature v11.50.
This is a set of tools that help customers by taking advantage of their Informix infra-structure in order to transform operational data into information useful for business optimization.
This bundle includes the SQL Warehouse component which offers the following:

• SQW Warehouse Design Studio and SQW Client for data modeling, schema design, data transformation design, and data flow design
• SQW Warehouse Server with Administration Console to schedule and manage data flows
• SQL Warehouse runtime to perform data transformation within the IDS data server

The infrastructure specified can be integrated with business intelligence tools like Cognos (now part of the IBM Software portfolio), and Optim (former Princeton Softech) for management of data growth, and ETL tools like Information Server (former Ascential Datastage).
This feature is available for Informix Dynamic Server v11.50.xC3.

If you're an Informix customer, or if you've been paying attention to the traditional positioning of Informix as an OLTP database you may wonder how this fits the traditional Informix usage.
Well, this does not mean that Informix became the perfect choice for a large scale enterprise level data warehouse. But the fact is, a lot of Informix customers need to extract more information from the data they manage in their Informix instances. Information organized in a different manner. Not in the usual OLTP transaction oriented schema. Many of this customers can take advantage of their existing infra-structure to build some data-warehouse functionality into their information systems. This package attempts to provide them with some tools that can help setup these new capabilities.
Although Informix is not specially oriented into the data-warehouse usage, it includes a lot of functionality that can help:

• Dynamic Scalable Architecture (DSA)
  The internal engine arquitechture permits scalability and excelent performance. It also allows for extremely efficient usage of your hardware
• Decision Support Queries
  IDS has several paremeters that control the type of queries made in a datawarehouse type environment (decision support queries). You can control resourses like memory, number of parallel scans etc. Also, this type of queries are run in parts that can run concurrently (scans, sorts, ortders etc.)
• Read ahead capabilities and light scans
  This allow for more efficient batch reads like the ones ocurring in big tables sequential scans
• Configurable page sizes
  This can help improve performance for large batch reads/writes
• High performance loader
  A very efficient way to load data into your tables
  
• Flexible table fragmentation
  Can be used for data lifecycle management, parallel queries, fragment elimination in queries etc.

And what about the future? Well, if you take a look at the recent webcast about the IDS roadmap you can see features like "automatic storage provisioning", "warehouse", "external table support" (currently possible, but not built in). In a very near future, and accordingly to the early validation program, IDS 11.50.xC4 will support table compression.
So, there are old features, new features, and better integration between Informix and other IBM products that can make it a good choice to build a BI supporting structure.

You can find more information about this announcement in the following resources:

• The Informix Warehouse Feature announcement
• The Informix Warehouse Feature installation guide (at IDS 11.50 Infocenter)
• The Informix Warehouse Information page on IDS 11.50 Infocenter
  

FUD for thought

If you're a frequent visitor here or to any other Informix related post, there are good chances you also check the Informix usenet group. If you don't know what I'm writing about you can check it at http://groups.google.pt/group/comp.databases.informix?hl=en.

I'm a usual reader and poster on that group, and recently one of the topics got my attention. I think it deserves a bit of our time in order to understand a few things...
One person posted a message on the group, asking for an "IBM 10 year plan for Informix". The reason he needs it, as far as the post says, relates to the fact that, allegedly, a sales representative from an IBM competitor had that for it's database, and the consultants were saying IBM hadn't a similar documented plan for Informix.

Let me tell you that usually, the technical posts are more participated than the "commercial oriented" ones. But in this case we could see very quick answers from IBM business partners, IBM Informix architects and even from Oracle employees... All of them agreed on something: Neither IBM, or Oracle (and probably not any other software vendor) has a plan for 10 years. And why not? Well, simply because in 10 years everything can change in the IT industry. New trends, new needs, new paradigms. So what would be the point in making a plan that would almost for sure be changed in the middle?
This leads us back to the initial situation... so why would someone try to raise Fears, Uncertainty and Doubts (FUD) about IBM and Informix? The simple answer, provided by some, was simply because it's a usual sales tactic when the customer is leaning towards the competition.
Why not use technical or other commercial arguments in that situation? Probably because it's harder, or simply because there are no other arguments strong enough...
This simple situation, accordingly to some of the posters is relatively usual. I've seen it happen, or at least I've seen the effect of them, when people that are simply not informed ask me if IBM is trying to move Informix customers to DB2. So, let me try to raise a few questions and propose some answers:

1. Does IBM have a plan for Informix?
   Yes. You can check a roadmap in a recent presentation which you can access at:
   http://www.ibm.com/informix/webcasts
2. Does IBM have a ten year plan for Informix?
   No. It doesn't have a ten year plan for any product, simply because it's not realist. If such a plan existed it would ignore all the future changes, trends and shifts in the IT industry.
   On the other hand, IBM has nearly a ten year past with Informix. Think about that when you read the next questions
3. Has Informix been improved in the hands of IBM?
   Sure. IDS releases since 9.4 have seen done by IBM. I prefer to exclude 9.40 because it happened almost immediately after the acquisition, so the development phase was done by Informix Corporation. But think about IDS 10, IDS 11 and IDS 11.5. Think about all the new features. Think about MACH 11. Think about all the improvements in security (LBAC, default roles, SSL, single sign on, column level encryption, encryption expert, encrypted replication, PAM authentication...). Think about compression (11.50.xC4 as already announced in the early validation program). Think about unicode. Think about common client (DRDA). Think about performance (shared statement cache, non-blocking checkpoints, index self join, CPUVP cache, Direct I/O...). Think about Open Admin Tool. Think about all the new features in enterprise replication. Think about dynamic SQL in stored procedures. Think about ontape and OnBAR improvements. Think about SQL trace. Think about SQL admin API. Think about DB scheduler...
4. Does IBM talk about Informix?
   Yes. Have you noticed the recent announcements about Informix availability in the "cloud"? Have you noticed that we have regular webcasts? Have you read all the IBM redbooks about Informix? Have you been to any of the proof of technology events all around the globe? Have you noticed what are the "brands" on the bottom of the 2009 EMEA IOD Conference page?
   
5. Did Informix loose any of it's strengths in the hands of IBM?
   No... It's still stable, fast, easy to setup and manage, and "light" (both in installation size and in resource consuption)
6. Is it harder to upgrade than before?
   No... it's still the same process to move from IDS 7.31 to IDS 11.50 as it was from 7.30 to 7.31. Simple and quick...
7. Is it more expensive?
   No. It's still competitive. You get more features included on the base price than in most of it's competition. And you can get a fair deal if you run it in virtualized environments.
   
8. Do we have more or less information about Informix?
   More. Currently we have a lot of blogs and sites with information about Informix. The IBM site, although complex, has all the manuals, product lifecyle, product downloads etc.
9. It it harder to test Informix?
   No. You can download a developer version from the IBM site. You can even download a virtual appliance with the software and some demos (MACH 11 for example)
10. Did we loose Informix technical support quality?
    No. In recent surveys, Informix customer satisfaction was proven to be high. You don't get that with lousy technical support.
11. Do we still have a great international user group?
    Yes! IIUG continues to do a terrific job. Even in the current difficult times, IIUG continues to promote Informix and works closely with IBM. Just check some recent announcements, the IIUG 2009 user conference, the surveys, the monthly insider etc.
    
12. What about Informix training?
    IBM has been updating the Informix training courses. I had the pleasure to try some of them in the ILO (Instructor Led Online) environment, so I can assure that the new features are covered in the courses.

So... what the mentioned comp.databases.informix thread talked about is FUD (Fear, Uncertainty and Doubt). What I exposed above are verifiable facts. The decison between the two should be taken by customers. Do you prefer to trust those who have been providing good, fast, stable, scalable and easy to manage software, or do you prefer to trust those who try to scare you with statements that are contradicted by facts and an history of almost 10 years?

Regards.

Events...

If you usually check the Informix blogs, you've probably notice that IBM will present a virtual event on February 25th. This event is about Information Management, not necessarily focused on a specific product. Accordingly to the announcements you'll have the opportunity to chat with several specialists. You can see more information on Guy Bowerman's blog. The event registration can be found here.

Meanwhile, a colleague from France, Laurent Valenza is involved in the proof of technology that will take place in Paris on March 12. It will include hands on tutorials, and presentations about migration, MACH 11 and Open Admin tool. Please check the detailed agenda and the confirmation email at IIUG's page: http://www.iiug.org/news/announcements/pot_12mar2009.php
I had the pleasure to meet Laurent in 2008 and I'm sure his contribution will make this event worthwhile.

To finalize this post, a reference to a document Eric Hebert posted on his Informix Zone site. It's a translation to English of an interview of Jerry Keesee to Czech ComputerWord.
Please check it at: http://informix-zone.com/node/678.
If you prefer the original version, check it here

Informix academic initiative...

I've just received the IIUG Insider and one of the subjects that caught my attention was the news about Informix on Campus Academic Initiative.

A few people related to IIUG and some IBM staff are working together to bring Informix into the Academic community. Many people believe a software product needs to gain traction in the Academic world. The basic idea is that we all tend to work with what we know. And the Academic environment is an excellent place to learn about products.
IBM has programs for showing it's products to the Academic community but Informix has not taken advantage of this yet.

These people is working to change this. To start with, they put up a public and free (no registration needed) survey. If you're interested in this topic, please take five minutes to answer it (it really won't take more than this). You can give your opinion, suggest institutions to participate (if you have their contacts), and you can even volunteer yourself to help!

Be the first to check 11.50.xC4

After a long time without posting (usual lack of time) I decided to take five minutes to make an echo of some nice news. I already heard about plans for IDS 11.50.xC4 around April this year, but nonetheless I was surprised by today's IIUG's announcement.

Accordingly to this news, any customer wanting to get in touch with the next release of IDS will be able to do so, after agreeing to the usual conditions.

In the announcement we can see the major features for this new version:

• Compression
• Easy administration, setup & monitoring of Enterprise Replication with the Informix OpenAdmin Tool
• Improved embedability
• Support for the Amazon EC2 computing environment
• Support for VMWare Virtualization Infrastructure and Desktop solutions

So... Compression seems obvious, Amazon EC2 seems intriguing. VMWare seems logical.
Stay alert and consult the IIUG (International Informix Users Group) site for more information.
Once again IIUG shows great collaboration spirit with IBM on promoting IDS.

You should also take a look at the next Chat with the Labs (January 29). Jerry Keesee, Director of the Informix Lab, will talk about recent Informix activities and also about the roadmap for 2009.
To register go to:

https://ww4.premconf.com/webrsvp/register?conf_id=4834295