The task of migrating Oracle databases and applications to DB2 LUW became a lot easier with DB2 "Cobra", which IBM officially released in June 2009 as DB2 9.7. IBM got a jump start on developing Oracle compatibility for DB2 Cobra by licensing and adapting technology from EnterpriseDB. In addition to providing a native PL/SQL engine and implementing new locking behavior, DB2 9.7 also delivered many new data types and function libraries with the goal of achieving more than 90% compatibility with Oracle. The actual numbers turned out to be even better, with many Oracle to DB2 9.7 migrations requiring changes to less than 5% of the code. That statistic continues to improve as additional compatibility enhancements are introduced in newer DB2 releases.
From a licensing standpoint, IBM originally limited the Oracle compatibility features to DB2 Workgroup Edition and DB2 Enterprise Server Edition exclusively, but that restriction was lifted in November 2011 to include DB2 Express Edition (beginning with 9.7 Fix Pack 5) and the no-cost DB2 Express-C engine (beginning with 9.7.5).
High-volume, mission-critical Oracle applications can be migrated to DB2 and clustered in a manner similar to Oracle RAC (i.e. shared storage, active-active) via DB2's pureScale feature, which is based on parallel sysplex data sharing groups on DB2 z/OS. Although a DB2 pureScale cluster needs additional hardware, software, and networking, DB2 does not require any cluster awareness in the database DDL or in the application code.
- Oracle to DB2 Conversion Guide: Compatibility Made Easy published September 2012
- Oracle to DB2 Conversion Guide for Linux, UNIX, and Windows published August 2007
IDUG Conference Presentations
Presentation slides and notes from past technical conferences can be viewed by registered members of IDUG. Membership is free, click here to sign up.
IDUG 2012 EMEA
- Re-using Oracle PL/SQL Code Under IBM DB2 by Udo Brede
IDUG 2012 North America
- Zero Outage Oracle to DB2 Migrations by Frank Fillmore, The Fillmore Group
- Oracle Compatibility Update for DB2 10 for Linux, UNIX, and Windows by John Hornibrook, IBM
IDUG 2011 North America
- DB2 pureScale vs. Oracle RAC: Scale-Out Done Right by Paul Zikopoulos, IBM
IDUG 2010 North America
- Enabling Oracle Applications on DB2: An Early User Experience by Bernie O'Connor, Anixter