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 - - 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 - - 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 - - DNS impact on Informix / Impacto do DNS no Informix... Read
8 Sep 11 - - 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 - - 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

IIUG Insider (Issue #126)
December 2010

Other Issues

Highlights: Holiday Greetings

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.



Editorial Back to top

Happy new year to all IIUG members!

In 2010 IBM released Informix 11.7 code named Panther.

Unlike its predecessor the Cheetah Panther did not receive a new version number but looking at the feature list it is without a doubt a giant step forward.

The best place to acquire a full knowledge of all the new features will be the IIUG Informix Conference in Kansas, USA May 15-18 2011. There are always many good reasons to attend our conference. Getting up to date with the new Panther release gives this year's conference a huge additional value.

I have been participating in the IDS beta program since IDS10 (when it was still called 9.5). It is a great experience and an opportunity to combine helping Informix with getting to know the product. Since version 10 every new version is loaded with new features we DBAs where longing for. Panther has them too but the flexible grid offering the capability of building a high availability cluster on a mixture of hardware and software platforms is something we CIOs could only dream of. Getting this unique powerful and flexible distributed environment with no need to invest in new hardware and software is a CIO's dream come true.

I know many of you are concerned with Informix's visibility in the press.

This time I do not share these concerns. Like Panthers in the wild the Informix team is recruiting new people getting ready for a leap. During 2011 we will see the results.

I wish 2011 will be better than ever for IBM and Informix. More Informix users, more IIUG members, more local user groups, a bigger and better conference, more content for the IIUG Insider, an interesting and profitable year to you all at work and a happy and peaceful year all together.


Feliz ano novo a todos os membros do IIUG.

Em 2010 A IBM lançou o Informix 11.70, cujo nome código é Panther (Pantera).

Diferentemente de seu predecessor, o Cheetah, o Panther não recebeu um novo número de versão, porem, observando a lista de funcionalidades ele, sem dúvida, representa um grande passo adiante.

O melhor lugar para se atualizar e aprender estas funcionalidades será a Conferência Internacional de Usuários Informix do IIUG, em Kansas, USA de 15 a 18 de Maio de 2011. Sempre há boas razões para comparecer na conferência, mas conhecer as novas funcionalidades da Panther este ano, é um grande diferencial.

Tenho participado do programa beta do Informix desde a versão 10 (quando ainda era chamado Informix 9.5). é uma grande experiência e uma ótima oportunidade para ajudar a Informix e conhecer o produto. Desde a versão 10, a cada nova versão que é lançada com novas funcionalidades nós, DBAs esperamos ansiosamente este programa.

Dentre outras, a funcionalidade de "Grid Flexmvel" disponibiliza a capacidade de construir um ambiente de alta disponibilidade numa mistura de plataformas de hardware e software e, é algo que os CIOs até hoje apenas sonharam.

Com este único, poderoso e flexmvel ambiente distribumdo, sem necessidade de investimento e novos hardwares ou software, é o sonho que se torna realidade para qualquer CIO.

Eu sei que muitos de vocês estão preocupados com a visibilidade do Informix na imprensa. Neste momento eu não compartilho com esta preocupação. "Como Panteras na selva, o time de Informix esta recrutando novas pessoas para este grande salto." Durante o ano de 2011 nós iremos ver o resultado.

Eu espero que 2011 será muito melhor para IBM e para Informix. Mais usuários Informix, mais membros no IIUG, mais grupos de usuários locais , uma maior e melhor conferência , mais conteúdo para nosso "Insider" , e um interessante e lucrativo ano para vocês e todos aqueles que trabalharam para o sucesso do Informix.

Desejo um ano de Felicidade e Paz para todos.

Thanks to Miguel for the Portuguese translation.


Bonne année à tous les membres d'IIUG !

En 2010, IBM a sorti Informix 11.7, nom de code « Panther ».

Contrairement à son prédécesseur, Cheetah, Panther n'a pas reçu un « nouveau numéro de version principal (comme 12) mais quand on regarde à la liste des fonctionnalités, il y a, sans discussion, un pas de géant.

Le meilleur endroit pour acquérir le savoir autour de ses nouvelles fonctionnalités sera lors de notre conférence, IIUG Informix Conference, au Kansas du 15 au 18 mai 2011. Il y a toujours de nombreuses bonnes raisons d'assister à notre conférence, mais, cette année, vous pourrez rester à jour avec la nouvelle version Panther donne à la conférence de cette année une réelle valeur supplémentaire.

J'ai participé au programme bêta IDS depuis la version 10 (quand il était encore appelé 9.5). Il s'agit d'une grande expérience et une opportunité de combiner aider à développer Informix et connaître le produit. Depuis la version 10, chaque nouvelle version est enrichie de nouvelles fonctionnalités que nous autres DBA espérions. Panther en a aussi, mais la grille flexible (flexible grid) offre la possibilité de construire un cluster à très haute disponibilité sur un système hétérogènes de plates-formes matérielles et logicielles, est quelque chose dont nous, les DSI, ne pouvions que rêver. L'arrivée de cet unique environnement puissant, flexible et distribué sans avoir besoin d'investir dans du nouveau matériel et du logiciel est un rêve devenu réalité.

Je sais que beaucoup d'entre vous sont concernés par la visibilité d'Informix dans la presse.

Cette fois, je ne partage pas ces préoccupations. Comme les panthères à l'état sauvage, l'équipe Informix recrute de nouvelles personnes et se prépare pour un saut. Au cours de 2011, nous verrons les résultats.

Thanks to JGP for the French translation.


¡Feliz Año Nuevo a todos los miembros de IIUG!

En 2010 IBM lanzo Informix 11.7, codigo Panther (Pantera).

A diferencia de su antecesor el Cheetha, Panther no recibio numeracion de version sino que a juzgar for su lista de contenido, es sin duda un gigante paso adelante.

La conferencia de IIUG Informix de Kansas, EEUU 2011 (Mayo 15-18, 2011) es el mejor lugar para adquirir pleno conocimiento de las nuevas caracteristicas.

Siempre hay muchas buena razones para asistir a nuestra conferencia. Ponerse al tanto dell nuevo lanzamiento Panther le confiere a esta conferencia valor adicional.

He participado en el IDS beta program desde IDS10 (cuando aun se llamaba 9.5). Es una excelente experiencia y una gran oportunidad el poder combinar el ayudar a Informix con el poder conocer al producto.

Desde la version 10, cada nueva version esta llena de nuevas caracteristicas de contenido que nosotros DBAs esperabamos ansiosamente.

Panther no solo las tiene, sino ofrece posibilidades que nosotros CIOs solo podiamos sohñar! Su "Grid flexible" ofrece la capacidad de construir un entorno de alta disponibilidad, una mezcla de plataformas de hardware y software que es el sueño de los CIOs hecho realidad.

Se que muchos de ustedes estan preocupados con la visibilidad de de Informix en la prensa. Esta vez no soy participle de esta preocupacion. Como panteras salvajes el equipo de Informix esta enlistando nuevos recrutas, preparandonos al gran salto. Durante 2011 veremos los resultados.

Deseo que el 2011 sea aun un año mejor para IBM e Informix. Que tengamos más usuarios de Informix, más miembros de IIUG, más grupos locales, una mejor conferencia y mas contenido en IIUG Insider.

Que sea un año interesante y prospero para todos en el marco laboral.

Les deseo a todos un feliz año, lleno de paz.

Thanks to Noemi Lerner-Somech for the Spanish translation.


Ein frohes neues Jahr wünsche ich allen Mitgliedern der IIUG !

In 2010 hat IBM Informix 11.7 — interner Projektname "Panther" - auf den Markt gebracht. Im Gegensatz zu seinen Vorgänger - "Cheetah" -, erhielt Panther keine neue Haupt-Versionsnummer. Schaut man sich jedoch die Liste der neu hinzugekommenen Funktionen an, dann ist Panther ohne Zweifel ein gewaltiger Schritt nach vorne.

Die IIUG Informix Konferenz, die vom 15. bis 18.05.2011 in Kansas (USA) stattfindet, bietet sicherlich die beste Gelegenheit einen tiefen Einblick in die neuen Funktionalitäten zu erhalten. Es gibt immer viele gute Gründe an unserer Konferenz teilzunehmen. In diesem Jahr stellt die Möglichkeit das neue Panther Release näher kennenzulernen einen großen Mehrwert dar.

Ich habe seit IDS 10 (als es intern noch 9.5 genannt wurde) am Informix Betaprogramm teilgenommen. Es ist eine großartige Erfahrung und man hat einerseits die Möglichkeit Informix zu helfen und andererseits das Produkt noch besser kennenzulernen. Seit Version 10 ist jede neue Version voll mit neuen Funktionalitäten, die DBA's schon immer ersehnt haben. Auch Panther hat diese neuen Funktionen, aber die Möglichkeit, mit Flexible Grid hochverfügbare Datenbank-Cluster aus heterogenen Hardware- und Software-Komponenten zu relisieren, ist etwas von dem wir CIO's nur träumen konnten. Diese einzigartige, mächtige und flexible verteilte Umgebung ohne Neu-Investitionen in Hardware zu erhalten, lässt einen CIO Traum wahr werden.

Ich weiss, dass viele von Euch Bedenken hinsichtlich der Sichtbarkeit von Informix in der Presse bzw. am Markt haben. Diesmal teile ich diese Bedenken nicht. Wie ein Panther in der Wildbahn heuert das Informix-Team neue Leute an, um zum Sprung anzusetzen. In Laufe des Jahres 2011 werden wir die Resultate sehen.

Ich wünsche mir, dass 2011 besser den je für IBM und Informix wird. Mehr Informix Anwender, mehr IIUG Mitglieder, mehr lokale Anwendervereinigungen (User Groups), ein noch größere und bessere Konferenz, mehr Inhalte für den IIUG Insider, ein interessantes und profitables Jahr für Euch alle in Eurem Berufsleben und insgesamt ein frohes und glückliches Jahr.

Thanks to Eric Herber for the German translation.

Gary Ben-Israel
IIUG Insider Editor

Highlights Back to top

Holiday greetings

Even as IIUG President, I've never really known if we published at the end of the month or the beginning of the month. So this is either an "end of the year 2010" or the "start of the 2011 New Year" column. To go along with the idea of looking forward and to go along with the wonderful stolen graphic (hey I am a database person, what do I know about art work?), let's look forward and positively to 2011.

2010 brought us a year of changes in the Informix community from IBM. In with a new IBM executive overseeing the day-to-day operations of Informix at IBM: Robert Thomas, Vice President of Business Development for IBM Information Management. If you have not yet read Rob's letter to the Informix community, I strongly suggest you take a peak and of course, show it to the management at your company.

For much of the past nine and a half years (yes January 1, 2011 marks the nine and a half year anniversary of the Informix buy-out), people have had it in their minds that Informix, or Informix Dynamic Server, was going away. Well, after nine and a half years, can we please put that rumor to bed!! Informix is here to stay. After all, IBM is a business; one that is in, well, the business of making money. They have stockholders to answer to and when you kill a very profitable and successful business or product line, stockholders get mad. So yes, I will tell you that Informix is profitable and successful and leave you to do the rest of the math. Enough of the rumor. Informix is here to stay. We just had a major release (although you would hardly know it with that massive IBM Marketing machine not telling anyone) and the next release is already on the drawing board. From where I sit, Informix has never been stronger at IBM!

What else is new for 2011... The 2011 IIUG Informix Conference planning is well underway. This year we had to push the date into May as our usual date, the last week of April, ran up against Easter and Passover. So into May we went, which promises (I HOPE) to not have as much rain as previous years in Kansas City. A few weeks ago the Conference team met to review all the submitted sessions and they have been working even through the holiday to finalize the 80+ selected sessions from a RECORD submission crop of sessions! For more information on the conference, visit a href=""> Remember, at the end of January the price will increase so if you are an IIUG member, register before January 31, 2011 and lock in the conference rate of $525!

Back to our friend Rob Thomas. There has been much talk of Rob's four point plan (I always love when people have a X number point plan), and Rob's #1 point is to "Delight the Informix customer base." There has been much talk on the Internet as to whether or not IBM has achieved this. It is of course up for debate and while I don't wish to debate it here and now, I will say this; they are surely trying each and every day.

Following my long note is a note by Steve Shoaf from IBM. Steve is the WorldWide IBM Informix Seals Leader and heads now what IBM calls a "SWAT Team". Are as confused as I was about the meaning of an IBM "SWAT Team"? It is a group of dedicated sales people from around the world who ONLY sell, promote and deal with Informix. So please read Steve's note.

I could of course ramble on as I usually do, but we don't want to make the Insider too much longer so I will stop with one last thought or request. I am compiling a list of "Why I (or my company) use Informix?" Why am I looking for these answers? I want to put them here and elsewhere when I write. I just ask one favor of you when you submit them; Can I use your name and/or your company's name? Submit your thoughts to me at

Happy 2011 to all, and as a past Informix Product Manager use to say to me, "I will be happy when Informix has world domination." This is my wish for 2011!

Stuart Litel
International Informix Users Group
Reach me at:

Informix in 2010 — Outlook for 2011

If there is any one year that must rank as the most important year for Informix it is this past year - 2010. This year we've seen the launch of the Informix Business Imperatives, new and re-focused Direct and Channel marketing teams, the launch of the Informix Sales Tiger Team, and a new release with new pricing.

With the four essential elements (business strategy, marketing team, sales focus, and product capability) in place I believe IBM is in the best position since the acquisition in 2001 to support our customers and drive growth of Informix sales. I am particularly heartened by the comments this year from the many ISV's, and Systems Integrators selling with Informix that the changes we've made have helped them grow their business.

Looking forward to 2011, I am even more encouraged by our plans related to v.Next. The new capabilities planned are truly game changers and prove without doubt that Informix product investment by IBM continues and delivering unique and robust functional capabilities to market remains the primary goal of our development team.

It is interesting to note that the 10 year anniversary of the acquisition occurs this year. I am very pleased that our many customers and channel partners are still committed to the product As we enter the second decade of Informix at IBM I can tell you without any reservation that the team now responsible for Informix product development, marketing, and sales from executive to Tiger Team sales leader is more committed than ever before.

It is the team's enthusiasm and sense of purpose that is most fulfilling to be part of - we're on a mission I am truly excited about our prospects this year.

Happy New Year and will see you at the IIUG Conference in May!

Steve Shoaf

WW Informix Sales Leader

Informix fans:

As 2010 comes to a close, I wanted to express sincere enthusiasm to work for fellow Informix fanatics. 2010 has been a great year for Informix Support and me personally. In November I was promoted to Senior Manager, Informix Support replacing Charles Gonsalves. There is no place I'd rather be then with a business community I unequivocally believe in. I'm both excited and committed to maintain the unparalleled support you've come to expect!

A few quick comments therein:

By now you should be aware of the new Informix strategy. From a support perspective, this has been driven under the leadership of Al Martin (Director, WW Data Management Support; also IBM representative to the IIUG Board). Working to "Delight the Install Base", and in fielding your feedback, Al and I feel we have a line up of deliverables that serve to be key differentiators for Informix. These include:

Multichannel Support Offerings:

We strive to be the BEST. Please reach out if you have any comments, questions, or concerns around your Informix experience. Your feedback and observations are of paramount importance to the Informix Support Team.

Most importantly, as you all take time to enjoy your family and friends, I wish you all a very Merry Christmas ... Happy Holidays and great success in 2011!!

P.S: I hope to see most of you at the 2011 IIUG conference in Kansas. Please visit the conference landing page if you have not done so already and get an overview of all the great sessions and offerings at the conference. It is one event you should not miss! URL:

Happy Holidays!!!


Pradeep Kutty
Senior Manager, WW Informix Support
IBM Software Group.


Informix Support Information sources:

Conference corner Back to top

2011 IIUG Informix Conference Update

The speaker submissions for the 2011 IIUG Conference have been overwhelming this year. The submissions cover a wide variety of topics including: administration, new features, development and security. Selected speakers are among some of the best in the Informix community and include some new speakers.

The IIUG Conference committee worked through December to review all submitted presentations to select the very best sessions, hands-on-labs and tutorials for the 2011 Conference. Selected sessions include relevant topics that can be used to reinforce your professional skills and keep current in today.s changing market.

Please continue to review the conference website for regular updates at The Conference website will be updated as speakers confirm their selection to include details of sessions, hands-on-labs and tutorials.

The 2011 IIUG Conference should be the best conference to date.

To take advantage of the early bird registration price of $625, register for the Conference by January 31, 2011. Save an additional $100 if you are an IIUG member. If you are not currently an IIUG member and want to take advantage of the additional $100 savings, please go to There is no fee to become an IIUG member. Becoming a member will increase your Conference savings.

To register for the Conference or for additional information, go to

Are you having problems convincing your supervisor of the benefits of attending the 2011 IIUG Conference? If so, check out our justification document that can be found at This document provides information you can use to support your Conference attendance proposal. Remember, this is still the best conference you will find for the money!

See you at the Conference!

May 15 — 18, 2011
Overland Park Marriott, Kansas

Education Back to top



Take advantage of key Support and product benefits - renew your S&S

When you renew your Software Subscription and Support you not only compliment but protect your software investments with the latest innovations. Renew your S&S for continued access to:

  • the latest product upgrades at no additional cost
  • our comprehensive eSupport portfolio including the IBM Support Portal
  • our world-wide network of Support experts

Learn more and remember to renew today!


Complimentary Information Management Training Plans

The key to a successful training engagement is the planning and requirements gathering that precedes it. A poorly implemented training plan can impose increased costs on organizations, whereas developing a formal training plan that matches your corporate needs and audience with available training options can provide effective skills development for increased implementation success. Training plans offered by IBM Information Management Education are a complimentary service that will take the guess work out of the process. We will work with your organization to create a customized training plan to guide you through the creation, budgeting, scheduling and selection of your training program.

Learn more:

Study when and where you want: Data Management Self-Paced Virtual Classes The IBM Data Management portfolio continues to grow to help you advance your skills. Study when and where you want with unlimited access to courses and labs for 90 days. There are over 20 courses to choose from, our latest courses include:
  • Informix 11 New Features
  • Informix 11 Replication
  • Informix Warehouse - SQL Warehousing Tool and Administration Console

Learn more:

Take it Again: Take it once... take it twice with Information Management Certification

Take It Again is a voucher program, offered worldwide, by IBM Professional Certification. With Take It Again you may purchase specially priced vouchers so that in the event you do not pass an exam on your first attempt, you may quickly and easily retake the same exam for no additional costs.

Learn more:

Advanced DataTools

Learn How to become the FASTEST Informix DBA from Lester Knutsen and Art Kagel!

March 14-17, 2011 - Advanced Informix Performance Tuning Course

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 9am to 5pm; dress is casual.

For directions and hotels near Advanced DataTools' Office, see:

For information and to register visit or call (703) 256-0267 Ext.101

Developer corner Back to top

Exploring Array Fetching in ESQL/C

Array fetching is an Embedded SQL in C technique for retrieving large quantities of data very quickly. My dbcopy utility uses this technique. I have found that using array fetching can improve the runtime of large batch type processes significantly. The downside of using array fetching is that you must use dynamic SQL techniques using sqlda structures manually build or modify the sqlda contents. Fortunately, if your query is well defined, this is no complicated. Doing this for an unknown SQL statement, as I do in dbcopy, is quite complicated, but for a known query, it is not so bad. Here are the steps:

  1. Set the global variable FetArrSize to the number of rows you want to fetch in a single operation. It will also help to increase the size of the buffer used by the ESQL/C library to retrieve data from the engine by setting FetBufSize to the maximum value of 32767.
  2. Declare a pointer to an sqlda structure.
  3. Declare an array for each column you will be retrieving with enough elements to hold FetArrSize elements. If you may have to process NULL values in your columns, also allocate an array of shorts for each column that may have NULL values returned, to be used as indicator variables, so that you can determine if any of the returned rows contains a NULL for that column.
  4. PREPARE your SQL statement.
  5. DESCRIBE the prepared statement INTO an sqlda structure.
  6. Modify the structure to link an array of memory locations for each column being fetched.

That is all of the preparatory work you need to do. The actual data processing will differ from your normal processing cycle only slightly. If you structure things correctly, however, the code will not have to change very much at all. What I typically do is to declare a structure for my record just as I would for a "normal" type of fetch cycle, except that it is an array of pointers to the correct type instead of an array of variables. Then I link the array for each column into the structure. I do the same for the indicator variables. Here's some sample code for a very simple query. Note the comments for further hints:

/* - Sample code to implement array fetching. */

EXEC SQL include sqlca;
EXEC SQL include sqlhdr;
EXEC SQL include sqlda;
EXEC SQL include "sqltypes.h";
EXEC SQL include decimal;
EXEC SQL include datetime;
EXEC SQL include locator;

int main( int argc, char *argv ) {

    exec sql begin declare section;
        char *database;
        struct sqlda *da_struct;
        int tabids[100];
        char tabnames[12900]; /* For CHAR allocate a flat array! */
        short tabnames_ind[100];
      struct systables_s {
          int *tabids;
          char *tabnames;
      } systables;
        struct systables_ind_s {
          short *tabnames_ind;
      } systables_ind;
    exec sql end declare section;
    int blockcount = 0, slowcount = 0;
    int row;

    if (argc < 2) {
      printf( "Usage: %s \n", argv[0] );
      return 1;
    database = argv[1];

    memset( tabids, 0, sizeof tabids );
    memset( tabnames, 0, sizeof tabnames );
    memset( tabnames_ind, 0, sizeof tabnames_ind );

    exec sql connect to :database;

    FetArrSize = 100;
    FetBufSize = 32767;

    /* Allocate memory for tabnames. */
    systables.tabids = tabids;
    systables.tabnames = (char *)tabnames;

    exec sql prepare stmt from "select tabid, tabname from systables";
    exec sql describe stmt into da_struct;

    /* link the data array for the tabid column. */
    da_struct->sqlvar[0].sqldata = (void *)systables.tabids;
    da_struct->sqlvar[0].sqltype = CINTTYPE;
    da_struct->sqlvar[0].sqllen = sizeof (int);

    /* link the data and indicator arrays for the tabname column. */
    da_struct->sqlvar[1].sqldata = (void *)systables.tabnames;
    da_struct->sqlvar[1].sqltype = CSTRINGTYPE; /* Strip trailing spaces. */
    da_struct->sqlvar[1].sqllen = 129;
    da_struct->sqlvar[1].sqlind = (void *)systables_ind.tabnames_ind;

    exec sql declare curs cursor for stmt;

    exec sql open curs;

    for(;;) {
      exec sql fetch curs using descriptor da_struct;
      if (sqlca.sqlcode == SQLNOTFOUND) break;
      /* Loop on the actual number of rows inserted into the arrays. */
      blockcount += sqlca.sqlerrd[2];
      for( row=0; row < sqlca.sqlerrd[2]; row++ ) {
          if (systables_ind.tabnames_ind >= 0)
            printf( "Tabid: %d, Tabname: %s.\n",
                  &(systables.tabnames[row*129]) );
    /* end game processing. */
    printf( "Processed %d (%d) rows.\n", blockcount, slowcount );

Obviously a real program will have lots of error checking included, but I've left that all out to save space. Compile with:

$ esql -o FetArrayExample

And run it:

$ ./FetArrayExample sysmaster
Tabid: 1, Tabname: systables.
Tabid: 2, Tabname: syscolumns.
Tabid: 3, Tabname: sysindices.
Tabid: 4, Tabname: systabauth.
Tabid: 282, Tabname: sysdwacoord.
Tabid: 283, Tabname: sysextspaces.
Tabid: 98, Tabname:  SMIVERSION.
Processed 255 (255) rows.

Art S. Kagel

New in DeveloperWorks

IBM Informix Dynamic Server Enterprise Replication templates
Learn how to use the new templates in Informix Dynamic Server, Version 10.0, to administer a large number of Enterprise Replication nodes and tables. Introducing IBM Informix(R) Dynamic Server, Version 10.0, Enterprise Replication templates. Learn how to use templates to administer a large number of Enterprise Replication nodes and tables. The template feature is not currently available in the replication products of competitors
19 Dec 2010

Get started with the IBM Data Server CLI Driver for Informix
The IBM Data Server CLI Driver supports application development for IBM Informix and IBM DB2. It is available for download as part of the Informix Client Software Development Kit (CSDK). This article describes how the CLI Driver supports ODBC application development for Informix, and highlights the benefits of using the Data Server CLI Driver. The article also provides examples to help you quickly get started using the IBM Data Server CLI Driver.
09 Dec 2010

Upgrade Informix high availability clusters online
Now you can upgrade your Informix high availability cluster without any downtime to your client connections and transactions. In this article, get an introduction to the "rolling upgrade" feature and the various approaches to implementing it. Choose the approach that best meets your needs and follow the step-by step instructions to perform the rolling upgrade of your 11.50 Informix high availability cluster to 11.70 Informix high availability cluster.
02 Dec 2010

For more information go to DeveloperWorks - Informix:

Informix news Back to top

Informix Database: Total Economic Impact and Panther

An InformationWeek Webcast Replay:

Duration: 60 minutes

Few companies have a meaningful way to measure the value of IT and IT projects before making an investment. Technology providers frequently talk about features and functions but sometimes forget to help potential clients understand benefits.

Jon Erickson of Forrester Consulting will present the results of an IBM commissioned study which examines the total economic impact and potential return on investment (ROI) that organizations may realize by deploying IBM Informix database software. The study uses a comprehensive methodology to bring third-party, objective ROI analysis to organizations considering the use of Informix.

Richard Wozniak of IBM will also provide a brief overview of the recently released Informix "Panther" which extends the capabilities of Informix with greater simplicity, power and flexibility.

Informix events Back to top

Informix 11.7 North American Roadshow

Save The Date!!!!

The Informix 11.7 North American Roadshow is coming to a location near you!

At the recent IBM Information on Demand Conference, IBM announced the latest in a continuing series of updates and enhancements to IBM Informix Dynamic Server -- version 11.7! This new release continues to enhance and extend the market leading technology of Informix in a number of key areas including data replication and clustering, ease-of-use, security, and scalability.

To help you learn more about what Informix 11.7 has to offer, IBM is sponsoring a FREE, 2-day hands-on seminar at a number of locations across the United States and Canada. Events are also planned for other geographic regions. In these seminars you'll get a full explanation of all the latest technologies and features including Informix Flexible Grid, Informix Automatic Storage Provisioning, application development enhancements, migration assistant, instance cloning and more. Several hands-on labs will give you the ability to use some of these technologies in real-world conditions.

The North American Informix 11.7 Roadshow cities are listed below. A registration link with location and other information for each event will be available shortly.

Jan 24/25 Phoenix
Jan 27/28 Los Angeles
Jan 31/Feb 1 Denver
Feb 3/4 Salt Lake City
Feb 14/15 Dallas
Feb 21/22 Toronto
Feb 24/25 Boston
Mar 2/3 Chicago
Mar 7/8 New York City
Mar 10/11 Washington DC
Mar 21/22 Atlanta
Mar 24/25 Orlando
Mar 28/29 Tampa

We look forward to seeing you and telling all about the great things Informix is doing!

Carlton Doe
Informix Technical Specialist

Support corner Back to top

How to generate schema for storage spaces?

Starting with Informix 11.70, the dbschema utility now can generate the schema of storage spaces, chunks, and physical and logical logs. You can choose to generate schema either SQL administration API commands format or non-SQL format, which equivalent of onspaces and onparams utility commands. This new enhancement of dbschema allows you to quickly reproduce the necessary command to duplicate a storage space. For example, you might want to generate the schema before you use the dbexport and dbimport utilities to move data or before you drop a space that you might want to regenerate at a later date.

There might be a situation when you need to do a disk initialization but want to maintain all the storage spaces, chunks, physical and logical logs layout afterward. The simple solution is capture the storage space schema before disk initialization and once disk initialized use the same storage space schema to recreate all necessary storage spaces.

Let's take a look how you can generate storage schema. There is couple of new options added to dbschema utility. The .dbschema -c command. generates SQL administration API commands for reproducing storage spaces, chunks, logical logs, and physical logs. If you use the "dbschema -c -ns" command, the database server generates onspaces or onparams utility commands for reproducing storage spaces, chunks, physical logs, and logical logs.

For example:

  • Run the following command to generate an output file named dbschema.out that contains the commands for reproducing the storage spaces, chunks, physical logs, and logical logs in SQL Admin API format:
    dbschema -c dbschema.out
  • Run the following command to generate an output file named dbschema.out that contains the commands for reproducing the storage spaces, chunks, physical logs, and logical logs in onspaces and onparams utility format:
    dbschema -c -ns dbschema.out

Regardless of the situation, it.s a good idea to generate and keep a copy of storage schema output, which can save time and effort in case of a disaster.

Sanjit Chakraborty

Informix resources Back to top

Informix blogs and things  
Calendar of events Back to top

January - 2011
Date Event Location Contact
24-25 Informix 11.7 Roadshow Phoenix, Arizona  
27-28 Informix 11.7 Roadshow Los Angeles, California  
31-1 Informix 11.7 Roadshow Denver, Colorado  
February - 2011
Date Event Location Contact
3-4 Informix 11.7 Roadshow Salt Lake City, Utah  
14-15 Informix 11.7 Roadshow Dallas, Texas  
21-22 Informix 11.7 Roadshow Toronto, Canada  
24-25 Informix 11.7 Roadshow Boston, Massachusetts  
March - 2011
Date Event Location Contact
2-3 Informix 11.7 Roadshow Chicago, Illinois  
7-8 Informix 11.7 Roadshow New York City, New York  
10-11 Informix 11.7 Roadshow Washington, D.C.  
21-22 Informix 11.7 Roadshow Atlanta, Georgia Southeast Informix User Group
24-25 Informix 11.7 Roadshow Orlando, Florida  
28-29 Informix 11.7 Roadshow Tampa, Florida  
May - 2011
Date Event Location Contact
10-12 2011 IDS 11.7 Bootcamp Kuala Lumpur, Malaysia Fong Lee Yong
15-18 2011 IIUG Informix Conference Overland Park, Kansas Cindy Lichtenauer

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
IBM Corp.
Editors:  Gary Ben-Israel

For comments, please send an email to