Highlights: Modifications to the Innovator-C Edition of Informix
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.
- Conference corner
- Developer corner
- Sponsor corner
- Informix news
- Support corner
- Informix corner
- Informix resources
- Calendar of events
- Useful links
- Closing and credits
|Editorial||Back to top|
The world is focused on the 2012 Olympics in London. Unfortunately there is no competition for databases. If there was, Informix would gain more gold medals then the USA and China combined. Nevertheless, for all sport fans from all over the globe I wish well to you all.
IIUG Insider Editor
|Highlights||Back to top|
IBM has made modifications to the Innovator-C Edition of Informix. Many of the previous limits were too broad and were not sustainable for our business partners. Innovator-C continues to be a robust database requiring little or no administration for small-to-midsized applications, available at no-charge.
The revised 11.70 Innovator-C Edition includes the following capabilities and limits:
- Limited to 1 core/1 CPU VP and 2GB of memory.
- Unlimited data storage.
- Includes some autonomic features that minimize system failures and improve performance
- Offers automated backup and restore functions while eliminating many manual tasks
- Allows a customized deployment footprint, and application control of the server via the administration API, making it even easier to develop integrated applications
- Delivers easier use of location-based data in an SOA environment with the Web Feature Services API
- Integrates through a full range of APIs, including Java and Microsoft .NET and supports a broad range of integrated development environments (IDEs), such as Eclipse, IBM Rational Application Developer and Visual Studio .NET
- Operating systems supported: Linux, Windows, and MAC
To view more about the features and benefits of Innovator-C, review the following link:
World Wide Director, Informix Software
IBM Data Management
|Conference corner||Back to top|
Information On Demand 2012 Sample agenda builder
Have you created your sample agenda using the Information on Demand 2012 sample agenda builder? This new IOD 2012 smart site enables you to start building your agenda. Once you build your agenda you will be able to download your sample agenda. This agenda builder is only for evaluation purposes. You must be registered for the conference to actually schedule and enroll in sessions. You may save or email a sample agenda as a pdf file.
Get more details here:
Save Big at Information On Demand 2012
Save $300 on your registration fee and save big on your hotel accommodation when you register by August 31. And another good news for our IIUG members : You can save $100 on your registration fees at IOD 2012 by registering using the following promotional codes:
- If you are a customer please use the promotional code: D12CUG
- If you are a business partner please use the promotional code: D12BPUG
|Developer corner||Back to top|
Evaluate: Informix 11.7
Download a trial version of Informix Ultimate Edition 11.7 or download one of the free editions: Informix Developer Edition 11.7 (for development use only) or Informix Innovator-C Edition 11.7 (for small production workloads.)
Also available in:
|12 Jul 2012|
Compare the Informix Version 11 editions
Get an introduction to the various editions of IBM Informix, and compare features, benefits, and licensing considerations in a side-by-side table. Regardless of which edition you choose, Informix brings you legendary ease-of-use, reliability, stability, and access to extensibility features.
Also available in:
|5 Jul 2012|
Oracle to IBM Informix porting guide
This article describes the differences between Oracle and Informix functionality and syntax. In addition to DDL, DML and overall SQL syntax, you’ll explore the differences between Oracle and Informix with regards to the use of large objects, user-defined types, user-defined routines, and table partitioning.
|1 Jul 2012|
Save this link to find about Informix on DeveloperWorks: /url/devworks.html
|Sponsor corner||Back to top|
Remote Technical and DBA support from Advanced DataTools helps small, medium and enterprise installations maximize their IBM Informix database performance and uptime while minimizing costs and overhead. We can help resolve and/or prevent the worst technical problems you could imagine!
Advanced DataTools’ staff of highly experienced, certified IBM Informix consultants are well trained in all levels of database performance and optimization. This allows us to offer our customers IBM maintenance and support contracts on most versions of Informix Dynamic Server, on any platform/operating system.
Top experts in the field, Art Kagel and Lester Knutsen, manage and support our team of certified IBM Informix consultants. Art and Lester each have over 28 years of Informix DBA experience and both have received the IIUG Directors Award, and the Inaugural Data Champion award by IBM.
For more information: http://www.advancedatatools.com/Solutions/Support.html
September 10-13 2012 – Informix for Database Administrators
This course is for database administrators, programmers, and technical support personnel who will be setting up, managing, and tuning IBM Informix 11, 10 or 7 databases.
December 3-6 2012 – Advanced Informix Performance Tuning
This course is for database administrators and application developers who will be responsible for managing, optimizing, and tuning an Informix 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 Informix database server.
All courses may be taken online on the web from your desk or at our training center in Virginia. All you need is a web browser and a SSH client (like Putty) to connect to the lab machines in our office.
The follow is a link to the courses on our web site:
http://www.advancedatatools.com/Training/CourseRegistration.html or call 703-256-0267 x101 for more information and to Register
|Informix news||Back to top|
Empowering Business Analysts with Faster Insights!
A DBTA article by Keshava Murthy (Senior Technical Staff Member at IBM Informix development working on query processing and data warehousing)
IBM Data Magazine
New Certification : With this new exam and certification role, the successful candidate will be able to:
- Identify the files and applications necessary to install and configure Genero
- Run and recompile in both text and graphic mode
- Enhance applications with Genero features
- Enable Genero for the web
- Generate reports
- Implement web services
The exam consists of 70 questions, which students will have 90 minutes to complete.
|Support corner||Back to top|
When products are built with different versions of CSDK, or include a different version of CSDK, they must be installed in separate directories.
The Informix server 11.50 is shipped with a Client SDK (CSDK) whose version matches the server version. Informix 11.50.xC9 will ship with CSDK 3.50.xC9, where ‘x’ is F for 64 bit systems, and ‘x’ is either U,T or H for 32 bit systems.
Likewise, Informix server 11.70 is shipped with a Client SDK whose version matches the server version. Informix 11.70.xC5 will ship with CSDK 3.70.xC5, etc..
The tools such as the 4GL compiler, debugger, or rapid development system, or ISQL (and their respective runtimes) are also built with CSDK. The version of CSDK used will depend on the current release level of CSDK at that time, and whether it is intended to be used with Informix 11.50 or Informix 11.70.
Because of product architectural issues, 3.50.* and 3.70.* libraries cannot be mixed. Doing so will lead to application failure. Failure symptoms may include, but are not limited to blank form screens and core dumps. Application program failures do not appear to effect data in the database.
When you install tools in the same directory, you may overwrite the library of one product with the same library of the second product. This is not a problem as long as the products are built with the same version of CSDK, down to the minor release level. (e.g. 3.50.xC5 where C5 is the minor release). If the products are built with different versions of CSDK, it may cause problems which lead to application program failure.
If you have products which have been built with different versions of CSDK and installing them in the same directory has led to problems such as blank screens and core dumps, then segregate the products by CSDK build version. Set your PATH and LD_LIBRARY_PATH variables as appropriate for the users.
You can find the version of CSDK used to build a tool by untaring the product file, and checking the machine notes file under $INFORMIXDIR/release/, or by going on line to the Information Center for the appropriate Informix server and drilling down to Release Information, then Informix 4GL, then the particular release version, then Release Notes. In that file you will find the version of CSDK used to build the tool.
Note that the version of the tool and the version of CSDK used are not necessarily the same. For example, 4GL 7.50.xC6 was built with CSDK 3.70.xC4.
|Informix corner||Back to top|
Effective on the dates listed below, IBM. will withdraw from marketing, part numbers from the following product releases licensed under the IBM International Program License Agreement:
|Program number||VRM||Withdrawal from
|Program release name|
|5725-B41||11.50.0||08/17/12||Informix Choice Edition V11.50.0|
|5724-C23||3.0.0||08/17/12||Informix Client SDK V3.0.0|
|5724-C23||3.50.0||08/17/12||Informix Client SDK V3.50.0|
|5724-C24||3.0.0||08/17/12||Informix Connect Runtime V3.0.0|
|5724-C24||3.50.0||08/17/12||Informix Connect Runtime V3.50.0|
|5724-L23||10/16/12||Informix Dynamic Server (IDS)|
|5724-C29||1.30.0||08/17/12||Informix Excalibur Text Search DataBlade. V1.30.0|
|5724-Z04||11.50.0||08/17/12||Informix Express. Edition V11.50.0|
|5724-C19||8.5.0||08/17/12||Informix Extended Parallel Server (XPS)V8.5.0|
|5724-C58||3.11.0||08/24/12||Informix Geodetic DataBlade V3.11.0|
|5725-A40||11.50.0||08/17/12||Informix Growth Edition V11.50.0|
|5724-C59||2.00.0||08/17/12||Informix Image Foundation DataBlade V2.00.0|
|5724-I35||3.1.0||08/17/12||Informix JDBC Driver/Embedded SQL V3.1.0|
|5724-I35||3.50.0||08/17/12||Informix JDBC Driver/Embedded SQL V3.50.0|
|5724-C27||1.6.0||08/17/12||Informix Server Administrator V1.X V1.6.0|
|5724-C61||8.2.1||08/17/12||Informix Spatial DataBlade V8.2.1|
|5724-C61||8.20.0||08/17/12||Informix Spatial DataBlade V8.20.0|
|5724-C62||4.01.0||08/17/12||Informix TimeSeries DataBlade V4.01.0|
|5724-C63||1.10.0||08/17/12||Informix TimeSeries Real Time Load Bundle V1.10.0|
|5725-A39||11.50.0||08/17/12||Informix Ultimate Edition V11.50.0|
|5724-C30||4.12.0||08/17/12||Informix Web DataBlade V4.12.0|
|5724-C30||4.13.0||08/17/12||Informix Web DataBlade V4.13.0|
|5724-D27||1.00.0||08/17/12||Informix Workgroup Datablade Bundle V1.00.0|
|5724-C43||7.25.x||08/17/12||Informix Standard Engine|
|5724-E93||7.25.x||08/17/12||Informix Standard Engine Runtime Edition|
|5724-D61||5.20.X||08/17/12||Informix Online Personal Edition|
|5724-E03||5.20.x||08/17/12||Informix Online Extended Edition for Linux|
|5724-D59||7.25.x||08/17/12||Informix SE Personal Edition|
Informix 11.7 Bootcamp
|Aug 6 – 8, 10, 2012||South Africa||Johannesburg||Register at http://www-304.ibm.com/events/idr/idrevents/register.action?meid=5614&ieid=3315
Class to be held on Aug 6, 7, 8, and 10th. Extended 4-day agenda to cover Informix Warehouse Accelerator module* on Aug 10th
|For more details see http://www.ibm.com/developerworks/wikis/display/im/Informix+11.7+Bootcamp|
Informix Performance Tuning Bootcamp
|Sep 19 – 21, 2012||China||Shanghai||Register at https://www.ibm.com/events/swgeer/swgeer06.nsf/signin?openform&seminar=kwockwn8venqj&lang=en|
|For more details see http://www.ibm.com/developerworks/wikis/display/im/Informix+Performance+Tuning+Bootcamp|
A user group Event On August 2nd,2012
Be sure to be a part of the largest gathering of Informix users in Malaysia on August 2nd (Thursday) from 1: 30 PM to 7: 30 PM at Ballroom A, Level 10, DoubleTree Hotel, Kuala Lumpur, followed by Buka Puasa dinner that will commence from 7:30 PM onwards.
Get more details here:
A user group event on August 7th (Tuesday), 2012
If you are around Bangkok during the week of 7th (of August 2012), please join us to for this half a day event and be a part of the largest Informix users gathering Thailand. We will be having some of the members IBM Informix leadership team and Informix subject matter experts to be present for this event in person, and they will be most happy to spend time with you to discuss on how IBM could help better achieve your business goals with Informix.
Get more details here:
|Informix resources||Back to top|
- The IIUG forums at /forums/technical.php **** these are very good****
- Blogs, Videos, News and more at http://planetids.com *** Up to date feeds from many blogs ***
- Jerry Keesee http://jerrykeeseetalksinformix.wordpress.com/ *** New ***
- Informix documentation team https://www.ibm.com/developerworks/mydeveloperworks/blogs/idsdoc *** New ***
- IDS Experts blog https://www.ibm.com/developerworks/mydeveloperworks/blogs/idsteam *** New ***
- A Latin blog maintained by support http://the-information-x.blogspot.com.br
- Eric Vercelletto’s English Website http://en.vercelletto.com
- Gary Proctor http://garyproctorsblog.com
- Martin Fuerderer a blog on Informix Warehouse Accelerator http://tinyurl.com/the-iwa-blog
- ognjen.orel http://ifmx.wordpress.com/li>
- Keshava Murthy https://www.ibm.com/developerworks/mydeveloperworks/blogs/Keshav
- Louis T.Cherian http://louistcherian.wordpress.com
- Art Kagel’s blog http://informix-myview.blogspot.com
- Andrew Ford’s blog http://www.informix-dba.blogspot.com
- Mark Jamison at http://www.ibm.com/developerworks/blogs/page/gbowerman
- Jacques Roy at http://www.ibm.com/developerworks/blogs/page/jacquesroy
- Kate Dawson at http://www.ibm.com/developerworks/blogs/page/katedawson
- Fernando Nunes at http://informix-technology.blogspot.com
- Eric Vercelletto at http://www.levillageinformix.blogspot.com (in French)
- Mark Scranton at http://markscranton.wordpress.com/2011/07/23/informix-and-marketing/
- IBM DATABASE MAGAZINE at http://www.ibmdatabasemag.com
- The Informix Zone at http://www.informix-zone.com
- There is an Informix group on LinkedIn. The group is called “Informix Supporter”, so anyone loving Informix can join, from current IBM employees, former Informix employees, to users. It will also be a good occasion to get in touch with others or long-time-no-seen friends. If you fancy showing the Informix logo on your profile, join. To join, simply go to:
|Calendar of events||Back to top|
|August – 2012|
|1||Informix Road Show – Actually using smart sensors and other time sensitive data with TimeSeries||Dallas, Texas||Carlton Doe – firstname.lastname@example.org|
|8||Informix Road Show – Turning data into knowledge at the speed of thought||Chicago, Illinois||Carlton Doe – email@example.com|
|9||Informix Road Show – Actually using smart sensors and other time sensitive data with TimeSeries||Chicago, Illinois||Carlton Doe – firstname.lastname@example.org|
|14||Informix Road Show – Turning data into knowledge at the speed of thought||Atlanta, Georgia||Carlton Doe – email@example.com|
|15||Informix Road Show – Actually using smart sensors and other time sensitive data with TimeSeries||Atlanta, Georgia||Carlton Doe – firstname.lastname@example.org|
|October – 2012|
|21-25||Informix on Demand 2012||Las Vegas, Nevada|
|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
For comments, please send an email to email@example.com.