IIUG Insider (Issue #92)
February 2008

Other Issues

Highlights: VOTE for who you want on the IIUG Board, get into the Cheetah 2 Open beta program, Register for the 2008 IIUG Informix Conference and there is much more.

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.


Now. Turn the page... hit the 'pg dn' key... click down the page... whatever bangs your braces but read this issue of the IIUG Insider and then write me a note ( Do it NOW. :) :) :)


Editorial Back to top

Trev looked me up, the other day. I was, at the time, considering the nightmare scenario of Stu flipping burgers in a superman outfit in the lobby of the Overland Park Marriott Hotel in Kansas. He looked at me (Trev, that is), with a quizzical eye.

"Don't like the name." he said.

I had no idea what he was talking about and I told him so.

"Cheetah 2" he said, "Bout as original as sheep shags in a shearing shed".

I tried to imagine it. I failed.

"Cheetah 2" he continued without caring that I was now lost in the thought of Stu flipping sheep burgers surrounded by a quartet of sheep baaaring all. "Why did they have to call it Cheetah 2?" he asked, starting to warm to his subject. "I mean... what's with the number 2?"

When Trev starts like this you don't contradict the boy. "I dunno." I said. It was the best I could come up with under the circs. "Perhaps it is a binary thing". I said helpfully.

Trev gave me a withering glance that had an 'imbecile' tone attached, which I somewhat objected to. He looked away then turned back.

"I was talking to Norm" he said nonchalantly," and he suggested "Son of Cheetah," he paused, smiled and said quietly "But I got a better name."

I was a bit afraid to ask... "What?" I mumbled, not really wanting to know.

"Cheetah BABY!" He looked at me in a triumphant sort of way, sort of like a cross between a well fed cat and the business end of a charging elephant. Then he broke into a quiet song while drumming my desk with his fingers.

"Cheetah baby... when you run you're running so fast
You blast
Been some time finding your feet
But you're sweet
So come and rock my appln tonight.

Cheetah honey... Your gonna take the DB out of me,
For free
You're going make my application rock,
So come and Sap me over tonight".....

There were more verses, each progressively less rhythmic but, non the less, coherent, in a Trev sort of way. It all got a bit much.

I asked him to stop.

"Stop!" I said. "Enough with the singing!" I insisted. "Did you know that Cheetah 2 was out in Open Beta?" I was hoping to change the subject.

"Yes," he replied. "It rocks... on-socs." He continued to hum.

"Did you know that they are flippin Open Betas in Kansas" I said, starting to mix my metaphors.

"Yes" he said again, comprehending, if not understanding, me. "I'll be there," he said. "Best Informix conference ever".

And with that he turned and was gone. Well almost.

"Don't forget to vote!" he tossed over his shoulder as he finally lurched out.

"Who for?" I cried back... but I couldn't catch his reply.

And I was left doing an Eartha Kitt imitation, singing "Cheetah rocks" in my mind.

Well. I don't know about you but Trev had a point or two (or three).

  1. The Cheetah 2 beta is out. Read on and you will find out how to get it for yourself.
  2. The Informix Conference "ROCKS". Get your ticket quick before they sell out.
  3. And you just gotta vote for the IIUG Board.

But there is more that that in this Insider. So... you had better head on in and take a look.

Be outrageous.

David Fraser
The IIUG Insider man
IIUG Board of Directors

President's Note:

Once again the President gets to slip in a quick note in the Insider. I just want to call a few things to everyone's attention:

As you all know the IIUG Conference is coming up in just under eight weeks. As of the writing of this paragraph we are just about 2/3 Full. Yes this could be the first conference that sells out. Our fire code limit is 325. Once we hit it, we close the doors to registration!!

Also we are doing a video contest. The famous JGP is in charge of the video contest. With all the You-Tube hype out there why not share some fun on how you and/or your company uses Informix and IDS? And of course there is a second "serious" category for how you and/or your company uses Informix.

The other day an email went out that had the submission deadline as March 1. Sorry, this was a typo. It is really April 1 (and what better day to have that funny video submitted?). Winners in each of the two categories will get two free passes to the 2009 IIUG Informix conference. And all submissions will be featured on the web site!

On another note, I need to thank my two good friends, Kim and Angela, at IBM Database Magazine. Thank you to both of you for all your hard work on behalf of the Informix community. And yes the magazine has a new name. No longer will we refer to it as db2magazine, but rather IBM DATABASE MAGAZINE ( The first issue is available electronically in a link listed below or at their web site. Check it out.

Lastly, it is election time for the IIUG Board of Directors. Our good friend David Fraser, who will be leaving the IIUG Board this year, is overseeing the election along with departing board member June Hunt and IBM IIUG Board representative Bruce Weed. So as the saying goes, vote early and vote often.

Eight more weeks to the conference!!! Don't get shut out. Register now. I don't want to get emails or phone calls from people when we close the doors to registration. At this rate there will be no registration on-site as we will not have any space available. So register now at and oh yes, there is no truth to the rumor that Jerry Keesee, the IBM Informix Director of Development, lives at the special big house in nearby Leavenworth, but I am sure he will give you a tour!

Stuart Litel

Cool Informix stuff Back to top

Vote for the new IIUG Board

If you were an active IIUG member before the 1st of January 2008 then you can vote for the 2008 IIUG Board of Directors.

You just have to stop reading and... vote:

It will take less than 5 minutes.

Have you voted????????? No???? Then do it NOW dude!

Open Beta for Cheetah 2

Yep. Calling all techos, propeller-heads, pony-tails and other varieties of geekatrons. Cheetah 2 is now out in Open Beta. This is play time dudes with the "Son of Cheetah". Go... see for your self, download it and do your bit to help make this version the very best ever.

To download you have to go here: and follow the instructions. :)

Get the latest IDS white paper

After a bit of blah on Informix history this white paper discusses the capabilities that set IDS apart from the competition and distinguish it from other IBM RDBMS offerings (including DB2). It also shows how IBM has recommitted itself to IDS in terms of technology investment as well as sales and marketing effort, and how customers are deriving benefits from the product.

To read it go There you will find the link at the bottom of the page. Be warned... you have to register to download it, but it is worth it!!

Training, certification, fun ... it's all happening at the IIUG Informix Conference!

The IIUG Informix Conference 2008 is just around the corner. Just up the street from the IBM/Informix labs in Lenexa, Kansas, the Overland Park Marriott will be packed with attendees and the locals from IBM Tech Support and Development.

As the Informix Administration and Performance Track Chair, I am excited about the outstanding technical content in this track. Some folks you have seen before and others are new, but none are strangers to Informix. All of the sessions are updated to the latest and greatest tips and tricks not found in any manuals. If you are an Informix DBA, you do not want to miss this opportunity to learn and advance your skills.

Sunday starts with in-depth, half-day tutorials. The line-up includes:

  • IDS 11 Certification Exam Preparation
  • Troubleshooting Methods and Techniques
  • Encryption in IDS 11
  • Cheetah2
  • Advanced Troubleshooting Scenarios
  • IDS Does Hibernate
  • Open Admin Tool API
  • Application Development using Genero - 4J's
  • Exploring Next Generations Tools for Solving Complex IDS Challenges from AGS

More details about each on the Conference Registration website.

As always FREE certification testing will be onsite.

And the most important part of the conference, networking! The Welcome Reception will be held at the hotel Sunday evening. Monday the Informix developers and support staff from the Lenexa Labs will join us for a casual cookout, and Tuesday is the off-site party sponsored by Kazer Technologies. You may read about all of the details when you register. Space is limited and the price will go up March 1st. Time is running out so register today.

See you in Overland Park!

Informix Content Available Next Week at IDUG 2008 - Australasia

Are you looking for in-depth Informix education, networking opportunities with peers and industry experts, and IBM certification testing, all for a great value? Visit to learn more about IDUG 2008 - Australasia where you will find all this and much more!

Taking place next week, 5-7 March at the Cliftons Education Centre in Sydney Australia, IDUG will feature a stream of Informix content to help you advance as an Informix professional and grow the effectiveness of your organisation. Industry experts, including Scott Pickett from IBM Worldwide, William Byrne III from IBM Australia, Robert Clow from Datasync Consulting and David Fraser (not presenting thank goodness, just looking pretty) will all be present at this year's conference. Informix focused-content is new this year to IDUG and will be featured primarily on Wednesday, 5 March. To learn more about IDUG's Informix content, visit

Online registration is still available, so register for Wednesday's Informix-filled day or the entire conference by visiting Need help justifying attendance? IDUG's easy-to-use, customizable justification toolkit will help you build a strong case to attend or send employees to IDUG. Check out IDUG's justification toolkit at

Securing Your Data: Choosing the Right Platform - Webcast featuring Jonathon Leffler

Date is the 4th March 2008. See for details.

The IIUG is running a Video Contest

The videos should illustrate Informix Dynamic Server in action. IIUG will display the videos on IIUG.TV. Videos can be informative, fun, hilarious, sad or dramatic, but please do not hurt any animals or databases in the shooting!

You can pick your genre; anime, interview, Western... and pick any location; street-talk, dark data center, Paris' catacombs, Stuart's house (I can give the address if you need it)!

If you need inspiration, visit http://www.IIUG.TV or YouTube at (Informix search).

IIUG will give away two passes to our 2009 Conference - this is a value of over $1000 per winner! We will announce results during the Annual IIUG General Meeting (AGM) at the 2008 IIUG Conference.

Two categories:

  • Humor - can include jokes
  • Serious

There is one winner in each category. Each winner gets TWO free passes to IIUG Conference 2009.


  • Board members, CPC members and Jury cannot compete
  • IIUG gets full rights to use the video
  • Video producers are free to use IIUG artwork
  • You can use your artwork to promote your company
  • Video should not be more than 10 minutes long
  • No violent or sexual content


  • Have your videos ready by April 1st 2008, further instructions will be provided
  • Winners will be announced during the AGM at the 2008 IIUG Conference on April 28th

Finally, do not hesitate to contact me if you need any tips or simply to tell me you are in the running...

Watch for further announcements!

Jean Georges Perrin Proof of Technology - Informix IDS 11

salutations á tout le Français amical (great French eh? - ed)

The Proof of Technology (POT) will take place in Noisy-Le-Grand (Paris), the 19-20 March 2008. The purpose of this POT is to discover new features of IDS 11 with presentations and labs.

All IBM customers and partners are invited to this event.

The skills required to attend this POT are a good knowledge on Informix and Linux in order to get prepared to our labs on vmware Linux. If you want to participate to this event just confirm to and/or

CONNX Support for HP-UX 11i v2 on HP Integrity Servers

CONNX has been and continues to be a valuable tool for companies to access their HP-UX 11i data on HP Integrity servers and now extends that access to their applications. CONNX 10.5 SP3 gives companies the tools to enable HP-UX 11i applications running on Integrity to natively access off-platform enterprise data via JDBC or ODBC.

"CONNX gives application developers for HP-UX 11i on Integrity the freedom to seamlessly access off platform relational and non-relational data from any web engine or programming language," said Larry McGhaw, the CTO & VP of Engineering at CONNX Solutions, Inc.

CONNX Solutions continues to offer the same secure, real-time, read/write, SQL access, and seamless joins between most legacy and relational databases on Integrity servers running HP-UX 11i for:

CONNX is available on HP Integrity servers running HP-UX 11i for the above data sources. Contact CONNX Solutions at 888-882-6669 for pricing information.

"CONNX customers now have a clear path to migrate with HP from VAX and Alpha systems to new HP Integrity servers running OpenVMS. The CONNX client can now run on HP-UX 11i on Integrity servers," stated John Charpentier, Director of Marketing at CONNX Solutions, Inc.

CONNX Support for IMS DLI (Batch) Interface

With this new release, CONNX also offers access to IBM IMS data through both ODBA and DLI (Batch) Interfaces, providing greater flexibility in accessing IBM IMS data with CONNX.

About CONNX Solutions, Inc.

CONNX Solutions, Inc., located in Redmond, WA, is a leading provider of simplified data access, management and integration software solutions that allows users to directly access and manage vital enterprise information from virtually any data source (using open data access standards) including AdabasTM, RMS, Oracle® Rdb, Oracle® CODASYL DBMS, Oracle®, Microsoft® SQL ServerTM, Sybase®, IBM® DB2®, IBM® Informix®, IBM® C-ISAM, D-ISAMTM, Micro Focus®, IBM® VSAM, IBM® IMS, DataFlex® and Powerflex® databases.

CONNX Solutions' products, CONNX, DataSync and InfoNaut have been used by over 3,000 organizations worldwide. Government and business entities use CONNX in a wide range of industries, including manufacturing, education, healthcare, financial services, telecommunications, aerospace, and information technology.

For Simplified Data Access, visit

CONNX Solutions and CONNX are registered trademarks of CONNX Solutions. All other trademarks, registered trademarks, product names, and company names mentioned herein are acknowledged as the property of their respective owners.

Southern California Informix Users Group - Meeting March 6th

Time and Date: March 6, 8:30 am - 12 pm
Location: IBM
600 Anton Blvd. , Room 221
Costa Mesa, CA 92626
Parking in Structure (must pay for parking)
Parking at South Coast Plaza (FREE, walk across bridge)

We have something a little different planned for the next IUG meeting. Last October, IBM released it's next-generation database management and development tooling. The products are called IBM Data Studio and pureQuery. The interesting thing about these tools is that they support both DB2 and Informix Dynamic Server!

Accordingly, for this occasion only we've decided to hold a joint session of the Informix and DB2 user groups to hear IBM's VP and CTO for Database Servers talk about these new tools. Curt has responsibility for both DB2 and IDS tools and APIs, so please be sure to come and wave your Informix flag!

The doors open at 8:30, and the presentation starts at 9:00. We'll have coffee and pastries available as well. Also, be sure to invite your Java developers. They will be particularly interested in the pureQuery tool.

Please RSVP to if you plan on attending.

The basic version of Data Studio is available as a free download. It's an eclipse-based product available for Linux and Windows.


IBM Data Studio - Data and Application Life Cycle Management This presentation will provide an overview of IBM's new database and application life cycle management solution. Data Studio will provide a suite of integrated tools that allow the DBA or application developer to manage their DB2 and IDS databases. The presentation will show what is available today, and the expected rollout of new capabilities in 2008 and 2009.
pureQuery - Improved Management for Java Apps This presentation will show how pureQuery technology will maximize your ability to manage Java or .NET database applications that use DB2 or IDS. The solution provides unprecedented ability to perform problem determination, capacity planning, performance management, etc.

About Curt Cotner

IBM Fellow
Vice President & Chief Technology Officer for Database Servers

Curt Cotner is an IBM Fellow, and a member of the IBM Academy of Technology. Curt is the chief technology officer for the DB2 family and Informix IDS database servers, and has both management and technology oversight responsibility for all the client software offerings used with DB2 and IDS. This includes the client runtime APIs (JDBC, .NET, CLI, J-LinQ, etc.) and the application development and administration tools offerings (IBM Data Studio).

Prior to taking his current assignment, Curt was the Chief Architect for the DB2 for z/OS development team.

The New IBM Database magazine launches

The New IBM Database magazine (formerly DB2 Magazine) Q1 2008 issue now available online.

Read it folks. It has good Informix content.

Call for Speakers at IBM IOD EMEA Conference June 08

Call for Speakers Now Open for the IBM Information On Demand EMEA Conference June 3-6, 2008

The first ever IBM Information On Demand Europe, Middle East & Africa (EMEA) Conference will take place June 3 - 6, 2008 at the World Forum Convention Center in The Hague, and IBM is looking for a few good speakers. Do you:

  • work with strategic, management, or technical information?
  • use IDS products in a creative or novel way?
  • have experience in developing an interesting IDS application or technique?

The Conference provides an ideal platform for you to share your experiences with other IDS Customers and Business Partners. With a targeted audience of over 2,000 attendees, we not only want you to avoid missing out, we'd like you to come along and speak out!

REGISTER NOW AS A SPEAKER. Go to to submit your name as a potential speaker before March 3, 2008.

Informix success story

Get it now.

And check out the quote at the top of the page: "The Informix database has never failed to meet TranUnion's needs for the past 10 years of operation." - Warren Shum, Director, IT, Data Administration and Operations at TransUnion Ltd. Information means business for TransUnion Ltd.

2008 IIUG Informix Conference corner Back to top

Tutorials have been announced

The IIUG Conference Planning Committee has announced the eight half day tutorials that will be available on Sunday April 27th, 2008.

Sunday Morning Sessions:

  • Preparing for the IDS 11 Certification Exam - Guy Bowerman, Sanjit Chakraborty
  • Troubleshooting Methods and Techniques - Hyun-Ju Vega, Lead Instructor
  • Encryption in IDS 11 - Jonathan Leffler
  • Cheetah2 - The Safari Continues - Madison Pruet

Sunday Afternoon Sessions:

  • Preparing for the IDS 11 Certification Exam - (Repeat of morning session) - Guy Bowerman, Sanjit Chakraborty
  • Advanced Troubleshooting Scenarios - Hyun-Ju Vega, Lead Instructor
  • IDS Does Hibernate in the Winter, Spring, Summer and Fall - Jean Georges Perrin
  • Open Admin Tool API - John Miller, III

Full Descriptions available at:

The tutorials cost $125 for one half-day session and $200 for two half-day sessions. For more details and to register, please go to the conference website. Morning session includes continental breakfast and afternoon session includes lunch.

Free full day tutorials from Four J's and AGS
  1. Application Development Using Genero - 4J's
    This tutorial will discuss the migration of your current Informix-4GL applications, and how to create new applications for your Informix Dynamic Server (IDS) or Standard Engine (SE) databases for quick deployment in a Windows or Unix/Linux environment or over the Web. Covered topics will include Genero 2.10, Genero Studio, the Genero Application Generator, the Genero Web Client, and Genero Web Services. More info at
  2. Exploring Next Generation Tools for Solving Complex IDS Management and Performance Optimization Challenges - AGS
    This tutorial, designed for IDS developers and DBAs, will introduce attendees to the various tools at their disposal and demonstrate, with examples, how and when to apply each of these tools to efficiently manage and optimize performance of your IDS environment. Learn some of the best-practices, and save yourself many hours of wrestling with the complexity of your IDS infrastructure. Gain hands-on experience with how wide-ranging functionality provided by integrated suite of tools in Server Studio and Sentinel helps database professionals. More Info at

For more information on the tutorials visit:

Highlighted Tech Sessions and Speakers

Speaker: Ron Privett - SWG Client Support - Software Informix Advanced Technical Support Engineer, Lenexa KS

Session: Engine Hangs, Debugging Methods and Diagnostic Tools

Why would you want to attend this session?

  • Every wonder what the stack in the AF file really means? This discussion will cover how to Interpret AF Messages and Files.
  • Every wonder why your engine is hung? This discussion will cover the common reasons for hung systems, and what to collect for Tech Support.
  • Every wonder what 'other' methods Tech Support can use to solve your problem? This discussion covers various diagnostic methods and tools Tech Support may use to diagnose the issue.

Why do I love living in the Kansas City Area?

Personally, I enjoy the KC area most - during the Spring and Fall. During these times there are many things to do outside — such as: Walking on one of the interconnected trails in Johnson County, KS, catching a Royals Baseball game, or spending the evening window shopping on the Plaza or in Westport. One the best museums in the country, is the Nelson-Atkins ( and offers free admission. And the barbecue in the KC area cannot be beat — the following are my favorites:

  • Fiorella's Jack Stack Barbecue: Overland Park at the corner of 95th and Metcalf (913-385-7427)
  • Hayward's Pit Barbecue: 11051 Antioch Rd, Overland Park, KS 66210 (913-451-8080)
  • Oklahoma Joe's Barbecue: 11950 S Strang Line Rd, Olathe, KS 66062-5267 (913-782-6858)
  • Gates Bar-B-Q: 103rd & State Line, Leawood, KS, (913-383-1752)
  • Arthur Bryant's: 1727 Brooklyn Ave, at E 18th St, Kansas City, MO 64127 (816-231-1123)
More reasons to come to Kansas City

Oh... You want reasons to come to Kansas City besides a Great Informix Technical Conference?

As part of the IIUG Conference Planning Committee AND a Kansas City resident, I decided that I would pick a interesting place to visit and highlight it in the Insider each issue leading up to the conference.

This month's highlighted venues are:

The Nelson-Atkins Museum of Art (As mentioned above by Ron Privett)

You are invited to discover some of the 34,500 pieces in the collection of The Nelson-Atkins Museum of Art. From ceramic objects found in ancient Chinese tombs to whimsical sculptures of badminton birdies, the Nelson-Atkins collection spans over 5,000 years of humanity.

The Nelson-Atkins aspires to create a glorious environment--the ongoing experience which is in itself as compelling as a single "blockbuster" event. Each visit to the Nelson-Atkins brings different connections and unique experiences. Whether you are exploring the collection for the first time or the hundredth time, there's always something new.

Negro Leagues Baseball Museum

Part of the Museums on 18th & Vine complex, the Negro Leagues Baseball Museum (NLBM) recreates the look, sounds and feel of the game's storied past. Video presentations and memorabilia in the 10,000 square-foot multimedia exhibit chronicle the history and heroes of the leagues from their origin after the Civil War to their demise in the 1960s. The federal government recently designated the museum America's National Negro Leagues Baseball Museum.


  • The museum is laid out as a timeline of the Negro Leagues and American history. Exhibits include hundreds of photographs, historical artifacts and several interactive computer stations.
  • As the centerpiece of the NLBM, the Coors Field of Legends features 10 life-sized bronze sculptures of Negro Leagues greats positioned on a mock baseball diamond as if they were playing a game.
  • A documentary film narrated by actor James Earl Jones tells the story of the leagues with vintage film footage.
  • The Hall of Fame Lockers pay tribute to the Negro Leaguers who have been inducted into the National Baseball Hall of Fame.

Free Certification at 2008 IIUG Informix Conference

Free IBM Informix certification will be offered at the 2008 IIUG Informix Conference in April during the following hours:

Monday April 28th - 9:30 AM - 4:30 PM
Tuesday April 29th - 8:00 AM - 4:30 PM
Wednesday April 30th - 8:00 AM - 4:30 PM

All IBM Information Management certifications will be offered AND there is no limit on the number of tests you can take. Each test is normally $150! Take four tests and you have paid for your conference fee!

For a list of certifications available go to the IBM website:

Informix resources Back to top

New articles in developerWorks

These are two articles added to developerWorks in February:

Informix blogs and things

Get the real oil on Informix from:

Calendar of events Back to top

March - 2008
Date Event Location Contact
5 Australia Informix User Group Meeting Cliftons Education Centre Sydney, Australia David Fraser
6 Southern California Informix User Group Meeting IBM Facility, Costa Mesa Neil Williams
18-20 IDS Cheetah Technical Workshop Zagreb, Croatia Hrvoje Zokovic
19-20 IDS 11 Proof of Technology Workshop Noisy-Le-Grand Paris Eric Fleury
April - 2008
Date Event Location Contact
1 Submit your video before April 1st!   Jean-Georges Perrin
3 Washington DC Area Informix User Group Meeting IBM Facility, McLean, Virgina Lester Knutsen
27-30 2008 IIUG Informix Conference Overland Park, Kansas Cindy Lichtenauer

Board News Back to top

Board elections are here. If you have read this far then you should have voted. If not go back to the top of the page and start again. :).

Useful links Back to top

In response to your input, we have created a page on the IIUG web site containing all the links we used to include. Please find it at:

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. 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
Editors:  David Fraser
Stuart Litel

For comments, ideas, information, more ideas, gossip, lies and general dudette type chatter, please send an email to