Top Resources for Migrating to DB2 from Oracle

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.

IBM RedBooks


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

IDUG 2012 North America

IDUG 2011 North America

IDUG 2010 North America

Recent Stories
Db2 for z/OS locking basics

A Beginners Guide to Locks, Latches, Claims and Drains in DB2 for z/OS by Steve Thomas

Fun with Date Ranges