Informix on Linux
Reviewer: Fred Butzen
On Thursday, July 23, 1998, Linux took a stride closer to the business mainstream. Informix, in response to a groundswell of demand among its users, released its port of Informix to Linux.
For me personally, this was an important development. I have worked with Informix for over 15 years, and first used it on an Altos 586 under Xenix. I like the product, and seeing it available for free on my favorite operating system was like having Christmas in July.
What follows are my first impressions of Informix on Linux.
The Informix release consists of the following:
The Informix Standard Engine is Informix's older technology, which uses the file system to manage data. The Standard Engine is adequate for development work and for managing small- to mid-sized databases. It does not require the resources or management that Informix Online does, but it is not robust enough for enterprise-level work.
Informix Connect is a set of libraries which manage connections to the database over a network.
Informix ESQL/C is a kit of libraries, header files, and utilities that let you write C programs that interact with the Informix engine.
To download the package, you must register with Informix first. Informix then e-mails you a serial number and key required for installing the package. The package is free; however, you must still pay for technical support and for runtime licenses to run the bits you develop on customers' machines.
Most significantly, the package does not include ODBC or JDBC drivers. However, Informix CLI includes a Visigenic ODBC driver as part of its development kit. To register to download this development kit, check out http://www.intraware.com/shop/product.html?PLNK=000111. No Linux version is available yet, but kits are now available for Win95, NT and various other flavors of UNIX.
Installation and configuration was straightforward, since I'm familiar with Informix. (See the sidebar “Informix Installation and Configuration” for details.)
Informix offers an SQL engine that is fully compliant with SQL-2 standards. It also offers a stored-procedure language (a rather poor one, in my opinion) and triggers.
I tested Informix on Red Hat 5.0, using the 2.0.29 kernel on a home-brew machine, running a 100 MHz 486 with a 2GB SCSI disk and 32MB of RAM.
A reliable source has tested Informix with Debian 2.0 and its libc5 development package, and reports that Informix works fine on the simple tests to which he subjected it.
To test Informix, I ran the programs with my baseball database that I prepared for the book The Linux Database. This set exercises common features of SQL, both in interpreted SQL and in SQL/C.
I found that Informix performs as one expects a major commercial package to perform—without error. I could not get it to crash, return erroneous data or otherwise mess up. On these fairly limited exercises, I found its speed to be more than acceptable.
One problem, however, is that as I exercised Informix, I found that the SQL daemon sqlexecd spawned dozens of zombie processes. Clearly, work remains to be done.
Informix on Linux offers a number of pluses to anyone who develops database applications under Linux:
The main plus, of course, is name recognition: It is well-known and has credibility among potential customers that other packages, such as Yard or mysql, do not. This may not be fair, but it is nonetheless true.
Informix is a full, robust implementation of SQL-2. Even the best freeware packages have limitations in their implementation of SQL that require workarounds.
However, Informix has some serious drawbacks as well:
The package offered is Informix's trailing-edge technology. It does not offer the Online engine, data blades or Informix's other enterprise-scale tools. Informix's standard-engine product is a good, solid package, but it is not where the action is.
The only interface language offered so far is C. If you wish to build web interfaces with Perl, this package will not help you (although there may be a third-party package available that includes a Perl interface to Informix).
Documentation is particularly helpful in getting Informix up and running. However, it is hard to come by—you must either purchase documentation, which is expensive, or download and print it, which is also expensive.
Your customers still have to purchase a runtime license for Informix, which can be quite expensive. When you add in the cost of connectivity tools (ODBC, et al.), a customer can easily spend thousands of dollars per installation.
|Dynamic DNS—an Object Lesson in Problem Solving||May 21, 2013|
|Using Salt Stack and Vagrant for Drupal Development||May 20, 2013|
|Making Linux and Android Get Along (It's Not as Hard as It Sounds)||May 16, 2013|
|Drupal Is a Framework: Why Everyone Needs to Understand This||May 15, 2013|
|Home, My Backup Data Center||May 13, 2013|
|Non-Linux FOSS: Seashore||May 10, 2013|
- Dynamic DNS—an Object Lesson in Problem Solving
- Making Linux and Android Get Along (It's Not as Hard as It Sounds)
- Using Salt Stack and Vagrant for Drupal Development
- New Products
- Drupal Is a Framework: Why Everyone Needs to Understand This
- Validate an E-Mail Address with PHP, the Right Way
- A Topic for Discussion - Open Source Feature-Richness?
- New Products
- Download the Free Red Hat White Paper "Using an Open Source Framework to Catch the Bad Guy"
- The Secret Password Is...
3 hours 52 min ago
- Keeping track of IP address
5 hours 43 min ago
- Roll your own dynamic dns
10 hours 57 min ago
- Please correct the URL for Salt Stack's web site
14 hours 8 min ago
- Android is Linux -- why no better inter-operation
16 hours 24 min ago
- Connecting Android device to desktop Linux via USB
16 hours 52 min ago
- Find new cell phone and tablet pc
17 hours 50 min ago
19 hours 19 min ago
- Automatically updating Guest Additions
20 hours 28 min ago
- I like your topic on android
21 hours 14 min ago
Enter to Win an Adafruit Pi Cobbler Breakout Kit for Raspberry Pi
It's Raspberry Pi month at Linux Journal. Each week in May, Adafruit will be giving away a Pi-related prize to a lucky, randomly drawn LJ reader. Winners will be announced weekly.
Fill out the fields below to enter to win this week's prize-- a Pi Cobbler Breakout Kit for Raspberry Pi.
Congratulations to our winners so far:
- 5-8-13, Pi Starter Pack: Jack Davis
- 5-15-13, Pi Model B 512MB RAM: Patrick Dunn
- 5-21-13, Prototyping Pi Plate Kit: Philip Kirby
- Next winner announced on 5-27-13!
Free Webinar: Hadoop
How to Build an Optimal Hadoop Cluster to Store and Maintain Unlimited Amounts of Data Using Microservers
Realizing the promise of Apache® Hadoop® requires the effective deployment of compute, memory, storage and networking to achieve optimal results. With its flexibility and multitude of options, it is easy to over or under provision the server infrastructure, resulting in poor performance and high TCO. Join us for an in depth, technical discussion with industry experts from leading Hadoop and server companies who will provide insights into the key considerations for designing and deploying an optimal Hadoop cluster.
Some of key questions to be discussed are:
- What is the “typical” Hadoop cluster and what should be installed on the different machine types?
- Why should you consider the typical workload patterns when making your hardware decisions?
- Are all microservers created equal for Hadoop deployments?
- How do I plan for expansion if I require more compute, memory, storage or networking?