473,386 Members | 2,129 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,386 software developers and data experts.

death knell for Informix

http://www.computerworld.com/action/...icleId=9017838
IBM to open its midrange systems to MySQL's database

April 25, 2007 (Computerworld) -- SANTA CLARA, Calif. -- MySQL AB and IBM
announced Wednesday that users of the latter's System i hardware line will
be able to run the MySQL open-source database on the midrange servers.
The System i version of IBM's DB2 database, which is integrated with the
midrange line's operating system as a standard feature, will serve as a
certified storage engine for MySQL, the two companies said at MySQL's annual
user conference here.
MySQL claims that its namesake database is being used in 11 million active
installations worldwide. The software is based on a modular architecture
that lets users swap in different storage engines tuned for different
application scenarios.
Companies that use the System i -- better known by its original AS/400 name,
and then as the iSeries -- will gain the advantage of being able to
implement online and transactional MySQL applications while continuing to
store data in DB2, according to the two vendors.
The agreement to combine the technologies "is about opening up new
applications to old data and old applications to new data," said Mike Smith,
IBM's chief software architect for the System i line.
"I think it's an interesting and potentially excellent deal for both sides,"
said Stephen O'Grady, an analyst at Denver-based consulting firm RedMonk.
"IBM gets access to the more or less ubiquitous MySQL platform with its DB2
storage engine, and MySQL gets an opening to the still popular [System i]
platform."
DB2 is one of the three leading relational databases used by large
enterprises, along with Oracle and Microsoft Corp.'s SQL Server. But MySQL's
low cost of ownership and rapid rise in popularity has led to the creation
of a larger ecosystem of supporting software for the open-source database
than is currently available for DB2.
In addition, MySQL is making inroads into the installed bases of the top
database vendors. For example, one-third of the 269 Oracle users who
responded to an e-mail survey conducted last June for the Independent Oracle
Users Group said that they also use MySQL (download PDF).
IBM also agreed to sell service and support subscriptions for the MySQL
Enterprise database via its reseller network and the System i sales team.
That should help MySQL, which is preparing for an initial public offering,
to gain more paying customers. During his keynote speech on Tuesday, MySQL
CEO Marten Mickos said that his company has just one paying user for every
thousand nonpaying ones.
In another effort to increase its count of paying customers, MySQL in
January announced a site license that lets companies deploy as many MySQL
databases as they want for a flat fee of $40,000 per year. That price,
Mickos claimed, is roughly comparable to the cost of one single-processor
Oracle server license.
The MySQL Enterprise Unlimited offering has attracted users such as ESPN
Inc., The New York Times Co. and TransUnion LLC, according to MySQL. Mickos
said that in this year's first quarter, the company doubled the number of
MySQL Enterprise subscriptions sold compared with the same period last year.
MySQL recently also updated a remote network monitoring service, rolled out
last fall, that can scan all of the database servers behind a customer's
firewall, check to see if they're set up correctly and then provide advice
on how to make them adhere to best practices. Mickos said that can "take
away the black-box feel that servers sometimes have and help you implicate
or exonerate the database when an application is not running well."
Apr 26 '07 #1
5 1857
Data Cruncher wrote:
http://www.computerworld.com/action/...icleId=9017838
IBM to open its midrange systems to MySQL's database
What does that have to do with IDS?
IDS doesn't run on iSeries.
There are exactly 2 things at work here:
1. Enabling of mySQL on iSeries (good for iSeries)
2. Enabling of mySQL directly on DB2 for iSeries (without dependency on
another storage engine) (still good for iSeries)

Depending how one reads the articles one may suspect that IBM will
provide soem help to get mySQL closer to the SQL Standard.
I sure would love to see mySQL users stop nagging: DB2 is bad because
"SELECT 1+2" returns an syntax error ... ;-)

Cheers
Serge

--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
Apr 26 '07 #2
Serge Rielau wrote:

....
I sure would love to see mySQL users stop nagging: DB2 is bad because
"SELECT 1+2" returns an syntax error ... ;-)
....

Hmmm - I am confused:

C:\>db2 connect to sample

Database Connection Information

Database server = DB2/NT 9.1.3
SQL authorization ID = DB2ADMIN
Local database alias = SAMPLE
C:\>db2 select 1=2 from sysibm.sysdummy1
SQL0104N An unexpected token "=" was found following "select 1". Expected
tokens may include: ",". SQLSTATE=42601

C:\>db2 select 1+2 from sysibm.sysdummy1

1
-----------
3

1 record(s) selected.
Jan M. Nelken
Apr 26 '07 #3
Serge Rielau wrote:

....
I sure would love to see mySQL users stop nagging: DB2 is bad because
"SELECT 1+2" returns an syntax error ... ;-)
....

Hmmmm, I seem to be confused again:

C:\>db2 connect to sample

Database Connection Information

Database server = DB2/NT 9.1.3
SQL authorization ID = DB2ADMIN
Local database alias = SAMPLE

C:\>db2 select 1+2 from sysibm.sysdummy1

1
-----------
3

1 record(s) selected.
Jan M. Nelken
Apr 26 '07 #4
Jan M. Nelken wrote:
Serge Rielau wrote:

...
>I sure would love to see mySQL users stop nagging: DB2 is bad because
"SELECT 1+2" returns an syntax error ... ;-)
...

Hmmmm, I seem to be confused again:

C:\>db2 connect to sample

Database Connection Information

Database server = DB2/NT 9.1.3
SQL authorization ID = DB2ADMIN
Local database alias = SAMPLE

C:\>db2 select 1+2 from sysibm.sysdummy1

1
-----------
3

1 record(s) selected.
$ db2 "select 1+2"

SQL0104N An unexpected token "END-OF-STATEMENT" was found following "select
1+2". Expected tokens may include: "<table_expr>". SQLSTATE=42601

MySQL accepts this crap because they don't have the standardized VALUES
statement.

--
Knut Stolze
DB2 z/OS Utilities Development
IBM Germany
Apr 26 '07 #5
Serge Rielau wrote:
Data Cruncher wrote:
>>
http://www.computerworld.com/action/...icleId=9017838
>>

IBM to open its midrange systems to MySQL's database
What does that have to do with IDS?
IDS doesn't run on iSeries.
There are exactly 2 things at work here:
1. Enabling of mySQL on iSeries (good for iSeries)
2. Enabling of mySQL directly on DB2 for iSeries (without dependency on
another storage engine) (still good for iSeries)

Depending how one reads the articles one may suspect that IBM will
provide soem help to get mySQL closer to the SQL Standard.
I sure would love to see mySQL users stop nagging: DB2 is bad because
"SELECT 1+2" returns an syntax error ... ;-)

Cheers
Serge
Or even -

SELECT * FROM TABLE WHERE integer_column = '1';

Came across this during my work on Ruby on Rails !!!

You can put quotes around the literals for any data type in MySQL and it
works.

Phil
Apr 26 '07 #6

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: D. Sandmann | last post by:
I have had this problem in the past on another machine and fixed it by setting the environment variables for INFORMIXDIR and INFORMIXSERVER. When adding the same lines on the new machine I still...
3
by: Christian Eriksson | last post by:
Hi! I'm programming Perl DBI accessing Informix databases. I have a problem on a Solaris machine to use my installed Informix driver (DBD::Informix). I get the following error message: ...
1
by: Phil Hindmoor | last post by:
Hi, I am sure if anyone can help me, you guys can! I am an Informix Developer, moving to Oracle 8i and later databases. I am struggling to find the Oracle equivelant to many of the useful...
3
by: Lee | last post by:
Hi, I'm developing a socket program to connect to Informix database through the ODBC. In here i called my socket program as "tap" . My tap will listen for data from unix through port 1070. After...
10
by: Joachim Banzhaf | last post by:
Hi, Creating the federated datasource library for informix fails for me. The db2 server is version 8.1 WSE on AIX 4.3. The informix client on this server is version CSDK 2.81/ESQL 9.53 UC2....
6
by: FireHawkBr® | last post by:
Hi, My company uses Informix as corporative database. As experienced DBA of the company, I have that to make a study comparing Oracle, Informix and DB2 databases and suggesting new alternatives....
0
by: vishalp79 | last post by:
Hi, I am trying to install DBD::Informix module on perl on hpux 11.23 machine. but i get this weird error ...... Set up gcc environment - 4.1.1 *** ExtUtils::AutoInstall version 0.61 ***...
0
by: Lester Knutsen | last post by:
A two-day IBM Informix and DB2 User Group Technical Conference - Friday and Saturday, December 8-9, 2006 We are very please to announce our Keynote Speakers...
0
by: Prasad | last post by:
Hi, We have DB2 v9 FP2 on AIX 5.3 64-bit. We have Informix 7 on another AIX 5.3. Our requirement is to access Informix tables from within a DB2 database. I installed Informix Client SDK 2.9...
14
by: Khan | last post by:
Hello, I want to connect my intranet server (with php/apache) to the other informix database server, But I didnt it. I dont know how i can do it? Can i use php_informix extensions for example...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.