Become a fan of Slashdot on Facebook


Forgot your password?

Submission + - IBM's DB2 runs Oracle applications, say what? ( 2

An anonymous reader writes: Just in time for the imminent acquisition of Sun by Oracle it seems Big Blue has finally realized that it's in an all out war and they are going for the jugular.
Apparently making DB2 9.7 for Linux, Unix, and Windows understand PL/SQL and extending their own SQL to also
understand Oracle's dialect (down to the dreaded (+) join syntax!) last year was just the opening salvo.
According to an IBM developerWorks article by their SQL Architect those DB2 developers in Toronto have upped the ante and provided an OCI (Oracle Client Interface) compatible client. Makes one wonder: What's next?
Given the importance of Oracle's DBMS to their stream revenue, as compared to the relevance of
DB2 for LUW to IBM in the big picture, I wonder how much room to maneuver Oracle actually has if it comes to an all out pricing-war.
Has anyone tried the "Oracle compatibility features" of DB2 and is
considering a move or extension of an application?
Certainly what's offered is not sufficient to easily port all applications out there.
But for just how many of those apps will what's provided be good enough?
Are we seeing the end of the SQL dialect wars, vendor lock-in, and a commoditization the DBMS market?

This discussion was created for logged-in users only, but now has been archived. No new comments can be posted.

IBM's DB2 runs Oracle applications, say what?

Comments Filter:
  • What we have found so far is that there are plenty of applications that are highly "vanilla". That is beyond the obvious syntax very little Oracle specific features (such as VPD) are actually used. In these cases an enablement is nearly trivial once one supports the syntax and semantics. Additional features do increment the cost of course. So not all applications, but many are good candidates.
  • Have you ever dreamed about portability, you would think DDL is at most what can be done. With DB2 9.7, you compile all your SQL Oracle code as is with minor changes. I have tested complex customer applications using 200 stored procedures, and in 1 week this was done. Now, don't forget to test your application :-)!

The Macintosh is Xerox technology at its best.