Save 
Join IIUG
 for   
 

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

Previous Next Contents

9. Miscellaneous

9.1 What's the difference between SE and IDS/ODS?

In general, SE performs slower than IDS, supports fewer data types, and lacks many of the features of its larger sibling. Specifically speaking, Informix-SE has the following differences:

  • No support for BLOBs (Binary Large Objects)
  • No support for the VARCHAR data type
  • No support for the TEXT data type
  • No support for the BYTE data type
  • ESQL/C is not multi-threaded
  • ESQL/C does not support TP/XA
  • TERMINFO is not supported on Linux

Don't make the mistake, however, of thinking that this means you should ignore SE. Informix-SE is a wash-and-wear RDBMS because it is so simple to administer. Install it, make a couple of one-line edits to some configuration files, and you are off to the database races. SE will will just keep going and going and going and... This feature should appeal to those sites that lack a full-time MIS administrator. SE also shines when the applications banging on it don't demand breakneck performance; although not sluggish, it is not the speed-demon that some of its competitors are. Again, the trade-off is performance for robustness and ease of administration and maintenance.

9.2 What's the current release?

As of the date this FAQ was last updated, the most current release level is Informix-SE 7.24.UC5, released 13 July 1998. The code base, however, has been forked for the glibc release, and it is dated 14 October 1998.

9.3 What's the difference between sqlexec and sqlexecd?

The sqlexec program is the database engine, creating and manipulating databases. Each program that accesses a databases gets its own copy of sqlexec (which explains why killing sqlexec is such a bad idea). The host OS handles the locking necessary for resource management between multiple SE processes.

In contrast, sqlexecd never touches the database. It's raison d'etre is listening for requests for database access (usually originating from remote applications/clients) and starting a sqlexec process to communicate with the requesting client and twiddle the database as required.

This relationship is analogous to the difference between rlogind, which waits for a machine to try to login to a system, and the shell that rlogind executes to communicate with the user.

9.4 Is Informix-SE "thread-safe?"

Although the question is a good one, it doesn't matter. SE is a single-threaded, synchronous application dealing with a single request at a time. Hence, threading doesn't really have any bearing on how the engine behaves.

9.5 Will Informix-SE run on a multi-processor machine?

Yes, because the underlying OS will handle MP issues. On the other hand, if you are asking, "Will Informix-SE take advantage of multiple processors?" then the answer is "No." SE, being single-threaded, does not in itself benefit from multiple processors.

9.6 Is ESQL/C "thread-safe?"

Yes and no. The libc5-based version is not thread-safe because libc5 is not thread-safe, which was one of the motives behind glibc/libc6. Jonathan Leffler also pointed out the ESQL/C only works with DCE threads, while Linux (most likely) only supports POSIX threads. Although these two thread incarnations are similar, they are incompatible.

Until someone corrects me, I will assert that the glibc-based version is thread-safe because the C-library used to compile the engine is thread-safe.

9.7 How do I get involved?

Write documentation

If you would like to get involved with Informix on Linux, Tom Schaefer netd@mindspring.com coordinates the effort to get HOWTOs and related documentation written and distributed to the appropriate repositories. A special need exists for HOWTOs on these topics:

  • ODBC Connectivity
  • JDBC Connectivity
  • Perl, DBD and DBI
As other Informix products are released, we will need HOWTOs and FAQs for them.

Beta Testing

As other products approach formal release, Informix will need beta testers. Art Kagel coordinates the beta program. For further information, contact him at kagel@erols.com. Include at least the following information so that Informix can match the product being tested to your level of Informix experience and the platform on which you would be testing the product:

  • Linux distribution and version
  • Size of potential test database
  • Complexity and type of test application
  • Type of hardware (uni-, dual- or multi-CPU)
  • Tape archive device
  • General level of experience
  • Specific Informix products you want to test
Of course, you would need to sign a Non-Disclosure Agreement (NDA).

Join IIUG

The International Informix Users Group was instrumental in persuading Informix to release Linux versions of their products. The Advocacy Committee continues these efforts. Currently, joining IIUG doesn't cost a dime, and you get the opportunity to have influence with Informix as well as to interact with other people using Informix and Informix on Linux. Check them out at http://www.iiug.org on the web.

Write to Informix

You can always write directly to Informix and tell them what specific Informix product you would like to see ported to the Linux environment. They do listen.

9.8 What does "SE" stand for?

Standard Engine. Informix-SE is an ISAM-based database engine that lives on cooked, that is, formatted, filesystems.

9.9 Interesting Trivia

For those interested in such trivia, Carlton Doe reported that in the first few days following Informix's announcement, downloads from the Intraware site initially hit about 700 per day. They have since leveled off to about 300/day. Informix has not yet released information about sales of runtime licenses or support contracts.

A similar program for Microsoft Windows NT was announced at the same time as the Linux Developer Bundle. At least initially, Linux downloads out-paced NT downloads ;-).


Previous Next Contents