As you can see the change is not too traumatic.
If you subscribe to one of the SIGs that is affected you will receive an email from me inviting your feedback. Then, assuming that the feedback is generally positive we will proceed with the consolidation. Again, for existing subscribers, we will not consolidate you without your agreement. This means that you will get a further email from me asking if you wish to subscribe to the new SIG. The process to confirm your subscription is very simple and I hope that you will renew in the new groups.
All of this is going to happen in December when we upgrade to our new server.
SIG visibility. With the implementation of our new server we will be making the SIG's available in read only mode to the general public. You still need to be a member to post messages. This is a service to help new Informix uses find the treasure of information that exists in the SIGs.
Board of Directors
International Informix Users Group
A pop quiz on Informix past, present and future
Did you know that Janet Perna, the general manager of IBM Information Management software (the division of IBM that owns Informix), recently retired? I first spoke to Janet in 2001, on the day IBM announced it would purchase Informix. We constantly debated the merits of Informix over the next years. Janet asked me to "embrace all IBM technology, as it was first class." And she was right: IBM technology is first class. And, Janet, you're also first class. Good luck in all your future endeavors.
Did you know that Perna's successor, Ambuj Goyal, is an IBM veteran and was most recently general manager of the Lotus Division? Not long ago, I had the chance to meet Goyal and spend an hour with him. When I asked about his plans for Informix, he told me, "I love all my children," referring to the many databases in the IBM Information Management portfolio. And, from what he told me, he loves all his children equally, especially those products that make money for IBM. Guess what? Informix makes money for IBM.
Did you know that some people still believe Informix will go away? I want to bury these rumors. Informix won't be going away. In fact, after my meeting with Goyal, I felt quite happy about what I believe will be in store for Informix. Things are looking better than they have since the acquisition announcement.
Did you know that Informix was founded 25 years ago in California by Roger Sippl? The company was then called Relational Database Systems, and its products were known as Informix database software. In the early years, the tools (such as SQL, Perform, Ace, ESQL, and 4GL) were sold and the database was given away for free. That changed years later when the database was opened up to work with other products. When the company went public in the 1980s and changed its name to Informix Corp., it became the number-one performing stock based on percentage stock gain during the period from Jan. 1, 1990, to Dec 31, 1995, for any U.S. stock exchange.
I recently read The Real Story of Informix and Phil White (Sand Hill Publishing, 2005). Written by Steve Martin (no, not that Steve Martin), who worked for Informix during the 1990s, the book sheds a lot of light on the company's history. I highly recommend the book, available at http://www.storyofinformix.com (IIUG members even get a $4.00 discount).
Did you know that after pulling off a successful joint conference in 2005, the IIUG and IDUG are joining forces for a conference in 2006? Joe Burns and Cindy Lichtenauer will lead the event in Tampa, Fla., May 7 to 11. This will be the largest gathering of Informix users in the world, so mark your calendar for 2006 and visit http://www.iiug.org/conf for more details.
Did you know that the IIUG Web site offers more than 25 special interest groups via email or Web-based forums on everything from database engines to tools and has the largest known repository of Informix tools, programs, tips, and tricks anywhere? That may be why IIUG membership (which, by the way, is free) is up more than 50% since the IBM buyout.
Did you know IBM has a special tele-sales marketing organization to help IBM business partners market their IBM-related products at no charge? Informix partners have used this unique cross-brand lead generation program to reach out to small and midsize business customers using IBM representatives. The team's mission is to promote partner solutions that include IBM software components. This service showcases the global cooperation between IBM and Informix partners and resellers. Please contact William Freiwah at email@example.com for more information (and tell him Stuart sent you).
And, finally, did you know that sales of Informix are up quarter over quarter at IBM? Please encourage anyone with concerns about Informix's future to send me a note at http://www.iiug.org/president.
By Stuart Litel
Stuart Litel is CTO of Kazer Inc. and President of the International Informix Users Group.
The IDS V10.0 World Tour Recap
First of a 4-part series on "Informix@IBM"
This year has been incredibly busy for the IDS team. I have personally visited 9 countries, 30+ US cities...all to "evangelize" the largest IDS release since version 9. Many of the trips were very hectic - sometimes 4 cities in 4 days across two countries. They included Infobahns, T3's (training for partners and IBM folks), and Informix User Groups - and more than I could cover by myself. Jacques Roy, Christine Normile, Danilo Novelli, Manny Corniel, Jerry Keesee, and others have also addressed similar crowds in many countries this year - we were just "too busy" and had to pull many IDS folks into the mix. This is a great sign for the Informix faithful.
Many asked "how could you do it?" alluding to the schedule and how our team could physically stay sharp and cover so much ground. My take on this is simple - it IS hard work, but right now it's very important work for the future of IDS. As mentioned, IDS v10.0 is the largest release since v9.x, so there is much to talk about with respect to architecture, features, and future technical direction of the product.
Some highlights of the tour....
- Close to 100 partners, clients, and developers attended the IDS Infobahn in Argentina. Nearly 200 in the Prague Infobahn.
- Very good client visits in many countries - including Brazil, Malaysia, Argentina, and Belgium. In almost all cases, this gave the clients confidence to go forward and renew, purchase, and make future plans for the continued use of IDS.
- T3's - 2 days of technical training on IDS v10.0 features and functionality, held in Tokyo, Denver, Atlanta, and other locations.
- A very successful Infobahn in Tokyo, including Janet Perna speaking on the future of IDS. In attendance were many clients and partners. At this Infobahn I received the first request for a help to migrate Oracle applications to Informix. Eventually we started the development of the Oracle-to-Informix MTK, or Migration Toolkit. It is still in development, but it's very exciting to have requests from multiple clients for this.
- I visited 30+ US Informix User Groups to continue "evangelizing the clear message" to Informix users.
Everywhere we traveled, we turned heads. We closed many deals for purchase or renewals of IDS, mostly due establishing a new confidence about the future of IDS. We were asked to visit mostly because clients still didn't believe that IDS is here to stay. This is largely due to the mixed messages that clients have been getting over the past 4 years with respect to IDS and DB2. That message "officially" changed in August of 2004 - that IDS is a flagship database product for IBM, particularly in the OLTP space. But to completely change the message has taken time - and many road miles.
I do continue to receive many emails from clients still concerned about the future of IDS. After all these miles, this seems a bit surprising, but I realize that the continued requests shows that there are still more clients we haven't touched yet. So we have more chances going forward to solidify "IDS' rightful place in the industry - and in the IBM portfolio." So again, we are lining up visits as fast as we can. Our team will still continue to visit, webcast, write, develop, and shake the hands of our IDS clients...until IDS has again taken its rightful place - as a database market leader.
In my next article, I will cover "Proof of Life: IDS@IBM", highlighting "proof points" that should show conclusively that IDS is here to stay - for our clients, and for the Informix faithful.
Informix Technical Evangelist - Worldwide Team
Chat with the Lab
Our December Chat with the Lab will be Thursday, December 8 at 11 AM Eastern Standard Time:
Indexing and Fragmentation Strategies by Mark Scranton.
This month we are joining the Informix Users Forum meeting being held in Atlanta at Home Depot. The session begins on a Thursday which is why we are departing from our normal Wednesday session. Mark Scranton will be discussing Indexing and Fragmentation Strategies. Mark is a Worldwide Technical Strategist for Informix. Jerry Keesee, Director of the Informix Lab, will be kicking the session off.
Please RSVP to: https://ww4.premconf.com/webrsvp/register?conf_id=8964976
Save the date: Our next Chat will be Wednesday, February 8, 2005. There will be no Chat in January.
Replays of previous Chats may be found at:
PHP driver for Informix Dynamic Server (IDS) - beta release
Are you looking for an optimized PHP driver for Informix Dynamic Server (IDS)?
IBM has recently contributed a PHP Data Objects (PDO) driver for IDS to the open source community.
The driver is now available:
I had to try MySQL
As some of you already know, I had a bit of free time lately and I investigated MySQL (and PHP). "Why should I keep using IDS when I can get a freebie for free?" Well, this was my initial thinking...
When you get to download the product, it's a bit faster than to get to an IBM evaluation product. You also need to look for GUI tools elsewhere, which is at first cumbersome. You go back and forth to find what you really need. You really need to pick 2 of them, the MySQL Administrator and MySQL Query Browser. Both tools are far beyond what one can find in excellent AGS ServerStudio. Client connectivity also needs to be downloaded separately.
Installation is pretty straightforward.
One "cool" thing I found was "backuping". MySQL Administrator has a "single file" backup capability (in a .sql file). So I now archive seven databases in just one SQL file. When backbiters say it's not possible to back up Oracle data, they should switch to MySQL. I must admit I voluntarily did not try to break the backup tool. I use it on four different web sites, archiving CMS data. The web sites are filled with plenty of read-only data, so there is practically almost no risk (and I cron'ed a backup every 12 hours and the data is mostly recoverable).
Security was really my most painful experience with MySQL. The default user "seems" to be root and you initially start the database with no password. You need to create at least a user and grant it most rights if you plan on using the administration tools remotely. Then you "grant" access to user using SQL commands or the MySQL Administrator tool. You can limit connectivity by your client's IP address or name (actually, I did not manage to make the machine's name work). Finally, it gets on your nerves and you grant every right to every user connecting from everywhere. That's the right way to do security. Oh... Don't forget to flush the privileges after you ran all those granting SQL commands; otherwise you're lost.
I did not find system tables, but a system database called "mysql". The system tables in this database even contain help text... I think Art Kagel would be sad (mad?) not to be able to play with all the systables... It's a clever system, it does not need anything as complex as systables...
I am still in the early stages in discovering all the features, but I am not excited about the whole story.
Then I studied pricing. It is free as long as you hope it's going to work. There is no license cost. However, support fees range from Basic at 245₠/server/year (that was a few trillions of USD at the beginning of the year, now about $285) to about 4,000₠/server/year (about $4,650). The supported version includes a "pro version" of MySQL, which does not look like Open Source anymore.
Is the global TCO (Total Cost of Ownership) only a license cost away? Well, it really looks like it is and IDS Express starts at only 633₠ (which turns out to be only $624, thanks to IBM France) - ok, that's a base price where you add users, but you can also get discounts, so...
Finally, there are also political reasons to make the choice. Reliance in the vendor is one. Alliances is another. Owner of the technology is another:
"October 7, 2005 - Oracle Corporation announced the acquisition of Finland-based Innobase OY. Innobase is the developer of discrete transactional database technology, InnoDB, that is distributed under an open source license. [...] InnoDB is not a standalone database product: it is distributed as a part of the MySQL database. InnoDB's contractual relationship with MySQL comes up for renewal next year. [...]".
If after all you still consider MySQL as a viable choice, you may be right for small, non critical applications, for which I'd use derby (oops, cloudscape)... MySQL managed to fill a niche when no Open Source database was available. Now, as the market matures, we should be more critical and careful in our choices.
(EDITOR'S NOTE: The author has provided some post-Insider clarifications at /news/articles/mysql_jgp.html.)
Jean Georges Perrin
IBM developerWorks Informix zone
The Informix zone in IBM developerWorks can be reached at the following URL:
It is a valuable source of technical information.
Introduction to the TimeSeries DataBlade
Sean R. Durity (firstname.lastname@example.org)
27 Oct 2005
Date and time-stamped data is growing at tremendous rates. The Informix® TimeSeries DataBladeTM offers powerful tools for storing, manipulating, and accessing this type of data. Data architects and programmers can learn how to use this DataBlade to shrink data storage and improve processing time for time-related data. The article concludes with real-world advice based on 3 years of production use.
When to step to the plate
The Informix TimeSeries DataBlade was designed to help Informix users better handle time-related data. Using the object-relational technology built into the Informix Dynamic Server, the TimeSeries DataBlade reduces the size of the data, speeds up processing across that data, and provides a new set of tools for analyzing it. As the User's Guide presents, the performance gains can be remarkable. Space can be reduced by 55%. Processing can be up to 30 times faster. It is truly a useful technology for a specific data problem.
The TimeSeries DataBlade works on large sets of date-time-based data. Examples are: stock/financial data (this is the primary example in the User's Guide), audit trails or logs, monitoring statistics, weather, seismic readings, and billing. The TimeSeries DataBlade can be paired with the Real-Time Loader to handle huge volumes of streaming, real-time data. Because of the difficulty of migrating TimeSeries data and schemas, TimeSeries is best used with known data schemas that are unlikely to change.
If you are interested in this article you can go to it directly at:
IBM Express Runtime Integration with Gillani IDistribute V8.2
Gillani is currently working with IBM on integrating iDistribute V8.2 - an end-to-end Supply Chain Management Solution, and Gillani Financials (formerly FourGen Accounting) - with IBM Express Runtime. IBM Express Runtime provides packaging and installation technology to create and deploy complete business solutions across multiple platforms and offers a cohesive set of middleware components as a single offering. Gillani/FourGen solutions are deployed by customers on IDS, SE and IDS Workgroup Edition. Now users will have the option to run the applications on IDS Express as well.
IBM Express Runtime contains a variety of integrated components to serve as a scalable yet robust environment to deploy applications. Following is the list of components that is included in the IBM Express Runtime product:
- IBM Informix Dynamic Server or IBM DB2 Universal Database as part of middleware offering.
- IBM WebSphere Application Server to support JSP and servlets.
- IBM HTTP Server and Plug-In to support your Web Environment.
- Solution Assembly Toolkit to provide development and deployment of tools for creating and delivering a complete Solution Package.
- IBM Express Runtime Console - an integrated solutions console - to allow developers to create a dashboard to manage their entire set of solutions, locally or remotely. This Console will also allow third party products to be easily integrated into the application solutions environment.
- IBM Rational Web Developer - an application development environment - to build and maintain J2EE apps & Web Services.
In all, the Integration process will provide Gillani's customers a seamless & smooth installation process and will have multiple options to choose the type of middleware and web services components at the time of installation. The timeline for the release of Integration process is set for the end of this quarter (Q4 2005). For more information, visit http://www.gillani.com.
Calendar of events
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: http://www.iiug.org/quicklinks.html
Closing and credits
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.
IIUG Board of Directors|
Gary Ben Israel|
Jean Georges Perrin
For comments, please send an email to email@example.com.