|End of Support Dates|
IIUG Insider (Issue #15)
|Q:||How do you use Informix in your "real" job (DBA, Consultant, Developer, etc.)?|
|A:||I am a freelance Informix consultant specializing in applications (4GL, 4Js) and DBA work (5.X, 7.X and 9.x) for about the last 12 years.|
|Q:||How long have you been using Informix products?|
|A:||TOOOOO LONG.... for almost 19 years I have been using Informix products, including doing the beta test on the Informix products that included the very first versions of the SQL products, 4GL, RDS, Interactive Debugger, and the original version of OnLine which was then called Turbo. I have been using their products almost every work day for the last 19 years.|
|Q:||What is your role on the IIUG Board?|
|A:||I am responsible for the IIUG Server and have been overseeing the server, including developing the Member Area and getting much of the content for it. I think there needs to be some "genuine Informix" material available to members only.|
|Q:||Why did you volunteer to be on the board?|
|A:||I actually enjoy it. The biggest reason is to meet and work with Informix users around the world. In fact, I possibly communicate with more Informix users on a regular basis than anyone else given my responsibilities running the IIUG Server and as webmaster of iiug.org. The part I actually enjoy is meeting the people personally, so if I travel I try to meet the people I might know in the area I'll visit. Over the past years I have met thousands of Informix users and communicate with many of them still today. Just a few weeks ago, at Forum 2002, I ran into an Informix user I had not seen in about six years. Great talking about old times!|
The complete profile may be found at: http://www.iiug.org/iiug/bio_slitel.html.
This is another contribution from an esteemed IIUG Directors Award winner: the very famous Jonathan Leffler. His original posting was made in CDI, but we've taken the liberty to do a little copying and pasting:
IBM Informix Database Driver for Perl (also known as DBD::Informix) is the driver code that enables Perl 5.005 or later to access Informix databases via the DBI module. You will need the code for DBI version 1.14 or later as well. You should upgrade to - at least - version Perl 5.8.0. The code is available for download via:
- When you successfully build Informix Database Driver for Perl, use the ItWorks (Perl) script to report your configuration to the maintenance team at either firstname.lastname@example.org (yes, this is a change from the 1.00.PC2 release), and copy Jonathan Leffler. Note that ItWorks does not send email to anybody; you have to do that yourself.
New in release 1.04:
- This release is supported by Jonathan Leffler. It isn't clear what
IBM's official stance on the product is. However, they do support
DBD::DB2 so there is likely to be minimal objection to this work.
- This release provides support for INSERT cursors.
- This release provides support for UPDATE of blobs (BYTE and TEXT).
- This release provides semi-tested support for BEGIN WORK WITHOUT
- This release works with ClientSDK 2.80; the prior versions of
DBD::Informix do not because the version string changed radically.
- Has better support for non-standard Perl installations.
- You can tell DBD::Informix to avoid testing smart blobs if you have
IDS 9.x but no smart blob spaces. You can also say which smart blob
space to use if you don't want to use 'sbspace'.
- Fix up file locations so it works better with CPAN.
- Functionally the same as 1.04, but with the wrong Announce file. It's amazing how you never spot these problems until too late.
As always, see the ChangeLog file for details about what has changed.
The last quarter of 2002 is full of Informix-themed events. With the InfoBahn road show in full swing and a bevy of local user group meetings, the Informix community will have ample opportunities to meet, learn and network.
Important highlights of the last month include user group meetings in Northern California, Southern California, Washington DC, Central Florida, and Germany. Typical of local user group topics of interest, the Northern Cal group's agenda included Mark Scranton's IDS Performance Tuning Foundations, case studies from our local members and an overview of what's new in IDS 9.4.
Most importantly, though, were the foundational meetings for future user groups in Seattle, Washington, and Toronto, Canada. Interest in both cities was very strong. We expect to see new user group meetings there soon!
For December, local user group meetings are scheduled at:
|Dec. 4:||Boston, Massachusetts - http://www.iiug.org/neiug/|
|Dec. 5:||Philadelphia, Pennsylvania - http://www.iiug.org/gpaiug/|
|Dec. 6:||New York City, New York - email@example.com|
|Dec. 10:||Chicago, Illinois - http://www.chiug.org/|
|Dec. 11:||Brüttisellen, Switzerland - http://www.idbug.ch/|
|Dec. 18:||Phoenix, Arizona - http://www.iiug.org/aziug/|
2003 will be upon us too soon. IIUG would like to encourage all local user groups to begin planning their first meeting of the year and let us know those dates to make sure you are in our calendar.
IIUG's efforts to provide Informix partners a place to exchange valuable business and technical information continue. The Partners special interest discussion list now exceeds 100 members; IBM's representative to the list has begun sharing information and requesting suggestions. If you are an IBM Informix partner and want to participate, please visit the IIUG Member Area at www.iiug.org/members, then click "Subscriptions" and select the appropriate SIG list.
Additionally, a new and open e-mail alias has been created to support Informix partners: firstname.lastname@example.org. The objectives of this new tool are:
- To supplement IBM's PartnerWorld Partnerline [http://www.ibm.com/partnerworld/pwhome.nsf/weblook/questions.html] as a secondary resource for IBM Informix partners.
- To answer channel related topics when the legacy Informix partner doesn't know where else to go.
- To add IIUG into the IBM Informix partner resource mix.
IIUG member Rudy Fernandez recently published a very interesting note at http://www.geocities.com/RudyFernandes/DBAStuff/SQLvInformix/Main.html, sharing a series of tests he ran to "get a feel of how well SQLServer/W2K used resources of a machine when compared to Informix/Linux" using the same hardware.
Good job, Rudy! And thanks so much for allowing us to refer your story.
Please take note of the following upcoming webcasts which IIUG considers of interest to the Informix community:
- Dec. 5: IBM's "IBM Informix DataBlades Solving Business Problems". Details at
- Dec. 10: IBM's "IBM Informix OnLine Extended Edition 5.20 and Classics Tools": http://www.iiug.org/resources/webcasts/webcast_10dec02.html.
Please note that IIUG's webcast replay facility will no longer be available after 11 December. We encourage you to visit our Webcast Corner at http://www.iiug.org/news/webcasts.html to review past events. Among them:
- Getting the Best Performance from the IBM Informix API Products
- Informix Future Visions: A Follow-up on the Informix User Conference and Latest Product Information
- Using IBM Office Connect with the Informix Dynamic Server (IDS)
- IBM Informix 4GL Modernization Interactive Webcast
- The Websphere App Server and Informix Dynamic Servers
- Best Practices for Informix Database Performance: A Field Study
|IBM Informix Homepage:||http://www.ibm.com/informix/|
|IIUG Software Repository:||http://www.iiug.org/software/|
|Informix Answers Online:||http://www.ibm.com/software/data/informix/pubs/library/|
|Informix Product Family News:||http://www.ibm.com/software/data/informix/news/|
|Informix Today - Subscription & Archive:||http://www.ibm.com/software/data/informix/informixtoday/|
|IBM Informix Support Site:||http://www.ibm.com/software/data/informix/support|
|Informix Developer Zone:||http://www7b.boulder.ibm.com/dmdd/zones/informix/|
|Data Management Certification Program:||http://www.ibm.com/software/data/db2/skills/cert.html|
|Informix Page Within IBM PartnerWorld for Developers:||http://www.developer.ibm.com/data/informindex.php|
|Recent Data Management Product Announcements:||http://www.ibm.com/software/data/launch/|
|Upcoming IBM Conferences Worldwide:||http://www.ibm.com/services/learning/conf/|
|Bad Press on Nasty Informix Competitors:||http://www-3.ibm.com/software/data/news/competitors.html|
The International Informix Users Group (IIUG) is an organization designed to enhance communications between IBM and its worldwide user community. IIUG now exceeds 16,000 members 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 Smith, IIUG Board of Directors|
Jean Georges Perrin, IIUG Board of Directors
Fred Hubbard, IIUG Managing Director, and
Paul Etcheverry, IIUG Editor
|For comments, please send an email to UG@IIUG.org.|